Investment and Debt Spreadsheet - Joshua
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+\$500.00x1.0671=\$533.55-\$0.00=\$533.55
16
OCT. 28th2\$533.55+\$0.00x1.1669=\$622.60-\$0.00=\$622.60
17
NOV. 4th3\$622.60+\$0.00x1.1194=\$696.94-\$0.00=\$696.94
18
NOV. 11th*4\$696.94+\$0.00x1.2302=\$857.37-\$0.00=\$857.37
19
NOV. 18th5\$857.37+\$0.00x0.9867=\$845.97-\$0.00=\$845.97
20
NOV. 25th*6\$845.97+\$0.00x1.1803=\$998.50-\$0.00=\$998.50
21
DEC. 2nd7\$998.50+\$0.00x1.0405=\$1,038.94-\$0.00=\$1,038.94
22
DEC. 9th8\$1,038.94+\$0.00x1.1418=\$1,186.26-\$0.00=\$1,186.26
23
DEC. 16th9\$1,186.26+\$0.00x1.0108=\$1,199.07-\$0.00=\$1,199.07
24
DEC. 23rd*10\$1,199.07+\$0.00x1.2034=\$1,442.96-\$0.00=\$1,442.96
25
DEC. 30th*11\$1,442.96+\$0.00x1.0431=\$1,505.15-\$0.00=\$1,505.15
26
JAN. 6th12\$1,505.15+\$0.00x1.0857=\$1,634.14-\$0.00=\$1,634.14
27
JAN. 13th13\$1,634.14+\$0.00x1.0805=\$1,765.69-\$0.00=\$1,765.69
28
JAN. 20th14\$1,765.69+x=\$0.00-=\$0.00
29
JAN. 27th15+x=\$0.00-=\$0.00
30
FEB. 3rd16+x=\$0.00-=\$0.00
31
FEB. 10th17+x=\$0.00-=\$0.00
32
FEB. 17th*18+x=\$0.00-=\$0.00
33
FEB. 24th19+x=\$0.00-=\$0.00
34
MAR. 3rd20+x=\$0.00-=\$0.00
35
MAR. 10th21+x=\$0.00-=\$0.00
36
MAR. 17th22+x=\$0.00-=\$0.00
37
MAR. 24th23+x=\$0.00-=\$0.00
38
MAR. 31st*24+x=\$0.00-=\$0.00
39
APR. 7th*25+x=\$0.00-=\$0.00
40
APR. 14th26+x=\$0.00-=\$0.00
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...