W02 Project 01-2 AA

xlsx

School

Brigham Young University, Idaho *

*We aren’t endorsed by this school

Course

180

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

4

Uploaded by ConstableSalmon4162

Report
W02 Project 1: Projected Profit and Loss Statement Starter Kalei Ukuleles CLV - C Projected Profit and Loss Statement Ukuleles S For the Two Years Ended December 31, 2021 and 2022 Ukuleles/c Gross pro Assumptions Ukuleles Average Ukulele Price $ 100 Subscripti Average Ukulele Cost $ 95 Subscripti Ukuleles Per Customer 1.0 Subscribe Subscription Rate 25% Months of Average Number Months Subscribed 18 Subscrip Average Subscription Price $ 9.99 Customer L Initial Number of Clicks Per Month 1000 Customer Conversion Rate 2% Contribut Growth Rate Per Month 0.5% Cost Per Click $ 0.65 1 2 3 4 Sales in units Jan Feb Mar Apr PPC clicks 1,000 1,005 1,005 1,005 Number of Ukuleles Sold 20 20 20 20 New Subscriptions Each Month 250 251 251 251 Subscriptions Ended Each Month - - - - Number of Active Subscriptions 250 251 251 251 Revenue Jan Feb Mar Apr Subscription Sales $ 2,498 $ 2,510 $ 2,510 $ 2,510 Ukulele Sales $ 2,000 $ 2,010 $ 2,010 $ 2,010 Total Sales $ 4,498 $ 4,520 $ 4,520 $ 4,520 Cost of Goods Sold $ 1,900 $ 1,910 $ 1,910 $ 1,910 Gross Profit $ 2,598 $ 2,610 $ 2,610 $ 2,610                -
CAC Sales customer 1.0 ofit/ukulele $ 5 s Contribution $ 5.00 ions ions/month $ 9.99 er rate 25% f subscription 18 ption Contribution $ 44.96 Lifetime Value $ 49.96 Acquisition Cost $ 32.50 tion to Cash Flow $ 17.46 5 6 7 8 9 10 11 12 13 May Jun Jul Aug Sep Oct Nov Dec Jan 1,005 1,005 1,005 1,005 1,005 1,005 1,005 1,005 1,005 20 20 20 20 20 20 20 20 20 251 251 251 251 251 251 251 251 251 - - - - - - - - - 251 251 251 251 251 251 251 251 251 May Jun Jul Aug Sep Oct Nov Dec Jan $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 2,610
14 15 16 17 18 19 20 21 22 Feb Mar Apr May Jun Jul Aug Sep Oct 1,005 1,005 1,005 1,005 1,005 1,005 1,005 1,005 1,005 20 20 20 20 20 20 20 20 20 251 251 251 251 251 251 251 251 251 - - - - - 250 251 251 251 251 251 251 251 251 1 - - - Feb Mar Apr May Jun Jul Aug Sep Oct $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 2,510 $ 12 $ - $ - $ - $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 4,520 $ 2,022 $ 2,010 $ 2,010 $ 2,010 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 2,610 $ 113 $ 101 $ 101 $ 101
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
23 24 Total Total Nov Dec Year 1 Year 2 1,005 1,005 1,005 1,005 20 20 20 20 251 251 251 251 251 251 - - 251 251 Total Total Nov Dec Jan Feb $ - $ - $ 2,510 $ 2,510 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 2,010 $ 4,520 $ 4,520 $ 1,910 $ 1,910 $ 1,910 $ 1,910 $ 101 $ 101 $ 2,610 $ 2,610