(Calculations set to Manual. Press F9 to recalculate).
Year Raise % Salary Saved Return % Prev Balance Balance Input data:
2 0.0% $60,000.00 $6,000.00 4.05% $6,243.22 $12,243.22 Min raise % 0 1 $1,443,741
4 5.0% $64,260.00 $6,426.00 5.28% $20,794.13 $27,220.13 Savings % 10 3 $810,935
6 6.0% $68,796.76 $6,879.68 -0.44% $32,767.18 $39,646.86 Max return % 20 5 $826,413
8 5.0% $78,015.52 $7,801.55 18.84% $60,673.49 $68,475.04 7 $540,286
10 2.0% $83,554.62 $8,355.46 4.16% $78,686.74 $87,042.20 9 $1,136,326
12 7.0% $92,979.58 $9,297.96 7.96% $111,576.33 $120,874.29 11 $695,230
14 6.0% $106,443.03 $10,644.30 2.88% $135,843.69 $146,488.00 13 $1,828,589
16 0.0% $113,894.04 $11,389.40 6.13% $177,278.20 $188,667.60 15 $854,424
18 3.0% $126,695.73 $12,669.57 19.61% $241,936.84 $254,606.41 17 $1,243,531
20 4.0% $139,669.37 $13,966.94 11.52% $331,565.17 $345,532.11 19 $740,133
22 0.0% $142,462.76 $14,246.28 12.30% $475,941.42 $490,187.70 21 $920,401
24 3.0% $154,073.48 $15,407.35 16.74% $598,103.86 $613,511.21 23 $1,251,513
26 6.0% $171,483.78 $17,148.38 5.29% $765,604.75 $782,753.13 25 $974,631
28 7.0% $196,331.78 $19,633.18 11.59% $1,059,484.70 $1,079,117.88 27 $749,796
30 3.0% $218,399.47 $21,839.95 14.91% $1,421,900.62 $1,443,740.57 29 $1,034,362
30 $986,616
Based on 1 replication: 31 $1,004,234
39 $792,331
40 $1,236,747
41 $1,079,284
42 $920,881
43 $1,362,536
44 $987,726
45 $1,082,403
46 $1,196,328
47 $804,892
48 $1,293,231
Data Table
Problem 10-50
59 $1,374,978
60 $916,379
61 $1,177,628
62 $991,537
63 $867,135
74 $610,725
75 $987,417
76 $909,244
77 $1,025,348
78 $1,214,362
89 $1,237,493
90 $896,824
91 $735,169
92 $1,132,446
93 $840,494
104 $844,897
105 $1,115,660
106 $992,730
107 $891,127
108 $1,392,889
119 $988,835
120 $1,028,268
121 $935,648
122 $1,003,618
123 $795,261
134 $1,167,869
135 $862,692
136 $612,884
137 $838,728
138 $1,130,396
149 $1,628,116
150 $998,044
151 $1,084,212
152 $640,894
153 $968,258
164 $1,099,604
165 $710,873
166 $784,315
167 $1,088,513
168 $930,386
179 $762,816
180 $798,074
181 $1,014,457
182 $807,808
183 $1,292,438
194 $792,010
195 $1,099,216
196 $800,912
197 $1,467,436
198 $887,255
Scenario Summary
Current Values: 12 14 16 18 20
Changing Cells:
$J$7 10 12 14 16 18 20
Result Cells: