For you to create a bond calculator, you first need data like this:

Note: 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).

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.

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