Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On your first job assignment as an equity analyst, you need to analyze one of three companies: Chipotle Mexican Grill (CMG), Nvidia (NVDA) or Facebook
On your first job assignment as an equity analyst, you need to analyze one of three companies: Chipotle Mexican Grill (CMG), Nvidia (NVDA) or Facebook (FB). You may do this analysis in Microsoft Excel (preferred), Google Sheets or use Microsoft Word (not recommended). 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.) Please complete the following tasks: Source the past 3 years financial statements for your company. 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 Excel or Word. It is best to put the individual financial statements on separate sheets (tabs) within the workbook or google sheet. For each of the 3 years, compute the following ratios for each firm: Current ratio Inventory turnover Operating margin Net profit margin 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. 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. 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.
Step by Step Solution
★★★★★
3.48 Rating (171 Votes )
There are 3 Steps involved in it
Step: 1
Ratio analysis of the firm Current Ratio 794 to 196 The firm is showing high current ratio which dep...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started