Bank Account/ Cash Flow Forecast TEMPLATE

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1		Type	Monthly?	Currency	Conversion Rate	EUR	Sep '20	Oct '20	Nov '20	Dec '20	Jan '21	Feb '21	Mar '21	Apr '21	May '21	Jun '21	Jul '21	Aug '21
2	Starting Balance			EUR			-342.77	-48.62	345.52	1,739.67	1,833.81	2,182.09	2,430.36	2,778.63	3,126.90	2,475.17	2,823.44	3,079.96

3	Boursorama			EUR	1		-500.00
4	Boursorama Savings			EUR	1		100.00
5	Revolut			GBP	1.135760871		10.00
6	Revolut			USD	0.91749		50.00
7					1
8					1
9					1
10	To add more rows, right click the row number, "Insert 1 above", then copy this row and paste above in the new row				1
11
12	INCOME
13	Salary				1	18,000.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00
14	Bonus				1	1,000.00			1,000.00
15					1	0.00
16					1	0.00
17	To add more rows, right click the row number, "Insert 1 above", then copy this row and paste above in the new row				1	0.00
18	Total Income			EUR		19,000.00	1,500.00	1,500.00	2,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00
19
20	EXPENDITURES
21	Rent	Rent			1	6,000.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00
22					1	0.00
23	Local tax	Tax			1	100.00						100.00
24					1	0.00
25	Phone	Bills			1	239.88	19.99	19.99	19.99	19.99	19.99	19.99	19.99	19.99	19.99	19.99	19.99	19.99
26	Electricity	Bills			1	240.00	20.00	20.00	20.00	20.00	20.00	20.00	20.00	20.00	20.00	20.00	20.00	20.00
27	Spotify	Bills			1	119.88	9.99	9.99	9.99	9.99	9.99	9.99	9.99	9.99	9.99	9.99	9.99	9.99
28					1	0.00
29	Save the Children	Charity			1	120.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00
30					1	0.00
31	Day-to-day	Day-to-day			1	6,000.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00
32					1	100.00	100.00
33	Investing	Investing		USD	0.91749	1,100.99	50.00	50.00	50.00	50.00	100.00	100.00	100.00	100.00	100.00	100.00	200.00	200.00
34					1	0.00
35	Christmas trip	Travel			1	300.00				300.00
36					1	0.00
37	New laptop	Wishes			1	1,000.00									1,000.00
38					1	0.00
39	To add more rows, right click the row number, "Insert 1 above", then copy this row and paste above in the new row				1	0.00
40	Total Expenditures			EUR		15,229.91	1,205.85	1,105.85	1,105.85	1,405.85	1,151.73	1,251.73	1,151.73	1,151.73	2,151.73	1,151.73	1,243.48	1,243.48
41
42	Net Gain			EUR			294.15	394.15	1,394.15	94.15	348.27	248.27	348.27	348.27	-651.73	348.27	256.52	256.52
43
44	Ending Balance			EUR			-48.62	345.52	1,739.67	1,833.81	2,182.09	2,430.36	2,778.63	3,126.90	2,475.17	2,823.44	3,079.96	3,336.48
45	Invested Sum			EUR			0	50.00	100.00	150.00	250.00	350.00	450.00	550.00	650.00	750.00	950.00	1,150.00
46
47	Emergency Fund Planning:
48
49	Amount
50	Min expenditure per month	1,000.00		EUR
51	3 months (min fund target)	3,000.00		EUR
52	6 months (max fund target)	6,000.00		EUR
53
54	Accounts & Currencies	4,603.39		EUR
55	Boursorama Savings	3,000.00		EUR	1	3,000.00
56	Revolut Vault	1,500.00		USD	0.91749	1,376.24
57	Revolut Vault	200.00		GBP	1.135760871	227.15
58					1	0.00
59					1	0.00
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