Initial investment 1 annual interest rate12 years 12. Download Corporate Valuation Investment Banking Accounting CFA Calculator others. We will use the FV excel formula to calculate compound interest.
To get the total number of payment periods we multiply it by 12.
There are many ways in which we can define the annuity formula and it depends what we want to calculate. Monthly compound interest formula As you have guessed all you need to do is change the Number of compounding periods per year to 12. Type IPMT B2 1 B3 B1 into cell B4 and press Enter. FV C6 C8 C7 C80 - C5.