Format Painter BIU- -A- SEE BE Merge & Center ~ ~ % 9 108-98 Explanatory.. Input Linked Cell Note Insert Delete Format Clipboard Font Alignment Cells X v fx =G31-H31 1,000,000.00 Government Bonds Annual Returns 1% Max Wealth 1,037,301.36 Min Wealth 991,868.61 Mean 6% Proportion Invested In Stocks 50% Annual Withdrawl ($Y) 65,000.00 Year Wealth at Numbers 1+ Return on Wealth at End 10 Stocks Invested in Bonds (Normal) Stocks of Year Wealth Simulation - 1,056,868.61 11 65 1,000,000.00 500,000.00 0.23 1.06 1,037,301.36 65,000.00 1 - 882,790.44 Average 987,537.03 66 972,301.36 486, 150.68 486,150.68 0.86 1.04 65,000.00 2 - 1,037,117.26 67 33,012.50 466,506.25 466,506.25 .20 1.06 65,000.00 3 - 1,063,607.65 25th Percentile - 1,051, 184.60 68 898,777.34 149,388.67 0.42 1.07 934,025.55 65,000.00 4 - 1,036,719.90 50th Percentile - 984,811.96 69 869,025.55 434,512.78 434,512.78 0.73 1.07 905,817.83 65,000.00 75th Percentile - 929,380.72 70 840,817.83 420,408.92 420,408.92 0.84 1.04 863,198.56 65,000.00 6 - 989,560.62 95th Percentile - 841,170.90 71 798,198.56 399,099.28 399,099.28 65,000.00 7 - 996,955.39 72 761,165.94 380,582.97 380,582.97 0.73 793,401.04 65,000.00 8 - 1,127,140.22 73 728,401.04 364,200.52 364,200.52 0.62 9 -894,222.51 Q1. Probability 74 684,364.63 342,182.31 342,182.31 1.04 10 - 1,058,144.47 75 636,205.11 318,102.55 1.52 1.09 668,152.80 + 65,000.00 76 603,152.80 301,576.40 301,576.40 0.27 1.05 622,641.18 65,000.00 12 - 1,009,877.94 557,641.18 278,820.59 278,820.59 0.06 1.06 576,800.07 65,000.00 511,800.07 255,900.03 1.43 1.03 522,402.70 65,000.00 977,248.44 457,402.70 228,701.35 1.22 467,837.18 65,000.00 15 - 900,515.90 402,837.18 201,418.59 201,418.59 415,958.79 65,000.00 16 - 937,195.23 65,000.00 17 - 1,079,558.15 146,979.18 146,979.18 1.35 1.03 300,266.56 65,000.00 8 - 973,081.67 235,266.56 117,633.28 1.03 1.04 241,089.34 65,000.00 9 - 933,024.03 176,089.34 88,044.67 88,044.67 0.37 1.07 182,896.87 65,000.00 20 - 1,019,917.98 117,896.87 58,948.44 58,948.44 1.05 1.08 123,265.69 65,000.00 21 - 984,362.82 86 87 58,265.69 29,132.84 29,132.84 65,000.00 22 - 924,471.67 1.34 4,637.21 65,000.00 3 - 990,579.61 88 34,818.60 34,818.60 0.90 71,448.85 65,000.00 89 136,448.85 - 68,224.43 1.22 65,000.00 25 - 1,075,668.79 90 91 207,895.77 - 103,947.88 - 103,947.88 1.54 65,000.00 26 - 920,679.61 283,375.00 - 0.11 1.06 - 292,974.77 27 - 1,133, 155.59 92 357,974.77 - 0.46 65,000.00 28 - 991,912.33 93 437,155.22 - 218,577.61 0.30 1,0/ - 453,748.23 65,000.00 29 - 822,805.95 518,748.23 - 259,374.12 - 0.63 1.07 - 540,168.64 65,000.00 30 - 1,118,883.26 95 605,168.64 - 302,584.32 - 1.01 65,000.00 31 - 1,060,175.03 96 1.05 - 705,592.20 65,000.00 97 385,296.10 - 385,296.10 1.61 1.09 - 809,933.34 65,000.00 33 - 1,090,163.88 98 437,466.67 - 437,466.67 - 0.01 1.06 - 905,438.10 34 - 1,017,548.45 99 970,438.10 485,219.05 485, 219.05 1.29 991,868.61 65,000.00 35 - 985,261.10 100 207,895.77 - 103,947.88 103,947.88 0.88 36 - 1,003,982.53 37 - 926,687.39 38 - 806,043.75 39 - 1,056, 198.51 40 - 923,857.72 41 - 892,156.32 42 - 995,863.59 43 - 1,106,006.19 45 - 1,016,132.38 46 - 1,027,987.34 Sheet1+
