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

**Compounding Formula (Table of Contents)**

### What is Compounding Formula?

Compounding can be considered an amount of interest that is earned on an investment or on an account where the interest is also reinvested. The formula for compounding is represented as below

**C = P [ (1+r)**

^{n}– 1 ]Where,

- C is the compound interest
- P is the principal amount
- r is the rate of interest
- n is the number of periods

### Explanation of the Compounding Formula

The formula is very useful and is powerful when one wants to calculate compound interest. This equation takes into consideration the principal amount, the rate of interest, the frequency at which it shall pay an interest rate. The equation in itself compounds the interest amount which is earned and reinvested. This gives the effect of multiplication and the amount grows more than what growth it achieved in the earlier years. Hence, this is more powerful than the simple interest which only pays with the same amount of interest every year.

### Examples of Compounding Formula (with Excel Template)

Let’s see some simple to advanced examples of the compounding formula to understand it better.

#### Example #1

**Mr. V deposited $100,000 in HFC bank for a period of 2 years and the bank pays 7% interest which is compounded annually. You are required to compute the compounded interest amount.**

**Solution**

** **All of the variables that are required in the formula are given, hence we can use the above formula to calculate compound interest.

Use the below data for calculation of compound interest.

Therefore, calculation of compound interest can be done using the above formula as,

4.9 (1,067 ratings)

- = 100,000 [ (1+7%)
^{2}– 1 ] - = 100,000 [ (1.07)
^{2}– 1 ]

**Compound Interest will be –**

**Compound Interest = 14,490.00**

Hence, the amount of interest will be 14,490 on the amount invested.

#### Example #2

**KBC bank has just launched a new product to compete with the existing market product. They believe this would be the winning game for them. Below are the details of both of the schemes. Mr. W was interested to invest in New Scheme as he was shown by the bank that the interest amount he would earn at maturity would be 37,129.99 and 52,279.48 on the existing scheme and a new scheme. You are required to validate the statement made by the banker.**

**Solution**

Here, we need to do a comparison of the schemes and Mr. W will surely get lured by seeing the difference of interest earned. But, however, there is a mismatch in a number of years and hence cannot be compared to the interest of 37,129.99 verses 52,279.48 as one is for 4 years and the other one is for 5 years. Hence, we will calculate compound interest for 4 years using the below formula.

**Existing Scheme**

Therefore, the calculation of compound interest for the existing scheme can be done as follows,

- = 100,000 [ (1+(7.92%/12))
^{(4*12)}– 1 ] - = 100,000 [ (1.0198)
^{48}– 1 ]

**Compounding Interest of Existing Scheme will be –**

**Compound Interest = 37,129.99**

**New Scheme**

Therefore, calculation of compound interest for the new scheme can be done as follows,

- = 100,000 [ (1+(8.50%/4)
^{(5*4)}– 1 ] - = 100,000 [ (1.02125)
^{48}– 1 ]

**Compounding Interest of New Scheme will be –**

**Compound Interest = 52279.48**

As we can see the difference is not that much major, but as we can see the difference is of approx. 15149.5 and further, there is one year more of the lock-in period. Hence, it’s up to Mr. W whether he requires funds in 4 years and then he can go for the existing scheme and it appears that the bank is luring customers by displaying such a high value of interest difference and lock funds with bank for one more year.

#### Compounding Example #3

**Mr. Vince is interested in purchasing the house but he does not want to take a loan burden. He learns about Mutual fund in an advertisement and he is keen to know that on an average the return on a mutual fund is 10-12% if kept invested for 10 years or more. The house that he wants to purchase is valued at 5,000,000. Hence, he approaches financial advisors to know what amount he should invest every month in order to reach the goal. The financial advisor takes 11.50% as an annual interest rate compounding monthly and considers staying invested for 12 years one-time investment of 1,700,000. You are required to compute the income earned on the investment if Mr. Vince stays invested for 12 years.**

**Solution**

We are given all the details here, and we can use the below formula to calculate the income that will be derived by investing 10,000 monthly for 12 years at a rate of 11.50% compounded monthly.

Use the below data for calculation of compound interest.

Therefore, calculation of compound interest can be done using the above formula as,

- = 1,700,000 [ (1+(11.50%/12)
^{(12*12)}– 1 ] - = 1,700,000 [ (1.02125)
^{144}– 1 ]

**Compound Interest will be –**

**Compound Interest= 50,13,078.89**

Hence, if Mr. Vince stays invested for 12 years he would be able to reach his goal of buying the house assuming he earns 11.50%.

### Relevance and Uses

The compound interest formula is used in many instances like for calculating recurring fixed deposit income, mutual fund returns, also in capital markets like in growth in sales, profit, etc. by financial analysts. The formula looks simple, but the effect it has is very large in the longer term. Many of the banks use compounding in their housing loans, vehicle loans, education loans which are the major chunk of the revenue sources. The power of compounding can make one wealthy in the long term.

### Recommended Articles

This has been a guide to Compounding Formula. Here we discuss step by step how to calculate compound interest using its formula along with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –

- Formula of Continuous Compounding
- Calculate Compound Interest Formula in Excel
- Calculate Daily Compound Interest
- Formula of CAGR

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