Consider a coupon bond with a face value (F) of $10,000, annual coupon payments of $500, and a yield to maturity (i) of 3%. [Hint: it is helpful to use excel for this question.]

(a) Calculate the price (present value) of the bond for maturities of one to thirty years. Graph these prices with the bond price on the vertical axis and maturity on the horizontal axis. Be sure to label your figure.

Show in Excel, Explain Solution!! Thank you