issued.$)$

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.

Download spreadsheet Ch$04$ P$24$ Build a Model$-$c$374$b$5.$xlsx

a$.$ What is the bond's yield to maturity? Round your answer to two decimal places.

$\%$

b$.$ What is the bond's current yield? Round your answer to two decimal places.

$5\mathrm{.}78$

$\%$

c$.$ What is the bond's capital gain or loss yield? Round your answer to two decimal places. Use a minus sign to enter a negative value, if any.

$\%$

d$.$ What is the bond's yield to call? Round your answer to two decimal places.

$\%$

going rate of interest falls below the coupon rate. This is an oversimplification, but assume it for purposes of this problem.$)$ Round your answers to the nearest cent.