Question

Cost of debt Dundern, Inc. (DM) is sling 600.000 bonds to raise money for the publication of new magazines in the coming year
0 0
Add a comment Improve this question Transcribed image text
Answer #1
semi annual cost of bond-1 Using rate function in MS excel = rate(nper,pmt,pv,fv,type) nper = 60 pmt = -3600000 pv =45000000 fv =-60000000 type =0 RATE(60,-3600000,45000000,-60000000,0) 8.03%
Annual rate 8.03*2 16.06
semi annual cost of bond-2 Using rate function in MS excel = rate(nper,pmt,pv,fv,type) nper = 60 pmt = -3600000 pv =54000000 fv =-60000000 type =0 RATE(60,-3600000,54000000,-60000000,0) 6.68%
Annual rate 6.68*2 13.36
semi annual cost of bond-3 Using rate function in MS excel = rate(nper,pmt,pv,fv,type) nper = 60 pmt = -3600000 pv =66000000 fv =-60000000 type =0 RATE(60,-3600000,66000000,-60000000,0) 5.43%
Annual rate 5.43*2 10.86
semi annual cost of bond-4 Using rate function in MS excel = rate(nper,pmt,pv,fv,type) nper = 60 pmt = -3600000 pv =75000000 fv =-60000000 type =0 RATE(60,-3600000,75000000,-60000000,0) 4.74%
Annual rate 4.74*2 9.48
X New Microsoft Office Excel Worksheet Microsoft Excel Cia Formulas Data Home Insert Page Layout Review View Cut Σ AutoSum A

X New Microsoft Office Excel Worksheet Microsoft Excel Cin Formulas Data Home Insert Page Layout Review View Cut Σ AutoSum AX New Microsoft Office Excel Worksheet Microsoft Excel Cia Formulas Data Home Insert Page Layout Review View Cut Σ AutoSum AX New Microsoft Office Excel Worksheet Microsoft Excel Cla Formulas Data Home Insert Page Layout Review View Cut Σ AutoSum A

Add a comment
Know the answer?
Add Answer to:
Cost of debt Dundern, Inc. (DM) is sling 600.000 bonds to raise money for the publication...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Dunder-Mifflin, Inc.​ (DMI) is selling​ 600,000 bonds to raise money for the publication of new magazines...

    Dunder-Mifflin, Inc.​ (DMI) is selling​ 600,000 bonds to raise money for the publication of new magazines in the coming year. The bonds will pay a coupon rate of 14.2​% with semiannual payments and will mature in 30 years. Its par value is ​$100. DMI hires an investment banker for the sale of the​ 600,000 bonds. The investment banker charges a fee of 2​% on each bond sold. What is the cost of debt to DMI if the following are the...

  • Kintel, Inc., management wants to raise $1 million by issuing six-year zero coupon bonds with a...

    Kintel, Inc., management wants to raise $1 million by issuing six-year zero coupon bonds with a face value of $1,000. The company’s investment banker states that investors would use an 12.38 percent discount rate to value such bonds. Assume semiannual coupon payments. At what price would these bonds sell in the marketplace? (Round intermediate calculations to 4 decimal places, e.g. 1.2514 and Bond price to 2 decimal places, e.g. 15.25) How many bonds would the firm have to issue to...

  • Crane, Inc., management wants to raise $1 million by issuing six-year zero coupon bonds with a...

    Crane, Inc., management wants to raise $1 million by issuing six-year zero coupon bonds with a face value of $1,000. The company’s investment banker states that investors would use an 9.1 percent discount rate to value such bonds. Assume semiannual coupon payments. At what price would these bonds sell in the marketplace? (Round answer to 2 decimal places, e.g. 15.25) Market rate $ How many bonds would the firm have to issue to raise $1 million? (Round answer to 0...

  • (Cost of debt) Gillian Stationery Corporation needs to raise $579,000 to improve its manufacturing plant. It...

    (Cost of debt) Gillian Stationery Corporation needs to raise $579,000 to improve its manufacturing plant. It has decided to issue a $1,000 par value bond with an annual coupon rate of 7.2 percent with interest paid semiannually and a 10-year maturity. Investors require a rate of return of 11.1 percent a. Compute the market value of the bonds. b. How many bonds will the firm have to issue to receive the needed funds? c. What is the firm's after-tax cost...

  • After-tax Cost of Debt The Holmes Company's currently outstanding bonds have a 9% coupon and a...

    After-tax Cost of Debt The Holmes Company's currently outstanding bonds have a 9% coupon and a 13% yield to maturity. Holmes believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 40%, what is Holmes's after-tax cost of debt? Round your answer to two decimal places. %

  • Turnbull Co. is considering a project that requires an initial investment of $270,000. The firm will raise the $270,000...

    Turnbull Co. is considering a project that requires an initial investment of $270,000. The firm will raise the $270,000 in capital by issuing $100,000 of debt at a before-tax cost of 10.2%, $30,000 of preferred stock at a cost of 11.4%, and $140,000 of equity at a cost of 14.3%. The firm faces a tax rate of 25%. What will be the WACC for this project? (Note: Round your intermediate calculations to three decimal places.) Consider the case of Kuhn...

  • The cost of debt Gronseth Drywall Systems, Inc, is in discussions with its investment bankers r...

    The cost of debt Gronseth Drywall Systems, Inc, is in discussions with its investment bankers r informed the firm that different matunities will carry diferent coupon rates and sell at different prices. The firm must choose among several alternatives. In each case the on s wil have a S1 000 par value and tation costs will be $40 per bond The company s taxed at 24% Use the approximation formula to calculate the aff tax cost of financing with the...

  • 2. An overview of a firm's cost of debt To calculate the after-tax cost of debt,...

    2. An overview of a firm's cost of debt To calculate the after-tax cost of debt, multiply the before-tax cost of debt by (1-1) Western Gas & Electric Company (WGC) can borrow funds at an interest rate of 12.50% for a period of six years. Its marginal federal-plus-state tax rate is 25%. WGC's after-tax cost of debt is 9.38% (rounded to two decimal places). At the present time, Western Gas & Electric Company (WGC) has 15-year noncallable bonds with a...

  • Bridgeport Inc. has decided to raise additional capital by issuing $167,000 face value of bonds with...

    Bridgeport Inc. has decided to raise additional capital by issuing $167,000 face value of bonds with a coupon rate of 10%. In discussions with investment bankers, it was determined that to help the sale of the bonds, detachable stock warrants should be issued at the rate of one warrant for each $100 bond sold. The value of the bonds without the warrants is considered to be $118,400, and the value of the warrants in the market is $29,600. The bonds...

  • Caughlin Company needs to raise $55 million to start a new project and will raise the money by selling new bonds. The co...

    Caughlin Company needs to raise $55 million to start a new project and will raise the money by selling new bonds. The company will generate no internal equity for the foreseeable future. The company has a target capital structure of 55 percent common stock, 15 percent preferred stock, and 30 percent debt. Flotation costs for issuing new common stock are 7 percent, for new preferred stock, 4 percent, and for new debt, 2 percent. What is the true initial cost...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT