Start Early Example (1).xlsx

	A	B	C	D	E	G	H	J	K	L
1	Savings Interest Calculator (© www.niofe.org)
2
3	Savings Variables
4
5			Length of Investment		40	Initial Investment		0
6
7					Annual Tax Rate			Annual Earnings Rates
8			Tax Calculations		Disabled	Annual Earnings Rate		10.00%
9				Income Tax	22%		Interest Rate	Fixed
10							Min Rate	-5.00%
11					Scheduled Deposits		Max Rate	15.00%
12			Deposit Amount (DA)		2,648		Average Rate	10.00%
13			Deposit Frequency (DF)		Monthly		Press F9 to Recalculate
14		Additional Annual Deposits			0	Interest Compounded		Daily
15
16	Savings Growth Summary
17
18		TOTAL				Future Value of Your Savings
19
20		Invested:		1,271,040.00		Value after 40 years:		16,953,352
21
22		Withdrawn:		0.00
23
24
25	Savings Chart
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46					Contributions			Cumulative
47	Year	Rate	Interest	Tax	Scheduled Deposits	Add. Annual Deposits or Withdrawals	Balance	Deposits	Interest	Tax
48
49					0		0	0
50	1	10.00%	1,503.8	0.0	31,776.0		33,279.8	31,776.0	1,503.8	0.0
51	2	10.00%	5,003.4	0.0	31,776.0		70,059.3	63,552.0	6,507.3	0.0
52	3	10.00%	8,871.0	0.0	31,776.0		110,706.2	95,328.0	15,378.2	0.0
53	4	10.00%	13,145.2	0.0	31,776.0		155,627.5	127,104.0	28,523.5	0.0
54	5	10.00%	17,869.0	0.0	31,776.0		205,272.5	158,880.0	46,392.5	0.0
55	6	10.00%	23,089.4	0.0	31,776.0		260,137.9	190,656.0	69,481.9	0.0
56	7	10.00%	28,858.8	0.0	31,776.0		320,772.7	222,432.0	98,340.7	0.0
57	8	10.00%	35,235.0	0.0	31,776.0		387,783.7	254,208.0	133,575.7	0.0
58	9	10.00%	42,281.5	0.0	31,776.0		461,841.2	285,984.0	175,857.2	0.0
59	10	10.00%	50,069.1	0.0	31,776.0		543,686.4	317,760.0	225,926.4	0.0
60	11	10.00%	58,675.6	0.0	31,776.0		634,138.0	349,536.0	284,602.0	0.0
61	12	10.00%	68,187.1	0.0	31,776.0		734,101.1	381,312.0	352,789.1	0.0
62	13	10.00%	78,698.8	0.0	31,776.0		844,575.9	413,088.0	431,487.9	0.0
63	14	10.00%	90,315.9	0.0	31,776.0		966,667.8	444,864.0	521,803.8	0.0
64	15	10.00%	103,154.6	0.0	31,776.0		1,101,598.3	476,640.0	624,958.3	0.0
65	16	10.00%	117,343.3	0.0	31,776.0		1,250,717.6	508,416.0	742,301.6	0.0
66	17	10.00%	133,024.0	0.0	31,776.0		1,415,517.7	540,192.0	875,325.7	0.0
67	18	10.00%	150,353.7	0.0	31,776.0		1,597,647.4	571,968.0	1,025,679.4	0.0
68	19	10.00%	169,505.7	0.0	31,776.0		1,798,929.1	603,744.0	1,195,185.1	0.0
69	20	10.00%	190,671.6	0.0	31,776.0		2,021,376.7	635,520.0	1,385,856.7	0.0
70	21	10.00%	214,063.3	0.0	31,776.0		2,267,216.0	667,296.0	1,599,920.0	0.0
71	22	10.00%	239,914.7	0.0	31,776.0		2,538,906.7	699,072.0	1,839,834.7	0.0
72	23	10.00%	268,484.6	0.0	31,776.0		2,839,167.3	730,848.0	2,108,319.3	0.0
73	24	10.00%	300,058.7	0.0	31,776.0		3,171,002.0	762,624.0	2,408,378.0	0.0
74	25	10.00%	334,953.0	0.0	31,776.0		3,537,731.0	794,400.0	2,743,331.0	0.0
75	26	10.00%	373,516.7	0.0	31,776.0		3,943,023.8	826,176.0	3,116,847.8	0.0
76	27	10.00%	416,135.6	0.0	31,776.0		4,390,935.3	857,952.0	3,532,983.3	0.0
77	28	10.00%	463,236.1	0.0	31,776.0		4,885,947.4	889,728.0	3,996,219.4	0.0
78	29	10.00%	515,289.5	0.0	31,776.0		5,433,012.9	921,504.0	4,511,508.9	0.0
79	30	10.00%	572,816.6	0.0	31,776.0		6,037,605.5	953,280.0	5,084,325.5	0.0
80	31	10.00%	636,393.0	0.0	31,776.0		6,705,774.4	985,056.0	5,720,718.4	0.0
81	32	10.00%	706,654.8	0.0	31,776.0		7,444,205.2	1,016,832.0	6,427,373.2	0.0
82	33	10.00%	784,305.1	0.0	31,776.0		8,260,286.3	1,048,608.0	7,211,678.3	0.0
83	34	10.00%	870,120.7	0.0	31,776.0		9,162,183.0	1,080,384.0	8,081,799.0	0.0
84	35	10.00%	964,960.4	0.0	31,776.0		10,158,919.3	1,112,160.0	9,046,759.3	0.0
85	36	10.00%	1,069,772.9	0.0	31,776.0		11,260,468.3	1,143,936.0	10,116,532.3	0.0
86	37	10.00%	1,185,607.2	0.0	31,776.0		12,477,851.5	1,175,712.0	11,302,139.5	0.0
87	38	10.00%	1,313,622.1	0.0	31,776.0		13,823,249.6	1,207,488.0	12,615,761.6	0.0
88	39	10.00%	1,455,098.5	0.0	31,776.0		15,310,124.0	1,239,264.0	14,070,860.0	0.0
89	40	10.00%	1,611,451.9	0.0	31,776.0		16,953,351.9	1,271,040.0	15,682,311.9	0.0
90	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
91	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
92	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
93	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
94	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
95	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
96	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
97	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
98	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
99	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A
100	#N/A	#N/A	#N/A	#N/A	#N/A		#N/A	#N/A	#N/A	#N/A