Using the financial statements provided:
- Prepare a horizontal analysis of the balance sheet and income statement.
- Prepare a vertical analysis of the balance sheet and the income statement.
- Calculate the following ratios:
- Current ratio
- Average days to sell inventory
- Average days to collect accounts receivable
- Debt to assets ratio
- Plant assets to long term debt
- Return on investment
- Return on assets
- Write a paragraph summarizing your findings.
1 of 5 Consolidated Balance Sheets (in millions, except per share data) December 31 2020 December 31 2019 19,384 1886 4.101 1346 26717 3,091 5.979 12.747 155 313 207 1.535 52,148 6.268 1.324 3,552 959 12.103 2447 6,138 10,396 1.218 339 198 1.470 34309 $ Assets Current assets Cash and cash equivalents Accounts receivable, net Inventory Prepaid expenses and other current assets Total current assets Operating lease vehicles.net Solar energy systems, net Property, plant and equipment, net Operating lease right of use assets Intangible assets.net Goodwill Other non-current assets Total assets Liabilities Current liabilities Accounts payable Accrued liabilities and other Deferred revenue Customer deposits Current portion of debt and finance leases Total current liabilities Debt and finance leases, not of current portion Deferred revenue, net of current portion Other long-term liabilities Total liabilities Commitments and contingencies (Note 16) Redeemable no controlling interests in subsidiaries Convertible senior notes (Note 12) Equity Stockholders' equity Preferred stock: $0.001 par values 100 shares authorized ne shares issued and outstanding Common stock 50.001 par value: 2.000 shares authorized: 960 and 905 shares issued and outstanding as of December 31, 2020 and December 31 2019. respectively (1) Additional paid-in capital (1) Accumulated other comprehensive income doss) Accumulated deficit Total stockholders' equity Noncontrolling interests in subsidiaries Total liabilities and equity 6,051 3,855 1.458 752 2.132 14248 9,556 1.284 3,330 3,771 3.222 1.163 726 1.785 10,667 11,634 1.207 2.691 26.199 2418 6-63 604 51 27.260 363 15.399 22,225 850 52,148 1 12.736 (36) 16001) 6.618 149 34,309 Prior period results have been adjusted to reflect the five-for-one stock split effected in the form of a stock dividend in August 2020. See Note 1 Overview, for details. The accompanying notes are an integral part of these consolidated financial statements. 54 2 of 5 Tesla, Inc. Consolidated Statements of Operations (in millions, except per share data) Year Ended December 31 2019 2020 2018 26,184 1,052 27,236 1994 2,306 31,536 19,952 869 20,821 1,531 2.226 24,578 17.632 883 18,515 1.555 1,391 21.461 Revenues Automotive sales Automotive leasing Total automotive revenues Energy generation and storage Services and other Total revenues Cost of revenues Automotive sales Automotive leasing Total automotive cost of revenues Energy generation and storage Services and other Total cost of revenues Gross profit Operating expenses Research and development Selling, general and administrative Restructuring and other Total operating expenses Income (loss) from operations Interest income Interest expense Other (expense) income, net Income (loss) before income taxes Provision for income taxes Net Income (less) Net income (loss) attributable to noncontrolling interests and redeemablo noncontrolling interests in subsidiaries Net Income (loss) attributable to common stockholders 19,696 563 20.259 1,976 2.671 24,006 6,630 15,939 459 16,398 1,341 2.770 20,509 4,069 13.686 488 14.174 1.365 1,880 17.419 4,042 1.491 3,145 4,636 1.994 30 (748) (122) 1.154 292 862 1,343 2.646 149 4,138 (69) 44 (685) 45 (665) 110 1.460 2.835 135 4.430 (388) 24 (663) 22 (1.005) 58 (1.063) (775) 141 721 87 (862) 0926 11 1976) (1.14) Less Buy out of noncontrolling interest 31 Net income (loss) used in computing net income (loss) per share of common stock 690 (870) Net income (los) per share of common stock attributable to common stockholders (1) Basic 0.74 0.98 Diluted 0.64 (0.93) Weighted average shares used in computing net income (los) per share of common stock (1) Hasie BAZ Diluted 1.083 (1) Prior period results have been adjusted to reflect the five for one stock split effected in the form of a stock dividend in August 2020. Son Note 1, Owerview, for details The accompanying notes are an integral part of these consolidated financial statements. 55 853 853 6:26 Done Attachment = Tesla, Inc. Consolidated Statements of Cash Flows (in millions) 2020 Year Ended December 31, 2019 2018 32 (775) $ (1,0631 Cash Flows from Operating Activities Net tercih encome tested by stinct Court, 2.154 2.322 1.734 180 150 146 117 114 186 Investory Lees en diepeal af found aneta For your Nec interest and other operating site Operating cash flowed to paymente directible at otsmarturlanations Accueil Opening valide Prepares and other stats Other current Accounts payable and accrued Babi Duende Cum duple Other informatie Net cash provided by operating activities Cash Pows from investing Activities Purproperty and excluding finance canto al Purchase or 1650) 14223 1,072 2511 43 06) 19 (764 2.102 321 115 646 301 50 13 2.400 45 3,943 13 (75) 123 101 1.327 105) 46 143 0.132 the combinat cash acquired Nutcased in winte Cashews from Manding Activities rends from a commedia publicatione costa Proceeds from the and other debt and other 9999 z ai 303nxCall fianza 169970993 za 12.30 713 M 1. 3.16) (3) 2003 41 023 1476) 134 279 311) 2 1.529 (20) 297 Procedures and there mentem Dalecos Purchase the Proceeds from a warrant Pretty ruling interesse 24 Distributions paid to controlling interests in subsidiaries Payment for buy out of controlling intereses Net cash prided by facing activities het of change rate change on cash and chat and restricted cash 14 Not incassins adicted cash 13.118 Cabandcah vs and techning of gend Cash and child cash, woo 19.01 Supplementat Non-Cashosting and landing Activities putin me with a combinatie programes de la 1.0 Estimated for valentir toutes Supplemental Disclosure Cash and during the period fruit, watum capital Curhat during the pened for at fructe The accompanying notes are an integral part of these consolidated financial statements 2. 4222 57 2017 55 54 58 2 of 5) Calltatai 1 he (asi TE THE www Tatal era | Org ) - femme Pro Male tiram www. pre M Tag grap tamil tamaleatest cintamani Mit Com w Noring Tutal Subsidiaries 07 Equity 5.234 54 9 16 101 29 72 16 2101 (1.000 441 592 (25) 556 15131 34 9 Tesla, Inc. Consolidated Statements of Redeemable Noncontrolling Interests and Equity (in millions, except per share data) Accumulated Redeemable Additional Other Nemcontrolling Cm Stock Paldia Accumulated Comprehensive Stokholders Interests Amount (1) Capital (1) Det Irma l Halance as of December 31, 2017 9.177 14,974) Aired ASCO Autor ne perming Accounting Standard Update 201105 Beeches of coniun Braturo et cavertible se totes I commander uity inwand Stock.com Contribution to controlling interneta 270 Distribute to conting interest Other Note 002 Other compresi Balance of December 31, 2018 1024 Ata for prior pertadarum adopting AC 12 Confiture 2.00. Cei do 2004 1 2024 Nube 491 Phase of the other 14761 194 com for oily news and to tractic 42 a contok May 2019 public trang 60 per cesta 815 040 Stock based 973 Contributions from rencontrolling interest 105 Diretoria Net 48 8621 Oromo 21 Balance of December 31, 2019 1227 for per ASU 2016 Rady my bewerbe can betur nack for gay iniwa 1 12.29 12:26 LI Citroen Distributing in he writing Net Oh.com Balance of December 31, 2020 491 145 174 * 482 REE El- el segles 33 39 2... 194 1190 973 IN 1901 15 2 7167 11 417 12. 16 17 17 (132) 671 1311 On ao 30 (1) Prior pertod results have been adjusted to reflect the five-for one stock split etfected in the form of a stock dividend in August 2020. See Note 1, Overview, for details regarding stock split and public offerings. The accompanying notes are an integral part of these consolidated financial statements 57