How to calculate compound interest in Excel. One of the easiest ways is to apply the formula. The formula for compound interest is Compound Interest CI Principal 1Rate100n - Principal where P is equal to Principal R is equal to Rate of Interest T is equal to Time Period Image will be uploaded soon.
The compound interest formula is as follows.
Roi The annual rate of interest for the amount borrowed or deposited. Using the same information above enter Principal. T number of years for which investment is done 3 years. T The number of times the interest compounds yearly.