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	93,02,316	78,08,483	65,73,666	1,39,15,679	1,59,32,462	2,05,86,983	2,04,09,915	2,04,33,509	1,90,18,855	1,75,82,993	1,59,33,828	1,47,21,256
Receipts
▸ Export (8)	9,20,534	5,52,355	7,14,951	9,16,667	7,97,865	5,71,532	3,94,983	5,84,077	3,16,388	2,70,016	2,43,156	1,00,802	1,59,624
Everest Gourmet	17,551	27,143	1,52,571	1,23,365	1,12,932	67,961	11,789	5,879	12,260	58,226	42,284	18,881	3,050
Mandovi Traders	93,462	87,915	1,76,852	51,420	66,859	11,884	39,499	19,054	88,824	69,342	43,143	27,820	38,695
Omkar Wholesale			232	32,168	1,45,269	15,290	2,327	1,925	3,859	3,326	1,193	2,314	1,165
Rajdhani Foods	2,56,485	51,690	6,743	2,76,586	1,37,020	37,574	7,013	14,522	8,847	8,096	6,471	4,778	3,697
Sahyadri Retail		916	1,26,626	83,942	4,828	26,478	4,965	3,499	3,364	3,024	1,810	1,213	1,202
Tamil Nadu Cooperative	1,12,000	57,012	59,207	1,29,955	1,24,795	87,084	55,848	39,790	40,764	34,505	22,489	16,190	14,724
Yamuna Cash & Carry	1,65,441	88,716	28,110	1,13,601	1,66,522	1,58,697	62,745	93,798	64,983	4,611	16,640	3,266	2,672
Zenith Retail Group	2,75,595	2,38,963	1,64,612	1,05,630	39,639	1,66,564	2,10,797	4,05,610	93,487	88,886	1,09,126	26,340	94,419
▸ Institutional (13)	9,68,615	8,22,847	9,64,071	10,13,598	8,40,836	6,63,779	9,71,996	10,88,566	6,81,897	5,79,983	3,33,258	3,61,461	2,30,661
Deccan Institutional	60,018	71,538	35,573	6,061	1,27,753	31,529	23,367	34,625	31,092	38,512	3,947	27,699	752
Falcon Wholesale	80,141	1,08,956	1,33,129	1,30,195	47,438	51,579	75,008	1,24,132	91,426	37,708	10,975	600	400
Fresh Basket Retail		7	17,416	45,148	64,348	16,030	38,765	28,996	19,632	15,549	498	13,402	482
Ganga Retail Chain	9,716	7,914	5,607	56,421	1,62,255	1,58,224	82,409	2,28,910	74,136	5,533	2,944	1,432	1,527
Gujarat Trade Links	5,874	1,33,049	2,31,406	2,18,388	88,257	8,753	2,055	1,697	2,037	1,356	358	12	2
Indus Hospitality Group	1,22,319	1,12,829	9,393	20,317	2,367	44,498	78,722	58,453	21,683	1,41,185	1,08,561	1,67,695	74,025
Ivory Hotels	1,59,992	1,26,739	59,845	13,011	20,976	68,570	1,38,844	1,45,098	67,427	18,629	1,340	603	700
Kaveri Super Stores	81,853	1,21,130	54,727	5,185	21,382	78,692	94,146	30,455	1,03,845	1,42,473	61,025	5,166	1,414
Lakeview Resorts	8	4,861	1,14,501	1,72,475	1,37,654	65,231	81,320	90,045	47,230	42,373	21,072	26,991	43,173
Lotus Institutional Supply	1,31,356	79,714	94,916	1,15,902	38,953	14,750	8,666	42,222	56,478	12,656	4,363	140	270
Malabar Exports		2	48,864	1,11,387	22,253	1,488	7,721	13,265	8,654	2,952	931	563	739
Punjab Agro Wholesale	45,266	1,310	8,703	43,405	62,952	32,396	17,031	34,924	24,968	18,382	24,858	7,886	7,740
Quick Mart India	2,72,072	54,798	1,49,990	75,704	44,249	92,041	3,23,942	2,55,743	1,33,288	1,02,676	92,386	1,09,270	99,438
▸ 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)	5,84,476	47,19,781	39,36,916	54,95,090	47,68,923	60,35,611	33,20,871	9,39,377	9,86,857	4,34,171	2,56,504	96,583	42,268
Apex Retail Holdings	15,308	28,83,669	18,59,422	38,52,372	41,90,320	53,36,729	19,88,606	2,95,225	3,15,917	1,88,366	1,41,207	46,498	21,200
Bharat Supermart	36,749	68,825	15,052	30,164	34,130	11,449	2,141	2,289	2,645	1,061	383	143	205
Brahma Catering	3,389	7,553	53,511	61,676	42,144	26,236	3,913	22,573	10,502	15,324	75	126	181
Chola Supermarkets	1,40,310	7,12,562	6,97,599	2,55,791	76,067	2,56,597	7,52,585	3,45,362	4,90,930	50,228	25,051	943	1,383
Coastal Provisions	18,714	72,763	6,191	497	1,393	3,646	1,390	690	109	296	103	4	3
Eastern Grocers Co-op	4	10,182	24,329	6,263	26,654	68,303	1,13,557	62,248	98,577	62,725	3,255	507	485
Harbour Exports Ltd	2,627	2,78,839	1,54,664	3,993	3,998	8,945	14,159	4,889	938	901	1,331	19	19
Jaipur Bulk Traders		864	3,85,390	4,17,928	53,419	4,364	12,268	33,692	11,284	4,384	1,775	2,604	41
Navjeevan Hospitals	26,377	1,30,425	2,45,226	3,06,895	46,828	34,563	13,234	12,934	5,596	2,555	833	972	365
Nilgiri Stores	7,120	45,023	2,67,938	1,57,165	1,44,398	80,139	2,81,402	73,339	8,540	31,498	43,233	44,711	18,341
Orchid Hotels Pvt Ltd	2,19,245	1,76,335	2,21,650	4,00,037	1,43,081	1,86,813	1,31,644	83,816	40,879	75,455	39,236	36	32
Vardhman Traders	1,14,631	3,32,740	5,943	2,309	6,491	17,827	5,971	2,320	939	1,378	22	19	14
▸ Wholesale (6)	2,94,565	5,28,209	15,17,546	15,46,797	5,68,757	3,15,609	4,80,175	6,49,953	6,37,872	1,79,968	1,17,917	28,583	21,664
Anand Kirana Network	1,169	1,24,743	2,32,120	1,35,518	71,010	27,451	14,356	18,411	7,420	5,162	4,957	2,669	3,669
Delta Wholesale Mart	6,417	1,451	1,438	29,704	54,605	13,001	7,291	29,630	65,663	32,030	9,486	8,771	935
Jupiter Mart	1,72,674	61,534	1,77,056	2,30,911	1,21,901	85,577	1,91,079	75,156	5,169	32,517	58,940	3,517	3,204
Kesari Provisions	35,413	1,09,386	10,37,711	10,94,238	2,81,093	30,417	95,010	4,24,391	5,42,064	97,731	8,195	7,986	10,410
Udaan Distribution	38,438	36,327	12,272	37,211	35,239	32,431	15,106	43,901	14,720	15	22,321	4	3
Western Edge Exports	40,455	1,94,768	56,950	19,216	4,909	1,26,732	1,57,332	58,464	2,835	12,514	14,019	5,636	3,442
Total receipts	35,68,190	66,23,192	79,33,484	89,72,151	77,76,381	75,86,532	59,68,024	32,61,972	34,23,014	22,64,138	9,50,835	5,87,429	12,54,217
Disbursements
▸ Accounts payable (25)	25,65,874	81,17,025	29,68,301	16,30,138	39,59,598	10,32,011	11,95,092	19,88,378	6,37,668
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	81,17,025	91,68,301	16,30,138	57,59,598	29,32,011	61,45,092	32,38,378	48,37,668	37,00,000	26,00,000	18,00,000	18,00,000
Net cash flow	-26,97,684	-14,93,832	-12,34,817	73,42,013	20,16,783	46,54,521	-1,77,068	23,594	-14,14,654	-14,35,862	-16,49,165	-12,12,571	-5,45,783
Closing cash	93,02,316	78,08,483	65,73,666	1,39,15,679	1,59,32,462	2,05,86,983	2,04,09,915	2,04,33,509	1,90,18,855	1,75,82,993	1,59,33,828	1,47,21,256	1,41,75,473
Cumulative net flow	-26,97,684	-41,91,517	-54,26,334	19,15,679	39,32,462	85,86,983	84,09,915	84,33,509	70,18,855	55,82,993	39,33,828	27,21,256	21,75,473
Closing cash p10	81,45,244	40,73,468	39,19,958	95,89,948	1,20,45,245	1,61,89,749	1,61,44,402	1,68,00,177	1,73,61,895	1,64,75,759	1,49,31,483	1,38,18,744	1,33,80,327
Closing cash p90	1,05,01,327	1,09,30,514	92,86,526	1,71,30,001	1,97,31,925	2,48,27,451	2,29,76,210	2,27,36,063	2,07,20,854	1,89,40,109	1,70,06,064	1,56,25,862	1,49,73,468
Below minimum (25,00,000)