13-week cash flow

Click a group to expand its lines. Receipts are probability-weighted expectations per customer.

Week	116 Oct	223 Oct	330 Oct	46 Nov	513 Nov	620 Nov	727 Nov	84 Dec	911 Dec	1018 Dec	1125 Dec	121 Jan	138 Jan
Opening cash	1,20,00,000	95,26,389	72,73,102	1,42,96,453	1,90,59,787	1,62,80,876	1,52,65,955	1,30,00,264	1,35,44,346	1,55,66,896	1,40,55,769	1,29,77,790	1,39,07,434
Receipts
▸ Export (8)	10,00,581	6,00,386	7,77,121	9,96,377	8,67,245	6,21,230	4,29,329	6,34,866	3,43,900	2,93,496	2,64,300	1,09,568	1,73,504
Everest Gourmet	19,077	29,503	1,65,838	1,34,092	1,22,752	73,871	12,815	6,390	13,326	63,289	45,961	20,523	3,315
Mandovi Traders	1,01,589	95,559	1,92,230	55,891	72,673	12,918	42,934	20,711	96,548	75,372	46,894	30,239	42,060
Omkar Wholesale			252	34,965	1,57,901	16,620	2,529	2,093	4,195	3,615	1,296	2,515	1,266
Rajdhani Foods	2,78,788	56,185	7,329	3,00,637	1,48,935	40,841	7,623	15,785	9,616	8,800	7,034	5,193	4,019
Sahyadri Retail		995	1,37,637	91,241	5,248	28,781	5,397	3,803	3,656	3,287	1,967	1,319	1,307
Tamil Nadu Cooperative	1,21,739	61,970	64,355	1,41,256	1,35,647	94,656	60,704	43,250	44,309	37,505	24,445	17,598	16,004
Yamuna Cash & Carry	1,79,827	96,431	30,554	1,23,479	1,81,002	1,72,496	68,201	1,01,954	70,634	5,012	18,087	3,550	2,905
Zenith Retail Group	2,99,560	2,59,743	1,78,926	1,14,816	43,086	1,81,047	2,29,127	4,40,880	1,01,617	96,615	1,18,615	28,631	1,02,630
▸ Institutional (13)	10,52,842	8,94,399	10,47,903	11,01,736	9,13,952	7,21,499	10,56,517	11,83,224	7,41,193	6,30,416	3,62,237	3,92,892	2,50,719
Deccan Institutional	65,237	77,759	38,667	6,588	1,38,862	34,270	25,398	37,636	33,796	41,861	4,290	30,108	817
Falcon Wholesale	87,110	1,18,430	1,44,706	1,41,516	51,563	56,065	81,530	1,34,927	99,376	40,987	11,929	653	435
Fresh Basket Retail		8	18,930	49,074	69,943	17,424	42,136	31,517	21,339	16,901	541	14,568	524
Ganga Retail Chain	10,560	8,602	6,095	61,327	1,76,364	1,71,982	89,574	2,48,815	80,582	6,014	3,200	1,557	1,659
Gujarat Trade Links	6,385	1,44,618	2,51,529	2,37,378	95,931	9,514	2,234	1,844	2,215	1,473	389	13	2
Indus Hospitality Group	1,32,955	1,22,641	10,210	22,084	2,573	48,367	85,567	63,536	23,568	1,53,462	1,18,002	1,82,278	80,462
Ivory Hotels	1,73,905	1,37,760	65,049	14,142	22,800	74,532	1,50,917	1,57,715	73,290	20,249	1,456	655	761
Kaveri Super Stores	88,970	1,31,663	59,486	5,636	23,242	85,534	1,02,333	33,104	1,12,875	1,54,862	66,331	5,615	1,537
Lakeview Resorts	9	5,283	1,24,458	1,87,472	1,49,624	70,903	88,391	97,875	51,337	46,058	22,904	29,338	46,927
Lotus Institutional Supply	1,42,778	86,645	1,03,169	1,25,980	42,340	16,033	9,420	45,894	61,389	13,757	4,743	153	293
Malabar Exports		2	53,113	1,21,073	24,188	1,617	8,393	14,418	9,406	3,208	1,012	612	804
Punjab Agro Wholesale	49,203	1,424	9,460	47,179	68,426	35,213	18,512	37,960	27,139	19,980	27,019	8,572	8,413
Quick Mart India	2,95,730	59,563	1,63,032	82,287	48,097	1,00,045	3,52,111	2,77,982	1,44,878	1,11,604	1,00,419	1,18,772	1,08,085
▸ One-offs (1)			89,70,000
Factoring advance (net of fee)			89,70,000
▸ Other inflows (1)	8,00,000		8,00,000		8,00,000		8,00,000		8,00,000	8,00,000			8,00,000
Cash & carry counter sales	8,00,000		8,00,000		8,00,000		8,00,000		8,00,000	8,00,000			8,00,000
▸ Retail chains (12)	6,18,661	19,95,773	22,58,145	17,85,562	6,28,915	7,59,654	14,48,165	17,80,026	44,42,414	7,21,301	11,96,588	21,96,116	46,67,626
Apex Retail Holdings							50	10,79,861	37,13,131	4,54,121	10,71,265	21,41,676	46,44,726
Bharat Supermart	39,945	74,810	16,361	32,787	37,098	12,445	2,327	2,488	2,875	1,153	416	156	222
Brahma Catering	3,684	8,210	58,164	67,040	45,808	28,517	4,254	24,536	11,415	16,656	82	137	197
Chola Supermarkets	1,52,511	7,74,524	7,58,260	2,78,034	82,681	2,78,910	8,18,028	3,75,393	5,33,619	54,596	27,230	1,025	1,503
Coastal Provisions	20,342	79,091	6,729	540	1,514	3,963	1,511	750	119	322	112	4	3
Eastern Grocers Co-op	5	11,067	26,445	6,808	28,971	74,243	1,23,432	67,661	1,07,149	68,179	3,538	551	527
Harbour Exports Ltd	2,856	3,03,086	1,68,114	4,340	4,345	9,723	15,391	5,314	1,020	980	1,447	20	20
Jaipur Bulk Traders		940	4,18,902	4,54,269	58,064	4,743	13,334	36,622	12,265	4,765	1,930	2,830	45
Navjeevan Hospitals	28,671	1,41,766	2,66,550	3,33,582	50,900	37,568	14,385	14,059	6,083	2,777	906	1,057	397
Nilgiri Stores	7,740	48,938	2,91,237	1,70,831	1,56,955	87,108	3,05,872	79,717	9,282	34,237	46,992	48,599	19,935
Orchid Hotels Pvt Ltd	2,38,310	1,91,668	2,40,924	4,34,823	1,55,523	2,03,057	1,43,091	91,104	44,434	82,016	42,648	39	34
Vardhman Traders	1,24,599	3,61,674	6,460	2,510	7,055	19,377	6,490	2,522	1,021	1,497	24	21	15
▸ Wholesale (6)	3,20,180	5,74,141	16,49,507	16,81,301	6,18,214	3,43,053	5,21,929	7,06,471	6,93,339	1,95,617	1,28,171	31,068	23,547
Anand Kirana Network	1,270	1,35,590	2,52,304	1,47,302	77,184	29,839	15,604	20,012	8,066	5,611	5,388	2,901	3,988
Delta Wholesale Mart	6,975	1,577	1,563	32,287	59,353	14,131	7,925	32,207	71,373	34,815	10,311	9,534	1,016
Jupiter Mart	1,87,689	66,885	1,92,452	2,50,990	1,32,501	93,018	2,07,695	81,691	5,619	35,344	64,066	3,823	3,483
Kesari Provisions	38,492	1,18,898	11,27,946	11,89,389	3,05,535	33,062	1,03,272	4,61,294	5,89,200	1,06,229	8,908	8,680	11,315
Udaan Distribution	41,781	39,486	13,339	40,447	38,304	35,251	16,420	47,719	16,000	16	24,261	4	3
Western Edge Exports	43,973	2,11,704	61,902	20,887	5,336	1,37,752	1,71,013	63,548	3,082	13,602	15,238	6,126	3,742
Total receipts	37,92,263	40,64,699	1,55,02,676	55,64,978	38,28,327	24,45,437	42,55,940	43,04,586	70,20,845	26,40,830	19,51,294	27,29,644	59,15,396
Disbursements
▸ Accounts payable (25)	25,65,874	63,17,985	22,79,325	8,01,643	48,07,238	15,60,359	15,71,630	25,10,505	7,98,295	4,51,957	4,29,274
Akash Pest Control	3,03,480	1,48,071			2,68,287
Apollo Security Services					6,61,756	6,88,976	4,70,823
Bluebird Pallets	3,22,702			2,41,334
City Telecom		73,996				70,406
Crescent Cleaning					2,30,150
Greenfield Farms			1,58,815			1,30,490	1,83,521
Gupta Spices Ltd	7,88,673				5,34,364
Hindustan Cartons					5,13,788			5,46,560		4,51,957	4,29,274
Kohinoor Foods		9,23,671			12,76,799
Lalit Stationery					2,54,914				1,60,627
Mehta Edible Traders			3,94,705
Metro Fuel Services		2,80,603		5,60,310
Neha Printing Works	5,34,344		4,10,363				5,59,614
Om Cold Chain			3,13,778
Patel Packaging		10,13,195	10,01,664
Pinnacle Insurance Broking								2,79,107
PowerGrid Utilities	78,914	99,136			60,250
Reliance Logistics Partners		10,88,769			8,68,498	6,70,487		6,82,437
Shree Plastics		2,98,142
Sterling Legal Advisors					1,38,431		1,37,332
Sunrise Agro Mills		19,48,997
Surya Equipment Rentals								1,25,733
Tata Oils Supply	5,37,762							8,76,668	6,37,668
Vertex IT Services		4,43,404
Zen Corporate Travel							2,20,340
▸ Debt service (1)			12,50,000					12,50,000				12,50,000
Term loan EMI - HDFC			12,50,000					12,50,000				12,50,000
▸ Payroll (2)	18,00,000		44,00,000		18,00,000		44,00,000		18,00,000	18,00,000	26,00,000		18,00,000
Factory payroll (biweekly)	18,00,000		18,00,000		18,00,000		18,00,000		18,00,000	18,00,000			18,00,000
Staff payroll (monthly)			26,00,000				26,00,000				26,00,000
▸ Rent & facilities (1)			5,50,000				5,50,000					5,50,000
Warehouse & office rent			5,50,000				5,50,000					5,50,000
▸ Taxes (2)	19,00,000					19,00,000			24,00,000	19,00,000
Advance corporate tax									24,00,000
GST payment (20th)	19,00,000					19,00,000				19,00,000
Total disbursements	62,65,874	63,17,985	84,79,325	8,01,643	66,07,238	34,60,359	65,21,630	37,60,505	49,98,295	41,51,957	30,29,274	18,00,000	18,00,000
Net cash flow	-24,73,611	-22,53,286	70,23,351	47,63,334	-27,78,911	-10,14,921	-22,65,690	5,44,082	20,22,550	-15,11,126	-10,77,979	9,29,644	41,15,396
Closing cash	95,26,389	72,73,102	1,42,96,453	1,90,59,787	1,62,80,876	1,52,65,955	1,30,00,264	1,35,44,346	1,55,66,896	1,40,55,769	1,29,77,790	1,39,07,434	1,80,22,831
Cumulative net flow	-24,73,611	-47,26,898	22,96,453	70,59,787	42,80,876	32,65,955	10,00,264	15,44,346	35,66,896	20,55,769	9,77,790	19,07,434	60,22,831
Closing cash p10	82,85,253	56,27,339	1,20,28,491	1,70,73,480	1,44,70,829	1,34,53,384	1,12,27,019	1,08,64,622	1,37,03,497	1,24,13,350	1,16,16,445	1,16,07,854	1,65,51,304
Closing cash p90	1,08,15,669	90,17,580	1,66,12,837	2,10,18,416	1,81,51,541	1,70,74,196	1,48,42,715	1,77,35,756	1,73,53,666	1,58,13,817	1,43,89,204	1,92,32,679	1,94,68,584
Below minimum (25,00,000)