For this week’s assignment, use the spreadsheet you created in Module 3 and updated in Module 6. Update the spreadsheet by adding the financing component (calculation of WACC) for the model. In other words, instead of the model simply having an input that is the value of “r,” users should input information about the capital structure of the firm, the cost of debt, the cost of equity for the firm, the weight of each, and WACC should be calculated and used in the calculations of the model. For your submission, the only additional data that will be needed to add to your model is:
Cost of Equity13%
Cost of Debt8.5%
Weight of Equity50%
Weight of Debt50%
the spread sheet for module 6 assignment is attached. The bold information needs to be incorporated into this weeks assignment.