Video

Excel Online Structured Activity: Interest rate premiums spreadsheet and perform the required analysis to answer the question below.

Open spreadsheet

What is the yield on this $5-$year corporate bond? Round your answer to two decimal places.

$$

$\%$

$12$

$f_x$

$$

A

B

C

D

E

F

G

Interest rate premiums

$5-$year Treasury yield GT

$4\mathrm{.}65\%$

$10-$year Treasury yield $($t$)$

$6\mathrm{.}40\%$

$.$

$6$

Maturity Risk Premium $($MRP$)$

$2\mathrm{.}25\%$

DRP Treasury

$0\mathrm{.}00\%$

LP Treasury

$0\mathrm{.}00\%$

$DR{P}_{C5}+L{P}_{C5}=DR{P}_{610}+L{P}_{C10}$

Real risk$-$free rate, $r^{**}$

$$

$\backslash$table$[[$Formulas$],[$IN$/$A$]]$

Inflation premium over $5$ years $($f$)$P

#N$/$A

$DR{P}_{10}+L{P}_{10}$

IN$/$A

$5-$year Corporate yield

#N$/$A