Plan finances for new business ventures in Australia

GrabACoffee Financial Plan

Projected Cash Flow and Working Capital Requirements

			Projected Cash Flow for the year ended 30 June
		Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Total yr
Cash inflows
	Coffee regular	$ 14,310	$ 15,025	$ 15,777	$ 16,565	$ 17,394	$ 19,133	$ 17,220	$ 18,081	$ 18,985	$ 19,934	$ 20,931	$ 21,977	$ 215,331
	Coffee Large	$ 11,845	$ 12,437	$ 13,059	$ 13,712	$ 14,397	$ 15,837	$ 14,253	$ 14,966	$ 15,714	$ 16,500	$ 17,325	$ 18,191	$ 178,238
	Bottled water	$ 1,349	$ 1,416	$ 1,487	$ 1,561	$ 1,639	$ 1,803	$ 1,623	$ 1,704	$ 1,789	$ 1,879	$ 1,973	$ 2,071	$ 20,296
	Banana cake	$ 1,959	$ 2,057	$ 2,159	$ 2,267	$ 2,381	$ 2,619	$ 2,357	$ 2,475	$ 2,599	$ 2,728	$ 2,865	$ 3,008	$ 29,473
	Carrot cake	$ 2,111	$ 2,217	$ 2,327	$ 2,444	$ 2,566	$ 2,823	$ 2,540	$ 2,667	$ 2,801	$ 2,941	$ 3,088	$ 3,242	$ 31,767
	Choc chip cookie	$ 2,405	$ 2,525	$ 2,652	$ 2,784	$ 2,923	$ 3,216	$ 2,894	$ 3,039	$ 3,191	$ 3,350	$ 3,518	$ 3,694	$ 36,192
Total cash inflows	$ 33,978	$ 35,677	$ 37,461	$ 39,334	$ 41,301	$ 45,431	$ 40,888	$ 42,932	$ 45,079	$ 47,333	$ 49,699	$ 52,184	$ 511,298
Cash outflows
	Start up costs (less $5,000 in savings)	$ 23,379	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 23,379
	Coffee (variable costs)
	- Raw materials and labour	$ 16,514	$ 17,340	$ 18,207	$ 19,117	$ 20,073	$ 22,080	$ 19,872	$ 20,866	$ 21,909	$ 23,005	$ 24,155	$ 25,363	$ 248,502
	Purchase price of retail pre pkgd products
	- Bottled water	$ 759	$ 797	$ 837	$ 879	$ 923	$ 1,015	$ 913	$ 959	$ 1,007	$ 1,057	$ 1,110	$ 1,166	$ 11,421
	- Banana cake	$ 1,313	$ 1,379	$ 1,448	$ 1,520	$ 1,596	$ 1,756	$ 1,580	$ 1,660	$ 1,742	$ 1,830	$ 1,921	$ 2,017	$ 19,764
	- Carrot cake	$ 1,452	$ 1,525	$ 1,601	$ 1,681	$ 1,765	$ 1,941	$ 1,747	$ 1,835	$ 1,926	$ 2,023	$ 2,124	$ 2,230	$ 21,849
	- Choc chip cookie	$ 1,719	$ 1,805	$ 1,896	$ 1,990	$ 2,090	$ 2,299	$ 2,069	$ 2,172	$ 2,281	$ 2,395	$ 2,515	$ 2,641	$ 25,872
	Fixed costs
	- Rent	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 3,100	$ 37,200
	- Electricity	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 200	$ 2,400
	- Coffee machine servicing	$ 50	$ 50	$ 50	$ 50	$ 50	$ 200	$ 50	$ 50	$ 50	$ 50	$ 50	$ 50	$ 600
	- Internet service	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 80	$ 960
	- Bank fees	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 15	$ 180
	- Marketing	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 350	$ 4,200
	- Barista (full time)	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 4,180	$ 50,160
Total cash outflows	$ 53,112	$ 30,821	$ 31,963	$ 33,162	$ 34,422	$ 37,217	$ 34,157	$ 35,466	$ 36,841	$ 38,284	$ 39,800	$ 41,391	$ 446,487
Net cash flows	-$19,134	$4,856	$5,498	$6,172	$6,879	$8,214	$6,730	$7,466	$8,238	$9,048	$9,900	$10,793	$64,661
	Beginning cash balance	$5,000	-$14,134	-$9,277	-$3,779	$2,392	$9,271	$17,486	$24,216	$31,682	$39,920	$48,968	$58,868
	Ending cash balance	-$14,134	-$9,277	-$3,779	$2,392	$9,271	$17,486	$24,216	$31,682	$39,920	$48,968	$58,868	$69,661

1. Based on Projected Cash Flow above, record the month that GrabACoffee will start to show consistent positive net cashflows each month: