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

1. Running Deer firm is considering a target capital structure 45% debt and 55% equity. The cost of equity for an unlevered firm of Running Deer is 12% and the before tax cost of new debt issued is constant at 8%.

(a) Calculate the Weighted Average Cost of Capital (WACC) for the Levered Firm assuming the corporate tax rate is 35%

(b) Calculate the Market Value of Levered Firm and the Market Value of Equity from Levered Firm if the operating income is $2,000,000 and corporate tax rate is 40%

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