Question

You bought one of Rocky Mountain Manufacturing Co.'s 9 percent coupon bonds one year ago for $1,054.80. These bonds make annual payments and mature seven years from now. Suppose that you decide to sell your bonds today, when the required return on the bonds is 8.5 percent. If the inflation rate was 4.4 percent over the past year, what would be your total real return on the investment? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g. 32.16.) Total real return
need to solve both questions and if both correct, I will give thumb

Answer 1

1)

1,000 9% 9 90 7 А B A Par value (FV) B Coupon rate C| Number of compounding periods per year D = AxB/C Interest per period (PMT) E Number of years to maturity Number of compounding periods till F = CxE maturity (NPER) Market rate of return/Required rate of G return Market rate of return/Required rate of G/C return per period (RATE) 11 12 8.5% 8.5% 13 14 Bond sale price PV(RATE,NPER,PMT,FV)*-1 16 Bond sale price 1,025.59 =PV(8.5%,7,90,1000)*-1 Holding period return 5.76% =(1025.59+90-1054.8)/1054.8 Real rate of return 1.30% =(1+5.76%)/(1+4.4%)-1

Please rate thumbs up