5-2 Project Two Milestone: Comparison Analysis

profileJMooreHelpNeeded
TeslaBalanceSheet.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/2021 03/31/2021 09/30/2020 06/30/2020 03/31/2020 09/30/2019 06/30/2019 03/31/2019
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 16229000 17141000 14531000 8615000 8080000 5338000 4954740 2198169
Restricted cash - - - - - 233000 128006 130950
Accounts receivable, net 2129000 1890000 1757000 1485000 1274000 1128000 1147100 1046945
Raw materials 2067000 1836000 1573000 1842000 1653000 1284000 1095888 1079216
Work in process 858000 454000 572000 420000 494000 335000 334641 277155
Finished goods 1318000 1341000 1674000 1379000 1961000 1583000 1600214 2151012
Service parts 490000 501000 399000 377000 386000 379000 351615 329467
Inventory 4733000 4132000 4218000 4018000 4494000 3581000 3382358 3836850
Prepaid expenses & other current assets 1602000 1542000 1238000 1218000 1045000 660000 569748 464908
Total current assets 24693000 24705000 21744000 15336000 14893000 10940000 10181952 7677822
Operating lease vehicles, net 3748000 3396000 2742000 2524000 2527000 2253000 2069540 1972502
Solar energy systems in service - - 6744000 6722000 6703000 6649000 6587439 6461833
Initial direct costs related to customer solar energy system lease acquisition costs - - 103000 103000 102000 102000 101197 101204
Solar energy systems, gross - - 6847000 6825000 6805000 6751000 6688636 6563037
Less: accumulated depreciation & amortization - - 897000 839000 781000 666000 608006 550558
Solar energy systems in service after depreciation & amortization - - 5950000 5986000 - 6085000 6080630 -
Solar energy systems under construction - - 25000 28000 24000 23000 49777 49648
Solar energy systems pending interconnection - - 50000 55000 58000 60000 70297 179510
Solar energy systems, net 5883000 5933000 6025000 6069000 6106000 6168000 6200704 6241637
Machinery, equipment, vehicles & office furniture 9156000 8711000 7943000 7687000 7428000 7007000 6919869 6584307
Tooling 2038000 1916000 1794000 1711000 1574000 1477000 1463543 1418368
Leasehold improvements 1596000 1494000 1291000 1157000 1103000 1029000 1010893 987916
Building & building improvements - - - - - - - 2631607
Land & buildings 3725000 3681000 3245000 3172000 3146000 2956000 2839746 -
Computer equipment, hardware & software 1148000 1020000 782000 700000 647000 549000 553265 525138
Construction in progress 3826000 2435000 1607000 1012000 812000 700000 543452 622180
Property, plant & equipment, gross 21489000 19257000 16662000 15439000 14710000 13718000 13330768 12769516
Less: accumulated depreciation & amortization 5824000 5389000 4814000 4430000 4072000 3528000 3248310 2918587
Property, plant & equipment, net 15665000 13868000 11848000 11009000 10638000 10190000 10082458 9850929
Operating lease right-of-use assets 1734000 1647000 1375000 1274000 1197000 1234000 1248277 1253027
Digital assets, net 1311000 1331000 - - - - - -
Intangible assets, net 283000 299000 318000 312000 323000 351000 327358 273568
Goodwill 203000 206000 203000 196000 193000 186000 153475 74312
MyPower customer notes receivable, net of current portion - - - - - 398000 400308 413181
Restricted cash, net of current portion - - - - - 255000 365547 353679
Other non-current assets 1626000 1587000 1436000 1415000 1373000 820000 842978 801867
Total assets 55146000 52972000 45691000 38135000 37250000 32795000 31872597 28912524
Accounts payable 7558000 6648000 4958000 3638000 3970000 3468000 3133587 3248827
Accrued purchases 1437000 993000 711000 782000 643000 - - -
Taxes payable 834000 828000 635000 484000 399000 - - -
Payroll & related costs 840000 660000 502000 495000 409000 - - -
Accrued warranty reserve, current portion 608000 544000 400000 384000 362000 - - -
Sales return reserve, current portion 382000 430000 461000 345000 289000 - - -
Financing obligation, current portion - - 48000 47000 53000 - - -
Operating lease liabilities, current portion 325000 309000 251000 233000 229000 - - -
Resale value guarantees, current portion - - 20000 70000 202000 - - -
Accrued interest 60000 36000 51000 91000 55000 - - -
Other current liabilities 292000 273000 173000 179000 184000 - - -
Accrued liabilities & other current liabilities 4778000 4073000 3252000 3110000 2825000 2497000 2622943 2276951
Deferred revenue 1693000 1592000 1258000 1130000 1186000 1045000 883293 762810
Resale value guarantees - - - - - 441000 526758 480225
Customer deposits 812000 745000 708000 713000 788000 665000 631107 768276
Current portion of debt & finance leases 1530000 1819000 3126000 3679000 3217000 2030000 1791085 1705711
Total current liabilities 16371000 14877000 13302000 12270000 11986000 10146000 9588773 9242800
Recourse debt 3838000 4085000 - - 6011000 - - -
Non-recourse debt 3040000 3934000 - - 3468000 - - -
Total debt 6878000 8019000 - - 9479000 - - -
Finance lease 993000 1034000 - - 1187000 - - -
Debt & finance leases, net of current portion 7871000 9053000 10559000 10416000 10666000 11313000 11234401 9787950
Deferred revenue, net of current portion 1318000 1294000 1233000 1198000 1199000 1140000 1182042 1157343
Resale value guarantees, net of current portion - - - - - 38000 61200 211390
Operating lease liabilities 1407000 1330000 1101000 1016000 941000 1028000 1030797 1000886
Accrued warranty reserve, net of current portion 1083000 990000 869000 812000 768000 692000 653095 590211
Sales return reserve, net of current portion 378000 424000 519000 529000 488000 547000 577914 524222
Deferrred tax liabilities 63000 144000 - - - - - -
Financing obligation - - 30000 42000 34000 - - -
Resale value guarantees - - 36000 36000 36000 - - -
Financing obligation, net of current portion - - - - - 42000 44549 45566
Other noncurrent liabilities 405000 395000 494000 435000 400000 367000 349365 314250
Other long-term liabilities 3336000 3283000 3049000 2870000 2667000 2676000 2655720 2475135
Total liabilities 28896000 28507000 28143000 26754000 26518000 25313000 24722136 22874618
Redeemable noncontrolling interests in subsidiaries 605000 601000 608000 613000 632000 600000 580227 570284
Convertible senior notes - - 48000 44000 60000 - - -
Common stock 1000 1000 1000 - - - 179 174
Additional paid-in capital 28205000 27623000 21574000 15895000 15390000 12348000 12052458 10563746
Accumulated other comprehensive gain (loss) 206000 143000 125000 -40000 -113000 -120000 -5605 -35019
Retained earnings (accumulated deficit) -3608000 -4750000 -5669000 -6000000 -6104000 -6188000 -6331639 -5923305
Total stockholders' equity (deficit) 24804000 23017000 16031000 9855000 9173000 6040000 5715393 4605596
Noncontrolling interests in subsidiaries 841000 847000 861000 869000 867000 842000 854841 862026