C5 C5 rate. To access FV function we can go to Insert Function which is beside the formula bar or type sign where we need to see the result. 1i n Where i is the interest rate per period and n is the number of periods.
R the annual interest rate expressed in decimal form decimal 100.
FV PV 1Rnmmt. To calculate compound interest use the formula below. N the number compounding periods per year n 1 for annually n 12 for monthly etc t the time in years or fraction of years multiples of 1n. In the example shown the formula in C6 is.