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

**Maturity Value (Table of Contents)**

## Maturity Value Definition

Maturity value is defined as the amount which is due and is payable to the person who is holding a financial obligation as of the date of maturity of the obligation. To calculate the maturity value or the maturity amount for the investments which are made by the investor, they need to sum up all of the compounding interest which they have earned over the period to the initial or the principal amount invested.

### Maturity Value Formula

The Formula for calculation of Maturity Value is as per below:

**MV = P * ( 1 + r )**

^{n}Where,

- MV is the Maturity Value
- P is the principal amount
- r is the rate of interest applicable
- n is the number of compounding intervals since the time of the date of deposit till maturity

### Explanation

The formula that is used for calculation of Maturity value involves use of principal amount that is the amount which is invested at the initial period and n is the number of periods for which the investor is investing in and r is the rate of interest that is earned on that investment.

When one takes frequency of compounding as a power to rate it get multiples which is nothing but compounding and then when that result is multiplied by principal amount, one gets the maturity value that one can have.

### Maturity Value Formula Examples (with Excel Template)

Let’s see some simple to advanced examples of Maturity Value Formula to understand it better.

#### Example #1

**Mr. A invested 100,000 in bank fixed deposit at ABC bank ltd. ABC bank ltd. pays 8.75% compounded annually. Calculate the maturity amount that Mr. A will get provided he invests for 3 years.**

**Solution:**

Mr. A has invested in fixed deposit for 3 years and since it’s compounded annually, n will be 3, P is 100,000 and r is 8.75%.

4.9 (1,067 ratings)

So, the calculation of Maturity Value is as follows,

- MV
**=**100,000 * ( 1 + 8.75% )^{3} - MV = 100,000 * (1.286138672)

Maturity Value will be –

- MV = 128,613.87

#### Example #2

**John Bradshaw a high net worth individual and has invested 60% of his investments in equities and now he is of the view that market will go down in coming future and hence he wants to temporarily invest funds in debt to avoid risk and hence he is considering investing in CD which is abbreviation for Certificate of Deposit.**

**Vista limited has issued CD which states it will pay 9% interest that will be compounded monthly. Now suppose that Mr. John has invested 30% of his investments which is $150,000 for 2 years. Calculate the maturity amount that Mr. John will receive at the end of 2 years.**

**Solution:**

Mr. John has invested in Certificate of Deposit for 2 years and since it is compounded monthly, n will be 2 x 12 which is 24, P is $150,000 and r is 9.00% which p.a. and hence monthly rate will be 9/12 which is 0.75%.

So, the calculation of Maturity Value is as follows,

- MV = $150,000 * ( 1 + 0.75%)
^{24} - = $150,000 * (1.196413529)

**Maturity Value will be –**

- MV = $179,462.03

Hence, Mr. John will receive $179,462.03 at end of 2 years.

#### Maturity Value Formula – Example #3

**Carol is 45 years old women working as a manager in an MNC located in New York. She is considering a retirement plan which was proposed to her by an investment advisor who advises her to invest a lump sum amount of $1,000,000 in his guaranteed retirement plan until she retires at the age of 60. He advises she would receive a lump sum amount of $3,744,787.29 and that plan appears to her to be lucrative. However, the investment advisor told her that it compounds quarterly and the rate of return she would earn will be 12%. **

**However, she is not convinced with the rate of return that he says she would earn. You are required to calculate the rate of return that she will earn on this investment using the maturity value formula and advise whether the investment advisor has made a correct statement, or he has bluff about the return?**

**Solution:**

Carol will invest in the guaranteed retirement plan for 15 years which is the time left until she retires at age of 60 and since it’s compounded quarterly, n will be 15*4 which is 60, P is $1,000,000 and r we need to find out and here we are given the maturity value as $3,744,787.29

We can use below formula of maturity value and plug in the figures and arrive at the interest rate.

MV = P * ( 1 + r )^{n}

- 3,744,787.29 = 1,000,000 x ( 1 + r )
^{(60)} - 3.74478729 = (1 + r)
^{60} - r = (3.7447829 – 1)
^{1/60}

So, Quarterly Rate of Interest will be –

- r = 2.23% quarterly

The yearly rate of interest will be –

- r (yearly)= 2.23 x 4
- = 8.90% p.a.

Hence, the statement made by an investment advisor that she will earn 12% is incorrect.

### Maturity Value Calculator

You can use the following Maturity Value Calculator.

P | |

r | |

n | |

MV | |

MV = P * (1 + r)^{n} |

0 * (1 + 0)^{0} = 0 |

### Relevance and Uses

It’s important for them to be able to calculate the maturity value of a note so that they can know how much a firm or the company or the business will have to pay when the note shall come due. Investment advisors use this formula to advise clients on the spot of the scheme they are selling and like how much amount will they have in hand.

A salaried person uses to calculate the fixed deposit they make with the banks in which they have their salaried accounts. The formula can be used to calculate reverse interest rate when one has maturity value to know the true rate of interest earned on the investment as we did in our last example.

You can download this Maturity Value Formula Excel Template from here – Maturity Value Formula Excel Template

### Recommended Articles

This has been a guide to what is Maturity Value & its definition. Here we discuss how to calculate Maturity Value using its formula along with examples and downloadable excel template. You can learn more about financial modeling from the following articles –

- What is Compound Interest?
- Definition of Compounding
- Daily Compound Interest Calculations
- CAGR Formula Calculations
- Compare Simple Interest vs Compound Interest
- Continuous Compounding Examples

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