Tesla Financial Statement Analysis Case Study

Sheet1

Tesla Financial Statement Analysis Case Study

Due date of your case study is 11:59pm, Friday, April 12, 2024. Please submit your case study report on Canvas under “Assignments” then “Case Study” then submit Assignment as a file upload. The submission should include all the required analyses in Excel as well as a written report in Microsoft Word or PDF file format. The case study will comprise 15% of your final grade for the semester. The report will be checked by the built-in software for plagiarism and AI generated content. Quote or cite appropriately. If the text similarity report shows a percentage greater than 10%, your paper will not be accepted for grading (note: Similarity score already excludes quoted content).

Students will:

 Use the annual Financial Statements (Income Statement and Balance Sheet) of Tesla from Canvas under “Assignments” then “Case Study” for the two most recent years. Some balance sheet items for 2020 are also needed for calculating averages for ratio analysis;

 Calculate trend analysis (horizontal analysis) by comparing 2022 to 2021 for each of the income statement and balance sheet items of Tesla (only show percentage changes such as +5.7% or −12.3%.); Excel formula such as =(B3-C3)/+C3 and etc.

 Calculate a common-size (vertical analysis) for each of the income statement and balance sheet items of Tesla for the most recent year (2022); Excel formula such as =B3/81462 and etc.

 Calculate all the ratios*** (except Earnings per share) found in Chapter 9 PowerPoint slides under the following headings, for the two most recent years (2022 and 2021):

o Liquidity Ratios (6 ratios; current ratio, quick ratio, accounts receivable turnover, average days to collect receivables, inventory turnover, average days to sell inventory)

o Solvency Ratios (2 ratios; debt to assets ratio, debt to equity ratio) o Profitability Ratios (3 ratios; net margin, return on investment, return on

equity) o Stock Market Ratios (1 ratio; price-earnings ratio)

 Prepare a case study report: answer the question (one to two pages) – would you invest in Tesla? Why or why not based upon your calculations [provide sufficient evidence (such as ratios are improving/deteriorating and/or better/worse than the “rule of thumb” standard, etc.) to support your decision].

***Students must show detailed calculations for all the ratios for the most recent year (2022) {e.g., accounts receivable turnover = net credit sales / average accounts receivable = $81,462 / [($2,952 + $1,913) / 2] = 33.49 for 2022} to ensure that they are not simply copying them from a website.

Additional information: 1. Based on the given information of Tesla, we will treat total revenue as sales, net sales and net credit sales; cost of revenue as cost of goods sold; net receivable as accounts receivable. 2. Inventory and assets listed thereafter on the balance sheet are not quick assets while assets listed before inventory are quick assets.

3. Earnings per share (EPS) = $ for 2022 and use the most recent stock market price (available from Yahoo Finance http://finance.yahoo.com/quote/goog/?p=goog) to calculate the P/E ratio for 2022 only and compare it with the current S&P 500 companies’ average P/E ratio of 16.

Your case study report should be completed with 10- to 12-point font, 1-inch margins on each side.

Format of the report: Title Page

Introduction (a short paragraph about what your case study is about) Analyses (horizontal, vertical and ratio) Decision/Conclusion