please ignore my answers in the blue.

To copy paste a formula acron a row or down a wolum, an absolute will reference or amid cell reference may be prel a specific Exowl function is to be the directions will specify the use of that function. Do not type in numerical data into a celor miction Instead make a reference to the call in which the data is found. Make your compulations only in the blue le highlighted below. In all cases, wless otherwise directed the earliest appearance of the data in your formular, wually the Glen Dola section Afler reaching the competiton of El Enterprises, you determine that most comparable fims have the following valuation nation EV/EBITDA PE Comp 1 12.0 19.0 Comp 2 11.0 18.0 Comp3 12.5 20.0 Comp 4 10.0 170 EH Enterprises had EPS of S2, EBITDA of 300 million, $30 million in cash, $40 million in debt, and 100 million shares outstanding What range of price is consistent with both sets of multiples? EPS EBITDA (000) Cash (000) Debt (000) Shares outstanding (000) s s S $ 2.00 300,000 30,000 40,000 100,000 EV/EBITDA PE Comp1 Comp 2 3.590.000,005 3,290,000.00 38.00 $ 36.00S Comp3 3.740.000,00 40.00 $ Comp 4 2.990,000.00 34.00 23 21 Maximum value Minimum value 40.00 29.90 Requirements In cell range D19:G19, by using cell references, calculate the EVEBITDA multiple for Compl.Compi, respectively (4 pt). 27 2 In cell range D20 G20, by using cell references, calculate the P/E matio for Compl.Comp, respectively (4 pt). 3 In cell D22, by using cell references, calculate the maximum stock price (pt.) In cell D2), by using cell references, calculate the minimum stock price (pt) 4 11