Envision Solar International, Inc. EVSI Cash Flow

Envision solar international, inc. (EVSI)

CashFlow / Quarterly

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
Operating Activities:
Net Loss
-942,521	-1,390,054	-610,363	-983,874	-949,631	-1,206,346	-606,556	-774,271	-1,011,607	-1,251,326	-566,199	-604,332	-619,573	-672,200	-609,564	-614,460	-737,292	-246,734	-530,153	-603,421	-459,225	-673,192	-555,864	-900,016	-1,017,230	-715,165	-323,986	-708,992	-1,045,767	-661,758	-600,606	-235,405	-983,959	-429,397	-1,171,559	381,450	-1,327,987
Adjustments to reconcile net loss to net cash used in operating activities:
Depreciation and Amortization
-	-	-	-	-	-	-	-	-	-	-	17,306	17,475	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation and amortization
8,936	10,482	10,055	10,034	9,929	11,023	15,461	18,284	18,071	-	-	-	-	-	17,584	19,556	47,332	-	41,453	39,292	8,700	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Common stock issued for services
78,447	138,431	155,000	31,250	31,250	31,250	37,500	28,125	140,625	-	-	-	-	65,377	148,875	74,915	61,749	10,416	37,416	10,418	47,832	57,778	83,251	45,834	74,417	67,784	-31,020	37,500	0	-	-	-	-	-	-	-	-
Amortization of prepaid expenses paid in common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-17,956	-	-20,122	-43,222	-28,995	-	-	-	-	-	-	-	-
Amortization of prepaid expenses paid in common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	27,401	-	-	2,069	2,627
Gain on debt extinguishment
-	-	-	-	-	-	-	-	-	-	-	0	107,081	-	-	-	-	0	7,358	0	0	1	6,000	0	-20,689	-	1,500	0	112,667	-	0	7,426	20,769	-	-	-	-
Depreciation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,538	11,868	10,961	11,025	11,027	8,928	12,203	12,201	12,494	13,915	17,115	16,904	16,256	16,256	16,257	16,257
Shares issued for services
-	-	-	-	-	-	-	-	-	-	-	-	30,375	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock option expense
27,068	36,823	8,260	1,531	2,301	98,546	4,342	4,342	4,342	-	-	-	-	-	1,745	2,922	58,515	-	2,922	2,922	7,065	-	113,957	113,957	115,281	-	-	-	-	-	-	-	-	-	-	-	10,440
Change in fair value of embedded conversion option liability
-	-	-	-	-	-	-	-	-	-	-	-	0	27,776	86,813	12,175	-145,853	149,849	-42,967	-46,674	207,411	153,768	204,381	-189,333	235,399	207,452	431,017	-18,700	-444,961	108,999	232,638	524,575	-218,235	234,193	398,602	994,984	-663,848
Amortization of Debt Discount
-	-	-	-	-	-	-	-	-	-	-	805	0	-	-	-	-	0	0	126,035	126,035	126,036	126,034	126,035	42,011	114,018	114,019	114,018	114,018	161,995	161,994	161,995	188,270	135,433	130,393	128,809	122,649
Amortization of Debt Issue Costs
-	-	-	-	-	-	-	-	-	0	0	0	800	42,304	27,871	27,871	27,871	9,290	0	1,219	1,219	1,218	1,219	1,219	406	1,250	1,250	1,250	1,250	0	0	0	30,480	-	-	-	-
Amortization of debt discount
5,990	1,498	1,498	224,688	298,739	210,144	90,738	181,556	379,344	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on Debt Settlement, net
-	-	-	-	-	-	-	-	-	-81,557	104,726	2,355	0	446,672	4,175	1,366	-1,286	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock Option Expense
-	-	-	-	-	-	-	-	-	-	-	39,780	39,111	-	-	-	-	-	-	-	-	-	-	-	-	173,959	90,899	85,085	85,085	142,971	207,920	207,920	207,921	-	-	-	-
Warrants issued as debt conversion inducement fees
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-482,300	-	0	0	0	-24,548	0	0	12,274	-	-	-	-
Changes in assets and liabilities:
(Increase) decrease in:
Accounts receivable
214,077	-302,864	-295,805	176,010	-101,080	497,010	104,333	-184,410	867,823	-131,905	-292,464	-37,486	-693,263	889,938	59,150	50,488	-669,619	449,691	-32,885	297,308	25,986	-268,331	74,249	284,174	-166,334	188,504	2,655	-76,679	-252,837	-2,423,523	-74,984	110,921	1,257,640	-1,125,805	-239,767	24,961	-72,886
Prepaid expenses and other current assets
308,685	-21,951	87,589	299,975	102,700	-84,616	263,284	-124,886	176,887	-122,604	109,877	-20,410	13,478	-32,661	9,676	24,944	22,886	8,434	-29,487	9,920	42,213	93,322	-20,749	57,244	-15,338	-22,280	-71,256	52,923	46,406	15,887	12,942	2,668	-33,451	27,214	8,122	8,832	-36,583
Costs and Estimated Earnings in Excess of Billings on Uncompleted Contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-35,056	10,339	20,824	25,951	4,909	6,897	-101,466	19,052	69,811	-111,595	94,921	39,529	-	-	-	-	-	-	-	-	-	-	-	-
Costs and estimated earnings in excess of billings on uncompleted contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	135,985	-62,152	38,644	-69,897	-	-	-	-
Inventory
605,396	106,785	-128,780	79,803	52,647	368,788	-141,031	348,058	-1,816,855	1,095,361	519,229	335,705	54,231	-542,151	71,021	141,012	163,882	-349,830	30,146	-87,540	427,716	127,881	166,723	-46,279	80,106	-33,053	-15,824	8,895	3,129	65,569	-9,244	0	0	-	-	-	-
Costs in excess of billings on uncompleted contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,947
Costs and estimated earnings in excess of billings on uncompleted contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-15,640
Deposits
223	0	0	0	-48,672	0	-1,457	-2,790	-46,800	0	0	1,810	0	-29,674	124,351	-77,121	-26,062	0	0	-207	-856	126,354	25,871	0	2,715	0	0	0	0	-	-	-	-	-	-	-	-
Increase (decrease) in:
Accounts payable
522,770	-228,424	57,363	-938,135	225,958	621,629	-226,035	379,864	106,109	-175,093	-307,419	271,158	-174,968	518,154	48,625	-28,799	-186,289	-57,946	313,506	95,043	-76,117	-127,011	103,585	-12,507	144,834	-41,013	100,608	-27,480	-90,551	-52,570	112,810	-98,079	-801,621	493,077	144,282	56,880	-42,627
Accounts payable - related party
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,512	0	0	-7,512
Accrued expenses
67,167	-51,016	61,506	-370,953	84,179	130,366	6,117	40,912	-15,149	-109,196	83,149	21,803	150,429	10,759	72,386	51,031	38,695	-73,311	-9,436	-66,885	129,873	11,409	-31,005	-49,251	-11,066	125,962	17,255	31,011	76,655	53,598	88,048	13,953	97,894	24,849	83,047	-31,356	146,876
Convertible note payable issued in lieu of salary - related party
-220,417	-	-	-	12,500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Convertible Note Payable Issued in Lieu of Salary - Related Party
-	-	-	-	-	-	12,500	12,500	12,500	12,500	12,500	12,500	47,500	50,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued rent
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,354	-	-	-	2,354	2,354	2,354	2,355	2,354
Sales tax payable
22,218	-127,189	119,110	14,230	-129	-46,434	-6,616	18,372	34,823	46	-14,047	-4,312	-31,822	31,006	7,009	-4,106	-97,469	24,492	-8,023	20,623	18,559	58,693	-35,250	36,516	0	-1,230	1,230	-22	-2,014	-3,402	5,438	0	-5,438	-	-	-	-
Deferred revenue
5,447	-	-	-	68,322	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred Revenue
-	-	-	-	-	-	149,878	15,075	-21,865	-12,653	0	-25,813	40,657	-151,414	142,837	-5,747	-123,820	-461,860	-257,412	-103,727	319,175	686,169	31,122	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Billings in excess of costs on uncompleted contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,342
Billings in excess of costs and estimated earnings on uncompleted contracts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-5,614	-32,279	37,893	0	-163,129	163,129	0	-4,662	-22,176	22,308	4,530	0	-102,921	92,254	10,667	-23,744	17,943
NET CASH USED IN OPERATING ACTIVITIES
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-650,505	-280,607	-966,712	-348,789	-549,822	-604,020	-72,490	-458,070	-827,979	-458,583	-492,866	-408,787	-385,660	-304,354	-	-	-	-	-	-	-	-
Net cash used in operating activities
-1,553,276	-1,382,058	-598,591	-2,623,514	-222,177	-303,321	-764,060	-111,213	466,138	-1,990,613	-993,957	-471,199	18,457	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-377,465	-423,025	41,317	-329,527	-481,848	-643,504	-515,952
Investing Activities:
Purchase of equipment
125,142	22,863	3,862	3,005	3,110	23,470	0	0	0	17,976	2,699	1	3,219	18,409	29,252	68,225	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Funding of patent costs
18,370	35,192	19,884	11,551	10,119	3,014	11,207	17,636	27,222	543	90	875	962	12,608	7,346	2,857	14,500	10,725	25,895	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
NET CASH USED IN INVESTING ACTIVITIES
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-71,082	-14,500	-62,282	-34,013	-167,245	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-143,512	-58,055	-23,746	-14,556	-13,229	-26,484	39,060	-17,636	-27,222	-18,519	-2,789	-876	-4,181	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Financing Activities:
Proceeds from sale of common stock
-	-	-	-	-	0	0	0	290,000	2,085,000	15,000	215,000	30,000	350,000	290,000	855,000	325,000	135,000	680,000	0	0	965,000	880,510	230,000	927,500	0	0	91,500	1,843,700	0	0	1,050,000	0	0	0	545,251	1,172,000
Proceeds from Subscription Receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	25,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from subscription receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payments of offering costs related to sale of common stock
-	-	-	-	-	0	0	0	12,000	50,000	0	1,200	2,400	24,000	0	21,200	23,600	8,900	0	0	0	38,400	22,840	17,600	24,000	0	0	7,320	147,496	0	0	84,000	0	-2	0	82,539	171,976
Borrowings (repayments) on convertible line of credit, net
0	-	-	-	158,442	-	-	-	0	-	-	-	-	-	-200,000	0	200,000	800,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Borrowings (repayments) on convertible line of credit, net
-	-	-	-	-	-436,220	-184,547	-49,233	860,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on Line of Credit, Net
-	-	-	-	-	-	-	-	-	0	-1,500,000	500,000	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of convertible notes payable, net
-	-	-	-	-	3,000	3,000	3,000	3,000	-	-	3,000	3,000	-9,000	3,000	3,000	3,000	3,000	259,325	3,000	3,000	3,000	3,000	3,000	3,000	3,000	3,000	3,000	3,067	0	0	0	0	-	-	-	-
Repayments of auto loan
2,718	2,661	2,652	2,608	2,583	2,500	2,501	2,518	3,166	2,345	1,580	2,332	2,276	2,253	2,213	2,164	2,130	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from warrant exercises
282,350	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of equity offering costs
0	-1	1	1,137,165	38,686	81,831	72,781	40,416	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of Debt Issue Costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0	6,500	0	0	0	0	-	-	-	-	-	-	-	-
NET CASH PROVIDED BY FINANCING ACTIVITIES
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	828,636	496,270	945,105	420,675	-3,000	22,000	923,600	854,670	209,400	894,000	-3,000	-3,000	81,180	1,693,137	-	-	-	-	-	-	-	-
Net cash provided by financing activities
279,632	-2,660	-2,652	8,429,497	117,173	318,889	851,265	3,299	-588,166	2,281,099	856,348	698,813	22,324	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	966,000	0	-34,244	960,000	462,712	1,000,024
Net decrease in cash
-1,417,156	-1,442,773	-624,989	5,791,427	-118,233	-10,916	126,265	-125,550	-149,250	271,967	-140,398	226,738	36,600	-72,127	-259,968	107,049	201,163	-83,889	37,873	-720,067	-582,020	775,268	396,600	-618,829	435,417	-497,814	-451,787	-304,480	1,388,783	-408,639	-382,820	538,762	41,317	-376,730	478,152	-180,792	484,072
Supplemental Disclosure of Cash Flow Information:
Cash paid for interest
52,666	196	573	345,040	18,286	-	-	27,189	71,372	24,409	18,556	19,032	11,412	11,582	11,523	11,434	10,594	104,246	47,374	0	0	0	0	0	0	0	0	0	0	6,134	0	3,067	3,067	-	-	-	-
Cash paid for taxes
0	0	2,269	831	0	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Supplemental Disclosure of Non-Cash Investing and Financing Activities:
Recording of debt discount
0	-	-	-	3,967	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid for tax
-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid for income tax
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	1,600	0	0	0	0	1,600	0	0	0	1,600	0	677	0	34	1,037	2,371	9,154	35	1,600
Shares issued for debt conversion
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Convertible debt converted to shares of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,000,000	-	-	-	-
Convertible debt converted to shares of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	550,000	-	0	0	0	-	-	-	-	-	-	-	-
Accrued interest converted to common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	175,850	-	0	0	0	-	-	-	-	-	-	-	-
Warrants issued as debt extension fee
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	193,625	0	0	0	0	-	-	-	-	-	-	-	-
Embedded conversion option liability recorded as debt discount
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	595,014	34,483	0	18,480
Shares issued for debt conversion
-	-	-	-	-	-	-	-	-	-	-	0	704,709	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recording of debt discount
-	-	-	-	-	-	-	30,960	212,420	239,839	475,990	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of prepaid asset to inventory
72,750	35,391	218,439	243,018	79,850	-	-	0	30,272	0	0	0	21,168	0	0	0	31,752	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recording of right of use asset and corresponding liability
0	0	0	0	872,897	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Embedded conversion option based effective interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	478,561	-	0	0	0	-	-	-	-	-	-	-	-
Depreciation transferred to inventory
-	-	-	-	-	-	-	-	-	-	-	5,508	5,481	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Transfer of inventory to property and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	11,760	41,229	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation capitalized into inventory
3,705	5,785	6,685	6,684	6,607	-	-	5,507	5,508	-	-	-	-	-	10,247	5,858	5,501	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Prepaid insurance financed by a third party
-	-	-	-	-	-	-	-	-	-7,000	-7,001	-14,915	31,250	-7,234	-7,235	-7,235	24,116	-6,660	-6,661	-6,660	19,981	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Shares of common stock issued for services
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	48,240	0	37,500	-	-	-	-	-	-	-	-
Convertible accrued interest converted to common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	47,836	-	-	-	-
Shares of common stock issued for prepaid services
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-