Please answer in excel and show formulas being used!! Thank you in advance. You are considering purchasing a $$15,000$ bond on June $14,2022.$ It matures at par on December $14,$

$2023$ and pays semi$-$annual coupons at $i^{(2)}=4\mathrm{.}5\%.$ Assuming you require a yield rate of $i^{(2)}=6\mathrm{.}5\%,$

$($a$)$ Calculate the values of $P,k,I(=kFr),$ and $Q$ every $10$ days, starting on June $14,2022$ and going

until December $14,2023.($Make sure you calculate the values on December $14/22,$ June $14/23$

and December $14/23$ in addition to the values every $10$ days$).$ You will need to figure out how

Excel can count the number of days to help you calculate the values of $k.(5$ marks$)$

$($b$)$ Graph the values of $P$ and $Q$ from $($a$)$ on the same graph, using a line graph. $(4$ marks$)$