Explore BrainMass
Share

Explore BrainMass

    Calculate WACC in Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 10, 2019, 3:59 am ad1c9bdddf
    https://brainmass.com/business/weighted-average-cost-of-capital/calculate-wacc-in-excel-444386

    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 ...

    Solution Summary

    This solution helps in calculating WACC in Excel.

    $2.19