Answer the following questions using the data in the table below. Submit your solutions with workings in a report format, which is in WORD format. You are to submit both the report and the Excel file, or any other file used in the calculations. (a) On the 1st of July 2022, you bought the following portfolio of Commonwealth Government bonds. Calculate the amount you paid for each instrument per $100 ace value and thus the total for the equally weighted portfolio: Use the yields within the table at the end of the assignment which correspond to your student ID number. (b) Calculate the price of the instruments if they were sold on 30th of June 2023 (c) Calculate the holding period yield for each instrument if you sold them on the 30th of June 2023 . Using the reinvestment rate contained within the table. (d) What would be the holding period yield for the portfolio as a whole over the same period? Comment on your answer (e) Using a table format, manually calculate the duration and convexity for the 3.75\% 21 1st April 2037 Treasury Bond 144 on the 21st of April 2023, if the yield for that day is contained within the table below. (f) Using a spreadsheet (Excel) and its duration formula, calculate the duration for all the bonds as at 30th of June 2023. (g) What is the duration for the portfolio as at 30th of June 2023 ? (h) If the portfolio had 44-day Bank Accepted bill with the yield contained within the table, what would be the bill's duration? Explain you answer. (i) Comparing the two sets of rates, what can you say about the term structure? Answer the following questions using the data in the table below. Submit your solutions with workings in a report format, which is in WORD format. You are to submit both the report and the Excel file, or any other file used in the calculations. (a) On the 1st of July 2022, you bought the following portfolio of Commonwealth Government bonds. Calculate the amount you paid for each instrument per $100 ace value and thus the total for the equally weighted portfolio: Use the yields within the table at the end of the assignment which correspond to your student ID number. (b) Calculate the price of the instruments if they were sold on 30th of June 2023 (c) Calculate the holding period yield for each instrument if you sold them on the 30th of June 2023 . Using the reinvestment rate contained within the table. (d) What would be the holding period yield for the portfolio as a whole over the same period? Comment on your answer (e) Using a table format, manually calculate the duration and convexity for the 3.75\% 21 1st April 2037 Treasury Bond 144 on the 21st of April 2023, if the yield for that day is contained within the table below. (f) Using a spreadsheet (Excel) and its duration formula, calculate the duration for all the bonds as at 30th of June 2023. (g) What is the duration for the portfolio as at 30th of June 2023 ? (h) If the portfolio had 44-day Bank Accepted bill with the yield contained within the table, what would be the bill's duration? Explain you answer. (i) Comparing the two sets of rates, what can you say about the term structure
