Reference no: EM133002109
On the 1st of September 2020, you bought the following portfolio of Commonwealth Government bonds:
Yields as at 1st September 2020
Treasury Bond 151 2.00% 21-Dec-2021: 1.228
Treasury Bond 137 2.75% 21-Apr-2024: 0.79
Treasury Bond 164 0.50% 21-Sep-2026: 1.044
Treasury Bond 155 2.50% 21-May-2030: 1.966
Treasury Bond 163 1.00% 21-Nov-2031: 1.888
Treasury Bond 147 3.25% 21-Jun-2039: 0.545
Yields as at 31 August 2021
Treasury Bond 151 2.00% 21-Dec-2021: 1.783
Treasury Bond 137 2.75% 21-Apr-2024: 1.256
Treasury Bond 164 0.50% 21-Sep-2026: 0.63
Treasury Bond 155 2.50% 21-May-2030: 1.769
Treasury Bond 163 1.00% 21-Nov-2031: 2.132
Treasury Bond 147 3.25% 21-Jun-2039: 2.263
Problem 1: calculate the duration and convexity for the 3.25% 21st June 2039 Treasury Bond 147 on the 21st June 2021, if the yield for that day is 1.685
Problem 2: Using a spreadsheet (Excel) and its duration formula, calculate the duration for all the bonds as at 31st August 2021.
Problem 3: What is the duration for the portfolio?