Paste a. Av B I uv fx D20 Complete thelew ng cell reference to gl dam or prin callation. In some cases, simple sell reference all you need to capra a formele across a row or down a colum, an abroute cell refermce ora calleerence may he preferred to specific El function is to be used the directions will specify the use of that to Do not npe in Americal data into a cell or function stand, make a reference to the cell whick the das found. Make your computation only in the blue celle highlighted below. In all cases, unless otherwise Wirecl, we the earliest appearance of the data in your formulas, really the Green Data rection After ching the competitors of ETH Enterprises, you determine that most companble fims have the following valtion wios: Como 1 12.0 190 EV EBITDA Como 2 11.0 180 Com 4 10.0 170 12.5 20.0 EJH Enterprises had EPS of $2, EBITDA of $300 million, 530 million in cash, 540 million in debt, and 100 million shares outstanding. What mange of prices is consistent with both sets of multiples? 11 10 14 EPS EBITDA (000) Casb (000) Debt (000) Shares outstanding (000) 5 $ $ S 2.00 300.000 30,000 40.000 100,000 15 Comp 1 Comp 2 Comp3 Comp 4 EV/EBITDA PE Maximum value Minimum value 5 5 29.90 40.00 25 Requirements 1 In cell range D19:619, by using cell references, calculate the EV/EBITDA multiple for Compl:Compi. 27 respectively (4 pt.) In cell range D20:620, by using cell references, calculate the P/E ratio for Compl.Comp4, respectively (pt) In cell D22, by using cell references, calculate the maximum stock price (pt). In cell D23, by using cell references, calculate the minimum stock price (1 pt.) 2 28 4 ARRA Draw Insert Formulas Review Home Data Page Layout View v Times New Roman 14 A A ase Ac Paste BI U Av $ D20 - fx ara med cell reference my he preferred to specific cel function is to be used the directions will specify the use of the function. Do not npe in merical data inte a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directeure the earliest appearance of the data in your formulas, wally the Given Data section After researching the competitors of ETH Enterprises, you determine that most comparable firms have the following valuation ration: EVEBITDA PE Campil 12.0 19.0 Comp2 11.0 18.0 Como 3 125 20.0 Comp 4 10.0 170 EJH Enterprises hind EPS of S2, EBITDA of $300 million, 530 million in cash, S40 million in debt, and 100 million shares outstanding. What range of prices is consistent with both sets of multiples? 30 5 s EPS EBITDA (000) Cash (000) Debt (000) Shares outstanding (000) s $ 2.00 300.000 30.000 40.000 100.000 16 Comp 1 Comp 2 Comp3 Comp 4 EV/EBITDA PE 20 Maximum value Minimum value S S 29.90 40.00 24 es Requirements 1 In cell range D19:G19, by using cell references, calculate the EV/EBITDA multiple for Compl:Comp4, 27 respectively (4 pt.) 2 In cell range D20:G20, by using cell references, calculate the P/E ratio for Compl:Comp4, respectively (4 pt.) 3 In cell D22, by using cell references, calculate the maximum stock price (1 pt.) 4 In cell D23, by using cell references, calculate the minimum stock price (1 pt.). 2 10-16 + Paste a. Av B I uv fx D20 Complete thelew ng cell reference to gl dam or prin callation. In some cases, simple sell reference all you need to capra a formele across a row or down a colum, an abroute cell refermce ora calleerence may he preferred to specific El function is to be used the directions will specify the use of that to Do not npe in Americal data into a cell or function stand, make a reference to the cell whick the das found. Make your computation only in the blue celle highlighted below. In all cases, unless otherwise Wirecl, we the earliest appearance of the data in your formulas, really the Green Data rection After ching the competitors of ETH Enterprises, you determine that most companble fims have the following valtion wios: Como 1 12.0 190 EV EBITDA Como 2 11.0 180 Com 4 10.0 170 12.5 20.0 EJH Enterprises had EPS of $2, EBITDA of $300 million, 530 million in cash, 540 million in debt, and 100 million shares outstanding. What mange of prices is consistent with both sets of multiples? 11 10 14 EPS EBITDA (000) Casb (000) Debt (000) Shares outstanding (000) 5 $ $ S 2.00 300.000 30,000 40.000 100,000 15 Comp 1 Comp 2 Comp3 Comp 4 EV/EBITDA PE Maximum value Minimum value 5 5 29.90 40.00 25 Requirements 1 In cell range D19:619, by using cell references, calculate the EV/EBITDA multiple for Compl:Compi. 27 respectively (4 pt.) In cell range D20:620, by using cell references, calculate the P/E ratio for Compl.Comp4, respectively (pt) In cell D22, by using cell references, calculate the maximum stock price (pt). In cell D23, by using cell references, calculate the minimum stock price (1 pt.) 2 28 4 ARRA Draw Insert Formulas Review Home Data Page Layout View v Times New Roman 14 A A ase Ac Paste BI U Av $ D20 - fx ara med cell reference my he preferred to specific cel function is to be used the directions will specify the use of the function. Do not npe in merical data inte a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directeure the earliest appearance of the data in your formulas, wally the Given Data section After researching the competitors of ETH Enterprises, you determine that most comparable firms have the following valuation ration: EVEBITDA PE Campil 12.0 19.0 Comp2 11.0 18.0 Como 3 125 20.0 Comp 4 10.0 170 EJH Enterprises hind EPS of S2, EBITDA of $300 million, 530 million in cash, S40 million in debt, and 100 million shares outstanding. What range of prices is consistent with both sets of multiples? 30 5 s EPS EBITDA (000) Cash (000) Debt (000) Shares outstanding (000) s $ 2.00 300.000 30.000 40.000 100.000 16 Comp 1 Comp 2 Comp3 Comp 4 EV/EBITDA PE 20 Maximum value Minimum value S S 29.90 40.00 24 es Requirements 1 In cell range D19:G19, by using cell references, calculate the EV/EBITDA multiple for Compl:Comp4, 27 respectively (4 pt.) 2 In cell range D20:G20, by using cell references, calculate the P/E ratio for Compl:Comp4, respectively (4 pt.) 3 In cell D22, by using cell references, calculate the maximum stock price (1 pt.) 4 In cell D23, by using cell references, calculate the minimum stock price (1 pt.). 2 10-16 +