Hi, wouldyou be able to help me with this within the next 2 hours? It is based on the Walmart WACC assignment you had helped me with last week.

OCS Assignment

This assignment follows from your previous WACC project. Here, you must determine what the optimum capital structure is for your firm. A sample spreadsheet is provided where you may input the data that you have already found for the WACC. The spreadsheet will use Hamadas Equation to recalculate the levered betas based on the weights that you choose.

NOTE: You cannot just assume that your weights and your bond values are the same as the sample. You must choose the appropriate weights first based on the market value weights your firm currently has. Then, you must choose appropriate bond rates as you increase or decrease the weight for debt.

You must explain and reference how you chose your numbers and attach a copy of the spreadsheet.

Note that the spreadsheet has all the calculations for the WACC on the top portion, but Hamadas Equation only uses the CAPM to refigure the levered beta and the new WACC for that beta.

I have attached the spreadsheets from the referenced WACC project for Walmart