What is Compound Interest?
Compound interest is the formula to calculate the interest of loan. In this article, we will learn the formula that can be used to calculate the quarterly compound rate of interest in Microsoft Excel.
 
Let us take an example to calculate compound interest:-
If loan amount of $100 is provided by Bank at an Interest Rate of 10%, then what will be theloan amount at the end of 10 years?
With Compound Interest, we can work out the interest for the first year, add it to the totaland then calculate the interest for the next year and continue the same till the given time (in years).
Here are the calculations for a 10 Year Loan at 10%:
Let us see how we calculate Loan at End step by step:
There are more simple ways to calculate the ‘Loan at End’
Adding 10% interest is the same thing as we are multiplying by 1.10
The basic concept of calculating compound interest is that interest is added back to the principal sum so that interest is earned on that added interest during the next compounding period.
 
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
 
 
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.