Equity Project
Financial Analysis Project
On your first job assignment as an equity analyst, you need to analyze one of four companies: Chipotle Mexican Grill (CMG), Nvidia (NVDA), Tesla (TSLA) or Meta (FB). You may do this analysis in Microsoft Excel (preferred), Google Sheets (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 4 years financial statements for your company.
Download (or copy/paste) the annual income statements, balance sheets, and cash flow statements for the last 4 fiscal years (2018, 2019, 2020, 2021) 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 4 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 2021 ratio to the available industry ratios for the most recent year (2021 or 2022 is ok).
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
