Investment and Debt Spreadsheet - Nathan
 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+$600.00x1.0922=$655.32-$0.00=$655.32
16
OCT. 28th2$655.32+$0.00x1.2375=$810.96-$0.00=$810.96
17
NOV. 4th3$810.96+$0.00x1.1278=$914.60-$0.00=$914.60
18
NOV. 11th*4$914.60+$0.00x1.2838=$1,174.16-$0.00=$1,174.16
19
NOV. 18th5$1,174.16+$0.00x0.9880=$1,160.07-$0.00=$1,160.07
20
NOV. 25th*6$1,160.07+$0.00x1.2025=$1,394.99-$0.00=$1,394.99
21
DEC. 2nd7$1,394.99+$0.00x1.0479=$1,461.81-$0.00=$1,461.81
22
DEC. 9th8$1,461.81+$0.00x1.1638=$1,701.25-$0.00=$1,701.25
23
DEC. 16th9$1,701.25+$0.00x1.0012=$1,703.29-$0.00=$1,703.29
24
DEC. 23rd*10$1,703.29+$0.00x1.2564=$2,140.02-$0.00=$2,140.02
25
DEC. 30th*11$2,140.02+$0.00x1.0426=$2,231.18-$0.00=$2,231.18
26
JAN. 6th12$2,231.18+$0.00x1.1109=$2,478.62-$0.00=$2,478.62
27
JAN. 13th13$2,478.62+$0.00x1.1000=$2,726.48-$0.00=$2,726.48
28
JAN. 20th14$2,726.48+$0.00x0.9499=$2,589.88-$0.00=$2,589.88
29
JAN. 27th15$2,589.88+$0.00x1.0997=$2,848.10-$0.00=$2,848.10
30
FEB. 3rd16$2,848.10+$0.00x1.0146=$2,889.68-$0.00=$2,889.68
31
FEB. 10th17$2,889.68+$0.00x1.1408=$3,296.54-$0.00=$3,296.54
32
FEB. 17th*18$3,296.54+$0.00x1.1096=$3,657.85-$0.00=$3,657.85
33
FEB. 24th19$3,657.85+$0.00x1.1352=$4,152.39-$0.00=$4,152.39
34
MAR. 3rd20$4,152.39+$0.00x1.2157=$5,048.06-$0.00=$5,048.06
35
MAR. 10th21$5,048.06+$0.00x1.0037=$5,066.73-$0.00=$5,066.73
36
MAR. 17th22$5,066.73+$0.00x1.1188=$5,668.66-$0.00=$5,668.66
37
MAR. 24th23$5,668.66+$0.00x1.1706=$6,635.74-$0.00=$6,635.74
38
MAR. 31st*24$6,635.74+$0.00x0.9621=$6,384.24-$0.00=$6,384.24
39
APR. 7th*25$6,384.24+$0.00x1.1332=$7,234.62-$0.00=$7,234.62
40
APR. 14th26$7,234.62+$0.00x1.1952=$8,646.82-$0.00=$8,646.82
41
APR. 21st27$8,646.82+$0.00x1.1544=$9,981.89-$0.00=$9,981.89
42
APR. 28th28$9,981.89+$0.00x1.1260=$11,239.61-$0.00=$11,239.61
43
MAY 5th*29$11,239.61+$0.00x1.1780=$13,240.26-$0.00=$13,240.26
44
MAY 12th30$13,240.26+$0.00x1.0738=$14,217.39-$0.00=$14,217.39
45
MAY 19th31$14,217.39+$0.00x1.0503=$14,932.52-$0.00=$14,932.52
46
MAY 26th32$14,932.52+$0.00x1.2004=$17,925.00-$0.00=$17,925.00
47
JUN. 2nd33$17,925.00+x=$0.00-=$0.00
48
JUN. 9th34$0.00+x=$0.00-=$0.00
49
JUN. 16th35$0.00+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...