To calculate the quarterly compound interest you can use the below-mentioned formula. Fortnightly interest rate divide by 26 d. Initial investment 1 annual interest ratecompounding periods per year years compounding periods per year.
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.
To calculate compound interest use the formula below. A P 1 rn nt Where. If interest is compounded daily find the rate at which an amount doubles itself in 5 years. Below is the compound interest formula on how to calculate compound interest.