1 Comparative Stock Analysis 10 marks Complete a comparative analysis on "XYZ" using the given data. Fill in all shaded cells. Company: XYZ Symbol: XYZ $ $ 50.18 2.25 10% Company Key Statistics Current Share Price Dividend per share Equity Cost of Capital Forecast Growth Rate Market Capitalization (bil) Enterprise Value (bil) Total Revenue (bil) EBITDA (bil) LTM 3% $ $ $ $ $ EPS NIM 18.96 28.86 15.20 2.98 3.65 377.87 5.30 15.20 13.7 9.7 Shares Outstanding (mil) Cash (bil) Long term Debt (bil) Price/Earnings EV/EBITDA $ $ Company Comp Set Company Name Company A Company B Company C Company D Company E Company F Company G Company H EV/EBITDA Price/ EPS LIM om 8.Ox 14.1x 7.7x 14.7x 4.1x 11.2x 7.8% 13.9x 12.5x 20.8x 9.9x 22.2x 13.9x 9.3x 18.3x 26.8x Median 1 mark 9.7 1 mark 13.7 Company XYZ 4 marks 2 marks = Implied Price per Share Median 2 State 2 inputs into the Comparative analysis that an equity analyst can manipulate to influence the resulting valuat 2 marks 1 Comparative Stock Analysis 10 marks Complete a comparative analysis on "XYZ" using the given data. Fill in all shaded cells. Company: XYZ Symbol: XYZ $ $ 50.18 2.25 10% Company Key Statistics Current Share Price Dividend per share Equity Cost of Capital Forecast Growth Rate Market Capitalization (bil) Enterprise Value (bil) Total Revenue (bil) EBITDA (bil) LTM 3% $ $ $ $ $ EPS NIM 18.96 28.86 15.20 2.98 3.65 377.87 5.30 15.20 13.7 9.7 Shares Outstanding (mil) Cash (bil) Long term Debt (bil) Price/Earnings EV/EBITDA $ $ Company Comp Set Company Name Company A Company B Company C Company D Company E Company F Company G Company H EV/EBITDA Price/ EPS LIM om 8.Ox 14.1x 7.7x 14.7x 4.1x 11.2x 7.8% 13.9x 12.5x 20.8x 9.9x 22.2x 13.9x 9.3x 18.3x 26.8x Median 1 mark 9.7 1 mark 13.7 Company XYZ 4 marks 2 marks = Implied Price per Share Median 2 State 2 inputs into the Comparative analysis that an equity analyst can manipulate to influence the resulting valuat 2 marks