Consider a bond with annual coupon payments of $$100,$ a principal payment of $$1,000$ in $10$ years, and a cost of $$1,000.$ Assume a flat yield curve with a $10\%$ yield to matu$-$rity. What is the duration of the bond? If the yield curve remains unchanged, what is the bond$$s duration in three years? In five years? In eight years?

Can you do this on excel?