Compounding Quarterly Formula

Compounding Quarterly Formula (Table of Contents)

• Formula
• Examples

What is Compounding Quarterly Formula?

Compounding Quarterly can be considered as the interest amount which is earned quarterly on an account or an investment where the interest earned will also be reinvested. The formula for Compounding Quarterly is:

Where,

• C_q is the quarterly compounded interest
• P would be the principal amount
• r is the quarterly compounded rate of interest
• n is the number of periods

The formula for compounding quarterly is a subset of compounding formula. Here the principal amount, number of periods, rate of interest would be required. The only modification in this formula is the rate of interest would be raised to n*4 which is static since we are supposed to calculate interest quarterly. Therefore, this formula compounds the interest quarterly and the income grows every quarter which is what this formula is trying to explain and get those results.

Examples of Compounding Quarterly Formula (with Excel Template)

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

Example #1

Mr. Kamal deposited $50,000 in KJK bank for a period of 4 years and the bank pays 5 percent as rate of interest which is quarterly compounded. You are required to calculate the quarterly compounded interest.

Solution

We are given all the required variables; hence we can use the below formula to calculate quarterly compound interest.

Therefore, calculation of quarterly compound interest will be –

• C_q = P [ (1+r)^4*n – 1 ]
• =  50,000 [ (1+5%/4)^4*4 – 1 ]
• = 50,000 [ (1.0125)¹⁶ – 1 ]

Quarterly Compound Interest will be –

• =  10,994.48

Hence, the amount of quarterly compounded interest will be 10,994.48 on the amount invested.

Example #2

BCC co-operative bank has two schemes which they are evaluating the projections as to which would be more preferred by their customers. The details of both schemes are given below as collected by the finance department.

The initial amount that is deposited includes a premium of 11,000 for scheme 1 which shall not be invested and for scheme II there is a premium of 25,000 which shall not be invested. Life Insurance covers the benefit of 1000,000 whereas medical scheme covers the benefit of 700,000.

You are required to evaluate the benefits of the scheme.

Solution

Here, we need to compare the scheme benefits, and first, we shall calculate the quarterly compounded interest.

The initial amount that would be invested will be 200,000 less 11,000 which is 189,000 for the scheme I and for scheme II it would be 400,000 less 25,000 which is 375,000.

Use the following data for calculation of quarterly compound interest

Scheme I

Therefore, the calculation of quarterly compound interest will be –

• C_q =  P [ (1+r)^n*4 – 1 ]
• =189,000 [ (1+(8.50%/4))^(6*4) – 1 ]
• =189,000 [ (1.02125)²⁴ – 1 ]

Quarterly Compound Interest will be –

• = 1,24,062.81

Scheme II

Therefore, the calculation of quarterly compound interest will be –

• C_q =  P [ (1+r)^n*4 – 1 ]
• = 375,000 [ (1+(8.25%/4)^(7*4) – 1 ]
• =  375,000 [ (1.020625)²⁸ – 1 ]

Quarterly Compound Interest will be –

• = 2,89,178.67

It is difficult to make a decision here as we are not comparing apples to apples as one scheme is for 6 years and another one is for 7 years and further, if we go through policy benefits then the customer might choose scheme I as lower investment and policy cover of 1000,000.

Example #3

SMC Municipal corporation has issue new products for capturing money from the market. Money has to be invested in two phases. In phase I, 50% will be invested and rest will be invested after 5 years. For, first 5 years, the rate of interest that will be paid is 8% and for the next 5 years, it will be 7.5%. These will be paid quarterly. Mr. W invested 500,000 in the initial period.  You are required to calcualte the income earned on the investment for Mr. W.

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 following data for calculation of quarterly compound interest

Phase I

Therefore, the calculation of quarterly compound interest will be

• C_q =  P [ (1+r)^n*4 – 1 ]
•   =  250,000 [ (1+(8.00%/4)^(4*5) – 1 ]
• =  250,000 [ (1.02)²⁰ – 1 ]

Quarterly Compound Interest will be –

= 1,21,486.85

Phase II

Therefore, the calculation of quarterly compound interest will be

• C_q = P [ (1+r)^n*4 – 1 ]
• =  250,000 [ (1+(7.50%/4)^(4*5) – 1 ]
• =250,000 [ (1.01875)²⁰ – 1 ]

Quarterly Compound Interest will be –

= 1,12,487.01

Total Income 

Hence, the total income earned by Mr. W on his investment will be 1,21,486.85 + 1,12,487.01 which shall be 2,33,974.

Relevance and Uses

 The compounding quarterly formula is useful in calculating the fixed deposit income as most of the banks offer interest income on the deposits which compound quarterly. Further, this formula can also be used to calculate any income on other financial products that offer quarterly income. Compounding quarterly can be used in money market instruments majorly.

Compounding can be monthly, quarterly, semi-annually and annually and most of the financial products which include saving accounts as well, are mostly based on a quarterly or semi-annually basis. Compounding grows the money much faster than the interest which is earned by way of simple interest. 

This has been a guide to Compounding Quarterly Formula. Here we discuss the calculation of quarterly compounded interest along with practical examples and downloadable excel templates. You may learn more about finance from the following articles –

• Formula of Marginal Product of Labor | Uses
• Break-Even Sales | Formula with Calculation
• Compound Interest Definition
• Examples of Compound Interest
• Calculate Daily Compound Interest
• Formula of Continuous Compounding