WEEK 7 Project 3-THULIE NSOKOSI-1
.xlsx
School
Brigham Young University, Idaho**We aren't endorsed by this school
Course
BUS 180
Subject
Accounting
Date
Dec 16, 2024
Pages
6
Uploaded by HighnessMoonDuck36
W07 Projected P&L and Balance SheetKalei UkulelesProjected Profit & Loss StatementFor the Period of January 1 - December 31AssumptionsAprilAvg. ukulele price$ 105 Tax Rate 18%Avg. ukulele cost$ 95 Days Inventory33 35Ukuleles/customer1.0 Equip Life36 Subscriber rate50% Days Receivable 5 Avg. no. of months of subscription18 Days Payable 15 Avg. Subscription Price$ 9.99 Initial # of clicks/Mnth1000Conversion Rate2%Growth Rate/Month0.5%Cost Per Click$ 0.65 123Sales in unitsJanFebMarPPC clicks1,000 1,005 1,010 Number of Ukuleles Sold20 20 20 New Subscriptions Each Month10 10 10 Subscriptions Ended Each Month- - - Subscriptions Sold Each Month10 20 30 RevenueJanFebMarSubscription Sales$ 100 $ 200 $ 301 Ukulele Sales2,100 2,111 2,121 Sales2,200 2,311 2,422 Cost of Goods Sold1,900 1,910 1,919 Gross Profit$ 300 $ 401 $ 503 Advertising Cost$ 650 $ 653 $ 657 Rent500 500 500 Internet50 50 50 Legal Fees500 - - Wages- - - Depreciation14 14 14 Total expenses$ 1,714 $ 1,217 $ 1,220 Net Income $ (1,414) $ (816) $ (717)Projected Balance SheetJanFebMarAssets
Cash$ 4,283 $ 4,807 $ 8,482 Accounts Receivable367 385 404 Inventory2,100 2,111 2,122 Equipment500 500 500 Less Accumulate Depreciation(14) (28) (42)Total Assets$ 7,264 $ 7,831 $ 11,550 LiabilitiesAccounts Payable$ 850 $ 602 $ 603 Notes Payable3,000 Total Liabilities$ 850 $ 602 $ 3,603 Owners EquityPaid-in-Capital$ 5,000 $ 5,000 $ 5,000 Retained Earnings1,414 2,230 2,947 Less: Owner's Withdrawals- - - Total Owner's Equity6,414 7,230 7,947 Total Liabilities and Owner's Equity$ 7,264 $ 7,831 $ 11,550 Difference$ - $ - $ -
CLV - CACUkuleles SalesUkuleles/customer1.0 Gross profit/ukulele$ 10 Ukuleles Contribution$ 10.00 SubscriptionsSubscriptions/month$ 9.99 Subscriber rate50%Months of subscription18Subscription Contribution$ 89.91 Customer Lifetime Value$ 99.91 Customer Acquisition Cost$ 32.50 Contribution to Cash Flow$ 67.41 4567AprMayJunJulAugSepOct1,015 1,020 1,025 1,030 1,036 1,041 1,046 20 20 21 21 21 21 21 10 10 10 10 10 10 10 - - - - - - - 40 51 61 71 81 92 102 AprMayJunJulAugSepOct$ 403 $ 505 $ 607 $ 710 $ 813 $ 917 $ 1,022 2,132 2,142 2,153 2,164 2,175 2,185 2,196 2,534 2,647 2,760 2,874 2,988 3,103 3,218 1,929 1,938 1,948 1,958 1,968 1,977 1,987 $ 606 $ 709 $ 812 $ 916 $ 1,020 $ 1,125 $ 1,231 $ 660 $ 663 $ 666 $ 670 $ 673 $ 676 $ 680 500 500 500 500 500 500 500 50 50 50 50 50 50 50 - - - - - - - - - - - - - - 14 14 14 14 14 14 14 $ 1,224 $ 1,227 $ 1,230 $ 1,234 $ 1,237 $ 1,240 $ 1,244 $ (618) $ (518) $ (418) $ (318) $ (217) $ (115) $ (13)AprMayJuneJulyAugSeptOct
$ 8,942 $ 9,419 $ 9,794 $ 10,069 $ 10,244 $ 10,315 $ 10,286 422 441 460 479 498 517 536 2,250 2,261 2,273 2,284 2,295 2,307 2,318 500 500 500 500 500 500 500 (56) (69) (83) (97) (111) (125) (139)$ 12,170 $ 12,690 $ 13,110 $ 13,429 $ 13,648 $ 13,764 $ 13,779 $ 605 $ 607 $ 608 $ 610 $ 612 $ 613 $ 615 3,000 3,000 3,000 3,000 3,000 3,000 3,000 $ 3,605 $ 3,607 $ 3,608 $ 3,610 $ 3,612 $ 3,613 $ 3,615 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 3,565 4,084 4,502 4,820 5,036 5,151 5,164 - - - - - - - 8,565 9,084 9,502 9,820 10,036 10,151 10,164 $ 12,170 $ 12,690 $ 13,110 $ 13,429 $ 13,648 $ 13,764 $ 13,779 $ - $ - $ - $ - $ - $ - $ -
NovDec1,051 1,056 1,062 21 21 21 11 11 11 - - - 113 123 134 NovDecJan$ 1,127 $ 1,232 $ 1,338 2,207 2,218 2,230 3,334 3,451 3,568 1,997 2,007 2,017 $ 1,337 $ 1,444 $ 1,551 $ 683 $ 687 $ 690 500 500 500 50 50 50 - - - - - - 14 14 14 $ 1,247 $ 1,251 $ 1,254 $ 90 $ 193 $ 297 NovDec
$ 10,151 $ 9,915 556 575 2,330 2,342 500 500 (153) (167)$ 13,690 $ 13,499 $ 617 $ 618 3,000 3,000 $ 3,617 $ 3,618 $ 5,000 $ 5,000 5,074 4,881 - - 10,074 9,881 $ 13,690 $ 13,499 $ - $ -