Calculation guide
For business owners exploring costs, cash flow or valuation scenarios.
Keep revenue, cost and time periods consistent. Profit margin divides by revenue; markup divides by cost. Discounted cash flows are scenario assumptions, and terminal growth must be below the discount rate. Payback uses linear interpolation within the recovery period. Customer lifetime value uses the entered finite horizon, retention, margin and discount assumptions. No valuation or business outcome is guaranteed.
Inputs
Annual interest / discount rate
Effective annual discount rate used to express future cash flows in today’s value.
Terminal growth
Annual cash-flow growth after the forecast; it must be below the discount rate.
Cash
Cash available at the start; valuation adds this separately to business value.
Debt
Debt subtracted from enterprise value when estimating equity value.
Amount
Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.
Worked example
| Input | Value |
|---|---|
| Annual interest / discount rate | 10% |
| Terminal growth | 2% |
| Cash | 0 |
| Debt | 0 |
Forecast
| Amount |
|---|
| 50,000 |
| 60,000 |
| 70,000 |
Formula:
EV=Σ PV(FCF_t)+PV(FCF_N(1+g)/(r−g)); Equity=EV+Cash−Debt
Equity value = 818181.818181818
Year = 1.00000000000000; Cash flow = 50000.0000000000; Present value = 45454.5454545454
Year = 3.00000000000000; Cash flow = 70000.0000000000; Present value = 52592.0360631104
| Result | Value |
|---|---|
| Equity value | 818,181.818182 |
| Enterprise value | 818,181.818182 |
| Forecast present value | 147,633.358377 |
| Terminal value present | 670,548.459805 |
Interpreting the result
Enterprise value plus entered cash minus entered debt.
Present value of forecast cash flows plus discounted terminal value.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Annual interest / discount rate | 10% | 11% | Equity value | 818,181.818182 | 725,004.283563 |
| Terminal growth | 2% | 3% | Equity value | 818,181.818182 | 921,487.603306 |
| Cash | 0 | 1 | Equity value | 818,181.818182 | 818,182.818182 |
| Debt | 0 | 1 | Equity value | 818,181.818182 | 818,180.818182 |
| Amount (row 1) | 50,000 | 55,000 | Equity value | 818,181.818182 | 822,727.272727 |
