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.