You need to analyze the following company: Chipotle Mexican Grill (CMG). You may do this analysis in Microsoft Excel (Preferred). You must show your company data with web citation, and clearly show all ratio inputs and output values. (Note: If using Microsoft excel, please use cell references for computation of ratios.)
Download (or copy/paste) the annual income statements, balance sheets, and cash flow statements for the last 3 fiscal years (2017, 2018, 2019) from your company from either: SEC Website, Annual reports, Google Finance or other site. Enter the company’s stock symbol and then go to “financials”. Copy and paste the financial statements into Word. It is best to put the individual financial statements on separate sheets (tabs) within the workbook.
2.For each of the 3 years, compute the following ratios for each firm:
Current ratio, Inventory turnover, Operating margin, Net profit margin
3. Obtain industry averages for your respective firm from Zack’s, y-charts, google finance, or other site. Cite your source by copying the URL to your document. Compare the firm’s 2019 ratio to the available industry ratios for the most recent year (2019 or 2020 is ok). Comment on your firm’s ratio’s compared to its industry.
4. Analyze the performance of your firm (ratios) versus its industry (Peer analysis – against benchmark) and comment on any trends (Trend analysis – over time) in each individual firm’s performance. Comment on both the peer analysis and the trend analysis. A couple sentence is adequate.
5. Identify any/all strengths or weakness, including qualitative factors, which you find in your firm. Answer the question: “Would you invest in this firm?” A couple sentences is adequate.
Requirements: Majority needs to be on Excel, but the questions towards the end just a couple sentences, unless noted otherwise.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more