Cash flow spreadsheet needs correct formula calculations

Completed Posted Oct 15, 2009 Paid on delivery
Completed Paid on delivery

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.

Excel

Project ID: #529208

About the project

5 proposals Remote project Active Oct 16, 2009

Awarded to:

onegcf

i'm an experienced accountant. can do the formula calculations for you.

$50 USD in 1 day
(1 Review)
1.4

5 freelancers are bidding on average $88 for this job

DrTech76

Hi, lets talk, shall we? Regards, DrTech76

$70 USD in 0 days
(23 Reviews)
4.6
FlashBack

Hi I am ready to start immediately. Thanks Abir

$130 USD in 3 days
(6 Reviews)
3.4
trivietsales

Hi, I am willing to help you. Thanks, trivietsales

$60 USD in 2 days
(1 Review)
2.4
tamaramm

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.

$100 USD in 0 days
(0 Reviews)
0.0
floriezyl

I am a CPA and finance director. Please see my PMB.

$100 USD in 5 days
(0 Reviews)
0.0