need help solving in excel pls pls. Problem 12-22 Calculating the Cost of Debt [LO2]Ying Import has several bond issues outstanding, each making semiannual interestpayments. The bonds are listed in the table below.Bond123Coupon Rate8.90%Aftertax cost of debt6.408.609.10Price Quote105.994.5%104.794.5If the corporate tax rate is 24 percent, what is the aftertax cost of the company'sdebt?Note: Do not round intermediate calculations and enter your answer as a percentrounded to 2 decimal places, e.g., 32.16.Maturity3 years6 years13.5 years23 years

Answered: Image /qna-images/answer/496519c8-7bcf-4c3b-b9c3-94a1fd977539.jpg

Ying Import has several bond issues outstanding, each making semiannual interest payments. The bonds are listed in the table below. Bond 1 2 3 4 Coupon Rate 8.90% 6.40 8.60 9.10 Price Quote 105.9 94.5 104.7 94.5 Maturity 3 years 6 years. 13.5 years 23 years If the corporate tax rate is 24 percent, what is the aftertax cost of the company's debt?

Ying Import has several bond issues outstanding, each making semiannual interest payments. The bonds are listed in the table below. Bond 1 2 3 4 Coupon Rate 8.90% 6.40 8.60 9.10 Price Quote 105.9 94.5 104.7 94.5 Maturity 3 years 6 years. 13.5 years 23 years If the corporate tax rate is 24 percent, what is the aftertax cost of the company's debt?

Corporate Financial Accounting

14th Edition

ISBN:9781305653535

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter11: Liabilities: Bonds Payable

Section: Chapter Questions

Problem 11.1EX

See similar textbooks

Similar questions

Question 8 Ch. 13. For questions 7, 8, and 9, use the following information: 7.) Consider a firm whose debt has a market value of $35 million and whose stock has a market value of $55 million. The firm pays a 7 percent rate of interest on its new debt and has a beta of 1.23. The corporate tax rate is 21%. Assume that the security market line holds, that the risk premium on the market is 10.5 percent, and that the current Treasury bill is rate is 1 percent. What is the aftertax cost of debt? Format as a percentage and round to two places past the decimal point as "X.XX" 5.53 8.) Consider a firm whose debt has a market value of $35 million and whose stock has a market value of $55 million. The firm pays a 7 percent rate of interest on its new debt and has a beta of 1.23. The corporate tax rate is 21%. Assume that the security market line holds, that the risk premium on the market is 10.5 percent, and that the current Treasury bill is rate is 1 percent. Using the pretax cost of debt…
20.1 Evaluate the following statements: S1 The proceeds of a bond with a face amount of P100,000,000 which sells at 102 will be P102,000,000. S2 The proceeds of a bond with a face amount of P100,000,000 which sells at 98 will be P98,000,000. S3 When bonds are issued at a discount, the bonds payable account may be credited for the proceeds from the issue. S4 When bonds are issued at a premium, amortizing the premium using the effective interest method, will increase the amortization. a. Only 1 statement is correct b. All statements are correct c. Only 2 statements are correct d. Only 3 statements are correct e. All statements are incorrect
Problem 6-10 Liquidity Premium Theory (LG6-7) One-year Treasury bills currently earn 3.10 percent. You expect that one year from now, 1-year Treasury bill rates will increase to 3.30 percent and that two years from now, 1-year Treasury bill rates will increase to 3.80 percent. The liquidity premium on 2-year securities is 0.15 percent and on 3-year securities is 0.25 percent. If the liquidity premium theory is correct, what should the current rate be on 3-year Treasury securities? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Problem 6-32 Credit Risk (LO4) a. Several years ago, Castles in the Sand Inc. issued bonds at face value of $1,000 at a yield to maturity of 7.4%. Now, with 8 years left until the maturity of the bonds, the company has run into hard times and the yield to maturity on the bonds has increased to 12%. What is the price of the bond now? (Assume semiannual coupon payments.) (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Suppose that investors believe that Castles can make good on the promised coupon payments but that the company will go bankrupt when the bond matures and the principal comes due. The expectation is that investors will receive only 82% of face value at maturity. If they buy the bond today, what yield to maturity do they expect to receive? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
P6–23 Bond valuation and yield to maturity Mark Goldsmith’s broker has shown him two bonds issued by different companies. Each has a maturity of 5 years, a par value of $1,000, and a yield to maturity of 7.5%. The first bond is issued by Crabbe Waste Disposal Corporation and has a coupon rate of 6.324% paid annually. The second bond, issued by Malfoy Enterprises, has a coupon rate of 8.8% paid annually. D. Assume that Mark will reinvest all the interest he receives as it is paid, and his rate of return on reinvested interest will be 10%. Calculate the total dollars that Mark will accumulate over 5 years if he invests in Crabbe bonds or Malfoy bonds. Your total dollar calculation will include the interest Mark gets, the principal he receives when the bonds mature, and all the additional interest he earns from reinvesting the coupon payments that he receives. E. The bonds issued by Crabbe and Malfoy might appear to be equally good investments because they offer the same yield to…
Problem 6-3 Bond Prices [LO 2] Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 7 years to maturity, and a coupon rate of 8.8 percent paid annually. If the YTM is 10.8 percent, what is the current bond price in euros?
Problem 3 Linz Styles Coupon Rate (RWJJ Ch. 20, Q5) Linz Stylers intends to issue perpetual callable bonds with annual coupon payments. The bonds are callable at $1,250. One-year interest rates are 11 percent. There is a 60 percent probability that long-term interest rates one year from today will be 13 percent, and a 40 percent probability that long-term interest rates will be 9 percent or even lower. Assume that if interest rates fall, the fall will be sufficient for the bonds to be called. What coupon rate should the bonds have in order to sell at par value?
kk.2 The coupon rate on an issue of debt is 9%. The yield to maturity on this issue is 11%. The corporate tax rate is 32%. What would be the approximate after-tax cost of debt for a new issue of bonds? (Round your answer to 2 decimal places.)
P6–23 Bond valuation and yield to maturity Mark Goldsmith’s broker has shown him two bonds issued by different companies. Each has a maturity of 5 years, a par value of $1,000, and a yield to maturity of 7.5%. The first bond is issued by Crabbe Waste Disposal Corporation and has a coupon rate of 6.324% paid annually. The second bond, issued by Malfoy Enterprises, has a coupon rate of 8.8% paid annually. A. Calculate the selling price for each bond. B. Mark has $20,000 to invest. If he wants to invest only in bonds issued by Crabbe Waste Disposal, how many of those bonds could he buy? What if he wants to invest only in bonds issued by Malfoy Enterprises? Round your answers to the nearest integer. C. What is the total interest income that Mark could earn each year if he invested only in Crabbe bonds? How much interest would he earn each year if he invested only in Malfoy bonds?
Q 10. The duration of to be approved loan of $15 million is 4 years. The increase in credit risk premium for bonds belonging to the same risk category of the loan has been estimated to be 4.5 per cent. What is the capital at risk if the current average level of interest rates for this category of bonds is 10 percent? a) $357,142.86 b) $1,789,565 c) $2,454,545.45 d) $2,755,357.14 e) $1,964,285.71
Question 4: Chapter 1 On 1 October 20X3, Shanghai issued $10 million convertible loan notes which carry a coupon rate of 5% per annum. The loan notes are redeemable on 30 September 20X6 at par for cash or can be exchanged for equity shares. A similar loan note, without the conversion option, would have required Shanghai to pay an interest rate of 8%. (1) What is the amount that will be recognized as finance costs for the year ended 30 September 20X4. (2) What is the amount that should be shown under liabilities at 30 Sep 20X4. (3) How much would be recorded in equity in relation to the loan notes? Show your workings and round your answers to 2 decimals.
LO 13.1 On October 1 a company sells a 3-year, $2,500,000 bond with an 8% stated interest rate. Interest is paid quarterly and the bond is sold at 89.35. On October 1 the company would collect ________. $200,000 $558,438 $2,233,750 $6,701,250