Calculating a Cumulative Cash Flow Curve

Revenue Assumptions

Initial Customer Base $1,000,000
Lifetime Customer Revenue 25
Up-Front Revenue 25
Average Customer Tenure (months) 25

Balance Sheet Assumptions

Net Working Capital (% of Sales) 25

Variable Cost Assumptions

Customer Acquisition and Setup Cost 25
Recurring Customer Cost 25

Fixed Cost Assumptions

Monthly Fixed Costs 25
Annual Fixed Cost Growth Rate 25

Customer Growth Assumptions

New Customers Per Month in Year 1 25
New Customers Per Month in Year 2 25
New Customers Per Month in Year 3 25
New Customers Per Month in Year 4 25
New Customers Per Month in Year 5 25

Capital Expenditure Assumptions

Initial Capital Expenditure 25
CapEx Required for Year 2 (Month 12) 25
CapEx Required for Year 3 (Month 24) 25
CapEx Required for Year 4 (Month 36) 25
CapEx Required for Year 5 (Month 48) 25

Implied Values

Implied Monthly Customer Retention Rate 25
Implied Upfront Customer Revenue 25
Implied Monthly Recurring Customer Revenue 25
Implied Monthly Fixed Cost Growth Rate 25
Implied Cash Conversion Cycle (Days) 25