Calculate WACC in Excel
Not what you're looking for?
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 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.
Purchase this Solution
Solution Summary
This solution helps in calculating WACC in Excel.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Motivation
This tests some key elements of major motivation theories.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.