Bond calculator in Excel

For you to create a bond calculator, you first need data like this:input variablesNote: Put values of your choice. They act as components to the bond calculation.Click beside Bond Repayment Per Month (1), and type =PMT(B5/12;B6*12;-B4;0;0).

bond repayment per month

Note: The =PMT(annual interest rate/12(number of months in a year);Period of Bonds*12(also number of months in a year);put a minus symbol before the amount of bond. This minus symbol will make it possible to get accurate result.

Click beside total period interest (1), and type =B12-B4.

period interest

Click beside total bond repayment (1), and type =B10*12*B6.

total bond repayment

Template

You can download the Template here – Download