Question

A. For Company I, list ten firms which you consider "comparable" to Company I. Create a single table of these ten firms showing the Trailing P/E. Price/Sales, Price/Book and Enterprise Value/EBITDA

ratio for each (You can find ratios like these easily using public information sources like Yahoo Finance. For an illustrated example, click on this link: Yahoo finance has useful ratios). B. Assess the value of Company I using these criteria: • What is the average and median Trailing P/E for the ten firms you chose as comparable to Company I? What do these suggest about the value of Company I? • What is the average and median Price/Sales ratio for the ten firms you chose as comparable to Company I? What do these suggest about the value of Company I? • What is the average and median Price/Book for the ten firms you chose as comparable to Company I? What do these suggest about the value of Company I? • What is the average and median Enterprise Value/EBITDA for the ten firms you chose as comparable to Company I? What do these suggest about the value of Company I? C. For Company II, list ten firms which you consider "comparable" to Company II. Create a single table of these ten firms showing the Trailing P/E. Price/Sales, Price/Book and Enterprise Value/EBITDA ratio for each. D. Assess the value of Company II using these criteria: • What is the average and median Trailing P/E for the ten firms you chose as comparable to Company II? What do these suggest about the value of Company II? • What is the average and median Price/Sales ratio for the ten firms you chose as comparable to Company II? What do these suggest about the value of Company II? • What is the average and median Price/Book for the ten firms you chose as comparable to Company II? What do these suggest about the value of Company II? • What is the average and median Enterprise Value/EBITDA for the ten firms you chose as comparable to Company II? What do these suggest about the value of Company II? E. For Company III, list ten firms which you consider "comparable" to Company III. Create a single table of these ten firms showing the Trailing P/E. Price/Sales. Price/Book and Enterprise Value/EBITDA ratio for each. F. Assess the value of Company III using these criteria: • What is the average and median Trailing P/E for the ten firms you chose as comparable to Company III? What do these suggest about the value of Company III? • What is the average and median Price/Sales ratio for the ten firms you chose as comparable to Company III? What do these suggest about the value of Company III? • What is the average and median Price/Book for the ten firms you chose as comparable to Company III? What do these suggest about the value of Company III? • What is the average and median Enterprise Value/EBITDA for the ten firms you chose as comparable to Company III? What do these suggest about the value of Company III? G. Explain the limitations, problems and shortcomings of using multiples in developing an objective valuation. Be specific and use examples from your work on Company I, Company II and Company III. H. Examine the Statements of Cash Flows for Company I for the past five years. Explain in detail the dividends, stock repurchases, and other payouts made to equity holders during that five-year period. If there were stock repurchases, what reasons did management give for the repurchase? What specific changes in retained earnings do you see on the balance sheets for those same five years, and how did those payouts specifically affect the retained earnings balances during that time? Explain and describe the per-share dividend history of Company I for the past five years. Explain the limitations, problems and shortcomings of using dividends in developing an objective valuation of Company I. 1. Examine the Statements of Cash Flows for Company Il for the past five years. Explain in detail the dividends, stock repurchases, and other payouts made to equity holders during that five-year period. If there were stock repurchases, what reasons did management give for the repurchase? What specific changes in retained earnings do you see on the balance sheets for those same five years, and how did those payouts specifically affect the retained earnings balances during that time? Explain and describe the per-share dividend history of Company II for the past five years. Explain the limitations, problems and shortcomings of using dividends in developing an objective valuation of Company II. J. Examine the Statements of Cash Flows for Company III for the past five years. Explain in detail the dividends, stock repurchases, and other payouts made to equity holders during that five-year period. If there were stock repurchases, what reasons did management give for the repurchase? What specific changes in retained earnings do you see on the balance sheets for those same five years, and how did those payouts specifically affect the retained earnings balances during that time? Explain and describe the per-share dividend history of Company III for the past five years. Explain the limitations, problems and shortcomings of using dividends in developing an objective valuation of Company III.