WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Perpetuity

Perpetuity

By Sayantan MukhopadhyaySayantan Mukhopadhyay | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

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 –

PV of Perpetuity  = D/R

PV of perpetuity formula

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 –

PV of Perpetuity = ∞∑n=1 D/(1+r)n

Here n = time period

Perpetuity Example

You can download this Perpetuity Excel Template here – Perpetuity Excel Template

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?

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • 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.

Concept-wise, 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 =
D
=
R
0
= 0
0

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.

excel example

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 –

  • Formula of Time Value of Money
  • Calculate Simple Interest
  • Time Value of Money
  • NPV vs XNPV
7 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Perpetuity Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More