EFIN$101$

Spring $2024$

Assignment $4$

Answer $($briefly$)$ the following questions using material in the D$2$L posted notes and other sources you can find. The examples in those notes should prove helpful in answering the following questions.$)$ Use excel to find answers to the following questions. Please type $($or neatly print$)$ your answers, convert$/$scan your answers into a pdf file, and post your pdf and your excel spreadsheet to the class's D$2$L page.

Assume that a set of coupon bonds have the following initial costs and associated annual cash flows:

$\backslash$table$[[$EOP$,$Cash Flow,B$1,$B$2,$B$3,$B$4,$B$5,$B$6],[0,$COST,$100\mathrm{.}96,101\mathrm{.}42,101\mathrm{.}42,101\mathrm{.}01,100\mathrm{.}22,???$