PLEASE USE EXCEL AND SHOW FORMULAS

The following table gives the prices of bonds Bond Price ($) Bond Principal ($) 100 100 100 100 Time to Maturity (yrs) 0.5 1.0 Annual Coupon ($)* 0.0 0.0 6.2 8.0 98 95 101 104 1.5 2.0 *Half the stated coupon is paid every six months a) Calculate zero rates for maturities of 6 months, 12 months, 18 months, and 24 months