1. Consider a bond with a par value of $10,000 compounded yearly and a coupon yield of 5%. Make a table that reports the value of the bond as the maturity date varies from 5 years to 30 years in 5-year increments and the prevailing interest rates for investments of similar risk vary from 3% to 8% in .5% increments.

Create the table in EXCEL so that you only have to write the formula only once and can copy the formula to the other cells.