Cash Flow Forecast

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Cash Flow Forecast
2	Paul's Pottery Palace - Pottery and Pottery Lessons
3
4		Time "0"	Jan 2019	Feb 2019	Mar 2019	Apr 2019	May 2019	Jun 2019	Aug 2019	Sep 2019	Oct 2019	Nov 2019	Dec 2019
5
6	Cash Inflows
7	Loans	25,000.00
8	Bank Loan
9	Family Loan	50,000.00
10	Owner's investment	25,000.00
11		100,000.00
12
13	Cash Outflows
14	Website	5,000.00
15	Furniture	1,000.00
16	Equipment	12,500.00
17	Improvements	40,000.00
18	Inventory	10,000.00
19		68,500.00
20
21	Cash Inflows
22	Product Sales		0.00	0.00	0.00	0.00	4,000.00	6,500.00	9,500.00	9,500.00	9,500.00	9,500.00	9,500.00
23	Service Sales		0.00	0.00	2,500.00	5,000.00	7,500.00	10,000.00	10,000.00	15,000.00	15,000.00	15,000.00	15,000.00
24	Total Cash Inflows		0.00	0.00	2,500.00	5,000.00	11,500.00	16,500.00	19,500.00	24,500.00	24,500.00	24,500.00	24,500.00
25
26	Cash Outflows
27	Accounting		350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00
28	Advertising		0.00	0.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00
29	Bank Charges		10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00
30	Bookkeeping		250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00
31	Employee Wages		0.00	0.00	3,000.00	4,500.00	6,000.00	9,000.00	9,000.00	9,000.00	9,000.00	9,000.00	9,000.00
32	Owner Wages		3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00
33	Insurance		1,200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
34	Interest		0.00	60.00	100.00	150.00	150.00	150.00	150.00	150.00	150.00	150.00	150.00
35	Meals and Entertainment		0.00	0.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00
36	Legal		1,200.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
37	Licenses and Fees		100.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
38	Office Supplies		50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00
39	Product Purchases		0.00	0.00	0.00	5,000.00	2,000.00	3,250.00	4,750.00	4,750.00	4,750.00	4,750.00	4,750.00
40	Rent		3,800.00	3,800.00	3,800.00	3,800.00	3,800.00	3,800.00	3,800.00	3,800.00	3,800.00	3,800.00	3,800.00
41	Software		250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00	250.00
42	Telephone		125.00	125.00	125.00	125.00	125.00	125.00	125.00	125.00	125.00	125.00	125.00
43	Travel		500.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00
44	Total Cash Outflows		10,835.00	7,945.00	11,535.00	18,085.00	16,585.00	20,835.00	22,335.00	22,335.00	22,335.00	22,335.00	22,335.00
45
46	Net Cash Inflows (Outflows)	31,500.00	(10,835.00)	(7,945.00)	(9,035.00)	(13,085.00)	(5,085.00)	(4,335.00)	(2,835.00)	2,165.00	2,165.00	2,165.00	2,165.00
47
48	Beginning of Month Cash Balance	0.00	31,500.00	20,665.00	12,720.00	3,685.00	(9,400.00)	(14,485.00)	(18,820.00)	(21,655.00)	(19,490.00)	(17,325.00)	(15,160.00)
49	Total Monthly Cash Flow	31,500.00	(10,835.00)	(7,945.00)	(9,035.00)	(13,085.00)	(5,085.00)	(4,335.00)	(2,835.00)	2,165.00	2,165.00	2,165.00	2,165.00
50	End of Month Cash Balance	31,500.00	20,665.00	12,720.00	3,685.00	(9,400.00)	(14,485.00)	(18,820.00)	(21,655.00)	(19,490.00)	(17,325.00)	(15,160.00)	(12,995.00)
51
52	Total cash needed to get us to July	(21,655.00)
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100