Calculation guide
Growth begins with the second payment. A finite perpetuity value requires discount rate above growth.
Perpetuity present value = (((100 × First payment) ÷ (Annual effective discount rate (%) − Annual payment growth (%))) ÷ ((1 + (Annual effective discount rate (%) ÷ 100)) ^ (Year of first payment − 1)))
Inputs
First payment
Example entry 1000 (in the selected currency).
Annual effective discount rate (%)
Example entry 10 %. Allowed range -90.0 to 100.0.
Annual payment growth (%)
Example entry 5 %. Allowed range -99.0 to 100.0.
Year of first payment
Example entry 2. Allowed range 1.0 to 150.0. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| First payment | 1,000 |
| Annual effective discount rate (%) | 10% |
| Annual payment growth (%) | 5% |
| Year of first payment | 2 |
| Result | Value |
|---|---|
| Perpetuity present value | 18,181.818182 |
Calculation steps
Perpetuity present value = (((100 × First payment) ÷ (Annual effective discount rate (%) − Annual payment growth (%))) ÷ ((1 + (Annual effective discount rate (%) ÷ 100)) ^ (Year of first payment − 1)))
(((100 × 1,000) ÷ (10 − 5)) ÷ ((1 + (10 ÷ 100)) ^ (2 − 1))) = 18,181.818182
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 |
|---|---|---|---|---|---|
| First payment | 1,000 | 1,100 | Perpetuity present value | 18,181.818182 | 20,000 |
| Annual effective discount rate (%) | 10% | 11% | Perpetuity present value | 18,181.818182 | 15,015.015015 |
| Annual payment growth (%) | 5% | 6% | Perpetuity present value | 18,181.818182 | 22,727.272727 |
| Year of first payment | 2 | 3 | Perpetuity present value | 18,181.818182 | 16,528.92562 |
