How to calculate compound interest in Excel To compute the compound interest in Excel for different time periods all you have to do is convert the formula above into a relatable formula in Excel. For the formula for compound interest just algebraically rearrange the formula for CAGR. If you make weekly monthly or quarterly payments divide the annual rate by the number of payment periods per year as shown in this example.
The daily interest accumulate on a daily basis on the amount of the loan from the date the interest charges begin until you repay the loan.
If you make weekly monthly or quarterly payments divide the annual rate by the number of payment periods per year as shown in this example. Effective Interest Rate 1 006365365 1 61831. To do so you should first click and drag the divider between columns A and B to the right at least three spaces so you dont run out of writing room. Beginning Value x 1 interest rate number of compounding periods per year years x number of compounding periods per year Future Value.