Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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 text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Accounting And Control A Managerial Emphasis

Authors: Sidney J. Gray, Stephen B. Salter, Lee H. Radebaugh

1st Edition

0471128082, 978-0471128083

More Books

Students also viewed these Accounting questions