I cannot figure out how to solve for the equity funded (line 23). Can someone please help?

Problem 16-19 Sarvon Systems has a debt-equity ratio of 1.2, an equity beta of 2.0, and a debt beta of 0.30. currently evaluating the following projects, none of which would change the firm's volatility Project Investment (million) NPV (million) A B C $100 $20 $50 $6 $85 $10 a. Which project will equity holders agree to fund? b. What is the cost to the firm of the debt overhang? D/E Ratio b Equity b Debt 1.20 2.00 0.30 a. Which project will equity holders agree to fund? Cutoff Project Profitability index Equity funded? 0.18 A B 0.20 C 0.12 0.12 b. What is the cost to the firm of the debt overhang? Opportunity cost (million) $16 Requirements 1. In cell D19, by using cell references, find the ratio between the debt beta and equity b equity ratio (1 pt.). 2. In cell D22, by using cell references, calculate the profitability index of project A (1 p cells E22:H22 (1 pt.). 3. To decide which project would be eligible for equity funding, you need to compare th the cutoff measure by using the function IF. In cell D23, by using the function IF and compare the profitability index of project A to the cutoff measure; if true, type "Yes" D23 and paste it onto cells E23:H23 (1 pt.). 4. In cell E27, by using cell references, calculate the cost to the firm of the debt overhan .0, and a debt beta of 0.30. It is change the firm's volatility: D E $30 $15 D $75 $18 E 0.50 0.24 n the debt beta and equity beta and multiply it by the debt-to- ility index of project A (1 pt.). Copy cell D22 and paste it onto ng, you need to compare the profitability index of each project to y using the function IF and absolute and relative cell references, easure; if true, type "Yes"; if false, type "No" (1 pt.). Copy cell he firm of the debt overhang (1 pt.)