please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

Dixie Inc. is financing its new product line with issuance of 6 million shares of 5 years 6% coupon bond with yield to maturity 4.5%, 15 million shares of preferred stock with dividend $3 and return of 9%, and 800 million shares of common equity at current price of $25 per share. If its common stock has beta 1.4 and long-term risk free rate is 3% and market risk premium is 5%. What is the Weighted Average Cost of Capital (WACC) given its tax rate is 38%? Ignore flotation costs.

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN