5-2 Project

profilegoldendoodlebug
4-2JournalEntryTesla.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 09/30/2020 06/30/2020 03/31/2020 09/30/2019 06/30/2019 03/31/2019 09/30/2018 06/30/2018 03/31/2018
3rd Quarter 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 USD
Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands
Cash & cash equivalents 14531000 8615000 8080000 5338000 4954740 2198169 2967504 2236424 2665673
Restricted cash - - - 233000 128006 130950 158627 146822 120194
Accounts receivable, net 1757000 1485000 1274000 1128000 1147100 1046945 1155001 569874 652848
Raw materials 1573000 1842000 1653000 1284000 1095888 1079216 997476 972739 902190
Work in process 572000 420000 494000 335000 334641 277155 358113 350443 315227
Finished goods 1674000 1379000 1961000 1583000 1600214 2151012 1657339 1721860 1125665
Service parts 399000 377000 386000 379000 351615 329467 301199 279601 222744
Inventory 4218000 4018000 4494000 3581000 3382358 3836850 3314127 3324643 2565826
Prepaid expenses & other current assets 1238000 1218000 1045000 660000 569748 464908 325232 422034 379379
Total current assets 21744000 15336000 14893000 10940000 10181952 7677822 7920491 6699797 6383920
Operating lease vehicles, net 2742000 2524000 2527000 2253000 2069540 1972502 2186137 2282047 2315124
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 6025000 6069000 6106000 6168000 6200704 6241637 - - -
Solar energy systems, leased & to be leased, net - - - - - - 6301537 6340031 6346374
Machinery, equipment, vehicles & office furniture 7943000 7687000 7428000 7007000 6919869 6584307 5950086 5201349 4532822
Tooling 1794000 1711000 1574000 1477000 1463543 1418368 1384382 1365588 1299296
Leasehold improvements 1291000 1157000 1103000 1029000 1010893 987916 943848 905759 840718
Building & building improvements - - - - - 2631607 - - -
Land & buildings 3245000 3172000 3146000 2956000 2839746 - 3995992 3904854 3808170
Computer equipment, hardware & software 782000 700000 647000 549000 553265 525138 463190 446959 426173
Construction in progress 1607000 1012000 812000 700000 543452 622180 963136 1333562 1604595
Property, plant & equipment, gross 16662000 15439000 14710000 13718000 13330768 12769516 13700634 13158071 12511774
Less: accumulated depreciation & amortization 4814000 4430000 4072000 3528000 3248310 2918587 2454339 2188723 1992548
Property, plant & equipment, net 11848000 11009000 10638000 10190000 10082458 9850929 11246295 10969348 10519226
Operating lease right-of-use assets 1375000 1274000 1197000 1234000 1248277 1253027 - - -
Intangible assets, net 318000 312000 323000 351000 327358 273568 291476 300406 346428
Goodwill 203000 196000 193000 186000 153475 74312 65226 64284 61284
MyPower customer notes receivable, net of current portion - - - 398000 400308 413181 422897 434841 449754
Restricted cash, net of current portion - - - 255000 365547 353679 396835 399992 433841
Other non-current assets 1436000 1415000 1373000 820000 842978 801867 431819 419254 415478
Total assets 45691000 38135000 37250000 32795000 31872597 28912524 29262713 27910000 27271429
Accounts payable 4958000 3638000 3970000 3468000 3133587 3248827 3596984 3030493 2603498
Accrued purchases 711000 782000 643000 - - - - - -
Payroll & related costs 502000 495000 409000 - - - - - -
Taxes payable 635000 484000 399000 - - - - - -
Accrued interest 51000 91000 55000 - - - - - -
Financing obligation, current portion 48000 47000 53000 - - - - - -
Accrued warranty reserve, current portion 400000 384000 362000 - - - - - -
Sales return reserve, current portion 461000 345000 289000 - - - - - -
Resale value guarantees, current portion 20000 70000 202000 - - - - - -
Operating lease liabilities, current portion 251000 233000 229000 - - - - - -
Other current liabilities 173000 179000 184000 - - - - - -
Accrued liabilities & other current liabilities 3252000 3110000 2825000 2497000 2622943 2276951 1990095 1814979 1898431
Deferred revenue 1258000 1130000 1186000 1045000 883293 762810 570920 576321 536465
Resale value guarantees - - - 441000 526758 480225 604949 674255 629112
Customer deposits 708000 713000 788000 665000 631107 768276 905838 942129 984823
Current portion of debt & finance leases 3126000 3679000 3217000 2030000 1791085 1705711 2106538 2020685 1915530
Current portion of solar bonds & promissory notes issued to related parties - - - - - - - - 82500
Current portion of promissory notes issued to related parties - - - - - - - 82500 -
Total current liabilities 13302000 12270000 11986000 10146000 9588773 9242800 9775324 9141362 8650359
Recourse debt - - 6011000 - - - - - -
Non-recourse debt - - 3468000 - - - - - -
Total debt - - 9479000 - - - - - -
Finance lease - - 1187000 - - - - - -
Debt & finance leases, net of current portion 10559000 10416000 10666000 11313000 11234401 9787950 9669879 9510696 8761070
Solar bonds issued to related parties, net of current portion - - - - - - 100 100 100
Convertible senior notes issued to related parties - - - - - - 2634 2594 2556
Deferred revenue, net of current portion 1233000 1198000 1199000 1140000 1182042 1157343 950126 795820 818250
Resale value guarantees, net of current portion - - - 38000 61200 211390 455762 584857 756800
Accrued warranty reserve, net of current portion 869000 812000 768000 692000 653095 590211 459398 367989 324871
Financing obligation 30000 42000 34000 - - - - - -
Sales return reserve, net of current portion 519000 529000 488000 547000 577914 524222 78387 78525 86359
Resale value guarantees 36000 36000 36000 - - - - - -
Operating lease liabilities 1101000 1016000 941000 1028000 1030797 1000886 - - -
Build-to-suit lease liability, net of current portion - - - - - - 1622059 1645969 1663972
Deferred rent expense, net of current portion - - - - - - 57643 53658 52222
Financing obligation, net of current portion - - - 42000 44549 45566 53976 58403 57312
Other noncurrent liabilities 494000 435000 400000 367000 349365 314250 283856 402914 377150
Other long-term liabilities 3049000 2870000 2667000 2676000 2655720 2475135 2555319 2607458 2561886
Total liabilities 28143000 26754000 26518000 25313000 24722136 22874618 23409144 22642887 21551021
Redeemable noncontrolling interests in subsidiaries 608000 613000 632000 600000 580227 570284 551264 539536 405835
Convertible senior notes 48000 44000 60000 - - - - - 2
Common stock 1000 - - - 179 174 171 170 170
Additional paid-in capital 21574000 15895000 15390000 12348000 12052458 10563746 9957711 9656537 9418896
Accumulated other comprehensive gain (loss) 125000 -40000 -113000 -120000 -5605 -35019 8271 18545 82921
Retained earnings (accumulated deficit) -5669000 -6000000 -6104000 -6188000 -6331639 -5923305 -5457315 -5768831 -5051292
Total stockholders' equity (deficit) 16031000 9855000 9173000 6040000 5715393 4605596 4508838 3906421 4450695
Noncontrolling interests in subsidiaries 861000 869000 867000 842000 854841 862026 793467 821156 863876