Investment and Debt Spreadsheet - Angelica
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLM
1
HTMCV Stewarsdhip Project - Investment Spreadsheet
2
The purpose of this form is to display a student's investment returns in stocks and bonds.
3
4
Students have the choice of selecting a basket of investments:100% stocks 0% bonds
5
NOTES:Interest is compounded weekly to simulate a 35 year working career.75% stocks 25% bonds
6
Returns are calculated by taking the average of 4 random S&P 500 (stocks) and 10 year treasury bonds returns from 1928 - 2014.50% stocks 50% bonds
7
The "*" signifies no school, but investments will still be calculated.25% stocks 75% bonds
8
9
Date
Week
Last week's final balance+
Any new
investment
x
1.00 +
Interest Rate
=Balance-Any
withdrawals
=Final
balance
10
ExampleA\$0.00+\$800.00x1.0520=\$841.60-\$0.00=\$841.60
11
ExampleB\$841.60+\$500.00x1.1232=\$1,506.89-\$0.00=\$1,506.89
12
ExampleC\$1,506.89+\$0.00x0.9622=\$1,449.92-\$0.00=\$1,449.92
13
ExampleD\$1,449.92+\$0.00x1.1172=\$1,619.86-\$300.00=\$1,319.86
14
DateWeekLast week's final balance+
Any new
investment
x
1.00 +
Interest Rate
=Balance-Any
withdrawals
=Final
balance
15
OCT. 21st1\$0.00+\$20.00x1.0671=\$21.34-\$0.00=\$21.34
16
OCT. 28th2\$21.34+\$0.00x1.1669=\$24.90-=\$24.90
17
NOV. 4th3\$24.90+\$70.00x1.1194=\$106.24-\$0.00=\$106.24
18
NOV. 11th*4\$106.24+\$0.00x1.2302=\$130.69-\$0.00=\$130.69
19
NOV. 18th5\$130.69+\$0.00x0.9867=\$128.95-\$0.00=\$128.95
20
NOV. 25th*6\$128.95+\$0.00x1.1803=\$152.20-\$0.00=\$152.20
21
DEC. 2nd7\$152.20+x1.0405=\$158.37-=\$158.37
22
DEC. 9th8\$158.37+x1.1418=\$180.82-=\$180.82
23
DEC. 16th9\$180.82+x1.0108=\$182.78-=\$182.78
24
DEC. 23rd*10\$182.78+x1.2034=\$219.95-=\$219.95
25
DEC. 30th*11\$219.95+x1.0431=\$229.43-=\$229.43
26
JAN. 6th12\$229.43+x1.0857=\$249.10-=\$249.10
27
JAN. 13th13\$249.10+x1.0805=\$269.15-=\$269.15
28
JAN. 20th14\$269.15+x0.9972=\$268.39-=\$268.39
29
JAN. 27th15\$268.39+x1.0818=\$290.35-=\$290.35
30
FEB. 3rd16\$290.35+x1.0141=\$294.44-=\$294.44
31
FEB. 10th17\$294.44+x1.1097=\$326.74-=\$326.74
32
FEB. 17th*18\$326.74+x1.3460=\$439.80-=\$439.80
33
FEB. 24th19\$439.80+x1.1110=\$488.61-=\$488.61
34
MAR. 3rd20\$488.61+x1.1644=\$568.94-=\$568.94
35
MAR. 10th21\$568.94+x1.0044=\$571.45-=\$571.45
36
MAR. 17th22\$571.45+x1.1105=\$634.59-=\$634.59
37
MAR. 24th23\$634.59+x1.1284=\$716.07-=\$716.07
38
MAR. 31st*24\$716.07+x0.9767=\$699.39-=\$699.39
39
APR. 7th*25\$699.39+x1.1101=\$776.39-=\$776.39
40
APR. 14th26\$776.39+x1.1402=\$885.24-=\$885.24
41
APR. 21st27+x=\$0.00-=\$0.00
42
APR. 28th28+x=\$0.00-=\$0.00
43
MAY 5th*29+x=\$0.00-=\$0.00
44
MAY 12th30+x=\$0.00-=\$0.00
45
MAY 19th31+x=\$0.00-=\$0.00
46
MAY 26th32+x=\$0.00-=\$0.00
47
JUN. 2nd33+x=\$0.00-=\$0.00
48
JUN. 9th34+x=\$0.00-=\$0.00
49
JUN. 16th35+x=\$0.00-=\$0.00
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 Loading...