5-2 Project Two Milestone: Comparison Analysis

profileJMooreHelpNeeded
TeslaCashFlow.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 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
Net income (loss) 1642000 464000 566000 197000 68000 -907000 -1056907 -667645
Depreciation, amortization & impairment 1302000 621000 1704000 1120000 553000 1577000 1046149 467577
Stock-based compensation 1088000 614000 1101000 558000 211000 617000 418241 208378
Amortization of debt discounts & issuance costs - - 144000 94000 46000 138000 82123 40108
Inventory & purchase commitments write-downs 88000 49000 140000 88000 45000 - - -
Inventory write-downs - - - - - 167000 115672 80843
Loss on disposals of fixed assets - - 67000 12000 7000 69000 47931 18421
Foreign currency transaction net loss (gain) -1000 -2000 144000 38000 19000 -102000 -10848 -39130
Non-cash interest & other operating activities 60000 8000 116000 110000 58000 189000 158699 116050
Digital assets gain, net -78000 -101000 - - - - - -
Operating cash flow related to repayment of discounted convertible notes - - - - - -188000 -188107 -188107
Accounts receivable -283000 -24000 -550000 -236000 -14000 -150000 -168312 -99640
Inventory -687000 -106000 -602000 -535000 -981000 -485000 -352428 -809152
Operating lease vehicles -916000 -426000 -640000 -330000 -197000 -467000 -175898 13012
Prepaid expenses & other current assets -131000 -143000 -290000 -301000 -154000 -236000 -139141 -46103
Other non-current assets -289000 -168000 -105000 -16000 40000 46000 42165 28064
Accounts payable & accrued liabilities 1592000 672000 765000 -372000 -265000 142000 49898 -27577
Deferred revenue 279000 162000 118000 -20000 53000 625000 476556 317888
Customer deposits 52000 -2000 -15000 5000 88000 -114000 -160376 -25173
Resale value guarantee - - - - - -112000 -76332 -47394
Other long-term liabilities 47000 23000 261000 112000 -17000 171000 114915 19974
Net cash flows from operating activities 3765000 1641000 2924000 524000 -440000 980000 224000 -639606
Purchases of property & equipment excluding finance leases, net of sales -2853000 -1348000 -2006000 -1001000 -455000 -915000 -529609 -279932
Purchases of solar energy systems, net of sales -22000 -12000 -62000 -46000 -26000 -68000 -43458 -25261
Purchases of digital assets -1500000 -1500000 - - - - - -
Receipt of government grants 6000 6000 1000 1000 1000 - - -
Proceeds from sales of digital assets 272000 272000 - - - - - -
Purchase of intangible assets - - -5000 - - -5000 -5333 -
Business combinations, net of cash acquired - - -13000 - - -45000 31012 -650
Net cash flows from investing activities -4097000 -2582000 -2085000 -1046000 -480000 -1033000 -547388 -305843
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 4862000 2983000 7826000 4946000 2802000 7119000 5007481 1494066
Repayments of convertible & other debt -7408000 -4038000 -7537000 -4226000 -2318000 -5601000 -3700332 -1970709
Collateralized lease repayments -8000 -6000 -224000 -168000 -97000 - - -
Collateralized lease borrowing - - - - - - -219323 -
Collateralized lease borrowings (repayments) - - - - - -302000 - -133891
Proceeds from exercises of stock options & other stock issuances 253000 183000 361000 217000 160000 167000 95585 77953
Principal payments on finance leases -196000 -101000 -248000 -154000 -100000 -223000 -142571 -66656
Debt issuance costs -5000 -5000 -6000 - - - - -
Common stock & debt issuance costs - - - - - -32000 -30376 -7757
Purchase of convertible note hedges - - - - - -476000 -475824 -
Proceeds from issuance of warrants - - - - - 174000 174432 -
Proceeds from investments by noncontrolling interests in subsidiaries 2000 - 23000 19000 19000 153000 88866 46821
Distributions paid to noncontrolling interests in subsidiaries -65000 -32000 -163000 -110000 -67000 -211000 -148759 -85257
Payments for buy-outs of noncontrolling interests in subsidiaries - - -33000 -2000 - -8000 -7589 -7589
Net cash flows from financing activities -2565000 -1016000 7281000 2831000 2708000 1608000 1489822 -653019
Effect of exchange rate changes on cash & cash equivalents & restricted cash -179000 -221000 100000 14000 -24000 -6000 5471 4878
Net increase (decrease) in cash & cash equivalents & restricted cash -3076000 -2178000 8220000 2323000 1764000 1549000 1171905 -1593590
Cash & cash equivalents & restricted cash, beginning of period 19901000 19901000 6783000 6783000 6783000 4277000 4276388 4276388
Cash & cash equivalents & restricted cash, end of period 16825000 17723000 15003000 9106000 8547000 5826000 5448293 2682798