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

View only
 
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+$0.00x1.0671=$0.00-$0.00=$0.00
16
OCT. 28th2$0.00+$0.00x=$0.00-=$0.00
17
NOV. 4th3$0.00+$0.00x=$0.00-=$0.00
18
NOV. 11th*4$0.00+$0.00x=$0.00-$0.00=$0.00
19
NOV. 18th5$0.00+$500.00x0.9867=$493.35-$0.00=$493.35
20
NOV. 25th*6$493.35+$0.00x1.1803=$582.30-$0.00=$582.30
21
DEC. 2nd7$582.30+x1.0405=$605.88-=$605.88
22
DEC. 9th8$605.88+x1.1418=$691.80-=$691.80
23
DEC. 16th9$691.80+x1.0180=$704.25-=$704.25
24
DEC. 23rd*10$704.25+x1.2034=$847.50-=$847.50
25
DEC. 30th*11$847.50+x1.0431=$884.02-=$884.02
26
JAN. 6th12$884.02+x1.0857=$959.78-=$959.78
27
JAN. 13th13$959.78+x1.0805=$1,037.05-=$1,037.05
28
JAN. 20th14$1,037.05+x0.9972=$1,034.14-=$1,034.14
29
JAN. 27th15$1,034.14+x1.0808=$1,117.70-=$1,117.70
30
FEB. 3rd16$1,117.70+x1.0141=$1,133.40-=$1,133.40
31
FEB. 10th17$1,133.40+x1.1010=$1,247.88-=$1,247.88
32
FEB. 17th*18$1,247.88+x1.0697=$1,334.86-=$1,334.86
33
FEB. 24th19$1,334.86+x1.1100=$1,481.69-=$1,481.69
34
MAR. 3rd20$1,481.69+x1.1644=$1,725.28-=$1,725.28
35
MAR. 10th21$1,725.28+x1.0037=$1,731.66-=$1,731.66
36
MAR. 17th22$1,731.66+x1.1105=$1,923.01-=$1,923.01
37
MAR. 24th23$1,923.01+x1.1284=$2,169.93-=$2,169.93
38
MAR. 31st*24$2,169.93+x0.9767=$2,119.37-=$2,119.37
39
APR. 7th*25$2,119.37+x1.1101=$2,352.71-=$2,352.71
40
APR. 14th26$2,352.71+x1.1402=$2,682.56-=$2,682.56
41
APR. 21st27$2,682.56+x1.0969=$2,942.50-=$2,942.50
42
APR. 28th28$2,942.50+x1.0000=$2,942.50-=$2,942.50
43
MAY 5th*29$2,942.50+x1.1110=$3,269.12-=$3,269.12
44
MAY 12th30$3,269.12+x1.0853=$3,547.97-=$3,547.97
45
MAY 19th31$3,547.97+x1.0483=$3,719.34-=$3,719.34
46
MAY 26th32$3,719.34+x1.1512=$4,281.70-=$4,281.70
47
JUN. 2nd33$4,281.70+x1.1102=$4,753.55-=$4,753.55
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...