Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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
101
102
103
104

Savings Interest Calculator

This spreadsheet is for illustrative purposes only.

http://www.vertex42.com/Calculators/savings-interest-calculator.html

Results are just estimates. Interests rates vary.

Savings Plan Inputs

Summary of Results

Notes:

- Savings Bonds are usually purchased in denominations

Years to Invest

Estimated Future Value

of $25, $50, $75, $100, $200, $500, $1000, and $5000

Initial Investment

$10,000

Value After 20 Years

$95,580.75

- Taxes on interest earned are not taken into account

Expected Annual Interest Rate

4.00%

Gain / Loss Summary

Scheduled Deposits

Total Invested

$58,000.00

Set Chart Y-Axis to a Fixed Value

Deposit Amount

$200.00

Interest Earned

$37,580.75

When making comparisons using the graph,

Deposit Frequency

Monthly

it helps to set the y-axis on the chart to some

Additional Annual Investments

maximum $ amount. Right-click on the $ axis, select

Format Axis, go to the Scale tab, uncheck the box

next to Maximum, and set the max value.

FALSE

Using Random Rates. If you check the

Min

-4.00%

"Use Random Rates" box, then the Rate column will

Max

10.00%

calculate a random rate between the min and max

Average

4.00%

that you specify. To recalculate, press F9.

(Press F9 to Recalculate)

[42]

Year

Rate

Interest

Scheduled Deposits

Extra Annual
Deposits

Balance

Cumulative Contribution

Cumulative Interest

$10,000

$10,000.00

4.00%

451.91

2,400.00

12,851.91

12,400.00

451.91

4.00%

568.10

2,400.00

15,820.01

14,800.00

1,020.01

4.00%

689.02

2,400.00

18,909.03

17,200.00

1,709.03

4.00%

814.88

2,400.00

22,123.91

19,600.00

2,523.91

4.00%

945.85

2,400.00

25,469.76

22,000.00

3,469.76

4.00%

1,082.17

2,400.00

28,951.93

24,400.00

4,551.93

4.00%

1,224.04

2,400.00

32,575.97

26,800.00

5,775.97

4.00%

1,371.69

2,400.00

36,347.66

29,200.00

7,147.66

4.00%

1,525.35

2,400.00

40,273.01

31,600.00

8,673.01

4.00%

1,685.28

2,400.00

44,358.29

34,000.00

10,358.29

4.00%

1,851.72

2,400.00

48,610.01

36,400.00

12,210.01

4.00%

2,024.94

2,400.00

53,034.94

38,800.00

14,234.94

4.00%

2,205.22

2,400.00

57,640.16

41,200.00

16,440.16

4.00%

2,392.84

2,400.00

62,433.00

43,600.00

18,833.00

4.00%

2,588.11

2,400.00

67,421.11

46,000.00

21,421.11

4.00%

2,791.33

2,400.00

72,612.45

48,400.00

24,212.45

4.00%

3,002.84

2,400.00

78,015.28

50,800.00

27,215.28

4.00%

3,222.96

2,400.00

83,638.24

53,200.00

30,438.24

4.00%

3,452.04

2,400.00

89,490.28

55,600.00

33,890.28

4.00%

3,690.46

2,400.00

95,580.75

58,000.00

37,580.75

#N/A

Savings