Q28, Q29, Q30: A 10-yearbond is trading for 104.0per 100 par value. The coupon rate is 4.45% with interest paid semi-annually. The bond is first callable in 3 years & is callable on coupon dates according to the following schedule:End of Year Call Price310341029100.5Q27

The bonds annual yield-to-maturity is closes tto:

a.3.96%

b.4.02%

c.3.42%

Do calculations & show your answers in Excel worksheet