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.