We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

Find out about compound interest and how to use the compounding interest formula in Microsoft Excel to calculate the compound interest on a loan.

Compound Interest Formula: Get here formula of the compound interest along with how to calculate, difference between compound and simple interest and more.

The exponential function combines the term and interest rate, the result of which you multiply by the principal amount, yielding a monthly payment or total loan cost.