Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need help in turning this graph into a pro forma

I need help in turning this graph into a pro forma forecast of annual sales...

60.1K

Verified Solution

Question

Accounting

I need help in turning this graph into a pro forma forecast of annual sales volume, with volume rather than revenue for The Sweet Password.

image

B11 =B2*(B3+B4) B C D E F G H 1 J K L M Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Average Revenue per User $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 3 Starting Subscribers 100 200 250 500 800 1,200 1,540 2,300 2,789 3,214 3,631 4,036 New Subscribers 80 120 500 600 210 500 500 500 500 500 500 500 S Cancellations 10 10 25 30 39 48 58 65 75 83 95 100 8 Net Additions 70 110 475 570 171 452 442 435 425 417 405 400 - Ending Subscribers 170 310 725 1070 971 1652 1982 2735 3214 3631 4036 4436 3 Churn Rate NA 5.00% 10.00% 6.00% 4.88% 4.00% 3.777 2.837 2.697 2.58% 2.627 2.48% Projected Lifetime (months) NA 20.0 10.0 16.7 20.5 25.0 26.6 35.4 37.2 38.7 38.2 40.4 Projected Lifetime Value (LTV NA $500.00 $250.00 $416.67 $512.82 $625.00 $663.79 $884.62 $929.67 $968.07 $955.53 $1,009.00 Total Monthly Recurring Revel $4,500.00 $8,000.00 $18,750.00 $27,500.00 $25,250.00 $42,500.00 $51,000.00 $70,000.00 $82,225.00 $92,850.00 $103,275.00 $113,400.00 2

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students