can someone give me the vertical analysis and horizontal analysis from the income statement of tesla 2019-2020
Breakdown TTM 12/31/2019 > Total Revenue 28,176,000 24,578,000 Cost of Revenue 22,221,000 20,509,000 Gross Profit 5,955,000 4,069,000 > Operating Expense 4,189,000 3,989,000 Operating Income 1,766,000 80,000 > Net Non Operating Interest .... -638,000 -641,000 > Other Income Expense -179,000 -104,000 Pretax Income 949,000 -665,000 Tax Provision 251,000 110,000 > Net Income Common Stockh... 556,000 -862,000 Diluted NI Available to Com Sto... 556,000 -862,000 Basic EPS 0 Diluted EPS 0 Basic Average Shares 885,000 Diluted Average Shares 885,000 Total Operating Income as Repo... 1,778,000 -69,000 Total Expenses 26,410,000 24,498,000 Net Income from Continuing & ... 556,000 -862,000 Normalized Income 547,174 -738,330 03-2019 04-2019 Q1-2020 02-2020 Q3-2020 5,132 221 5.353 402 548 6.303 6,143 225 6,368 436 580 7,384 4,893 239 5.132 293 560 5,985 4,911 268 5.179 370 487 6.036 7,346 265 7.611 579 581 8.771 4,014 117 4 131 314 667 5,112 1,191 4.815 119 4,934 385 674 5,993 1,391 3.699 122 3,821 282 648 4.751 1,234 3,714 148 3.862 349 558 4,769 1,267 5,361 145 5.506 558 644 6,708 2,063 STATEMENT OF OPERATIONS (Unaudited) In millions of USD or shares as applicable, except per share data REVENUES Automotive sales Automotive leasing Total automotive revenue 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 FROM OPERATIONS Interest income Interest expense Other income (expense), net INCOME BEFORE INCOME TAXES Provision for income taxes NET INCOME Net Income attributable to noncontrolling interests and redeemable noncontrolling interests NET INCOME ATTRIBUTABLE TO COMMON STOCKHOLDERS Less: Buy-out of noncontrolling interest NET INCOME USED IN COMPUTING NET INCOME PER SHARE OF COMMON STOCK Net income per share of common stock attributable to common stockholders Basic Diluted Weighted average shares used in computing net income per share of common stock Basic Diluted 334 596 324 627 279 661 366 888 930 261 15 (185) 85 176 26 150 7 143 345 699 (12) 1,032 359 10 (170) (25) 174 42 132 27 105 951 283 10 (169) (54) 70 2 68 52 16 940 327 8 (170) (15) 150 21 129 25 104 1.254 809 6 (163) (97) 555 186 369 38 SP 143 105 16 104 300 $ $ $ S 0.16 0.16 $ $ 0.12 0.11 $ 0.02 $ 0.02 0.11 0.10 0 + + 0.2 $ 897 922 902 935 915 994 928 1.036 1,105 30-Sep-19 31-Dec-19 31-Mar-20 30-Jun-20 30-Sep-20 BALANCE SHEET (Unaudited) In millions of USD 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 Goodwill and intangible assets, net Other non-current assets Total assets 5,338 1.128 3,581 893 10.940 2.253 6,168 10,190 1.234 537 1,473 32,795 6,268 1.324 3,552 959 12 103 2.447 6,138 10,396 1218 537 1,470 34,309 A OBO 1274 4.494 1,045 14,893 2,527 6,106 10,638 1.197 516 1,373 37,250 8.615 1,485 4,018 1.218 15.336 2.524 6,069 11 009 1274 508 1,415 38,135 14,531 1,757 1,218 1,238 21.744 2.742 6,025 11,848 1,375 521 1.436 45,691 LIABILITIES AND EQUITY Current liabilities Accounts payable Accrued liabilities and other Deferred revenue Customer deposits Current portion of debt and finance leases (1) Total current llabilities Debt and finance leases, net of current portion (1) Deferred revenue, net of current portion Other long-term liabilities Total liabilities Redeemable noncontrolling interests in subsidiaries Convertible senior notes Total stockholders' equity Noncontrolling interests in subsidiaries Total liabilities and equity 3,468 2.938 1,045 665 2.030 10,146 11.313 1,140 2,714 25,313 600 3.771 3.222 1,163 726 1.785 10.667 11.634 1.207 2,691 26,199 643 3.970 2.825 1.186 788 3.217 11,986 10.666 1,199 2.667 26,518 632 60 9,173 867 37,250 3,638 3.110 1,130 713 3.679 12.270 10,416 1.198 2,870 26.754 613 44 9,855 869 38,135 4.958 3.252 1.258 708 3,126 13,302 10.559 1,233 3,049 28,143 608 48 16,031 861 45,691 6,040 842 32,795 6,618 849 34,309 (1) Breakdown of our debt is as follows Vehicle and energy product financing (non-recourse) 1 3,702 4,183 4,022 4,043 60F Other non-recourse debt Recourse debt Total debt excluding vehicle and energy product financing 155 7.882 8,037 355 7.263 7,618 708 7,600 8.308 1415 7.106 8,521 7.4. + 8,05
