Compound interest is interest added to the principal of a deposit or loan so that the added interest also earns interest from then on. Interest calculated on the initial principal and also on the accumulated interest of previous periods of a deposit or loan. Compound interest can be termed as interest on interest. The effective rate of Interest at which the principal will earn depends on the frequency of compounding; the higher the number of compounding periods, the greater the effective rate of Interest.
The formula for calculating compound interest is:
Compound Interest = Total amount of Principal and Interest in future (or Future Value) less Principal amount at present (or Present Value)
Compound Interest = [P (1 + i)n] – P
Future Value (FV) = [P (1 + i)n]
(Where P = Principal, i = nominal annual interest rate in percentage terms, and n = number of compounding periods.)
If the number of compounding periods is more than once a year, “i” and “n” must be adjusted accordingly. The “i” must be divided by the number of compounding periods per year, and “n” is to be multiplied by the no of compounding in a year with the maturity term.
Similarly Present Value of any amount calculated in Future value can be calculated using the following Formula.
Present Value (PV)= FV
(1+i)n
(Where P = Principal, i = nominal annual interest rate in percentage terms, and n = number of compounding periods.)
If the number of compounding periods is more than once a year, “i” and “n” must be adjusted accordingly. The “i” must be divided by the number of compounding periods per year, and “n” is to be multiplied by the no of compounding in a year with the maturity term.
A Excel Utility for calculating Present & Future value at Compound Rate of Interest is attached herewith.