Cash flow spreadsheet needs correct formula calculations

Fertiggestellt Veröffentlicht Oct 15, 2009 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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

Projekt-ID: #529208

Über das Projekt

5 Vorschläge Remote Projekt Aktiv Oct 16, 2009

Vergeben an:

onegcf

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

$50 USD in 1 Tag
(1 Bewertung)
1.4

5 Freelancer bieten im Durchschnitt $88 für diesen Job

DrTech76

Hi, lets talk, shall we? Regards, DrTech76

$70 USD in 0 Tagen
(23 Bewertungen)
4.6
FlashBack

Hi I am ready to start immediately. Thanks Abir

$130 USD in 3 Tagen
(6 Bewertungen)
3.4
trivietsales

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

$60 USD in 2 Tagen
(1 Bewertung)
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 Tagen
(0 Bewertungen)
0.0
floriezyl

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

$100 USD in 5 Tagen
(0 Bewertungen)
0.0