Please Include excel formulas

. 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. C 1 a b 2 3 4 5 Coupon Par YTM Start 0.5 1.0 1.5 6 7 8 2.0 9 10 11 12 2.5 3.0 3.5 4.0 4.5 5.0 13 14 15