Instructions:

Solve for the Yield to Maturity $($YTM$)$ in cell C$17.$

Solve for the Yield to Maturity $($YTC$)$ in cell C$18.$

Use the YTM and YTC to calculate the Discount Factors in rows $10$ and $16,$ respectively.

Apply the Discount Factor to the Cash Flow.

Solve for the Yield using the following data:

$\backslash$table$[[$Frequency$,,$Semi$],[$Coupon$,7\%,],[$Maturity$,,5],[$Par Value,$$,1,000],[$Current Price,$$,1,047],[$Call Price,$$,1,040],[$Years til Call,,$2]]$

use $=$ rate$(...)*$

Yield to Maturity

Yield to Call $$

Note: in final period, you also get the Par Value $($$$1000)$ in addition to the Coupon.

$*$don$\text{'}$t forget to $2$

Note: in final period, you also get the Call Price $($$$1040)$ in addition to the Coupon.