he assignment will consist of one sheet of financial calculations and short answers to a series of uestions. The answers should be typed and hopefully no more than two pages. 1. Download the latest 10K for Tesla, Inc. from the investor relations section of the company's website (financials for the year ended December 31, 2022). Read the business description of the two operating segments in which Tesla operates. 2. Do some traditional financial analysis of the financial statements (except where requested below, just do the most recent year ended 2022). Include the numbers and your calculations in an easy to read excel spreadsheet. Please include the following data (use end of year balances rather than averages, and use 365 days in a year): a. Sales growth rate from 2020 to 2021 and from 2021 to 2022 b. Gross Margin as \% of sales for the years 2020, 2021, and 2022 c. Operating Margin as \% of sales for the years 2020, 2021, and 2022 d. Net Income Margin as \% of sales for the years 2020, 2021, and 2022 e. Net return on assets f. Total Asset Turnover g. Equity Multiplier (total assets/total stockholders' equity) h. Return on equity using end of year equity i. Return on equity using average equity for the year j. Return on Equity using the DuPont Formula (show the components above and the calculation). k. Net operating working capital (operating current assets minus operating current liabilities). Operating assets exclude cash and short term investments, and operating liabilities exclude short-term debt (if any). I. Days receivables m. Days inventory n. Days payable o. Interest coverage ratio using operating profit (times interest earned) p. Total debt as a percent of total capitalization (book values from the balance sheet). Include leases in debt. q. Total equity market value (you can get shares outstanding from the cover of the 10-K. Use a recent stock price) r. Total Equity Value/Net Income (or price per share/earnings per share) (PE Ratio) s. Total Enterprise Value t. Total Enterprise Value/EBITDA u. Dividend payout ratio he assignment will consist of one sheet of financial calculations and short answers to a series of uestions. The answers should be typed and hopefully no more than two pages. 1. Download the latest 10K for Tesla, Inc. from the investor relations section of the company's website (financials for the year ended December 31, 2022). Read the business description of the two operating segments in which Tesla operates. 2. Do some traditional financial analysis of the financial statements (except where requested below, just do the most recent year ended 2022). Include the numbers and your calculations in an easy to read excel spreadsheet. Please include the following data (use end of year balances rather than averages, and use 365 days in a year): a. Sales growth rate from 2020 to 2021 and from 2021 to 2022 b. Gross Margin as \% of sales for the years 2020, 2021, and 2022 c. Operating Margin as \% of sales for the years 2020, 2021, and 2022 d. Net Income Margin as \% of sales for the years 2020, 2021, and 2022 e. Net return on assets f. Total Asset Turnover g. Equity Multiplier (total assets/total stockholders' equity) h. Return on equity using end of year equity i. Return on equity using average equity for the year j. Return on Equity using the DuPont Formula (show the components above and the calculation). k. Net operating working capital (operating current assets minus operating current liabilities). Operating assets exclude cash and short term investments, and operating liabilities exclude short-term debt (if any). I. Days receivables m. Days inventory n. Days payable o. Interest coverage ratio using operating profit (times interest earned) p. Total debt as a percent of total capitalization (book values from the balance sheet). Include leases in debt. q. Total equity market value (you can get shares outstanding from the cover of the 10-K. Use a recent stock price) r. Total Equity Value/Net Income (or price per share/earnings per share) (PE Ratio) s. Total Enterprise Value t. Total Enterprise Value/EBITDA u. Dividend payout ratio
