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© BrainMass Inc. brainmass.com June 3, 2020, 10:53 pm ad1c9bdddf
I have solved the problem using the PV function in Excel. The purchaser of a bond purchases two income streams: the periodic interest payment (in this case, $50 per year) and the terminal face value payment (in this case, $1,000). Therefore, ...
Using an Excel spreadsheet, this solution demonstrates and explains how to compute the fair value of a bond when the prevailing interest rate differs from the bond's coupon rate.