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

What should be the proportion of debt financing (Wd) in WACC computations for a firm with $50 million par value in bonds (debt) but these 4 years bonds with a coupon rate 3% has a yield to maturity at 7.476%. The firm also has a $50 million book value of equity but its stock price is selling at $50 and there are 2 million shares of stock outstanding? Tax rate is 35%.

• A. 57.5%
• B. 29.8%
• C. 42.5%
• D. 60.5%
• E. 70.2%

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