Industry performance comparacing

36076Attached is the excel spreadsheet with financial data and investments for two automotive companies. In the spreadsheet, on the tab “Stock prices & Return” please answer the questions in the excel. On the separate word document, please answer the questions below. The data for the questions is provided in the excel workbook.

IV. Industry Averages
Answer the question below in one paragraph. Do not include the question:
B. In this context, how is each company’s financial health? How do these two companies compare to one another? Consider the appropriate date range you should use.
V. Performance Over Time
Answer the questions below in three paragraphs. Do not include the questions:
A. Analyze the performance of the Company A over time. What financial strengths and weaknesses does this company have? Consider addressing the free cash flows and ratios you calculated earlier.
B. Analyze the performance of your Company B over time. What financial strengths and weaknesses does this company have? Consider addressing the free cash flows and ratios you calculated earlier.
C. Analyze how the data differ between these two companies. Why do you think this is? Consider addressing the free cash flows and ratios you calculated earlier.
VI. Investment
Answer the questions below in two paragraphs. Do not include the questions:
A. Are the companies considered growth or value companies? Why?
B. Which company’s stock is the better investment? Consider supporting your answer with data.