Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- 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
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Formula of Deferred Annuity (Table of Contents)**

## What is Deferred Annuity Formula?

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 done 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 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 done 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

### Explanation of the Deferred Annuity Formula

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

**Step 1:** Firstly, ascertain the annuity payment and confirm whether the payment will be done 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**

4.9 (927 ratings)

**Step 4:** Next, determine the period of payment deferment and it is denoted by t.

**Step 5: **Finally, the formula for a deferred annuity can be derived using ordinary annuity payment (step 1), effective rate of interest rate (step 2), 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 done 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.

**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.

**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 formula for a deferred annuity can be derived using annuity payment due (step 1), effective rate of interest rate (step 2) 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]**

### Example of Deferred Annuity Formula (with 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 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 Ordianry Due**

Therefore, the deferred annuity can be calculated using the above formula as,

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

**Deferred Annuity will be –**

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

Therefore, the deferred annuity can be calculated using the above formula as,

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

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 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.

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

### Recommended Articles

This has been a guide to Deferred Annuity Formula. Here we discuss 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 –

- Calculate Present Value of an Annuity
- Compare Annuity vs Perpetuity
- Compare Annuity vs Pension
- Compare Annuity vs Lump Sum

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply