Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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 Tesla, Inc. Consolidated Balance Sheets (in millions, except per share data) December 31. 2020 December 31, 2019 19.384 1886 4101 1346 26,717 3.091 5,979 12.747 1.558 313 207 15:15 2141 6.268 1.324 3.552 959 12,103 2.447 6,138 10,396 1.218 339 198 1670 14,109 $ Assets Current assets Cash and cash equivalents Accounts receivable, net Inventory Prepaid expenses and other current sets 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, set 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 121 Equity Stockholders' equity Preferred stock 50.001 par value, 100 shares authorized no share 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 delicit Total stockholders' equity Noncontrolling interests in subsidiaries Total liabilities and equity 6,051 3,855 1458 752 2.132 14,248 9.556 1.284 3330 28418 3.771 3.222 1.163 726 1.785 10,067 11614 1.207 2.691 26199 6-43 606 51 27,260 363 15390 2222 150 52,1411 12.736 (36) 6.0833 6,618 19 14.109 (1) Prior period results have been adjusted to reflect the five-for-one stock split offected in the form of a stock dividend in August 2020. Sen Note 1 a 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) 2020 Year Ended December 31 2019 2018 26,184 1.052 27,236 1.994 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, not Income (loss) before income taxes Provision for income taxes Net Income (loss) Net income (loss) attributable to noncontrolling interests and redeemablo noncontrolling interests in subsidiaries Net Income (less) attributable to common stockholders 19,696 563 20.259 1,976 2.671 26 906 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 1,343 2.646 149 4,636 1.994 30 (748) (122) 1.154 292 862 (69) 44 (685) 45 (665) 110 (775) 1,460 2.835 135 4,430 (388) 24 (663) 22 (1.005) 58 (1.063) 141 721 87 (862) 1926 100 (976) (1.14) Less Buy out of noncontrolling interest 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.54 (0.90) Weighted average shares used in computing net income (los) per share of common stock (1) Basic 933 BAZ Diluted 1.03 32 (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. See Note 1, Overview, for details The accompanying notes are an integral part of these consolidated financial statements. 55 853 853 2 of 5) Taala - Contains . Cat Tatal eri | preg CM Ts | we - more Mal pre M talent interest Mar re 6:26 Done Attachment = Tesla, Inc. Consolidated Statements of Cash Flows (in millions) 2018 (1,003 1,01 949 ES 162 21 49 17! 1215) 12 2011 1,2 2001 1011 2181 Year Ended December 31, 2020 Cash Flows from operating Activiti 2019 Notice A terecedenti 2 17253 Deprecated and impairment Stof bad como 2.322 2.154 1.734 Amortisation of de discounts and coute 180 and pub.com write down 100 200 10 Lom a tupunals of land arts 117 146 For y tres 114 48 No cash interest and other operating activities 22 186 Operating contested to repayment of ducted the write 100 Changes in pering and let of effect of business.com Acasa 16521 30 wy 14223 Operating which 14291 1,0723 (164) Pr Other current 251 115 Accounts payable and werd alles 2.100 Duerre 121 Customer Sepete 7 Ochrona 4:53 Notatered by penting activities SM Cashews from uvesting this 2.400 Purchase of protecting finance of sales 153 Prosaryo 1271 751 (105) Mwig of grants 123 46 Purchase Bitcoin cashired (10) 15) Nutcasting 1451 0132 16 Cash Flows from Maning Activities Preds from the 12. Preds free of cover the debt 348 pements of contender det 2.13 10.60 Nepayment of brewing and to related parties 11.633 2.161) Cedar Proceedetrack and there 20 wym 330 Pircherweile 16 Procedure of war 114 Prodromime by interest in the 24 20 the partiets wat for business 10 Natured by financing mechagerute changes on hand and we 1.529 034 Not in the restricted 118 instalai, peat attal 1161 Cash and lowed dried 6703 Supplemental No Cashesting and Financing the yed in en with a combi 201 Acoperty and we LO dair value of what it Supplemental Blues el post during the period the worst, let us aptalent 44 458 Cathilde the form of 118 54 The accompanying notes are an integral part of these consolidated financial statements, (181 0337 6176 5.347 11001 2 4X7 122 112 30 3 58
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.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6696b65f9c9a2_1196696b65f38031.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6696b66057944_1196696b65fd0fc7.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6696b660eeb46_1206696b6608d3e1.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6696b66193482_1216696b6612ed98.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6696b662605ad_1216696b661c3c28.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started