PLEASE USE EXCEL AND SHOW ALL THE FORMULAS USED- EXPLAIN WITH DETAIL INFORMATION. THANK YOU

3. The effect of financialeverage on ROE Aa Aa Companies that use debt in their capital structure are said to be using financial leverage. Using leverage can increase shareholder returns, but leverage also increases the risk that shareholders bear Consider the following case: wizard Co. is considering a project that will require $600,000 in assets. The project will be financed with 100% equity. The company faces a tax rate of 40%. what will be the ROE (return on equity) for this project if it produces an EBIT (earnings before interest and taxes) of $160,000? 11.2% 9.6% 16.0% 12.0% Determine what the project's ROE will be if its EBIT is-$50,000. When calculating the tax effects, assume that Wizard Co. as a whole will have a large, positive income this year O-5.8% O-4.8% 0-50% O-4.3% wizard Co. is also considering financing the project with 50% equity and 50% debt. The interest rate on the company's debt will be 12%. what will be the project's ROE if it produces an EBIT of $160,000? 24.8% 27.3% 17.4% 28.5% o o