Step $2$: Using the data you receive from your eLA, write a report showing your calculations and answer the following questions: On $1$ July $2022,$ you bought the portfolio of Commonwealth Government bonds. Calculate the amount you paid for each instrument per $$100$ face value and thus the total for the equally weighted portfolio. Use the yields within the table provided by your eLA. $(6$ marks$)$Calculate the price of the instruments if they were sold on $30$ June $2023.(6$ marks$)$Calculate the holding period yield for each instrument if you sold them on $30$ June $2023.$ Using the reinvestment rate contained within the table. $(12$ marks$)$What would be the holding period yield for the portfolio as a whole over the same period? Comment on your answer. $(6$ marks$)$Using a table format, manually calculate the duration and convexity for the $3\mathrm{.}75\%21$ April $2037$ Treasury Bond $144$ on the $21$st of April $2023,$ if the yield for that day is contained within the table below. $(8$ marks$)$Using a spreadsheet $($Excel$)$ and its duration formula, calculate the duration for all the bonds as at $30$ June $2023.(3$ marks$)$What is the duration for the portfolio as at $30$ June $2023?(3$ marks$)$If the portfolio had a $44-$day Bank Accepted bill with the yield contained within the table, what would be the bills duration? Explain your answer. $(2$ marks$)$Comparing the two sets of rates, what can you say about the term structure? $(4$ marks$)$Note: Show all calculations for parts a$.$ to i$.$