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			-345.18	-48.31	348.56	1,745.44	1,842.31	2,196.04	2,449.77	2,803.49	3,157.22	2,510.95	2,864.67	3,132.11

3	Boursorama			EUR	1		-500.00
4	Boursorama Savings			EUR	1		100.00
5	Revolut			GBP	1.167095		10.00
6	Revolut			USD	0.86293		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.86293	1,035.52	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,113.34	1,203.13	1,103.13	1,103.13	1,403.13	1,146.27	1,246.27	1,146.27	1,146.27	2,146.27	1,146.27	1,232.57	1,232.57
41
42	Net Gain			EUR			296.87	396.87	1,396.87	96.87	353.73	253.73	353.73	353.73	-646.27	353.73	267.43	267.43
43
44	Ending Balance			EUR			-48.31	348.56	1,745.44	1,842.31	2,196.04	2,449.77	2,803.49	3,157.22	2,510.95	2,864.67	3,132.11	3,399.54
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,527.81		EUR
55	Boursorama Savings	3,000.00		EUR	1	3,000.00
56	Revolut Vault	1,500.00		USD	0.86293	1,294.40
57	Revolut Vault	200.00		GBP	1.167095	233.42
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