A high-yield bond fund manager is considering adding a US$50 million face value, five-year, 6.75% semiannual coupon bond with a YTM of 5.40% to an active portfolio. The manager uses regression analysis to estimate the bond’s empirical duration to be 2.95. Calculate the bond’s analytical duration, and estimate the difference in the expected versus actual market value change for this position, given a 50 bp decline in benchmark yields to maturity using these two measures.
请问这道题只能用Excel计算吗？如果考试出来类似问题，可以用计算器或者其他方法计算吗？多谢！
