Please show in excel with formulas.

4. Consider a semi-annual bond with an annual coupon = 3.0%, maturity = 5 years, par value = $1,000, and a market price today = $700: a. What is its yield to maturity (YTM)? b. Suppose the bond can be called at $900 at the end of year 3, what is its yield to call? A B D 1 a __b 2 3 4 5 6 Coupon Par YTM Start 0.5 1.0 1.5 2.0 2.5 7 8 9 10 11 12 3.0 3.5 4.0 13 14 4.5 5.0 15