Problem:
You purchased a $1,000 five percent coupon bond that matures in 10 years.
How much would your bond be worth if interest rates fall to 4% the day after you purchase the bond? What would the bond be worth in one year if interest rates fell to 4% at that point need calculations in excel.