Please use excel for this problem if you can. Thanks

Risk Measurement, Dollar Duration, Convexity, and Macaulay Duration - 30 points The following discount factors are given: B(0,1)=0.95206B(0,2)=0.81845B(0,3)=0.86476B(0,4)=0.77821 As a reminder, $ Duration, for a bond with continuously compounded yields is: $=t=1TtKteyt. (a) Using continuous compounding, calculate the duration D(y), modified duration MD(y),the dollar duration $, and the dollar convexity $ of a 4 -year 4% annual coupon bond with face value $1,000. (b) If there is a 300 basis point downward shift in the continuously compounded zeroyield curve (assume all shifts in the continuously compounded zero yield curve are uniform) calculate the following: i. The actual price of this 4-year, 4% coupon bond; ii. The price of the 4-year bond as estimated by $ alone; iii. The price of the 4-year bond as estimated by both $ and $