Cash flow template - Google Drive

Cash flow template : Cash flow


1	PLEASE MAKE A COPY FOR YOURSELF, The numbers are samples for illustration only
2	Cash Flow 12 months	Fill the yellow background cells only
3	Version 1	Blue background indicates calculations
4		Red in the last row indicates you won't have enough money in the bank that month
5
6	Cash balance at start	5,000		Cash balance at end
7	Cash balance at end	4,800
8
9		2016/01	2016/02	2016/03	2016/04	2016/05	2016/06	2016/07	2016/08	2016/09	2016/10	2016/11	2016/12	Total	Notes
10	Cash in hand (start)	5,000	3,700	3,400	-200	-1,300	-700	100	900	500	1,050	2,300	3,550	4,800	Cash in bank at start of this month
11
12	Income
13	Husband	2,500	0	0	2,500	2,500	2,500	2,500	2,500	2,750	2,750	2,750	2,750	26,000	salary bump in september, no pay feb/march
14	Wife	0	2,500	2,500	2,700	2,700	2,700	2,700	2,700	2,700	2,700	2,700	2,700	29,300	salary bump in march, no pay jan
15	Stocks	0	0	0	0	0	0	0	0	0	0	0	0	0
16	Misc	0	0	0	0	0	0	0	0	0	0	0	0	0
17	Misc 2	0	0	0	0	0	0	0	0	0	0	0	0	0
18	Misc 3	0	0	0	0	0	0	0	0	0	0	0	0	0
19	Misc 4	0	0	0	0	0	0	0	0	0	0	0	0	0
20	Total income	2,500	2,500	2,500	5,200	5,200	5,200	5,200	5,200	5,450	5,450	5,450	5,450	55,300
21	Cash + Income	7,500	6,200	5,900	5,000	3,900	4,500	5,300	6,100	5,950	6,500	7,750	9,000
22
23	Expenses
24	Mortgage	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	19,200
25	Living Expenses	800	800	800	800	800	800	800	800	800	800	800	800	9,600
26	Nanny	0	0	1,600	1,600	1,600	1,600	1,600	1,600	0	0	0	0	9,600	nanny ends aug
27	DayCare	0	0	0	0	0	0	0	0	1,400	1,400	1,400	1,400	5,600	day care starts sep
28	Vacations	0	0	1,200	0	0	0	0	1,200	0	0	0	0	2,400
29	Car insurance	0	0	500	0	0	0	0	0	500	0	0	0	1,000	march and september
30	Property taxes	0	0	0	1,900	0	0	0	0	0	0	0	0	1,900	feb and august
31	Doctor's/Pediatrician	200	0	0	0	200	0	0	0	200	0	0	0	600	estimates
32	Investments/stocks	400	400	400	400	400	400	400	400	400	400	400	400	4,800
33	Credit card payments	800	0	0	0	0	0	0	0	0	0	0	0	800
34	Car repair	0	0	0	0	0	0	0	0	0	0	0	0	0
35	12	0	0	0	0	0	0	0	0	0	0	0	0	0
36	13	0	0	0	0	0	0	0	0	0	0	0	0	0
37	14	0	0	0	0	0	0	0	0	0	0	0	0	0
38	15	0	0	0	0	0	0	0	0	0	0	0	0	0
39	16	0	0	0	0	0	0	0	0	0	0	0	0	0
40	17	0	0	0	0	0	0	0	0	0	0	0	0	0
41	18	0	0	0	0	0	0	0	0	0	0	0	0	0
42	19	0	0	0	0	0	0	0	0	0	0	0	0	0
43	20	0	0	0	0	0	0	0	0	0	0	0	0	0
44	Total expenses	3,800	2,800	6,100	6,300	4,600	4,400	4,400	5,600	4,900	4,200	4,200	4,200	55,500
45	Money in bank (end)	3,700	3,400	-200	-1,300	-700	100	900	500	1,050	2,300	3,550	4,800	4,800	Cash in bank at end of this month
46				ALERT	ALERT	ALERT