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

Randy Inc. is financing its new invention with issuance of 10 shares of 6 years 4.5% coupon bond with yield to maturity 6%, 60 shares of preferred stock with dividend $2.5 and return of 10%, and 800 shares of common equity at current price of $15 per share. If its common stock has beta 2.5 and long-term risk free rate is 3% and market risk premium is 6%. What is the Weighted Average Cost of Capital given its tax rate is 32%? Ignore floatation costs.

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