Shi Import-Exports balance sheet shows $300 million in debt, $50 million in preferred stock, and $250 million in total common equity. Shis tax rate is 40%, rd 6%, rps 5 8%, and rs 12%. If Shi has a target capital structure of 30% debt, 5% preferred stock, and 65% common stock, what is its WACC?

Provide Excel syntax, please no hand-written answers.