This simple spreadsheet allows you to value coupon bonds. To use the calculator, proceed as follows:

​

1. Enter the relevant bond valuation parameters in the blue fields.
    

2. Keep in mind that the date convention of this tool is MM/DD/YYYY.