No excel please.

Problem#4: At t=0, you purchase a five-year, 8 percent coupon bond (paid annually) that is priced at par. The face value of the bond is $1,000. You are also given that your investment horizon is also five years. Suppose that the market interest rate increases to 9 percent (increase by 100 basis points) during the first year of your purchase (within year 1), and it remains at that level (9 percent) for the next four years. You decided to sell the bond at the end of year 1. a) What is the selling price of the bond at the end of year 1 (t=1)? b) What is your holding period return at the end of your investment horizon (t=5)? Assume that the reinvestment rate for the first coupon payment and sale proceeds is the new interest rate, that is, 9 percent. Problem#4: At t=0, you purchase a five-year, 8 percent coupon bond (paid annually) that is priced at par. The face value of the bond is $1,000. You are also given that your investment horizon is also five years. Suppose that the market interest rate increases to 9 percent (increase by 100 basis points) during the first year of your purchase (within year 1), and it remains at that level (9 percent) for the next four years. You decided to sell the bond at the end of year 1. a) What is the selling price of the bond at the end of year 1 (t=1)? b) What is your holding period return at the end of your investment horizon (t=5)? Assume that the reinvestment rate for the first coupon payment and sale proceeds is the new interest rate, that is, 9 percent