What is Perpetuity?
Perpetuity, most commonly used in accounting and finance, means that a business or an individual who receives constant cash flows for an indefinite period of time (like an annuity that pays forever) and according to the formula, its present value is calculated by dividing the amount of the continuous cash payment by the yield or interest rate.
Perpetuity Formula
The present value of perpetuity can be calculated as follows –
Here. PV = Present Value, D = Dividend or Coupon payment or Cash inflow per period, and r = Discount rate
Alternatively, we can also use the following formula –
Here n = time period
Perpetuity Example
Smith has invested in a bond that pays him coupon payment for an infinite period of time. This bond pays Smith $100 every year. If we assume that the discount rate is 8%, how much Smith should pay for this bond?
 First of all, we know that the coupon payment every year is $100 for an infinite amount of time.
 And the discount rate is 8%.
 Using the formula, we get PV of Perpetuity = D / r = $100 / 0.08 = $1250.
For a bond that pays $100 every year for an infinite period of time with a discount rate of 8%, the perpetuity would be $1250.
Interpretation of Perpetuity
The very potent query would be why we should find out the present value of a perpetuity. Actually, every firm has a projected cash flow that may get realized after 2, 5, 10 years.
For an investor to be interested in the firm, she needs to know the present value of that future cash flow. Perpetuity is one sort of annuity that pays forever.
Conceptwise, it may seem a bit illogical; but it happens in the case of bonds issued by the British government. If an investor invests in this special sort of bond, she will receive an infinite amount of cash flows at the end of each period. But it may have a finite present value. To find out where an investor will receive, we can use the formula of perpetuity. And we need to know the present value of future cash flows to be accurate.
Use and Relevance
 In the case of preferred shareholders, they receive preferred dividends before equity shareholders are paid. And preferred dividends are fixed. That’s why we can use this formula to find out the present value of these preferred dividends.
 In finance, valuation methodologies are used to find out the valuation of a business. One of these valuation methodologies is the dividend discount model. This formula is also used in the dividend discount model.
Perpetuity Calculator
You can use the following calculator.
D  
R  
PV of Perpetuity Formula =  
PV of Perpetuity Formula = 


Perpetuity Calculation in Excel (with excel template)
Let us now do the same perpetuity example in Excel. This is very simple. You need to provide the two inputs of Dividend and Discount Rate. You can easily calculate the ratio in the template provided.
Recommended Article
This has been a guide to Perpetuity and its meaning. Here we learn how to calculate PV of perpetuity using its formula along with examples and a downloadable excel template. Learn more from the below articles –