Question#$2$

Home Depot bond has $10$ years to maturity, a $$1,000$ face value, and pays $11\%$ semiannual coupon interest. The bond's current market price is $$1,283\mathrm{.}09.$

A$.$ What is the YTM of the bond?

B$.$ If the $10-$year Treasury rate is $4\mathrm{.}19\%,$ what is a credit spread for Home Depot?

C$.$ If this bond were callable in $5$ years, would you pay more or less than $$1,283\mathrm{.}09?$ Explain why. show with excel