View the step-by-step solution to:

Cost of Capital - Raising Capital Problems 1, 3, 5, 6 1. P14-13 Calculating the WACC [LO3] - Weighted Average Cost of Capital Filer Manufacturing has...

Cost of Capital and Raising Capital - Please show me how to calculate 4 problems, using Excel, if possible.
Cost of Capital – Raising Capital Problems 1, 3, 5, 6 1. P14-13 Calculating the WACC [LO3] – Weighted Average Cost of Capital Filer Manufacturing has 9.6 million shares of common stock outstanding. The current share price is $49, and the book value per share is $4. Filer Manufacturing also has two bond issues outstanding. The first bond issue has a face value of $76 million, has a 6 percent coupon, and sells for 93 percent of par. The second issue has a face value of $62.4 million, has a 5.99 percent coupon, and sells for 97.4 percent of par. The first issue matures in 9 years, the second in 7 years. The most recent dividend was $2.5 and the dividend growth rate is 4.3 percent. Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 31 percent. Required: What is the company's WACC? (Do not round your intermediate calculations.) 8.49% is the correct answer. I need to know how to calculate it. Please show me using Excel, if possible. 3. P15-3 Rights [LO4] Red Shoe Co. has concluded that additional equity financing will be needed to expand operations and that the needed funds will be best obtained through a rights offering. It has correctly determined that as a result of the rights offering, the share price will fall from $140 to $119 ($140 is the rights-on price; $119 is the ex-rights price,also known as the when-issued price). The company is seeking $13 million in additional funds with a per-share subscription price equal to $70. How many shares are there currently, before the offering? (Assume that the increment to the market value of the equity equals the gross proceeds from the offering.) 433,333 is the correct answer. I need to know how to calculate it. Please show me using Excel, if possible. 5. P15-14 Selling Rights [LO4] Roth Corp. wants to raise $3.9 million via a rights offering. The company currently has 540,000 shares of common stock outstanding that sell for $30 per share. Its underwriter has set a subscription price of $23 per share and will charge the company a 8 percent spread. If you currently own 5,700 shares of stock in the company and decide not to participate in the rights offering, how much money can you get by selling your rights? (Do not round your intermediate calculations.) $10,153.07 is the correct answer. I need to know how to calculate it. Please show me using Excel, if possible.
Background image of page 1
6. P15-8 Price Dilution [LO3] Left Turn, Inc., has 140,000 shares of stock outstanding. Each share is worth $100, so the company's market value of equity is $14,000,000. Required: (a ) Suppose the firm issues 20,000 new shares at the price of $100, what will the effect be of this offering price on the existing price per share? (Do not round your intermediate calculations.) 0.25 0.00 -0.25 60.00 40.50 (b ) Suppose the firm issues 20,000 new shares at the price of $88, what will the effect be of this offering price on the existing price per share? (Do not round your intermediate calculations.) -1.50 57.60 -1.58 -1.42 37.60 (c ) Suppose the firm issues 20,000 new shares at the price of $67, what will the effect be of this offering price on the existing price per share? (Do not round your intermediate calculations.) -4.12 -3.92 -4.33 53.40 33.40
Background image of page 2
Sign up to view the entire interaction

Top Answer

Dear Student, The difference is only... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online