SOLVE WITH EXCEL:

The local manufacturing plant you work for is looking into expanding its operations by building a second plant with all new equipment. This investment would be a huge endeavor and require a large cash infusion. In attempting to run financials on this proposed expansion, you need to calculate the weighted average cost of capital. Based on the firm's current structure in the following table, what would be the weighted average cost of capital?

Costs of Capital

$\backslash$table$[[$Cost of debt $($after tax$),3\%$