Bond Valuation
You are considering a 10-year, $1000 per value bond. Its coupon rate is 9% and interest is paid semiannually. If you require an effective annual interest rate ( not a nominal rate) of 8.16%, how much should you be willing to pay for the bond?
Please answer in excel format.