Financial Modeling Tutorials
- Financial Modeling Basics
- What is Financial Modeling?
- Financial Modeling in Excel
- Types of Financial Models
- Financial Modeling Interview Questions
- Alibaba IPO Financial and Valuation Model
- Box IPO Modeling Details
- Box IPO Valuation Model
- Download Alibaba IPO Financial Model
- Financial Modeling Books
- Financial Modeling Templates
- Financial Modeling Course
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Internal Rate of Return (IRR)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Mortgage APR vs Interest Rate
In accounting, the perpetuity means which goes on for an indefinite period of time. In finance, perpetuity means that the business or the individual would receive a constant flow of equal amount of cash with no end.
In the UK, a bond is issued which has perpetuity inherent within. These British-issued bonds are called “Consols”.
Let’s look at the formula of perpetuity.
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
Let’s take a practical perpetuity example to understand formula of perpetuity.
Smith has invested into a bond that pays him coupon payment for the 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?
This perpetuity example is a classic case of perpetuity.
We will use the formula to solve this perpetuity example.
- 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.
Explanation of Perpetuity Formula
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.
Concept-wise, it may seem 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 the 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 of Perpetuity Formula
Since we find out the present value of a perpetuity, the payment remains equal; but the value of perpetuity changes along the way.
The same concept is used in the following.
Here are the uses of perpetuity formula –
- As mentioned above, if there’s any bond like Consols, the formula of perpetuity is used to find out the present value.
- 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 the formula of perpetuity 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. In dividend discount model also, formula of perpetuity is also used.
You can use the following formula of perpetuity Calculator
|PV of Perpetuity Formula =||
Perpetuity Formula 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.
You can download this Perpetuity template here – Perpetuity Excel Template
This has been a guide to Perpetuity formula, its uses along with practical perpetuity example. Here we also provide you with Perpetuity Calculator with downloadable excel template. Learn more from below articles –