You are given the following data on $\frac{8}{24}\frac{?}{2015}$ settlement

date:

Maturity Annual Coupon Rate Bid Price Asked Price

$8/31/20171\mathrm{.}875,102\mathrm{.}4922102\mathrm{.}5078$

$8/15/20256\mathrm{.}875,144\mathrm{.}6719144\mathrm{.}6875$

and the following data on $8/28/2015$ settlement date:

Maturity Annual Coupon Rate Bid Price Asked Price

$8/31/20171\mathrm{.}875,102\mathrm{.}1875102\mathrm{.}2031$

$\frac{8}{15}\frac{?}{20256\mathrm{.}875},142\mathrm{.}4531142\mathrm{.}4688$

a$)$ On $\frac{8}{24}\frac{?}{2015},$ open a repo position using the $\frac{8}{31}\frac{?}{2017}$

maturity bond and close the position on $8/28/2015.$ Compute

the profit$/$loss on this transaction.

b$)$ On $\frac{8}{24}\frac{?}{2015},$ open a reverse repo position using the

$8/15/2025$ maturity bond and close the position on $8/28/2015.$

Compute the profit$/$loss on this transaction.

Use an annual repo rate of $1\mathrm{.}0\%$ and an annual reverse repo rate

of $1\mathrm{.}5\%.$ Explain why you made a profit$/$loss in each of the

above transactions. Also, make sure to account for accrued

interest in your calculations and choose the bid or ask price

appropriately. If you are using the Excel function for accrued

interest, make up an Issue Date as the coupon payment date just

prior to the settlement date.

Solve this all in an excell format