FI Tracker

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		2012	2012	2012	2012	2012	2012	2012	2012	2012	2012	2012	2012
2		1	2	3	4	5	6	7	8	9	10	11	12
3	Expenses / mo	1,894	1,860	1,775	1,745	1,852	1,660	1,560	1,525	1,520	1,485	1,450	1,615
4	Theo Investment Income / mo	90	93	97	105	107	112	116	121	123	126	131	136
5	Investment Income / mo	50	30	80	100	75	80	60	120	100	130	152	108
6	Avg Investment Income / mo	50	40	55	60	55	65	63	75	80	95	110	100
7	Expenses / day	62.27	61.15	58.36	57.37	60.89	54.58	51.29	50.14	49.97	48.82	47.67	53.10
8	Investment Income / day	1.64	0.99	2.63	3.29	2.47	2.63	1.97	3.95	3.29	4.27	5.00	3.55
9	Savings	24,000	24,800	25,900	28,000	28,650	29,850	31,000	32,150	32,700	33,700	34,900	36,150
10	Projected Annual Savings	22,272	22,680	23,700	24,060	22,776	25,080	26,280	26,700	26,760	27,180	27,600	25,620
11	Savings Needed at SWR	505,067	496,000	473,333	465,333	493,867	442,667	416,000	406,667	405,333	396,000	386,667	430,667
12	Projected Years till FI	21.6	20.8	18.9	18.2	20.4	16.5	14.6	14.0	13.9	13.3	12.7	15.4
13	"Retire Today" ROI	94.70%	90.00%	82.24%	74.79%	77.57%	66.73%	60.39%	56.92%	55.78%	52.88%	49.86%	53.61%
14	% There	4.75%	5.00%	5.47%	6.02%	5.80%	6.74%	7.45%	7.91%	8.07%	8.51%	9.03%	8.39%
15	Simple Months Saved	12.7	13.3	14.6	16.0	15.5	18.0	19.9	21.1	21.5	22.7	24.1	22.4
16	Months Saved with Interest	13.0	13.7	15.0	16.6	16.0	18.6	20.7	22.0	22.5	23.7	25.2	23.4
17
18	Daily Breakdown			To Play Around With
19	Housing	$32.88		SWR		0.045
20	Food	$6.21		Standard of Living Adjust		0
21	Social Life	$2.62		Post-Tax Income		$45,000.00
22	Utilities	$5.62
23	Donation	$1.69
24	Entertainment	$0.47
25	Health	$0.82
26	Medical	$0.40
27	Transport	$1.37
28	Work	$1.51
29	Pets	$0.51
30	Cleaning	$0.33
31	Other	$0.00
32	Clothing	$0.22
33	Total	$54.63
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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