WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Deferred Annuity Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate Present Value of Deferred Annuity

Deferred annuity formula is used to calculate the present value of the deferred annuity which is promised to be received after some time and it is calculated by determining the present value of the payment in the future by considering the rate of interest and period of time.

An annuity is the series of periodic payments received by an investor on a future date, and the term “deferred annuity” refers to the delayed annuity in the form of installment or lump-sum payments rather than an immediate stream of income. It is basically the present value of the future annuity payment. The formula for a deferred annuity based on an ordinary annuity (where the annuity payment is made at the end of each period) is calculated using ordinary annuity payment, the effective rate of interest, number of periods of payment, and deferred periods.

Deferred Annuity Formula

Deferred Annuity based on an ordinary annuity, is represented as,

Deferred Annuity = P Ordinary * [1 – (1 + r)-n] / [(1 + r)t * r]

where,

  • P Ordinary = Ordinary annuity payment
  • r = Effective rate of interest
  • n = No. of periods
  • t = Deferred periods

The formula for a deferred annuity based on annuity due (where the annuity payment is made at the start of each period) is calculated using annuity payment due, effective rate of interest, a number of periods of payment, and deferred periods.

Deferred Annuity based on annuity due, is represented as,

Deferred Annuity = P Due * [1 – (1 + r)-n] / [(1 + r)t-1 * r]

where

  • P Due = Annuity payment due
  • r = Effective rate of interest
  • n = No. of periods
  • t = Deferred periods

Deferred Annuity Calculation (Step by Step)

The formula for deferred annuity using ordinary annuity can be derived by using the following steps:

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
  • Step 1: Firstly, ascertain the annuity payment and confirm whether the payment will be made at the end of each period. It is denoted by P Ordinary.
  • Step 2: Next, calculate the effective rate of interest by dividing the annualized rate of interest by the number of periodic payments in a year and it is denoted by r. r = Annualized rate of interest / No. periodic payments in a year
  • Step 3: Next, calculate the total number of periods, which is the product of a number of years and number of periodic payments in a year, and it is denoted by n. n = No. of years * No. of periodic payments in a year
  • Step 4: Next, determine the period of payment deferment, and it is denoted by t.
  • Step 5: Finally, the deferred annuity can be derived using ordinary annuity payment (step 1), an effective rate of interest rate (step 2), a number of periods of payment (step 3), and deferred periods (step 4), as shown below.

Deferred Annuity = P Ordinary * [1 – (1 + r)-n] / [(1 + r)t * r]

The formula for deferred annuity using annuity due can be derived by using the following steps:

  • Step 1: Firstly, ascertain the annuity payment and confirm whether the payment will be made at the start of each period. It is denoted by P Due.
  • Step 2: Next, calculate the effective rate of interest by dividing the annualized rate of interest by the number of periodic payments in a year, and it is denoted by r. i.e., r = Annualized rate of interest / No. periodic payments in a year
  • Step 3: Next, calculate the total number of periods, which is the product of the number of years and number of periodic payments in a year, and it is denoted by n. i.e., n = No. of years * No. of periodic payments in a year
  • Step 4: Next, determine the period of payment deferment, and it is denoted by t.
  • Step 5: Finally, the deferred annuity can be derived using annuity payment due (step 1), the effective rate of interest rate (step 2), the number of periods of payment (step 3), and deferred periods (step 4) as shown below.

Deferred Annuity = P Due * [1 – (1 + r)-n] / [(1 + r)t-1 * r]

Examples

You can download this Deferred Annuity Excel Template here – Deferred Annuity Excel Template

Let us take the example of John, who got a deal to lend $60,000 today, and in return, he will receive twenty-five annual payments of $6,000 each. The annuity will start five years from now, and the effective rate of interest will be 6%. Determine whether the deal is a feasible one for John if the payment is an ordinary annuity and annuity due.

  • Given, P Ordinary = $6,000,000
  • r = 6%
  • n = 25 years
  • t = 5 years

Calculation of Deferred Annuity if payment is Ordinary Due

Deferred Annuity Formula Example 1

Therefore, the deferred annuity can be calculated as,

Deferred Annuity Formula Example 1.1jpg

  • Deferred Annuity = $6,000 * [1 – (1 + 6%)-25] / [(1 + 6%)5 * 6%]

Deferred Annuity will be –

Deferred Annuity Formula Example 1.2jpg

Deferred Annuity = $57,314.80 ~ $57,315

n this case, John shouldn’t lend the money as the value of the deferred annuity is less than $60,000.

Calculation of Deferred Annuity if payment is Annuity Due

  • Given, P Due = $6,000,000
  • r = 6%
  • n = 25 years
  • t = 5 years

Example 2

Therefore, the deferred annuity can be calculated as,

Example 2.1jpg

  • Deferred Annuity = $6,000 * [1 – (1 + 6%)-25] / [(1 + 6%)5-1 * 6%]

calculate Deferred Annuity Example 2.2jpg

Deferred Annuity = $60,753.69 ~ $60,754

In this case, John should lend the money as the value of the deferred annuity is more than $60,000.

Relevance and Uses

From the perspective of an investor, deferred annuities are mainly useful for the purpose of tax deferral of earnings because of a lack of restrictions on the amount of its annual investment coupled with the guarantee of the lifelong source of income. However, one of the major drawbacks of an annuity is that its gains are taxed at the ordinary income tax rate, which is higher than the long-term capital gains tax rate.

Recommended Articles

This has been a guide to Deferred Annuity Formula. Here we learn how to calculate the Deferred Annuity for due and ordinary payment along with the practical examples and downloadable excel sheet. You can learn more about financing from the following articles –

  • Annualized Rate of Return
  • What is Tax-Deferred Annuity?
  • Annuity vs Perpetuity
  • Simple Random Sampling
0 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 Deferred Annuity Excel Template

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