WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Compounding

Compounding

Compounding Definition

Compounding is the method of computing interest rate which is effectively interest on interest where interest is calculated on investment/initial principal plus interest earned and other reinvestments, in other words interest earned is accumulated to the principal amount depending on the time period of deposit or loan that can be monthly, quarterly or annually

Let’s try to understand what is compounding and how it’s work through some basic examples

Top 4 Examples of Power of Compounding

You can download this Compounding Examples Excel Template here – Compounding Examples Excel Template

Example #1

Shane and Mark both decided to invest $1,00,000, but Shane decided to invest in simple interest, whereas Mark invests in compound interest for ten years at 10% interest. Let see what happens after ten years.

Solution:

So, the calculation of Shane investment will be –

Compounding Example 1

Total Earning Amount = $200,000

With a Simple interest, Shane will get $2,00,000 after 10 years.

The calculation of mark investment will be –

Compounding Example 1.1

Total Earning Amount = $2,59,374

With Compound interest, Mark’s investment values will grow to $2,59,374.

Now Shane decided to invest through compounding methods like Mark, and they both invested $2,00,000 at the rate of 15%.

The calculation of Shane investment will be –

Compounding Example 1.2

Total Earning Amount = $8,09,111.55

Shane stays invested for 10 years and gets the final amount as $8,09,111.55 at the rate of 15%.

The calculation of mark investment will be –

Compounding Example 1.3

Total Earning Amount = $65,83,790.52

However, Mark is patience long-term investors and stays invested for 25 years, and his investment value grows to $65,83,790.52

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

The above example shows the power of compounding. The longer the investment horizon, the greater is the exponential growth.

Example #2 (Weekly)

Simon is having $7500 in savings, and for his son’s college fund, who will be going to attend the college after 15 years, he decided to invest in US Savings Bonds. Simon’s goal is to save $20,000, and the annual percentage rate for a US saving bond is 6%. What is the Future Value of Simon Money after 15 years?

Solution:

Given,

  • Principal = $7500
  • Rate = 6% or 0.06
  • Time Period = 15 years.
  • How many times it’s compounded in a year n = 52 Weeks
  • Future Value =?

So, the calculation of future value will be –

Calculation 2

The formula for weekly compounding is as below.

F = P(1+r/n)^n*t
  • F = $7500(1+0.06/52)^52*15
  • F = $7500(1+0.001153846)^780
  • F = $18,437.45

So from the above calculation, it is clear that Simon’s goal to save $20,00 will not get achieved with the above methods, but it’s closer to that.

Continuous Compounding Method

Now let’s try the above example with Continuous Compounding Formula.

So, the calculation of future value will be –

Calculation 2.1

F = Pe^r*t
  • F = $7500e^0.06*15
  • F = $7500e^0.9
  • Future Value (F)= $18,447.02

Now even with Continuous Compounding, Simon’s goal of savings $20,000 for his son’s college fund will not be achieved.

Let’s see with Monthly compounded Formula that how much money did Simon need to invest to achieve his goal of saving $20,000 in 15 years at with an APR of 6%?

So, the calculation of future value will be –

Calculation 2.2

F = P(1+r/n)^n*t
  • $20,000 = P(1+0.06/12)^12*15
  • P = $20,000/(1+0.06/12)^12*15
  • Principal (P) = 8149.65

So by Solving the above equation, we will get an answer that is $8,149.65 (Amount, which Simon needs to invest to achieve his goal of saving $20,000 in 15 years).

Example #3 (Effective Annualized Yield)

Let’s Say XYZ limited bank gives 10% per annum to Senior citizens for fixed deposit, and we assume here that bank interest is quarterly compounded like all other banks. Calculate the effective annualized yield for 5, 7, and 10 years.

Solution:

Annualized Yield for 5 Years:
  • t = 5 years
  • n = 4 (quarterly compounded)
  • I = 10% per annum

So A = (1+10%/100/4)^ (5*4)

  • A = (1+0.025)^20
  • A = 1.6386
  • I = 0.6386 in 5 Years

Effective Interest = 0.6386/5

Effective I = 12.772% Per Annum

Annualized Yield for 7 Years:
  • t = 7 years
  • n = 4 (quarterly compounded)
  • I = 10% per annum

So A = (1+10%/100/4)^ (7*4)

  • A = (1+0.025)^28
  • A = 1.9965
  • I = 1.9965 in 7 Years
  • Effective I = 0.9965/7

Effective I = 14.236% Per Annum

Annualized Yield for 10 Years:
  • t = 10 years
  • n = 4 (quarterly compounded)
  • I = 10% per annum

So A = (1+10%/100/4)^ (10*4)

  • A = (1+0.025)^40
  • A = 2.685
  • I = 1.685 in 10 Years
  • Effective I = 1.685/10

Effective I = 16.85% Per Annum

Example #4 – (Annuities: Future Value)

$1,000 is invested every 3 months at 4.8% per annum compounded quarterly. How much will the Annuity be worth in 10 years?

Solution:

So when we say how much will the Annuity be worth in 10 years means here we have to find future value, and this important because whenever there is an example on annuities, we have to see what we have to find out.

So, the formula of Future Value is

FV of Annuity = P [ (1+ r)n – 1 / r ]
  • P = Periodic Payment
  • r = Rate per period
  • n = Number of periods

So the formula of Future Value is

  • So here P = $1,000
  • r = 4.8% Per Annum or 0.048
  • r (quarterly) = 0.048/4
  • r (quarterly) = 0.012
  • n = 10 years
  • n (Number of times compounding will apply) = 10×4 =40

So, the calculation of FV of Annuity will be –

Calculation 4

So now FV = $1000[1+0.012]^40 -1/0.012]

So by Solving the above equation will get an FV of $50,955.30

So how much will be the Annuity in 10 years and answer is $50,955.30

As additionally, we can also find out from the above example that how much interest is earned in 10 years.

As 40 times $1000 is invested that is a total investment (40×$1000 = $40,000).

So Interest = Future Value – Total investment

  • Interest = $50,955.30 – $40,000
  • Interest = $10,955.30

So here, it is important to understand that in Annuities, investors can earn a lot of interest. In the above particular examples, a deposit of $40,000 gives, in return, a total interest of $10,955.30.

Note: You can download the Excel template provided Above for detailed calculation.

Recommended Articles

This has been a guide to what is Compounding & its definition. Here we understand the power of compounding with the help of practical examples. You may learn more about accounting from the following articles –

  • Compounding Formula
  • Compound Interest Calculation
  • Daily Compound Interest Calculation
  • Simple Interest vs Compound Interest
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 >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

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

WallStreetMojo

Free Investment Banking Course

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

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

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

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Compounding Examples Excel Template

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