Consider the following bonds: Which of the bonds A to D is most sensitive to a 1%drop in interest rates from 6.5% to 5.5% Which bond is least sensitive? Bond Data table is most sensitive. (Select from the drop-down menu.) (Click on the following icon in order to copy its contents into a spreadsheet.) Bond Coupon Rate (annual payments) ABCD A 0.0% B 0.0% с 4.3% 7.7% Maturity (years) 10 15 15 10

Consider the following bonds: Which of the bonds A to D is most sensitive to a 1%drop in interest rates from 6.5% to 5.5% Which bond is least sensitive? Bond Data table is most sensitive. (Select from the drop-down menu.) (Click on the following icon in order to copy its contents into a spreadsheet.) Bond Coupon Rate (annual payments) ABCD A 0.0% B 0.0% с 4.3% 7.7% Maturity (years) 10 15 15 10

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 3R

See similar textbooks

Similar questions

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.
The following information about bonds A, B, C, and D are given. Assume that bond prices admit noarbitrage opportunities. What is the convexity of Bond D?Cash Flow at the end ofBond Price Year 1 Year 2 Year 3A 91 100 0 0B 86 0 100 0C 78 0 0 100D ? 5 5 105
Calculating the risk premium on bonds The text presents a formula where (1+1) = (1-p)(1 +i+x) + p(0) where i is the nominal interest rate on a riskless bond x is the risk premium p is the probability of default (bankruptcy) If the probability of bankruptcy is zero, the rate of interest on the risky bond is When the nominal interest rate for a risky borrower is 8% and the nominal policy rate of interest is 3%, the probability of bankruptcy is %. (Round your response to two decimal places.) When the probability of bankruptcy is 6% and the nominal policy rate of interest is 4%, the nominal interest rate for a risky borrower is %. (Round your response to two decimal places.) When the probability of bankruptcy is 11% and the nominal policy rate of interest is 4%, the nominal interest rate for a risky borrower is %. (Round your response to two decimal places.) The formula assumes that payment upon default is zero. In fact, it is often positive. How would you change the formula in this case?…
Give typing answer with explanation and conclusion Assume that you observe the following rates on long-term bonds: U.S. Treasury bonds = 4.15 percent AAA Corporate bonds = 6.2 percent BBB The main reason for the differences in the interest rates is Multiple Choice maturity risk premium inflation premium default risk premium convertibility premium
Consider the following bonds Bond Which of the bonds A to D is most sensitive to a 1% drop in interest rates from 6.7% to 5 7%? Which bond is least sensitive? is most sensitive (Select from the drop-down menu) Data table (Click on the following icon in order to copy its contents into a spreadsheet)) Bond Coupon Rate (annual payments) Maturity (years) A 0.0% 15 B 0.0% 10 15 10. 100 с D 3.8% 8.4% Print Done - X
A bond quotes a rate of return of 5% and will pay $1,000 in one year with a probability of 42% and $0 with a probability of 58%. part A)What is the time premium? part B)What is the default premium? I need full explanation .. No plagiarism plzz
Suppose that a short-term government bond has a face value of $100. If the price of that bond is $95. What is the insterest rate of that bond? 5.3% 9.0% 10.0% 1.0%
Determine the price of a single bond given the following information. Round your final answer to two decimal places. For example, if your answer is $89.12, enter 89.12 with no currency symbol. 4.39% Cost of Debt (Kd) The company is expected to pay the following forecasted CFFD (Cash Flows For Debt): Year 1: $50.00 interest payment Year 2: $50.00 interest payment Year 3: $50.00 interest payment Year 4: $50.00 interest payment Year 5: $50.00 interest payment The company will also pay the bond's face value of $1,000.00 at the end of year 5. The company faces a 25% tax rate. Type your answer...
Suppose the current price of the bond is $95, the YTM is 4%, and the duration of the bond is 9. If YTM decrease from 4% to 3.9%, approximate the change in price using duration of the bond. Price would increase by ____%
Consider the following bonds: Bond A B CD с Coupon Rate (annual payments) 0.0% 0.0% 4.3% 7.7% The percentage change in the price of bond A is |___%. (Round to one decimal place.) What is the percentage change in the price of each bond if its yield to maturity falls from 6.9% to 5.9%? The percentage change in the price of bond B is %. (Round to one decimal place.) Maturity (years) 15 The percentage change in the price of bond C is %. (Round to one decimal place.) The percentage change in the price of bond D is %. 21500
Consider the following bonds. Bond A B с D Coupon Rate (annual payments) 0.0% 0.0% 3.5% 7.8% Maturity (years) 10 15 15 10 Which of the bonds A to D is most sensitive to a 1% drop in interest rates from 6.7% to 5.7%? Which bond is least sensitive? Provide an intuitive explanation for your answer.
Bonds have a maturity risk premium that can be modeled as the following:MRP = (t-1) 0.3%were t represents the years to maturity. What is the Maturity risk premium of a bond that matures in 8 years? answer in % without the symbol