Question

PLEASE SOLVE USING EXCEL AND SHOW FORMULAS  Gronseth Drywall​ Systems, Inc., is in discussions with its...

PLEASE SOLVE USING EXCEL AND SHOW FORMULAS

 Gronseth Drywall​ Systems, Inc., is in discussions with its investment bankers regarding the issuance of new bonds. The investment banker has informed the firm that different maturities will carry different coupon rates and sell at different prices. The firm must choose among several alternatives. In each​ case, the bonds will have a ​$1000 par value and flotation costs will be ​$40 per bond. The company is taxed at 25​%. Use the approximation formula to calculate the ​after-tax cost of financing with the following alternative. 

Coupon Rate: 8%

Time to Maturity 17 Years

Premium or Discount: 290

The after-tax cost of financing using the approximation formula is

(round answer to two decimal places

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Gronseth Drywall Systems, Inc., is in discussions with its investment bankers regarding the issuance of new...
Gronseth Drywall Systems, Inc., is in discussions with its investment bankers regarding the issuance of new bonds. The investment banker has informed the firm that different maturities will carry different coupon rates and sell at different prices. The firm must choose among several alternatives. In each case, the bonds will have a $1,000 par value and flotation costs will be $40 per bond. The company is taxed at 21%. Use the approximation formula to calculate the after-tax cost of financing...
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc....
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc. Practice question 14: Calculate the company’s w.a.c.c. using the info below. ***assume this is a corporate bond that pays 2x annually when calculating the PV of the bond Harvey LLC’s capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The company’s main competitor just issued a similar bond paying 5%. The...
Please show formulas and calculations and not just results and numbers, and explain rationale for answers....
Please show formulas and calculations and not just results and numbers, and explain rationale for answers. Equity Lighting Corporation wishes to explore the effect on its cost of capital of the rate at which the company pays taxes. The firm wishes to maintain a capital structure of 30% debt, 10% preference shares and 60% ordinary shares. Considering Equity’s risk profile, shareholders expect a return of 14% on their investment, the cost of preference shares financing is 9% and the before-tax...
A firm that is in the 35% tax bracket forecasts that it can retain $4 million...
A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91 (91% of face value), have 4 years remaining, have an annual coupon of 7%, and their investment bank thinks that new bonds will have a 40 basis point (0.40%)...
I will be happy if you use excel and show me the calculation process. Please complete...
I will be happy if you use excel and show me the calculation process. Please complete in your own style. If u get any info missing or any sequence problem for the question then adjust it or take assumption for it. I hope all info there but still if i miss then do it in your own style. Thanks Roster Pte Ltd issued 100 million of 11-year bonds with a 9.5% coupon payable annually. This bond was issued a year...
3. The cost of debt What do lenders require, and what kind of debt costs the...
3. The cost of debt What do lenders require, and what kind of debt costs the company? The cost of debt that is relevant when companies are evaluating new investment projects is the marginal cost of the new debt to be raised to finance the new project. Consider the case of Red Oyster Seafood Company (Red Oyster): Red Oyster Seafood Company is considering issuing a new 20-year debt issue that would pay an annual coupon payment of $70. Each bond...
Cost of capital    Edna Recording​ Studios, Inc., reported earnings available to common stock of $4,000,000 last...
Cost of capital    Edna Recording​ Studios, Inc., reported earnings available to common stock of $4,000,000 last year. From those​ earnings, the company paid a dividend of $1.15 on each of its 1,000,000 common shares outstanding. The capital structure of the company includes 35​% debt, 15​% preferred​ stock, and 50​% common stock. It is taxed at a rate of 27​%. a.  If the market price of the common stock is $40 and dividends are expected to grow at a rate of...
Edna Recording​ Studios, Inc., reported earnings available to common stock of ​$4 comma 400 comma 0004,400,000...
Edna Recording​ Studios, Inc., reported earnings available to common stock of ​$4 comma 400 comma 0004,400,000 last year. From those​ earnings, the company paid a dividend of ​$1.251.25 on each of its 1 comma 000 comma 0001,000,000 common shares outstanding. The capital structure of the company includes 2525​% ​debt, 2020​% preferred​ stock, and 5555​% common stock. It is taxed at a rate of 2424​%. a.  If the market price of the common stock is ​$4545 and dividends are expected to...
Edna Recording​ Studios, Inc., reported earnings available to common stock of ​$4,400,000 last year. From those​...
Edna Recording​ Studios, Inc., reported earnings available to common stock of ​$4,400,000 last year. From those​ earnings, the company paid a dividend of ​$1.33 on each of its 1,000,000 common shares outstanding. The capital structure of the company includes 35​% ​debt, 20​% preferred​ stock, and 45​% common stock. It is taxed at a rate of 40​%. a. If the market price of the common stock is $50 and dividends are expected to grow at a rate of 6​% per year...
Brook’s Window Shields Inc. is trying to calculate its cost of capital for use in a...
Brook’s Window Shields Inc. is trying to calculate its cost of capital for use in a capital budgeting decision. Mr. Glass, the vice-president of finance, has given you the following information and has asked you to compute the weighted average cost of capital. The company currently has outstanding a bond with a 10.2 percent coupon rate and another bond with a 7.5 percent coupon rate. The firm has been informed by its investment banker that bonds of equal risk and...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT