Hello, I have a sample cash flow spreadsheet that I need to fill with specific parameters. The goal is to create a formula that will calculate my break even point for my subscription service business. As a result I have a box in row 62-70 that needs to calculate the changes based on this information:
Subscription fee: $20* (per member)
How many members I expect in 3 months: 100* | 100%(show as whole # and % member increase from month 0-3)
How many members I expect in 6 months: 110 | 10% (show as whole # and % member increase from month 3-6)
How many members I expect in 9 months: (show as whole # and % member increase from month 6-9)
How many members I expect in 12 months: (show as whole # and % member increase from month 9-12)
Month-to-month Increase in Revenue:
The whole point is, I want to be able to forecast how many members I will need to (1) generate revenue and (b) break-even or go positive (when will it occur?). The assumption is that I burrowed two loans and need to pay them back (see row 10 + 41).
The spreadsheet is based on a 2-year period.
5 freelancers are bidding on average $88 for this job
I am an experienced Accountant; I will provide you with a formula within 24hrs upon being awarded the project. If you wish I will even paste it into your file for you.