Net Worth and Financial Independence Tracker v1.41

	A	B	C	D	E	F	G	H	I	J	K	L
1	Please do not request edit access. Make a copy by clicking File > Make a copy. New version available via https://sites.google.com/view/financialindependencesheet/home
2	Include Equity?	TRUE
3	Use Budget?	TRUE
4	Withdrawl Rate %	4.00%
5	Return Rate %	7.00%
6	Reference Year	2018
7	Avg. Local Tax	24%
8	Annual Savings	197,585
9	Est. Anual Requirement	82,063
10	Total NW (+/- Equity)	117,318
11	FI Number	2,051,580
12
13	Total Networth inc. Equity	1,064,713	404,499
14	500K NW	212.94%
15	750K NW	141.96%
16	1M NW	106.47%
17	1.25M NW	85.18%
18	1.5M NW	70.98%
19	1.75M NW	60.84%
20	2M NW	53.24%
21	% to FI	51.90%
22	Current yrs of expenses	12.97
23	Years to FI	3.23
24	Yearly SWR (4%)	42,588.52
25
26	Total Invested excl. Equity	516,305	(99,047)
27	500K NW	103.26%
28	625K NW	82.61%
29	750K NW	68.84%
30	875K NW	59.01%
31	1M NW	51.63%
32	1.25M NW	41.30%
33	1.5M NW	34.42%
34	1.75M NW	29.50%
35	2M NW	25.82%
36	% to FI	25.17%
37	Current yrs of expenses	6.29
38	Years to FI	5.40
39	Yearly SWR (4%)	20,652.21
40
41	ETF / Stocks / Pension	48.49%
42	Home equity	51.67%
43	Cash	4.21%
44
45	Expenses covered by Investments
46	Home / Personal Insurance	1,889	Covered	23,845
47	Water / Council service	127	Covered	21,955
48	Electric	0	Covered	23,718
49	Mobile	0	Covered	23,845
50	Misc	339	Covered	23,845
51	Internet / TV	1,200	Covered	23,506
52	Transportation	4,908	Covered	22,645
53	Food & Groceries	5,564	Covered	18,936
54	Health Insurance	6,000	Covered	18,281
55	Child est.	1,224	Covered	17,845
56	Rent	30,000	Needed: 184472.586666667	22,621
57
58	Year start	Year end	Year	Total Income	Total Expenses	Net Income	Savings Rate	Necessary Total	Discretionary Total	Excess Total	Net Worth	Net Worth Growth
59	1/1/2015	12/1/2015	2015	-	-	-	-%	-	-	-	25,859	-
60	1/1/2016	12/1/2016	2016	234,219	89,283	144,936	61.88%	69,493	11,262	8,528	275,490	249,631
61	1/1/2017	12/1/2017	2017	259,609	87,921	171,688	66.13%	68,897	10,477	8,547	435,595	160,105
62	1/1/2018	12/1/2018	2018	284,713	87,128	197,585	69.40%	69,362	10,041	7,725	660,214	224,620
63	1/1/2019	12/1/2019	2019	0	0	0	#DIV/0!	0	0	0
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