In: Finance
1]
Macaulay duration is calculated using DURATION function in Excel
Settlement = date today
Maturity = date of maturity of bond = 3 years from today
Coupon = 5%
yld = YTM = 3%
frequency = number of coupon payments per year = 1
DURATION is calculated to be 2.8635
A]
Modified duration is calculated using MDURATION function in Excel
MDURATION is calculated to be 2.78
B]
If the YTM increases by 0.05%, the modified duration is 2.7787
C]
% change in price of bond = modified duration * % change in interest rates
% change in price of bond = 2.78 * 1% = 2.78%