You determine the format. I would like you to use WORD for any analysis comments and EXCEL for any spreadsheet analysis (Horizontal/Vertical) You are analyzing a company with the intention of either working for them or persuading your company to invest in them, or buy product from them. Convince me or the class that this company is in good shape or poor shape. Make it easy for us to read and understand. Make a recommendation to deal with this company or not based on your analysis Choose a company that interests you and is a public company. That means they trade their stock on a major stock exchange to anyone. 2. Go to the company website to get the full financial information. Or just google the company name and 10K. The 10K or the earnings release at the fiscal year end has the financial results. YOU MUST USE A FULL YEAR INCOME STATEMENT 3. Print out the income statement, balance sheet. If you want to know what the company says about its financial results read the latest financial statement released by the company. Do a Horizontal analysis of the Income Statement and Balance Sheet and a Vertical analysis of the Income Statement. Use cither a Quarter vs. Quarter or Year vs Year 5. Analyze the company results including the following: (For this, you will need to find the last full year of financial results. It might be a year ended a while hack). . What does the company do? What do they sell? . What is the par value of their stock? Where are they incorporated? How does their product compare to their competitors? . Who else is in this business? Who are the competitors? . What is their current ratio? What was it a year ago? Or last period? Debt ratio? Quick ratio/ acid test ratio (to be discussed in class) How much cash do they have? How much cash a year ago . If cash is lower, can you tell where it went? Did they have positive net income? A year ago? What changed from a year ago . What is their days sales outstanding! Average Days to Collector DSO . What is their Gross Profit? ? - Do they have inventory? Do they use FIFO.LIFO or AVG? You can get this info from the 10K . What were the inventory turns? Compare the Gross profit, current ratio, and DSO against another company in their business . What is their carnings per share? Or loss? . What is their stock price? Has it been increasing or decreasing What is their P/E ratio . What did the carnings release say about the future? Higher sales? . If you could ask the company president 3 questions, what would they be? You determine the format. I would like you to use WORD for any analysis comments and EXCEL for any spreadsheet analysis (Horizontal/Vertical) You are analyzing a company with the intention of either working for them or persuading your company to invest in them, or buy product from them. Convince me or the class that this company is in good shape or poor shape. Make it easy for us to read and understand. Make a recommendation to deal with this company or not based on your analysis Choose a company that interests you and is a public company. That means they trade their stock on a major stock exchange to anyone. 2. Go to the company website to get the full financial information. Or just google the company name and 10K. The 10K or the earnings release at the fiscal year end has the financial results. YOU MUST USE A FULL YEAR INCOME STATEMENT 3. Print out the income statement, balance sheet. If you want to know what the company says about its financial results read the latest financial statement released by the company. Do a Horizontal analysis of the Income Statement and Balance Sheet and a Vertical analysis of the Income Statement. Use cither a Quarter vs. Quarter or Year vs Year 5. Analyze the company results including the following: (For this, you will need to find the last full year of financial results. It might be a year ended a while hack). . What does the company do? What do they sell? . What is the par value of their stock? Where are they incorporated? How does their product compare to their competitors? . Who else is in this business? Who are the competitors? . What is their current ratio? What was it a year ago? Or last period? Debt ratio? Quick ratio/ acid test ratio (to be discussed in class) How much cash do they have? How much cash a year ago . If cash is lower, can you tell where it went? Did they have positive net income? A year ago? What changed from a year ago . What is their days sales outstanding! Average Days to Collector DSO . What is their Gross Profit? ? - Do they have inventory? Do they use FIFO.LIFO or AVG? You can get this info from the 10K . What were the inventory turns? Compare the Gross profit, current ratio, and DSO against another company in their business . What is their carnings per share? Or loss? . What is their stock price? Has it been increasing or decreasing What is their P/E ratio . What did the carnings release say about the future? Higher sales? . If you could ask the company president 3 questions, what would they be