In: Finance
You own a bond with a $20,000 face value and a 4.75% coupon with semiannual payments. The bond matures in 18 months and the yield to maturity is 3%. What is the Macaulay duration of your bond?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -