In this Excel tutorial, you will learn how to prepare bond repayment calculator in Excel.
How to create bond calculator?
For you to create a bond calculator, you first need data like this:
Put in the values of your choice. They act as components in the bond calculation.
Bond repayment formula
Type =PMT(B5/12;B6*12;-B4;0;0) next to Bond Payment Per Month (1).
Note: The =PMT(annual interest rate/12(number of months in a year);Period of Bonds*12(also number of months in a year). Place a minus symbol before the bond amount. This minus symbol will make it possible to get an accurate result.
Click beside total period interest (1) and type =B12-B4.
Click beside total bond repayment (1) and type =B10*12*B6.