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. Negative cash flows represent money paid out; positive flows represent money received. Include the final valuation as a positive flow if relevant. IRR uses equal periods; XIRR discounts actual calendar-day differences using ACT/365F. Nonconventional sign-change patterns are reported as potentially ambiguous instead of silently choosing one root. NPV uses the entered discount rate.
Inputs
Initial
Money already invested or available at the beginning of this calculation.
Annual interest / discount rate
Effective annual discount rate used to express future cash flows in today’s 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 |
|---|---|
| Initial | 100,000 |
| Annual interest / discount rate | 0% |
Forecast
| Amount |
|---|
| 50,000 |
| 60,000 |
| 70,000 |
Formula:
k=min{n:Σ_{t≤n}PV(CF_t)≥P}; T=(k−1)+(P−Σ_{t<k}PV(CF_t))/PV(CF_k)
Payback years = 1.83333333333333
Year = 1.00000000000000; Cash flow = 50000.0000000000; Present value = 50000.0000000000; Cumulative value = -50000.0000000000
Year = 3.00000000000000; Cash flow = 70000.0000000000; Present value = 70000.0000000000; Cumulative value = 80000.0000000000
| Result | Value |
|---|---|
| Payback years | 1.833333 years |
| Net cash at horizon | 80,000 |
Interpreting the result
First recovery point, with a fractional year estimated within the recovery period.
Cumulative discounted receipts minus the original investment at the final forecast year.
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 |
|---|---|---|---|---|---|
| Initial | 100,000 | 110,000 | Payback years | 1.833333 years | 2 years |
| Annual interest / discount rate | 0% | 1% | Payback years | 1.833333 years | 1.8585 years |
| Amount (row 1) | 50,000 | 55,000 | Payback years | 1.833333 years | 1.75 years |
