Calculation guide
Discount at year end and interpolate within the recovery year. A missing payback means the forecast ends before recovery.
Payback = complete years + unrecovered balance / discounted receipt in recovery year
Inputs
Initial investment
Example entry 100 (in the selected currency).
Annual discount rate
Example entry 0 %. Allowed range 0 to 100.
Net receipt
Example entry 50 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Initial investment | 100 |
| Annual discount rate | 0% |
Annual receipts
| Net receipt |
|---|
| 40 |
| 60 |
| 50 |
| Result | Value |
|---|---|
| Discounted payback period | 2 years |
| Discounted surplus at horizon | 50 |
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 investment | 100 | 110 | Discounted payback period | 2 years | 2.2 years |
| Annual discount rate | 0% | 1% | Discounted payback period | 2 years | 2.032522 years |
| Net receipt (row 1) | 40 | 44 | Discounted payback period | 2 years | 1.933333 years |
