• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Financial Modeling

          • What is Financial Modeling
          • Financial Modeling Excel
          • Financial Model Types
        • Excel Modeling

          • Financial Functions Excel
          • Sensitivity Analysis in Excel
          • Time Value of Money
        • Excel-Modeling
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment-Banking-Guides
        • Excel

          • Excel Functions
          • Excel Charts
          • Excel Tips
        • Excel
        • Others

          • Resources (A to Z)
          • Accounting
          • Financial Statement Analysis
          • Equity Research
          • Private Equity
          • Corporate Finance
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Financial Modeling Course

          Financial-Modeling-Course
        • Investment Banking Course

          Investment-Banking-Training
        • Others

          • M&A Modeling Course
          • LBO Modeling Course
          • Valuation Modeling Course


          • PE Modeling Course
          • VC Modeling Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Compound Interest

Home » Financial Modeling » Excel Modeling » Compound Interest

By Harshada Khot Leave a Comment

Compound Interest

What is Compound Interest?

The addition of the interest to the principal amount of the loan or the deposit, or rather say the interest on the interest is known as the Compound Interest. It is basically the outcome of reinvesting the interest and not paying it so that the interest is earned in the next period on the principal sum in addition to the formerly accumulated interest.

In simple terms, calculation of Compound interest is done on the amount borrowed and previous interest if any. It is very much standard in economics and finance. It is contrasted with the simple interest in which formerly accumulated interest is not included in the principal sum of the current period and hence, there is no such compounding here.

Compound Interest Formula

Below is the formula for compounding interest calculation.

A = P (1 + r/n) (nt)

Where,

  • A = Future value of loan/investment, including the interest
  • P = Principal investment amount i.e. the loan amount or the initial deposit
  • r = Interest rate annually
  • n = Number of times the interest is being compounded per unit
  • t = Time period for which amount is borrowed or invested

Example of Compound Interest Calculation

In this example, X did the investment of $ 7,000 initially for a period of 3 years. Calculate the value of the investment after the period of 3 years when the investment gives the return of 10 % compounded monthly.

Solution:

For the calculating value of the investment after the period of 3 years compound interest formula will be used:

Popular Course in this category
Cyber Monday Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) 250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,067 ratings)
Course Price

View Course

Related Courses
M&A Modeling CourseLBO Modeling CourseValuation Modeling Course
A = P (1 + r / n) nt

Given,

  • A (Future value of the investment) is to be calculated
  • P (Initial value of investment) = $ 7,000
  • r (rate of return) = 10% compounded annually
  • n (number of the times compounded annually) = 1
  • t (number of years for which investment is done) = 3 years

Now, Calculation of Compound Interest will be –

Compound Interest Example 1.1

  • A = $ 7,000 (1 + 0.10 / 1) 1*3
  • A = $ 7,000 (1 + 0.10) 3
  • A = $ 5,000 (1.10) 3
  • A = $ 7,000 * 1.331
  • A = $ 9,317

Thus it shows that the value of the initial investment of $ 7,000 after the period of 3 years will become $ 9,317 when the return is 10 % compounded annually.

Types of Compound Interest

It usually consists of two types:

Types of Compound Interest

#1 – Periodic Compounding

In this method, the rate of interest is applied at regular intervals and then generated. This amount of interest is then added to the principal. Periods can be weekly, monthly, annually or half-yearly.

#2 – Continuous Compounding

In this continuous compounding method, a formula based on the natural log is used that calculates the interest at the smallest possible time period. Here, the interest is included back to the principal. It can be leveled to a constant rate of growth for all-natural growth. The figure was discovered from physics. This uses the Euler’s number that is the famous irrational number known to more than 1 trillion digits of accuracy. Letter “E” is used to denominate the Euler’s number.

Pros

  • Increase in Value of Investment Exponentially – In the long run, the value of the investment increases exponentially. The interest is earned by the investor on principal as well as previously earned interest part of the investment so the investment in case of compound interest grows quickly depending on the rate of return and number of the compounding periods. It represents mainly the addition of the interest amount to the deposit.
  • Accumulation of Better Returns – Mainly there are two types of interest that include simple and compound interest. The investment in case of compound interest accumulates better return when compared with the simple interest as in case of simple interest, interest is paid on the principal amount only that one has invested initially whereas in case of compound interest is paid on both the principal amount and interest giving interest on previously earned interest as well.

Cons

The main reason for the increase in the overall loan amount payment is because of the compound interest because one has to pay interest on principal as well as interest payment until and unless the whole of the money has been repaid. With the time if any interest amount remains unpaid, then the interest is to be paid on that remaining unpaid interest as well which created the vicious cycle for the borrower of the loan.

Important Points

  • While doing the calculation of compound interest, the number of the compounding period should be correctly used as it makes a significant difference. Generally when the compounding periods are more, then the compounding interest will also be more. So, before starting any calculation with respect to compound interest, compounding periods should be correctly taken into consideration.
  • As the compounding is used in many areas including the loans, the borrower should know its annual payment rate exactly as the number of the compounding periods and the method of the calculation can have a serious impact on the monthly payments.
  • It generally works in favor when the investment is considered while it works negatively from the borrowers perspective, but sometimes it works in favor of borrowers as well like instead of making the mortgage loan payment fully in a month, if the same is paid twice in a month, then it will cut down the amortization period thereby saving interest amount.

Conclusion

One should have proper knowledge of the concept of compound interest because it helps the person in making better financial decisions and saving a good amount of money. Compound interest formula is one of the very useful tools for the calculation of the future value of an investment, rate of investment, etc using the other available information. The interest under compound interest is earned by the investor on principal as well as previously earned interest part of the investment, so the investment in case of compound interest grow quickly depending on the rate of return and number of the compounding periods of the particular investment.

Recommended Articles

This has been a guide to what is Compound Interest and its definition. Here we discuss compound interest formula and calculation along with practical examples. You can learn more about excel modeling from the following articles –

  • Bond Premium
  • Advantages of Premium Bond Amortization
  • Exponential Distribution Definition
  • Power of Compounding 
  • Monthly Compound Interest Calculation
  • Daily Compound Interest Calculation
  • Simple Interest vs Compound Interest
  • CAGR Formula
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 >>

Filed Under: Excel Modeling, Financial Modeling

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. 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

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Download Colgate's Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

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