can someone help me with a-c
theres a better photo
4. RETIREMENT PLAN $$ a. Using the retirement simulation spreadsheet that we created in class (based on file, "Retirement planning sim template," posted on Canvas), set the savings rate to 12.5% (instead of the 10% default value in the original simulation). Simulate 200 30-year careers. b. What percent of the time will the investment portfolio be worth more than $1,100,000? c. What is the probability that the portfolio will be worth less than $750,000? 14 4 of 384 words D Focus insert Delete form 6 % * $ Merge & Center BTU Conditional Format Call Formatting as Table Styles Paste 134 G K 0 Retirement planning - Raise and Returns tables Raise Probat SAP 500 Prob Dist Previous End of Year KE W lelalu WE NE Raise 05 025 15 25 35 45 55 Preb 0097 DOM 0314 0114 0 141 0029 0037 Return 35 -25 -15 5 5 15 25 35 Probe 0.024 0034 0.001 0119 0214 0.262 0.214 0.071 6 3 NY ME NE NE ME NE 6 WUM 10 11 13 13 14 15 96 17 18 13 1.000 SUM. 1.000 S105 SORES End of Year This Year Salary Rase Baturn 60,000 $5.0000 2 $61 X $6.1890 1 1.64 56,3654 4% 4 365564 5 167511 36,2531 4% 569556 7 TL 643 $7543 4% 3 57372 4 5.DOC 57,6006 4% 10 $78,236 11 1065 19 12 563.654 45 13 SAS 546 $8.554 Am 14 S.113 SA AN 13 590395 59.0755 16 99142 5913 AN $32 5282 AN 18 5121 599171 15 $100,346 $10,2140 ON 20 F10 210 IN $10.50 49 21 5100367 2006 22 SASA EL 1615 13 $114 24 AN 5121 IN 51 IN $12.95 3133232 4% $13.727.6 4 0 560000 $6.000 $12 400 $12.4200 519233 519 2012 $26,608 26.6099 $344773 534 4273 542,750,0 $42.7600 $51.6347 $516 5610194 $61.0794 $71 1232 $211232 581,7967 581 1942 $91,1321 1911121 S103 5105128 $117,9233 5113,7395531.4520 1145205145,2857 $145.785251001649 $16,471 1517303175151001 519402111805 3252.005.01 5211 DOT15251001 125L05415272.289 2 3272.282 5.0986724 SIA 2000 5363.2350 5140239.00 $39.1.1 5945271 $17.2077 $27.2477 1504 SE 64 54521516 5452-1516 543010 E w ME NE WE NE ME NE 11 1 23 W SE 28 NG 11 M NE M NE VE SIR NT NE WEETS LES SE VEZ DE SITES SE 10 Wow MacBook Pro Retirement planning - Raise and Returns tables Reise Probe Dist Year Return 1 2 3 4 5 4% 494 4% 494 Raise (s) -03 0.5 15 -25 35 45 55 Prob 0.057 ORG 0314 0.314 0.143 0.029 0.057 om trib... 6 7 4% 4% 4946 4% 4% SUM 1.000 Salary 560,000 $61,800 563.654 565,564 567,531 $69,556 $71.643 $73.792 $76,006 $78,286 $0.635 $83,054 585.546 588,112 590,755 $93.478 $96,282 599,171 $102.146 STOS 210 $108,367 SI11,618 $114,966 S118,415 5121.968 $125,627 S129,195 S133,277 $137,276 $141.394 9 TO 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 End of Year This Year Raise Savings 39 S6,0000 3 56,180,0 3% $6,365.4 3% S6,5564 3% $6,753.1 39 S6,955.6 34% $7,1643 39 573792 390 57.600.6 3% $7,828.6 35 58 0633 39 38 3054 394 $8.554.6 3% S88112 396 59,075.5 396 59,347.8 394 $9.6282 3% 59,917.1 394 $10,214.6 3% SIO 3210 3% $10,836,7 39 $11.161.8 395 $11.4966 39 $11.841.5 3% $12.1968 $12,5627 39 $12.9395 3% 513,327.7 39 $13,7276 39 S14,139.4 4% 4% 4% 49 4% 4% Previous End of Year Balance New Balance 0 $6,000.0 $6,000,0 $12.430,0 $12.420,0 $19.282.2 $19,282.2 $26,6099 $26,6099 $34,4273 $34,427.3 $42.760,0 $42,760,0 $51.614.7 $51.634.7 S61.079.4 $61,079,4 $71.123.2 $71,1232 S81.7967 $81.796,7 $93.132.1 $93.132.1 S105,162.8 $105.162.8 $117.923.9 S1179239 $131.452.0 $131.452.0 S145,785.7 5145.789.71 $160.9649 $160.9649 $177,031.7 $177,031.7 $194,030.1 $194,030,1 S212,005. $212,005.9 $231,007.1 S2310071 $251.084.1 $251,084.1 $272,2892 $272.289 2 $294.6774 $294.6774 $318 06.0 5318,306.0 $34, 235.0 5343.235.0 $369,527.1 $369.527.1 5397,247.7 $397 247.7 $426,465.4 $426,465,4 $457,251.6 5457,2516 $489,6510 44 456 ser 4% 496 4% 4% 4% 4% 494 4% 4%
