EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Compounding Formula
 

Compounding Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 26, 2023

Compounding Formula

 

 

Compounding Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is a Compounding Formula?

The term “compounding” refers to the accumulation of wealth based on growth in both principal and interest earned in the previous periods.

The formula for compounding involves a calculation of the compounded amount, which can be derived on the basis of initial amount, interest rate, tenure, and frequency of compounding per year. Mathematically, it is represented as,

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

A = P * [1 + (r / n)]t*n

Where,

  • A = Compounded Amount
  • P = Initial Amount
  • r = Interest Rate
  • t = Tenure
  • n = Frequency of Compounding Per Year

Further, the formula for continuous compounding is slightly different, requiring initial amount, interest rate, and tenure. Mathematically, it is represented as,

A = P * er*t

Examples of Compounding Formula (With Excel Template)

Let’s take an example to understand the calculation of Compounding in a better manner.

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

Compounding Formula – Example #1

Let us take the example of a sum of $5,000 that has been deposited for 5 years at an interest rate of 5% to be compounded annually. Then, calculate the compounded amount at maturity.

Compounding Formula Example 1-1

Solution:

Compounded Amount is calculated using the formula given below

A = P * [1 + (r / n)]t*n

Compounding Formula Example 1-2

  • Compounded Amount = $5,000 * (1 + (5%/1))5*1
  • Compounded Amount = $6,381.41

Therefore, as a result of the compounding effect, the amount is expected to grow upto $6,381.41 at the time of maturity.

Compounding Formula – Example #2

Let us take the example of David, who has decided to deposit a lump sum amount of $1,000 in the bank for 5 years. Now, he has recently learned about the effect of compounding on the final amount at the time of maturity and seeks to calculate the same for his deposited sum. Help David in calculating the compounding effect if the interest rate is 4% and the compounding is done:

  1. Annually
  2. Half Yearly
  3. Quarterly
  4. Monthly
  5. Daily
  6. Continuous

Compounding Formula Example 2-1

Solution:

For Annually

Compounded Amount is calculated using the formula given below

A = P * [1 + (r / n)]t*n

Compounding Formula Example 2-2

  • Compounded Amount = $1,000 * (1 + (4%/1))5*1
  • Compounded Amount = $1,216.65

For Half Yearly

Compounded Amount is calculated using the formula given below

A = P * [1 + (r / n)]t*n

Compounding Formula Example 2-3

  • Compounded Amount = $1,000 * (1 + (4%/2))5*2
  • Compounded Amount = $1,218.99

For Quarterly

Compounded Amount is calculated using the formula given below

A = P * [1 + (r / n)]t*n

For Quarterly Example 2-4

  • Compounded Amount = $1,000 * (1 + (4%/4))5*4
  • Compounded Amount = $1,220.19

For Monthly

Compounded Amount is calculated using the formula given below

A = P * [1 + (r / n)]t*n

For Monthly Example 2-5

  • Compounded Amount = $1,000 * (1 + (4%/12))5*12
  • Compounded Amount = $1,221.00

For Daily

Compounded Amount is calculated using the formula given below

A = P * [1 + (r / n)]t*n

For Daily Example 2-6

  • Compounded Amount = $1,000 * (1 + (4%/365))5*365
  • Compounded Amount = $1,221.39

For Continuous

Compounded Amount for continuous compounding is calculated using the formula given below.

A = P * er*t 

Continuous Compounding Example 2-7

  • Compounded Amount = $1,000 * e4%*5
  • Compounded Amount = $1,221.40

From the above results, it can be concluded that the compounding effect leads to an increase in the final amount with the increase in the frequency of compounding per year.

Explanation

The formula for compounding can be derived by using the following simple steps:

Step 1: Firstly, figure out the initial amount that is usually the opening balance of a deposit or loan. It is denoted by ‘P’.

Step 2: Next, figure out the interest rate that is to be charged on the given deposit or loan. It is denoted by ‘r’.

Step 3: Next, figure out the tenure, which is the number of years remaining till the maturity. It is denoted by ‘t’.

Step 4: Next, figure out the frequency of compounding in a year, and it is denoted by ‘n’.

Step 5: Finally, the formula for compounded amount can be derived by using the initial amount (step 1), interest rate (step 2), tenure (step 3), and frequency of compounding per year (step 4) as shown below.

A = P * (1 + r/n)t*n

On the other hand, the formula for continuous compounding is expressed using the initial amount (step 1), interest rate (step 2) and tenure (step 3), as shown below.

A = P * er*t

Relevance and Uses of Compounding Formula

It is important to understand the concept of compounding as it helps to comprehend how a certain sum of money can multiply with the change in the frequency of compounding. In fact, the rate at which the final amount accumulates depends on the frequency of compounding, such that the final amount increases with the increase in the frequency of compounding during a period. The compounding effect finds application across the financial system where it is used to compute the maturity amount. However, the frequency of compounding can vary from case to case, such as savings account at a bank usually uses daily compounding, while CDs use daily, monthly or semi-annual compounding.

Compounding Formula Calculator

You can use the following Compounding Calculator

P
r
t
n
A
 

A = P * [1 + r / n]t*n
0 * [1 + 0 / 0]0*0 = 0

Recommended Articles

This is a guide to Compounding Formula. Here we discuss How to Calculate Compounding along with practical examples. We also provide a Compounding Calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Examples of Continuous Compounding Formula
  2. How to Calculate Coupon Bond Using Formula?
  3. Interest Formula (Examples with Excel Template)
  4. Calculator For Compound Interest Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & 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
EDUCBA

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

EDUCBA

Download Compounding Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Compounding Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW