For an answer to be graded as correct, you must use an Excel formula:

Begin each formula with an $=$ sign.

Reference cells, instead of entering values.

Example: $=$B$3+$C$3$This first table describes prevailing market interest rates.

Required:

Using the yield above and the information contained in the table below, please calculate the price and duration of the bond as

well as all necessary steps.

$($Use cells A$5$ to B$5$ from the given information to complete this question.$)$