In: Finance
Determine the Macaulay duration and convexity of a 3-year 5% $2,000 bond having annual coupons and a redemption value of $2,200 if the yield to maturity is 6%.
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -