need a table and solve this in excel sheet with the values and formulaes

5-1

5-2

5-3

5-4

5-7

210 Part 2: Fixed Income Securities Answers Appear in Appendix D Problems Eto (5-1) Bond Volucion with Annual Payments (5-2) Yield 10 Motul for Au Payment (5-3) Cumen Yield for Annud Payments (5-4) Decemiorraf Ines Rores Jackson Corporation's bonds have 12 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 8% The bonds have a yield to maturity of 9%. What is the current market price of these bonds? Wilson Wonders's bonds have 12 years remaining to maturity. Interest is paid anno ally, the bonds have a $1,000 par value, and the coupon interest rate is 10%. The bonds sell at a price of $850. What is their yield to maturity? Heath Foods's bonds have 7 years remaining to maturity. The bonds have a face value of $1,000 and a yield to maturity of 8%. They pay interest annually and have 996 coupon rate. What is their current yield? The real risk-free rate of interest is 4%. Inflation is expected to be 2% this year and 4% during the next 2 years. Assume that the maturity risk premium is zero. What is the yield on 2-year Treasury securities? What is the yield on 3-year Treasury securities? A Treasury bond that matures in 10 years has a yield of 6%. A 10-year corporate bond has a yield of 9%. Assume that the liquidity premium on the corporate bond is 0.5%. What is the default risk premium on the corporate bond? The real risk-free rate is 3%, and inflation is expected to be 3% for the next 2 years A 2-year Treasury security yields 6,3%. What is the maturity risk premium for the 2-year security? (5-5) Deus Pemium (5-6) Mourya Premium (5-7) and Vehon mod Pomenis (5-8) Yield to M o nd Coll with Serioul Poymens (5-9) Dond Volunion and Irenes More Re Renfro Rentals has issued bonds that have a 10% coupon rate, payable sama The bonds mature in 8 years have a face value of $1,000, and a yield to matury of 8.5%. What is the price of the bonds? Thatcher Corporation's bonds will mature in 10 years. The bonds have a face of $1,000 and an 8% coupon rate, paid semiannually. The price of the bonds is S1,100. The bonds are callable in 5 years at a call price of S1,050. What is their yield to maturity? What is their yield to call? The Garraty Company has two bond issues outstanding. Boch bond pay $100 interest plus S1,000 at maturity. Bond L has a maturity of 15 years, and Bond Sha maturity of I year. What will be the value of each of these bonds when the going o (1) 5%, (2) 8%, and (3) 12 Assume that there is only one ment to be made on Bond S. Why does the longer-term (15-year) hond fluctuate when interest change than does the shorter-term bood (1 year Ye M (5-10) The Brownstone Corporation bonds have 5 years remaining to maturity ondes paid annually, the bonds have $1.000 a nd the compone rate is