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 face value and thus the total for the equally weighted portfolio

Note: I already created an Google Sheets (similar to Excel) template to calculate these bonds. I also have Excel function to do that. You only need to apply these functions and fill it out in the Google Sheets. I will upload the link in the comment section.

Transcribed Image Text:

9 Number of coupons after the next coupon. Thus, no more in 2017. 2 for each year from 2018 to 2024 which is 14. Then 1 more in 2025. Total 15 3 4 Coupon 5 Maturity 2 Pricing Formula 12.50% 15-Apr-25 6 Yield 10.500% 7 Setlement Date 15/7/17 8 Next Coupon 15/10/17 C 9 last coupon 15/4/17 10 f 92 =+B8-B7 11 d 183 =+B8-B9 12 g 6.25 =+B4/2*100 13 C 6.25 |=IF(B10 9 Number of coupons after the next coupon. Thus, no more in 2017. 2 for each year from 2018 to 2024 which is 14. Then 1 more in 2025. Total 15 3 4 Coupon 5 Maturity 2 Pricing Formula 12.50% 15-Apr-25 6 Yield 10.500% 7 Setlement Date 15/7/17 8 Next Coupon 15/10/17 C 9 last coupon 15/4/17 10 f 92 =+B8-B7 11 d 183 =+B8-B9 12 g 6.25 =+B4/2*100 13 C 6.25 |=IF(B10