Write a spreadsheet program to construct a series of bond tables that show the present value of

Question:

Write a spreadsheet program to construct a series of bond tables that show the present value of a bond given the coupon rate, maturity, and yield to maturity. Assume that coupon payments are semiannual and yields are compounded semiannually.

Coupon
A coupon or coupon payment is the annual interest rate paid on a bond, expressed as a percentage of the face value and paid from issue date until maturity. Coupons are usually referred to in terms of the coupon rate (the sum of coupons paid in a...