1)Use Excel to calculate WACC
2)Use Word to explain how the capital structure would need to change to reduce cost of capital
3)Determine if the capital structure is at optimal level now, explain in detail why you believe this to be true
4)If the capital is not optimal, would altering it increase or decrease the cost of capital. Explain in detail.

These are the following facts:
- Company debt and other long-term obligations are $14 million.
- The split for the $14 million is $5 million in bonds that are at 8% and $9 million in a long-term loan at 7.5%
- Company equity is $150.1 million.
- Cost equity (according to SML) is 9%.
- The company is in the 40% tax bracket

Include references except from Wikipedia and please include a word document with the explanations and not on the Excel spreadsheet.

Solution Preview

Calculate WACC in Excel, explain how the capital structure would need to change to reduce cost of capital etc

Please see the attached Word and Excel files for the solution.

Corporate Finance

Calculate WACC in Excel, explain how the capital structure would need to change to reduce cost of capital etc
THe course is Corporate Finance

1) Use Excel to calculate WACC
2) Use Word to explain how the capital structure would need to change to reduce cost of capital
3) Determine if the capital structure is at optimal level now, explain in detail why you believe this to be true
4) If the capital is not optimal, would altering it increase or decrease the cost of capital. Explain in detail.

These are the following facts:
- Company debt and other long-term obligations are $14 million.
- The split for the $14 ...

I have an excel spreadsheet where certain areas have been left blank and need to be computed in order to complete a research paper. However, I'm not sure how to do the calculations correctly. Please help. The areas highlighted in YELLOW need to be calculated. Thank you.

A company has 2,000,000 share of outstanding common stock with a market price of $2.00 per share. The company has 2,000 outstanding bonds that are selling for $1,200. The bonds mature in 15 years, have a coupon rate of 10%, and pay coupons annually. The company's beta is 1.2, the risk free rate is 5%, and the market premium i

Question: Malholtra Inc. (Ehrmann Data System) is considering a project that has the following cash flow and WACC data. What is the project's MIRR? Note, that a project's projected MIRR can be less than the WACC (and even negative), in which case it will be rejected.
WACC: 10.00%
Year: 0 1 2 3 4
Cash flows: $1,175 $30

ExxonMobil's required return for equity, Re is 14%. Its required return for debt, Rd is 8%, its debt-to-total-value ratio L, is 35%, and its marginal tax rate, T is 40%, calculate its (adjusted WACC)?

Question: Wippet Industries (WI) has a book value capital structure as shown below.
- Bonds pay annual coupons of $91
- Have 6 years to go until they mature
- Have a YTM of 7%
- Stock sells for $22 per share
- Has a beta of 1.39
- Expected return on the market is 12%
- t-bills pay 3.3%.
- Taxes are 32%.
What is t

The Boonville and Western Transportation Co. has the following capital structure.
Stock $50 mil with a P/E of 8
Bonds $20 million at 8 %
The company has a tax rate of 35%
What is the weighted average cost of Capital (WACC)
If the Boonville and Western Transportation Co had Bonds of $50 million a

Given:
Total assets $3,000,000
The risk free rate Krf 6%
The market rate Km 11%
the unlevered beta of the firm 1.1
The tax rate 40%
Assume that all earning are used for dividends (EPS = DPS) and 0 growth
The following 5 debt levels

I need your help with this problem. How do I calculateWACC; Reactive Industries has the following capital structure. Its corporate tax rate is 35 percent. What is its WACC?
SECURITY MARKET VALUE REQUIRED RATE OF RETURN
DEBT $20 Million 6%
PREFERRED STOCK $10 Million

Nathan's Catering is a gourmet catering service located in Southampton, New York. It has an unleveraged required return of r=43%. Nathan's rebalances its capital structure each year to a target of L=0.52. T*=0.20. Nathan's can borrow currently at a rate of rd=26%. What is Nathan's WACC?
Please provide step by step instructio