# Mathematics Chapter 10 Homework Problem 10-50 Calculations Set Manual Press Recalculate

Type Homework Help
Pages 5
Words 88
Authors Barry Render, Jr. Ralph M. Stair, Nagraj Balakrishnan

### Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
(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:

## Trusted by Thousands ofStudents

Here are what students say about us.