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