Question: . - . Compute earnings per share for each company. Compute dividend yield for each company. Compute dividend payout ratio for each company. Compute price-earnings

- Compute earnings per share for each company. - Compute dividend yield for each company. - Compute dividend payout ratio for each company. - Compute price-earnings ratio for each company. - Compute return on assets for each company. - Compute return on stockholders' equity for each company. - Identify which company you would invest in, Explain the rationale behind your decision. For the manufacturing organization and service organization chosen in Part 1, analyze the balance sheet and income statements. - Create a Google spreadsheet and share it so that abyone with the link can view it. - Within the spreadsheet, conduct a horizontal analysis of the balance sheet for each company over the past three years, You can use a different. sheet bab for each company to keep data organized. Refer to Example 15.1 in the toxtbook wherein Year 1 is the baseline 100 . 6 value). - Within the spreadsheet, conduct a vertical anabysis of the income statement for exch company over the past three years with net sales as the base. You can use a different sheet tab for each company to keep data organized. Refer to Example 15.2 in the textbook. Continue with the Word document created in Part 1 and write approximately two three pages for Part 2 of the project that includes the following informatione - Compare and contrast the balance sheets and income statements of the organizabions - Explain the trends that emerged during the horizontal analysis. - Evaluate the changes in percentages observed during the vertical analvas. - Summarize any interesting or unusual information discoyered during your analysis. - Provide a link to the Google spreadsheet in your docienent - Continue developing the reference page with any additional sources utilured. - Compute earnings per share for each company. - Compute dividend yield for each company. - Compute dividend payout ratio for each company. - Compute price-earnings ratio for each company. - Compute return on assets for each company. - Compute return on stockholders' equity for each company. - Identify which company you would invest in, Explain the rationale behind your decision. For the manufacturing organization and service organization chosen in Part 1, analyze the balance sheet and income statements. - Create a Google spreadsheet and share it so that abyone with the link can view it. - Within the spreadsheet, conduct a horizontal analysis of the balance sheet for each company over the past three years, You can use a different. sheet bab for each company to keep data organized. Refer to Example 15.1 in the toxtbook wherein Year 1 is the baseline 100 . 6 value). - Within the spreadsheet, conduct a vertical anabysis of the income statement for exch company over the past three years with net sales as the base. You can use a different sheet tab for each company to keep data organized. Refer to Example 15.2 in the textbook. Continue with the Word document created in Part 1 and write approximately two three pages for Part 2 of the project that includes the following informatione - Compare and contrast the balance sheets and income statements of the organizabions - Explain the trends that emerged during the horizontal analysis. - Evaluate the changes in percentages observed during the vertical analvas. - Summarize any interesting or unusual information discoyered during your analysis. - Provide a link to the Google spreadsheet in your docienent - Continue developing the reference page with any additional sources utilured
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
