Using the retirement simulation spreadsheet:

set the savings rate to 12.5% (instead of the 10% default value in the original simulation). Simulate 200 30-year careers. What percent of the time will the investment portfolio be worth more than $1,300,000?

Retirement planning starting point - fixed raises and rate of return. 4 End ofThis Year Previous End of Year Year Salar YearSavings Return Balance New $6,000.0 | $60,000| 800| | $63,654| | $65,564| | $67,531 | |$69,556| | $71,643 | | $73,792 | | $76,006| | $78,286 | | $80,635| | $83,054| | $85,546| | $88,112| | $90,755| | $93,478| | $96,282| | $99,171| |$102,146| |$105,210| |$108,367| |$111,618| |$114,966| |$118,415| |$121,968| |$125,627| |$129,395| |$133,277| |$137,276| |$141,394| | $6,000.01 | $6,180.01 | $6,365.4| | $6,556.4 | | $6,753.1 | | $6,955.6| | $7,164.3 | | $7,379.2 | | $7,600.6| | $7,828.6 | | $8,063.5| | $8,305.4| | $8,554.6| | $8,811.2| | $9,075.5| | $9,347.8| | $9,6282| | $9,917.1| |$10.2146| |$10,521.0| |$10,836.7| |$11,161.8| |$11,4966| |$11,8415| |$12,1968| |$12,562.7| |$12,939.5| |$13,327 |$13,727.6| |$14,139.4| | 3% 3% 3% 3% 396 3% 396 396 3% 396 396 396 3% 3% 3% 3% 3% 396 3% 3% 3% 396 396 3% 396 396 3% 396 396 396 4% 4% 4% 496 496 4% 496 496 496 496 496 496 4% 496 496 4% 4% 4% 496 4% 496 4% 4% 4% 4% 496 4% 4% 4% 496 0 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 $6,000.0 $12,420.0 | $12,420.0| $19,282.2 | $19,282.2 | $26,609.9 | $26,609.9 | $34,427.3 | $34,427.31 $42,760.0 | $42,760.0 | $51,634.7 | $51,634.7 | $61,079.4 | $61,079.4| $71,123.2 | $71,123.2 | $81,796.7 | $81,796.71 $93,132.1 | $93,132.1 | $105,162.8 | $105,162.8| $117,923.9 |$117,923.91 s131,452.0 | $131,452.0|$145,785.7 | $145,785.7| $160,964.9 | $160,9649|$177,031.7 | $177,031.7| $194,030.1 |$194,030.11 $212,005.9 |$212,005.9| $231,007.1 |$231,007.1| $251,084.1 |$251,084.1|$272,289.2 |$272,289.2|$294,6774 |$294,677.4| $318,306.0 |$318,306.0|$343,235.0 |$343,235.0|$369,527.1 |$369,527.11$397,247.7 |$397,247.7|$426,465.4 |$426,465.4|$457,251.6 |$457,251.6 $489,681.0 10 16 18 19 20 25 26 28 29 30 35 36 38 39 40 42 Fixed With tables +