6. You are obligated to pay $10,000 in a year. There are two bonds with the following information Bond A Bond B Time to maturity 2 years 0.5 year Coupon rate 7% 5% Price $101.86 $99.51 The yields for both bonds are 6%. Construct a portfolio of bonds A and B using the immunization technique.

6. You are obligated to pay $10,000 in a year. There are two bonds with the following information Bond A Bond B Time to maturity 2 years 0.5 year Coupon rate 7% 5% Price $101.86 $99.51 The yields for both bonds are 6%. Construct a portfolio of bonds A and B using the immunization technique.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 8R: a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it...

See similar textbooks

Similar questions

Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 8 percent interest annually and have 15 years until maturity. You can purchase the bond for $1,075. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 6 percent? Question content area bottom Part 1 a. The yield to maturity on the Saleemi bonds is enter your response here%. (Round to two decimal places.) Part 2 b. You ▼ should should not purchase the bonds because your yield to maturity on the Saleemi bonds is ▼ greater less than the one on a comparable risk bond. (Select from the drop-down menus.)
What is the solution for the attached quesjtom and the method? Thank you very much.
(Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 6 percent interest annually and have 8 years until maturity. You can purchase the bond for $1.115. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 3 percent?
(Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 12 percent interest annually and have 11 years until maturity. You can purchase the bond for $945. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 14 percent? Question content area bottom Part 1 a. The yield to maturity on the Saleemi bonds is enter your response here%. (Round to two decimal places.)
(Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1 comma 000 bonds pay percent interest annually and have 9 years until maturity. You can purchase the bond for $1 comma 075. a. b. What is the yield to maturity on this bond? Should you purchase the bond if the yield to maturity on a comparable - risk bond is 5 percent? 8
Please answer in typing format
Imagine a market where two bonds are traded. Both have a face value of $1,000 and a single annual payment. The first bond is a 5% bullet bond maturing in one year and is traded at $1,034.48. The second bond is a 4% bullet bond maturing in two years and is traded at $1,019.71. Assume that fractions of bonds can be traded. a. Using these bonds, show how you can construct a zero - coupon bond with face value $1,000 maturing in one year and a zero - coupon bond with face value $1,000 maturing in two years.
a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it be if there were only 9 or 8 years to maturity? Use the worksheet to compute the bond issue prices and enter them in the spaces provided. Bond issue price (9 years to maturity) __________________ Bond issue price (8 years to maturity) __________________ b. Compare these prices to the bond-carrying values found in the effective interest amortization schedule you originally printed out in requirement 3. Explain the similarity. c. Click the Chart sheet tab. The chart presented shows the price behavior of this bond based on years to maturity. Explain what effect years to maturity has on bond prices. Check your explanation by trying 8% as the effective rate (cell E10) and clicking the Chart sheet tab again. Also try 9%. When the assignment is complete, close the file without saving it again. Worksheet. Modify the BONDS3 worksheet to accommodate bonds with up to 20-year maturity. Use your new model to determine the issue price and amortization schedules of a 2,000,000, 18-year, 10% bond issued to yield 9%. Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as BONDST. Hint: Expand both amortization schedules to 20 years. Expand the scratch pad to 20 years. Modify FORMULA1 in cell F17 to include the new ranges. Chart. Using the BONDS3 file, prepare a line chart that plots annual interest expense over the 10-year life of this bond under both the straight-line and effective interest methods. No Chart Data Table is needed. Put A23 to A32 in the Label format and then select A23 to A32, D23 to D32, and B40 to B49 as a collection. Enter all appropriate titles, legends, formats, and so forth. Enter your name somewhere on the chart. Save the file again as BONDS3. Print the chart.
Krystian Inc. issued 10-year bonds with a face value of $100,000 and a stated rate of 4% when the market rate was 6%. Interest was paid semi-annually. Calculate and explain the timing of the cash flows the purchaser of the bonds (the investor) will receive throughout the bond term. Would an investor be willing to pay more or less than face value for this bond?
Listen Assume that there is a bond that pays $20.00 at the and of year 2, and $105.00 at the end of year 7. It sells at a total =$(20.00+105.00). The Macauley duration of the bond is? Answer with two digits decimal accuracy. Blank Excel Worksheet Your Answer
The Saleemi Corporation's $1,000 bonds pay 6 percent interest annually and have 15 years until maturity. You can purchase the bond for $1,155. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 6 percent? Question content area bottom Part 1 a. The yield to maturity on the Saleemi bonds is enter your response here%.
(Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 6 percent interest annually and have 9 years until maturity. You can purchase the bond for $1,115. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 6 percent? a. The yield to maturity on the Saleemi bonds is %. (Round to two decimal places.) C...