Financial Modeling Tutorials

- 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
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- 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
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- 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)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- 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
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- 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
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

**Future Value of Annuity Due Formula – Table of Contents**

## What is the Future Value of Annuity Due Formula?

The term “future value of an annuity” refers to the future value of the string of consecutive and equal payments that are likely to be made in the future. Further, annuity due indicates that the payments are done at the beginning of the time period. The formula for the future value of an annuity due is calculated based on periodic payment, number of periods and effective rate of interest. Mathematically, it is represented as,

**FVA**

_{Due}= P * [(1 + r)^{n}– 1] * (1 + r) / rwhere FVA _{Due} = Future value of an annuity due

- P = Periodic payment
- n = Number of periods
- r = Effective rate of interest

### Brief Explanation

The formula to calculate the future value of an annuity due can be derived by using the following steps:

**Step 1:** Firstly, figure out the payments that are to be paid in each period. Please keep in mind that the above formula is applicable only in the case of equal periodic payments It is denoted by P.

**Step 2:** Next, figure out the rate of interest to be charged on the basis of the prevalent market rate. It is the rate of interest to be received by the investor if the money is invested in the market. To get the effective rate of interest, divide the annualized rate of interest by the number of periodic payments in a year. It is denoted by r.

**r = Annualized rate of interest / Number periodic payments in a year**

**Step 3: **Next, the total number of periods is computed by multiplying the number of periodic payments in a year and the number of years. It is denoted by n.

4.9 (1,067 ratings)

**n = Number of years * Number of periodic payments in a year**

**Step 4:** Finally, the formula for future value of an annuity due is calculated based on periodic payment (step 1), effective rate of interest (step 2) and a number of periods (step 3) as shown above.

**Examples of Future Value of Annuity Due Formula (with Excel Template)**

Let’s see some simple to advanced examples of FV of Annuity Due Formula to understand it better.

#### Example #1

**Let us take the example of John Doe who plans to deposit $5,000 at the beginning of each year for the next seven years to save enough money for his daughter’s education. Determine the amount that John Doe will have at the end of seven years. Please note that the ongoing rate of interest in the market is 5%.**

Calculate the FV of annuity due for the Periodic Payment using above given information,

FV of Annuity _{Due} Formula= P * [(1 + r)^{n} – 1] * (1 + r) / r

= $5,000 * [(1 + 5%)^{7} – 1] * (1 + 5%) / 5%

**Future Value of Annuity Due will be –**

= $42,745.54 ~ *$42,746*

Therefore, after seven years John Doe will have $42,746 to spend for his daughter’s education.

#### Example #2

**Let us take another example of Nixon plans to accumulate enough money for his MBA. He decides to deposit a monthly payment of $2,000 for the next four years (beginning of each month) so that he is able to gather the required amount of money. As per the education counselor, Nixon will require $100,000 for his MBA. Check if Nixon’s deposits will fund his plans for MBA considering the ongoing rate of interest being charged by a bank is 5%.**

Given,

- Monthly payment, P = $2,000
- Effective rate of interest, r = 5% / 12 = 0.42%
- Number of periods, n = 4 * 12 months = 48 months

Calculate the FV of Annuity Due for monthly payment using the above given information,

= $2,000 * [(1 + 0.42%)^{48} – 1] * (1 + 0.42%) / 0.42%

**Future value of Monthly Payment will be –**

FV of Annuity _{Due} Formula = $106,471.56 ~ $106,472

So, with planned deposits, Nixon is expected to have $106,472 which more than the amount ($100,000) required for his MBA.

### Relevance and Uses

The future value of an annuity due is another expression of the time value of money, the money received today can be invested now that will grow over the period of time. One of the striking applications of the future value of an annuity due is in the calculation of the premium payments for a life insurance policy. It also finds application in the calculation of provident fund where the monthly contribution from the salary acts as the periodic payment. The future value of annuity grows based on the stated discount rate, as such the higher discount rate the higher will be the future value of the annuity.

### Recommended Articles

This has been a guide to Future Value of Annuity Due. Here we discuss how to calculate Future Value of Annuity Due using its formula along with some practical examples and downloadable excel template. You may learn more about Financial Modeling from the following articles –

- Formula to Calculate Tax Deferred Annuity
- Formula of Deferred Annuity
- PV of an Annuity
- Annuity vs Pension – Compare
- Annuity vs Lump Sum – Compare

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion