Calculating a Cumulative Cash Flow Curve
Harvard Business Publishing strives to make all of its products compliant with accessibility guidelines. The online tool you are using is not screen-readable due its complex and non-linear nature. If you encounter accessibility issues please contact us at: Thank you.
© 2014 Harvard Business School Publishing. Harvard Business Publishing is an affiliate of Harvard Business School.
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 |
