Module Two Journal

profileashbutt31
asreported-5.xlsx

asreported

Powered by Clearbit
Tesla Inc (NMS: TSLA)
Exchange rate used is that of the Year End reported date
As Reported Quarterly Balance Sheet
Report Date 06/30/2022 03/31/2022 09/30/2021 06/30/2021 03/31/2021 09/30/2020 06/30/2020 03/31/2020
2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter
Currency USD USD USD USD USD USD USD USD
Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands
Cash & cash equivalents 18324000 17505000 16065000 16229000 17141000 14531000 8615000 8080000
Short-term marketable securities 591000 508000 30000 - - - - -
Accounts receivable, net 2081000 2311000 1962000 2129000 1890000 1757000 1485000 1274000
Raw materials 4949000 3822000 2355000 2067000 1836000 1573000 1842000 1653000
Work in process 1370000 1306000 1061000 858000 454000 572000 420000 494000
Finished goods 1185000 977000 1252000 1318000 1341000 1674000 1379000 1961000
Service parts 604000 586000 531000 490000 501000 399000 377000 386000
Inventory 8108000 6691000 5199000 4733000 4132000 4218000 4018000 4494000
Prepaid expenses & other current assets 2118000 2035000 1746000 1602000 1542000 1238000 1218000 1045000
Total current assets 31222000 29050000 25002000 24693000 24705000 21744000 15336000 14893000
Operating lease vehicles, net 4782000 4745000 4167000 3748000 3396000 2742000 2524000 2527000
Solar energy systems in service - - - - - 6744000 6722000 6703000
Initial direct costs related to customer solar energy system lease acquisition costs - - - - - 103000 103000 102000
Solar energy systems, gross - - - - - 6847000 6825000 6805000
Less: accumulated depreciation & amortization - - - - - 897000 839000 781000
Solar energy systems in service after depreciation & amortization - - - - - 5950000 5986000 -
Solar energy systems under construction - - - - - 25000 28000 24000
Solar energy systems pending interconnection - - - - - 50000 55000 58000
Solar energy systems, net 5624000 5686000 5821000 5883000 5933000 6025000 6069000 6106000
Machinery, equipment, vehicles & office furniture 11749000 11163000 9458000 9156000 8711000 7943000 7687000 7428000
Tooling 2417000 2345000 2120000 2038000 1916000 1794000 1711000 1574000
Leasehold improvements 2018000 1911000 1706000 1596000 1494000 1291000 1157000 1103000
Land & buildings 6406000 5957000 3853000 3725000 3681000 3245000 3172000 3146000
Computer equipment, hardware & software 1746000 1595000 1284000 1148000 1020000 782000 700000 647000
Construction in progress 4544000 4322000 5109000 3826000 2435000 1607000 1012000 812000
Property, plant & equipment, gross 28880000 27293000 23530000 21489000 19257000 16662000 15439000 14710000
Less: accumulated depreciation & amortization 7787000 7266000 6232000 5824000 5389000 4814000 4430000 4072000
Property, plant & equipment, net 21093000 20027000 17298000 15665000 13868000 11848000 11009000 10638000
Operating lease right-of-use assets 2185000 2181000 1962000 1734000 1647000 1375000 1274000 1197000
Digital assets, net 218000 1261000 1260000 1311000 1331000 - - -
Intangible assets, net 241000 254000 269000 283000 299000 318000 312000 323000
Goodwill 196000 200000 201000 203000 206000 203000 196000 193000
Other non-current assets 2952000 2634000 1854000 1626000 1587000 1436000 1415000 1373000
Total assets 68513000 66038000 57834000 55146000 52972000 45691000 38135000 37250000
Accounts payable 11212000 11171000 8260000 7558000 6648000 4958000 3638000 3970000
Accrued purchases 2130000 2025000 1867000 1437000 993000 711000 782000 643000
Taxes payable 1045000 1272000 1084000 834000 828000 635000 484000 399000
Payroll & related costs 1077000 913000 823000 840000 660000 502000 495000 409000
Accrued warranty reserve, current portion 778000 709000 621000 608000 544000 400000 384000 362000
Sales return reserve, current portion 257000 279000 386000 382000 430000 461000 345000 289000
Financing obligation, current portion - - - - - 48000 47000 53000
Operating lease liabilities, current portion 413000 399000 343000 325000 309000 251000 233000 229000
Resale value guarantees, current portion - - - - - 20000 70000 202000
Accrued interest - - 18000 60000 36000 51000 91000 55000
Other current liabilities 337000 309000 301000 292000 273000 173000 179000 184000
Accrued liabilities & other current liabilities 6037000 5906000 5443000 4778000 4073000 3252000 3110000 2825000
Deferred revenue 1858000 1594000 1801000 1693000 1592000 1258000 1130000 1186000
Customer deposits 1182000 1125000 831000 812000 745000 708000 713000 788000
Current portion of debt & finance leases 1532000 1659000 1716000 1530000 1819000 3126000 3679000 3217000
Total current liabilities 21821000 21455000 18051000 16371000 14877000 13302000 12270000 11986000
Recourse debt 52000 70000 2008000 3838000 4085000 - - 6011000
Non-recourse debt 2043000 2183000 3431000 3040000 3934000 - - 3468000
Total debt 2095000 2253000 5439000 6878000 8019000 - - 9479000
Finance lease 803000 900000 999000 993000 1034000 - - 1187000
Debt & finance leases, net of current portion 2898000 3153000 6438000 7871000 9053000 10559000 10416000 10666000
Deferred revenue, net of current portion 2210000 2185000 1365000 1318000 1294000 1233000 1198000 1199000
Operating lease liabilities 1822000 1814000 1629000 1407000 1330000 1101000 1016000 941000
Accrued warranty reserve 1655000 1578000 1115000 1083000 990000 869000 812000 768000
Sales return reserve 74000 109000 325000 378000 424000 519000 529000 488000
Deferrred tax liabilities 22000 24000 40000 63000 144000 - - -
Financing obligation - - - - - 30000 42000 34000
Resale value guarantees - - - - - 36000 36000 36000
Other noncurrent liabilities 353000 314000 377000 405000 395000 494000 435000 400000
Other long-term liabilities 3926000 3839000 3486000 3336000 3283000 3049000 2870000 2667000
Total liabilities 30855000 30632000 29340000 28896000 28507000 28143000 26754000 26518000
Redeemable noncontrolling interests in subsidiaries 421000 459000 605000 605000 601000 608000 613000 632000
Convertible senior notes - - - - - 48000 44000 60000
Common stock 1000 1000 1000 1000 1000 1000 - -
Additional paid-in capital 30944000 30485000 28922000 28205000 27623000 21574000 15895000 15390000
Accumulated other comprehensive income (loss) -477000 -50000 120000 206000 143000 125000 -40000 -113000
Retained earnings (accumulated deficit) 5908000 3649000 -1990000 -3608000 -4750000 -5669000 -6000000 -6104000
Total stockholders' equity (deficit) 36376000 34085000 27053000 24804000 23017000 16031000 9855000 9173000
Noncontrolling interests in subsidiaries 861000 862000 836000 841000 847000 861000 869000 867000
As Reported Quarterly Income Statement
Report Date 06/30/2022 03/31/2022 09/30/2021 06/30/2021 03/31/2021 09/30/2020 06/30/2020 03/31/2020
2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter
Currency USD USD USD USD USD USD USD USD
Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands
Revenues - automotive sales 13670000 15514000 11672000 9874000 8705000 7346000 4911000 4893000
Revenues - automotive regulatory credits 344000 679000 - - - - - -
Revenues - automotive leasing 588000 668000 385000 332000 297000 265000 268000 239000
Total automotive revenues 14602000 16861000 12057000 10206000 9002000 7611000 5179000 5132000
Energy generation & storage 866000 616000 806000 801000 494000 579000 370000 293000
Services & other revenues 1466000 1279000 894000 951000 893000 581000 487000 560000
Total revenues 16934000 18756000 13757000 11958000 10389000 8771000 6036000 5985000
Cost of revenues - automotive sales 10153000 10914000 8150000 7119000 6457000 5361000 3714000 3699000
Cost of revenues - automotive leasing 368000 408000 234000 188000 160000 145000 148000 122000
Total automotive cost of revenues 10521000 11322000 8384000 7307000 6617000 5506000 3862000 3821000
Cost of energy generation & storage 769000 688000 803000 781000 595000 558000 349000 282000
Cost of services & other cost of revenues 1410000 1286000 910000 986000 962000 644000 558000 648000
Total cost of revenues 12700000 13296000 10097000 9074000 8174000 6708000 4769000 4751000
Gross profit (loss) 4234000 5460000 3660000 2884000 2215000 2063000 1267000 1234000
Research & development 667000 865000 611000 576000 666000 366000 279000 324000
Selling, general & administrative 961000 992000 994000 973000 1056000 888000 661000 627000
Restructuring & other expenses 142000 - 51000 23000 -101000 - - -
Total operating expenses 1770000 1857000 1656000 1572000 1621000 1254000 940000 951000
Income (loss) from operations 2464000 3603000 2004000 1312000 594000 809000 327000 283000
Interest income 26000 28000 10000 11000 10000 6000 8000 10000
Interest expense 44000 61000 126000 75000 99000 163000 170000 169000
Other income (expense), net 28000 56000 -6000 45000 28000 -97000 -15000 -54000
Income (loss) before income taxes 2474000 3626000 1882000 1293000 533000 555000 150000 70000
Provision (benefit) for income taxes 205000 346000 223000 115000 69000 186000 21000 2000
Net income (loss) 2269000 3280000 1659000 1178000 464000 369000 129000 68000
Net income (loss) attributable to noncontrolling interests & redeemable noncontrolling interests in subsidiaries -10000 38000 -41000 -36000 -26000 -38000 -25000 -52000
Net income (loss) attributable to common stockholders 2259000 3318000 1618000 1142000 438000 331000 104000 16000
Less: Buy-out of noncontrolling interest - 5000 - - - - - -
Net income used in computing net income per share of common stock - 3313000 1618000 - - - - -
Weighted average shares outstanding - basic 3111000 3102000 2994000 2913000 2883000 2811000 2790000 2745000
Weighted average shares outstanding - diluted 3465000 3471000 3369000 3357000 3399000 3315000 3105000 2985000
Year end shares outstanding 3123000 3108000 3012000 2952000 2889000 2844000 2790000 2775000
Net income (loss) per share - basic 0.727 1.067 0.54 0.393 0.153 0.107 0.037 0.006
Net income (loss) per share - diluted 0.65 0.953 0.48 0.34 0.13 0.09 0.033 0.005
As Reported Quarterly Retained Earnings
Report Date 06/30/2022 03/31/2022 09/30/2021 06/30/2021 03/31/2021 09/30/2020 06/30/2020 03/31/2020
2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter
Currency USD USD USD USD USD USD USD USD
Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands
Previous retained earnings (accumulated deficit) 3649000 331000 -3608000 -4750000 -5399000 -6000000 -6104000 -6083000
Adjustments for prior periods from adopting ASU 2016-13 - - - - - - - -37000
Adjustments for prior periods from adopting ASU 2020-06 - - - - 211000 - - -
Retained earnings (accumualted deficit) 5908000 3649000 -1990000 -3608000 -4750000 -5669000 -6000000 -6104000
As Reported Quarterly Cash Flow
Report Date 06/30/2022 03/31/2022 09/30/2021 06/30/2021 03/31/2021 09/30/2020 06/30/2020 03/31/2020
2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter
Currency USD USD USD USD USD USD USD USD
Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands
Net income (loss) 5549000 3280000 3301000 1642000 464000 566000 197000 68000
Depreciation, amortization & impairment 1802000 880000 2063000 1302000 621000 1704000 1120000 553000
Stock-based compensation 779000 418000 1563000 1088000 614000 1101000 558000 211000
Amortization of debt discounts & issuance costs - - - - - 144000 94000 46000
Inventory & purchase commitments write-downs 58000 33000 128000 88000 49000 140000 88000 45000
Loss on disposals of fixed assets - - - - - 67000 12000 7000
Foreign currency transaction net unrealized loss (gain) -52000 -30000 8000 -1000 -2000 144000 38000 19000
Non-cash interest & other operating activities 52000 16000 213000 60000 8000 116000 110000 58000
Digital assets gain, net 106000 - -27000 -78000 -101000 - - -
Accounts receivable -233000 -409000 -148000 -283000 -24000 -550000 -236000 -14000
Inventory -2192000 -633000 -1175000 -687000 -106000 -602000 -535000 -981000
Operating lease vehicles -795000 -462000 -1526000 -916000 -426000 -640000 -330000 -197000
Prepaid expenses & other current assets -533000 -289000 -287000 -131000 -143000 -290000 -301000 -154000
Other non-current assets -1042000 -611000 -744000 -289000 -168000 -105000 -16000 40000
Accounts payable & accrued liabilities 1406000 997000 2764000 1592000 672000 765000 -372000 -265000
Deferred revenue 648000 287000 452000 279000 162000 118000 -20000 53000
Customer deposits 292000 204000 80000 52000 -2000 -15000 5000 88000
Other long-term liabilities 501000 314000 247000 47000 23000 261000 112000 -17000
Net cash flows from operating activities 6346000 3995000 6912000 3765000 1641000 2924000 524000 -440000
Purchases of property & equipment excluding finance leases, net of sales -3497000 -1767000 -4672000 -2853000 -1348000 -2006000 -1001000 -455000
Purchases of solar energy systems, net of sales -5000 -5000 -28000 -22000 -12000 -62000 -46000 -26000
Purchases of digital assets - - -1500000 -1500000 -1500000 - - -
Receipt of government grants - - 6000 6000 6000 1000 1000 1000
Proceeds from sales of digital assets 936000 - 272000 272000 272000 - - -
Purchase of intangible assets -9000 -9000 - - - -5000 - -
Purchases of marketable securities -476000 -386000 -30000 - - - - -
Business combinations, net of cash acquired - - - - - -13000 - -
Net cash flows from investing activities -3051000 -2167000 -5952000 -4097000 -2582000 -2085000 -1046000 -480000
Proceeds from issuances of common stock in public offerings, net of issuance costs - - - - - 7282000 2309000 2309000
Proceeds from issuances of convertible & other debt - - 7633000 4862000 2983000 7826000 4946000 2802000
Repayments of convertible & other debt -2219000 -1945000 -11589000 -7408000 -4038000 -7537000 -4226000 -2318000
Collateralized lease repayments - - -9000 -8000 -6000 -224000 -168000 -97000
Proceeds from exercises of stock options & other stock issuances 245000 202000 445000 253000 183000 361000 217000 160000
Principal payments on finance leases -251000 -123000 -311000 -196000 -101000 -248000 -154000 -100000
Debt issuance costs - - -9000 -5000 -5000 -6000 - -
Proceeds from investments by noncontrolling interests in subsidiaries - - 2000 2000 - 23000 19000 19000
Distributions paid to noncontrolling interests in subsidiaries -76000 -42000 -108000 -65000 -32000 -163000 -110000 -67000
Payments for buy-outs of noncontrolling interests in subsidiaries -19000 -6000 - - - -33000 -2000 -
Net cash flows from financing activities -2320000 -1914000 -3946000 -2565000 -1016000 7281000 2831000 2708000
Effect of exchange rate changes on cash & cash equivalents & restricted cash -232000 -18000 -221000 -179000 -221000 100000 14000 -24000
Net increase (decrease) in cash & cash equivalents & restricted cash 743000 -104000 -3207000 -3076000 -2178000 8220000 2323000 1764000
Cash & cash equivalents & restricted cash, beginning of period 18144000 18144000 19901000 19901000 19901000 6783000 6783000 6783000
Cash & cash equivalents & restricted cash, end of period 18887000 18040000 16694000 16825000 17723000 15003000 9106000 8547000

company_logo129614631e1bbe979281.bmp