Assume today is September 5th 2019

CashDrain.com has bonds outstanding that mature on your birthday, 2026. These bonds have a 5% coupon rate, with coupons paid semi-annually, and are currently quoted at 96.624.

CashCow.com has bonds outstanding that mature on your birthday, 2026. These bonds have a 7% coupon rate, with coupons paid semi-annually, and are currently quoted at 101.941.

Assume both bonds are callable at face value beginning 5 years before maturity.

1.Calculate the YTM and the YTC for each bond

2.Highlight the yield that would be more relevant for each of the two bonds yield to maturity or yield to call.

3.For each, explain why that yield is the relevant one.

how would i solve this step by step on excel? face value is 100