This example assumes that 1000 is invested for 10 years at an annual interest rate of 5 compounded monthly. Step 2 We have the principal value or present value as 15000 and the annual interest rate is 5. Doing so opens a new spreadsheet for your.
Step 1 Open Microsoft Excel.
Select the cell you will place the calculated result in type the formula CUMIPMT B212B312B1B4B51 and press the Enter key. Entering 5 will result in a 500 interest rate each month. Enter the payments total. If you simply enter 512 instead Excel will interpret this as a 500 annual rate paid monthly.