Use excel and excel formulas and show the work for the following question;

Problem $14\mathrm{.}6$: You are working in the Finance Department of Coleman Technologies, and your supervisor has asked you to compute the appropriate discount rate to use when evaluating the purchase of new packaging equipment for the plant. Thus, you wish to calculate the firm's cost of capital. Under the assumption that the firm's present capital structure reflects the appropriate mix of capital sources for the firm, you have detemined the market value of the firm's capital structure shown below:

Source of Capital Bonds Preferred Stock Common Stock

$\backslash$table$[[$Market Value$],[$$$4,000,000$