Description
Financial Analysis Project
On your first job assignment as an equity analyst, you need to analyze one of three companies: Chipotle Mexican Grill (CMG), Nvidia (NVDA) or Meta (FB). You may do this analysis in Microsoft Excel (preferred) or Google Sheets. 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 (2020, 2021, 2022) 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 a reputable website: Barron’s, Zack’s, y-charts, google finance, or other site. Cite your source by copying the URL to your document. Compare the firm’s 2022 ratio to the available industry ratios for the most recent year (2022 preferred). 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.
Points breakdown (15 points)
#1: 4
#2: 5
#3: 2
#4: 2
#5: 2