In Progress

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.

Skills: Excel

See more: formula cash flow spreadsheet, service spreadsheet, formula it, month spreadsheet, cash flow spreadsheet, excel spreadsheet formula, spreadsheet 2, row spreadsheet, row b, need cash, forecast, excel formula, create spreadsheet, cash, cash back, calculations, increase flow, able calculate, excel month correct, need formula, month cash flow spreadsheet, needs, subscription box business, break point formula, need year forecast business

About the Employer:
( 3 reviews ) bayonne, United States

Project ID: #529208

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