ANSWE: .066 - PLEASE provide ALL equations on how to obtain the correct answer... Even BETTER if it is in EXCEL.

Given the following information, what is the WACC for the firm, WACCcomp?

Corporate tax rate: 40%

Market value:

Short-term debt: $200

Long-term debt:400

Preferred stock: 100

Common Stock: 300

Cost of capital:

Cost of short-term debt: .04

Cost of long-term debt: .08

Cost of preferred stock: .06

Cost of common stock: .12