5-2 Project

profilegoldendoodlebug
JournalEntry3.xlsx

asreported

Powered by Clearbit
Tesla Inc (NMS: TSLA)
Exchange rate used is that of the Year End reported date
As Reported Quarterly Cash Flow
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
Net income (loss) 566000 197000 68000 -907000 -1056907 -667645 -1272660 -1527333 -784627
Depreciation, amortization & impairment 1704000 1120000 553000 1577000 1046149 467577 1404313 - -
Depreciation & amortization - - - - - - - 901488 416233
Stock-based compensation 1101000 558000 211000 617000 418241 208378 543711 338983 141639
Amortization of debt discounts & issuance costs 144000 94000 46000 138000 82123 40108 120873 74419 39345
Inventory & purchase commitments write-downs 140000 88000 45000 - - - - - -
Inventory write-downs - - - 167000 115672 80843 59983 46098 18546
Loss on disposals of fixed assets 67000 12000 7000 69000 47931 18421 132639 118850 52237
Foreign currency transaction net loss (gain) 144000 38000 19000 -102000 -10848 -39130 -6614 6185 47661
Non-cash interest & other operating activities 116000 110000 58000 189000 158699 116050 22093 5685 -3984
Operating cash flow related to repayment of discounted convertible notes - - - -188000 -188107 -188107 - - -
Accounts receivable -550000 -236000 -14000 -150000 -168312 -99640 -686103 -98509 -169142
Inventory -602000 -535000 -981000 -485000 -352428 -809152 -1110611 -1055556 -322081
Operating lease vehicles -640000 -330000 -197000 -467000 -175898 13012 -188948 -186208 -97196
Prepaid expenses & other current assets -290000 -301000 -154000 -236000 -139141 -46103 -31532 -95194 -50001
Other non-current assets -105000 -16000 40000 46000 42165 28064 - - -
MyPower customer notes receivable and & assets - - - - - - -62399 -59446 -57583
Accounts payable & accrued liabilities 765000 -372000 -265000 142000 49898 -27577 1627997 909720 317983
Deferred revenue 118000 -20000 53000 625000 476556 317888 284417 107497 45795
Customer deposits -15000 5000 88000 -114000 -160376 -25173 9471 42920 67359
Resale value guarantee - - - -112000 -76332 -47394 -57621 -39563 -
Other long-term liabilities 261000 112000 -17000 171000 114915 19974 74232 -18076 -60560
Net cash flows from operating activities 2924000 524000 -440000 980000 224000 -639606 863241 -528040 -398376
Purchases of property & equipment excluding finance leases, net of sales -2006000 -1001000 -455000 -915000 -529609 -279932 -1775746 -1265475 -655662
Purchase of solar energy systems, leased & to be leased - - - - - - -189869 -140375 -72975
Purchases of solar energy systems, net of sales -62000 -46000 -26000 -68000 -43458 -25261 - - -
Receipt of government grants 1000 1000 1000 - - - - - -
Purchase of intangible assets -5000 - - -5000 -5333 - - - -
Business combinations, net of cash acquired -13000 - - -45000 31012 -650 -6804 -5604 -
Net cash flows from investing activities -2085000 -1046000 -480000 -1033000 -547388 -305843 -1972419 -1411454 -728637
Proceeds from issuances of common stock in public offerings, net of issuance costs 7282000 2309000 2309000 848000 848232 - - - -
Proceeds from issuances of convertible & other debt 7826000 4946000 2802000 7119000 5007481 1494066 3946575 3043227 1775481
Repayments of convertible & other debt -7537000 -4226000 -2318000 -5601000 -3700332 -1970709 -3111242 -2268716 -1389388
Collateralized lease repayments -224000 -168000 -97000 - - - - - -
Repayments of borrowings under solar bonds issued to related parties - - - - - - -100000 -17500 -17500
Collateralized lease borrowing - - - - -219323 - - - -
Collateralized lease borrowings (repayments) - - - -302000 - -133891 -343086 -200518 -87092
Proceeds from exercises of stock options & other stock issuances 361000 217000 160000 167000 95585 77953 219945 125071 94018
Principal payments on finance leases -248000 -154000 -100000 -223000 -142571 -66656 -105867 -48182 -18787
Debt issuance costs -6000 - - - - - - - -
Common stock & debt issuance costs - - - -32000 -30376 -7757 -5121 -3671 -2913
Purchase of convertible note hedges - - - -476000 -475824 - - - -
Proceeds from issuance of warrants - - - 174000 174432 - - - -
Payments for settlements of warrants - - - - - - -5 - -
Proceeds from investments by noncontrolling interests in subsidiaries 23000 19000 19000 153000 88866 46821 366297 253037 73704
Distributions paid to noncontrolling interests in subsidiaries -163000 -110000 -67000 -211000 -148759 -85257 -178511 -109545 -52942
Payments for buy-outs of noncontrolling interests in subsidiaries -33000 -2000 - -8000 -7589 -7589 -2921 -2921 -2921
Net cash flows from financing activities 7281000 2831000 2708000 1608000 1489822 -653019 686064 770282 371660
Effect of exchange rate changes on cash & cash equivalents & restricted cash 100000 14000 -24000 -6000 5471 4878 -18879 -12509 10102
Net increase (decrease) in cash & cash equivalents & restricted cash 8220000 2323000 1764000 1549000 1171905 -1593590 -441993 -1181721 -745251
Cash & cash equivalents & restricted cash, beginning of period 6783000 6783000 6783000 4277000 4276388 4276388 3964959 3964959 3964959
Cash & cash equivalents & restricted cash, end of period 15003000 9106000 8547000 5826000 5448293 2682798 3522966 2783238 3219708