You need to model the net bond price of a $15$ September $2030$ Treasury bond

with a coupon rate $2=5\%$ p$.$a$.$ and a face value of $$100$ that matures at par, the

yield to maturity is $2=6\%.$ You should account for a $30\%$ tax on interest and

capital gain, assuming the tax on interest is deferred $6$ months, and tax on

capital gain is deferred $12$ months.

You are required to create a bond price model that can calculate the net bond

price from $16$ March $2024$ to $15$ September $2024.$ Your marker would input these

dates in cell B$1($you can start with any dates from $16$ March $2024$ to $15$

September $2024$ in cell B$1),$ you are required to determine the net bond price in

cell E$1.$ You can use any Excel cells in $$part d$$ to aid you to calculate your final

answer in cell E$1.$