Problem 1 Please see the first article "A Technical Note on Duration and Convexity". You are to prepare an excel spreadsheet that will calculate (Macaulay) duration in semi-annual periods and in years (just divide your answer in semi-annual periods by 2 to get the answer in years). Specifically, you should turn in a spreadsheet that replicates Table 1 in the article. The article calculates the duration of a 5-year bond, having a 9% coupon (paid semi- annually), a current market value of $1040.55, and an annualized yield to maturity of 8% (or semi-annual yield of 4%)