Investment and Debt Spreadsheet - Angelica
 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+$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...