Calculation guide
Fractional times are measured in years.
PV = Σ cash(t) / (1+i)^t
Inputs
Effective annual discount rate (%)
Example entry 10 %. Allowed range -90.0 to 100.0.
Years until payment
Example entry 1. Allowed range 0.0 to 120.0.
Installment amount
Example entry 1100 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Effective annual discount rate (%) | 10% |
Settlement installments
| Years until payment | Installment amount |
|---|---|
| 1 | 1,100 |
| 2 | 1,210 |
| Result | Value |
|---|---|
| Equivalent lump sum | 2,000 |
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 |
|---|---|---|---|---|---|
| Effective annual discount rate (%) | 10% | 11% | Equivalent lump sum | 2,000 | 1,973.054135 |
| Years until payment (row 1) | 1 | 2 | Equivalent lump sum | 2,000 | 1,909.090909 |
| Installment amount (row 1) | 1,100 | 1,210 | Equivalent lump sum | 2,000 | 2,100 |
