Assume you have bought a $5\%$ coupon bond that matures on June $30,2036$ and it makes coupon payments on December $31$ and June $30$ of each year. You are pricing the bond as of October $15$th$,2024.$ What is the current quote price of the bond $($the value of the bond found by discounting its future cash flows to October $15$th$)?$ What is the cash price of the bond $($the price that includes accrued interest. $(10$ points$)$

Preferably solve in excel