# Cash flow spreadsheet needs correct formula calculations

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.

( 3 comentários ) bayonne, United States

ID do Projeto: #529208

## Premiar a:

onegcf

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

\$50 USD em 1 dia
(1 Comentário)
1.4

## 5 freelancers are bidding on average \$88 for this job

DrTech76

Hi, lets talk, shall we? Regards, DrTech76

\$70 USD in 0 dias
(23 Comentários)
4.6
FlashBack

Hi I am ready to start immediately. Thanks Abir

\$130 USD in 3 dias
(6 Comentários)
3.4
trivietsales

\$60 USD in 2 dias
(1 Comentário)
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 dias
(0 Comentários)
0.0
floriezyl

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

\$100 USD in 5 dias
(0 Comentários)
0.0