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
Annual interest / discount rate
Effective annual discount rate used to express future cash flows in today’s value.
Date
Date on which this payment or receipt occurs, entered as YYYY-MM-DD.
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% |
Cash flows
| Date | Amount |
|---|---|
| 2026-01-01 | -100,000 |
| 2027-01-01 | 60,000 |
| 2028-01-01 | 60,000 |
Formula:
NPV=Σ CF_t/(1+r)^((date_t−date₀)/365)
Net present value = 4132.23140495867
Time years = 0.00000000000000; Cash flow = -100000.000000000; Present value = -100000.000000000; Cumulative value = -100000.000000000
Time years = 2.00000000000000; Cash flow = 60000.0000000000; Present value = 49586.7768595041; Cumulative value = 4132.23140495867
| Result | Value |
|---|---|
| Net present value | 4,132.231405 |
Interpreting the result
Sum of dated cash flows discounted to the earliest entered date using actual days over 365.
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% | Net present value | 4,132.231405 | 2,751.400049 |
| Date (row 1) | 2026-01-01 | 2026-01-02 | Net present value | 4,132.231405 | 4,159.426357 |
| Amount (row 1) | -100,000 | -90,000 | Net present value | 4,132.231405 | 14,132.231405 |
