Best Math Formula website. Search anything about Math Formula in this website.
how to calculate compound interest on excel. Doing so will calculate the amount that youll have to pay in interest for each period. And in this method interest rate will divide by 12 for a monthly interest rate.
Pin On Finances from www.pinterest.com
So the formula will become 500 152100 5. To calculate compound interest in Excel you can use the FV function. Supposing there is 1000.
In cell D2 to calculate the compound interest you will want to input C2 x 108.
R is the annual interest rate as a decimal or a. The answer is 14693. To calculate monthly interest rate the formula in C6 is. The basic compound interest formula for calculating a future value is F P 1 rate nper where F the future accumulated value P the principal starting amount rate the interest rate per compounding period.
