See Description Final Business Plan

Cash Flow

Small Business Cash Flow Projection
Starting date	Jan-18
Cash balance alert minimum		0	0	0	0	0	0	0	0	0	0	0	0
	Beginning	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18	Total
Cash on hand (beginning of month)		0	528,653	1,057,306	1,585,959	2,114,612	2,643,265	3,171,918	3,700,571	4,229,224	4,757,877	5,286,530	5,815,183
CASH RECEIPTS
Cash sales		350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	4,200,000
Returns and allowances		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
Collections on accounts receivable		100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	1,200,000
Interest, other income		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
Loan proceeds		20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	240,000
Owner contributions		150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	150,000	1,800,000
TOTAL CASH RECEIPTS		620,000	620,000	620,000	620,000	620,000	620,000	620,000	620,000	620,000	620,000	620,000	620,000	8,640,000
Total cash available	0	620,000	1,148,653	1,677,306	2,205,959	2,734,612	3,263,265	3,791,918	4,320,571	4,849,224	5,377,877	5,906,530	6,435,183
CASH PAID OUT
Advertising		100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	100,000	1,200,000
Commissions and fees		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
Contract labor		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
Employee benefit programs		10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	120,000
Insurance (other than health)		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
Interest expense		2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	30,000
Materials and supplies (in COGS)		10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	120,000
Meals and entertainment		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
Mortgage interest		850	850	850	850	850	850	850	850	850	850	850	850	10,200
Office expense		1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	12,000
Other interest expense		500	500	500	500	500	500	500	500	500	500	500	500	6,000
Pension and profit-sharing plan		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
Purchases for resale		2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	30,000
Rent or lease		1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	12,000
Rent or lease: vehicles, equipment		500	500	500	500	500	500	500	500	500	500	500	500	6,000
Repairs and maintenance		500	500	500	500	500	500	500	500	500	500	500	500	6,000
Supplies (not in COGS)		345	345	345	345	345	345	345	345	345	345	345	345	4,140
Taxes and licenses		4,500	4,500	4,500	4,500	4,500	4,500	4,500	4,500	4,500	4,500	4,500	4,500	54,000
Travel		1,250	1,250	1,250	1,250	1,250	1,250	1,250	1,250	1,250	1,250	1,250	1,250	15,000
Utilities		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	60,000
Wages (less emp. credits)		546	546	546	546	546	546	546	546	546	546	546	546	6,552
Other expenses		356	356	356	356	356	356	356	356	356	356	356	356	4,272
Other expenses														0
Other expenses														0
Miscellaneous														0
SUBTOTAL		211,347	211,347	211,347	211,347	211,347	211,347	211,347	211,347	211,347	211,347	211,347	211,347	2,536,164
Loan principal payment		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
Capital purchases		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	600,000
Other startup costs		20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	20,000	240,000
To reserve and/or escrow		0												0
Owners' withdrawal		0												0
TOTAL CASH PAID OUT		91,347	91,347	91,347	91,347	91,347	91,347	91,347	91,347	91,347	91,347	91,347	91,347	3,976,164
Cash on hand (end of month)	0	528,653	1,057,306	1,585,959	2,114,612	2,643,265	3,171,918	3,700,571	4,229,224	4,757,877	5,286,530	5,815,183	6,343,836
OTHER OPERATING DATA
Sales volume (dollars)		350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000	350,000
Accounts receivable balance		0	0	0	0	0	0	0	0	0	0	0	0
Bad debt balance		0	0	0	0	0	0	0	0	0	0	0	0
Inventory on hand		0	0	0	0	0	0	0	0	0	0	0	0
Accounts payable balance		45,000	45,000	45,000	45,000	45,000	45,000	45,000	45,000	45,000	45,000	45,000	45,000
Depreciation

Cash Flow Chart

	Cash balance alert minimum		$ - 0

Cash Flow Projection [Company Name]

Cash Flow Projection Beginning Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 0 528653 1057306 1585959 2114612 2643265 3171918 3700571 4229224 4757877 5286530 5815183 6343836 Cash on Hand Minimum Alert Beginning Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 0 0 0 0 0 0 0 0 0 0 0 0

Period

Cash on Hand