Excek actuvity Bond Valuation please answer parts e and f

Years to

maturity

Number of coupen payment par year

Coupen rete

Parvalue

Current

price

Call price

Years until bond is callable

$8.$ Calculating the bond's yield to maturity

Periodic

YTM

Annualized nominat YTM

$3\mathrm{.}264895$

$6\mathrm{.}5305,C7,(6)$

$=,C12**2$

b$.$ Calculating the bond's current yield

Current yield

$\}\{7\}$

c$.$ Calculating the bond's capital gain

or loss yield

Capital gain$/$loss yield $$

d$.$ Calculating the bond's yield to call

Periodic YTC $$ Annualized nominat YTC

$2\mathrm{.}838296$

$==$RATEIC$9$C$5/$C$4.$C$7.$C$8)$

$5\mathrm{.}68\%6=C22**2$

e$.$ Assume that the bond will be called if and only if the going rate of interest falls below the coupon rate.

Conducting a sensitivity analysis of price to changes in the going market interest rate for the bond

Nominal market rate

Bond price if it's not called $896$

Bond price if it's called

$$N$/$A

HN$/$A

Bond price if

$\backslash$table$[[\backslash$table$[[$Nominal$],[$market rata$]],$Not egllad,Called,$\backslash$table$[[$Actual$],[$bend price$]]],[(C27),$$$0\mathrm{.}00,$$$0\mathrm{.}00,],[0\%,,,],[2\%,,,],[4\%,,,],[6\%,,,],[8\%,,,],[10\%,,,],[12\%,,,],[14\%,,,],[16\%,,,]]$

f$.$ Calculating the bond's

yield

Settlement date $($today$)$

Maturity

date

Call date

Coupon rate

Par value $(\%$ of par walue$)$

Current price $196$ of par

value$)$

Call price $(\%$ of parvalue$)$

Frequency $($semiannual bonds$)$

Basis $(360-$ or $305-$day year$)$

Yield to maturity

Yield to call

$$