looking for blue values of excel in third pic.

more John Morrow is ten years away from retirement He has accumulated a $100,000 nest egg that he would like to invest for his golden years. Furthermore, he is confident that he can invest $10,000 mo each year until retirement. He is curious about what kind of nest egg he can expect to have accumulated at retirement ten years from now. John plans to split his investments evenly among four investments: a Money Market Fund, a Domestic Stock Fund, a Global Stock Fund, and an Aggressive Growth Fund. Based on past performance, John expects each of these funds to earn a return in each of the upcoming ten years according to the distributions shown in the following table. Fund Distribution Money Market Uniform (Minimum = 2%, Maximum = 5%) Domestic Stock Normal (Mean = 6%, Standard Deviation = 5%) Global Stock Normal (Mean = 8%, Standard Deviation = 10%) Aggressive Growth Normal (Mean = 11%, Standard Deviation = 1696) it Assume that the initial nest egg ($100,000) and the first year's investment ($10,000) are made right now (year) and are split evenly among the four funds (ie, $27,500 in each fund). The returns of each fund are allowed to accumulate (i.e, are re-invested) in the same fund and no redistribution will be done before retirement. Furthermore, nine additional investments of $10,000 will be made and split evenly among the four funds ($2,500 each) at year 1, year 2, ... year 9. A financial advisor has told John that he can retire comfortably if he can accumulate $300,000 by year 10 to supplement his other sources of retirement income. Use a 1000-trial Analytic Solver simulation to estimate each of the following Saving for Retirement Investments Initial Money Market Fund $25,000 Income Fund $25,000 Growth & Income $25,000 Aggressive Growth Fund $25,000 Annual $2,500 $2,500 $2,500 $2,500 Year 0 Money Market Investment $27,500 Money Market Start $27,500 Money Market Return (%) 0.0% Money Market End $27,500 Year 1 $2,500 $30,000 0.0% $30,000 Year 2 $2,500 $32,500 0.0% $32,500 Year 3 $2,500 $35,000 0.0% $35,000 Year 4 $2,500 $37,500 0.0% $37,500 Year 5 $2,500 $40,000 0.0% $40,000 Year 6 $2,500 $42,500 0.0% $42,500 Income Fund Investment $27,500 Income Fund Start $27,500 Income Fund Return (%) #NUM Income Fund End #NUM $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUM! #NUM #NUM Growth & Income Investment Growth & Income Start Growth & Income Return (%) Growth & Income End $27,500 $27.500 #NUMI #NUM! $2,500 #NUMI #NUMI #NUM! $2,500 #NUMI #NUM! #NUMI $2,500 #NUM! #NUMI #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUMI #NUMI #NUM! $2,500 #NUM! #NUM! #NUM! F Aggressive Growth Investment $27.500 Aggressive Growth Start $27,500 Aggressive Growth Retum (%) #NUMI Aggressive Growth End #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUM! #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUM #NUMI #NUMI $2,500 #NUM! #NUMI #NUMI $2,500 #NUMI #NUM #NUMI Year 10 Year 6 $2,500 $42,500 0.0% $42,500 Year 7 $2,500 $45,000 0.0% $45,000 Year 8 $2,500 $47,500 0.0% $47.500 Year 9 $2,500 $50,000 0.0% $50,000 $50,000 Uniform (Min, Max) #NUM! $2,500 #NUM! #NUM! #NUM! $2,500 #NUM! #NUMI #NUM! $2,500 #NUMI #NUM #NUMI $2,500 #NUM! #NUM! #NUM! Normal (Mean, St Dev.) #NUM! $2,500 #NUMI #NUM! #NUM! $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUM! #NUM! #NUMI Normal (Mean, St Dev.) #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUMI #NUM! #NUM $2,500 #NUMI #NUM #NUMI Normal (Mean, St. Dev.) Total Nest Egg Mean(Nest Egg) Std. Dev. (Nest Egg) #NUMI #N/A #N/A more John Morrow is ten years away from retirement He has accumulated a $100,000 nest egg that he would like to invest for his golden years. Furthermore, he is confident that he can invest $10,000 mo each year until retirement. He is curious about what kind of nest egg he can expect to have accumulated at retirement ten years from now. John plans to split his investments evenly among four investments: a Money Market Fund, a Domestic Stock Fund, a Global Stock Fund, and an Aggressive Growth Fund. Based on past performance, John expects each of these funds to earn a return in each of the upcoming ten years according to the distributions shown in the following table. Fund Distribution Money Market Uniform (Minimum = 2%, Maximum = 5%) Domestic Stock Normal (Mean = 6%, Standard Deviation = 5%) Global Stock Normal (Mean = 8%, Standard Deviation = 10%) Aggressive Growth Normal (Mean = 11%, Standard Deviation = 1696) it Assume that the initial nest egg ($100,000) and the first year's investment ($10,000) are made right now (year) and are split evenly among the four funds (ie, $27,500 in each fund). The returns of each fund are allowed to accumulate (i.e, are re-invested) in the same fund and no redistribution will be done before retirement. Furthermore, nine additional investments of $10,000 will be made and split evenly among the four funds ($2,500 each) at year 1, year 2, ... year 9. A financial advisor has told John that he can retire comfortably if he can accumulate $300,000 by year 10 to supplement his other sources of retirement income. Use a 1000-trial Analytic Solver simulation to estimate each of the following Saving for Retirement Investments Initial Money Market Fund $25,000 Income Fund $25,000 Growth & Income $25,000 Aggressive Growth Fund $25,000 Annual $2,500 $2,500 $2,500 $2,500 Year 0 Money Market Investment $27,500 Money Market Start $27,500 Money Market Return (%) 0.0% Money Market End $27,500 Year 1 $2,500 $30,000 0.0% $30,000 Year 2 $2,500 $32,500 0.0% $32,500 Year 3 $2,500 $35,000 0.0% $35,000 Year 4 $2,500 $37,500 0.0% $37,500 Year 5 $2,500 $40,000 0.0% $40,000 Year 6 $2,500 $42,500 0.0% $42,500 Income Fund Investment $27,500 Income Fund Start $27,500 Income Fund Return (%) #NUM Income Fund End #NUM $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUM! #NUM #NUM Growth & Income Investment Growth & Income Start Growth & Income Return (%) Growth & Income End $27,500 $27.500 #NUMI #NUM! $2,500 #NUMI #NUMI #NUM! $2,500 #NUMI #NUM! #NUMI $2,500 #NUM! #NUMI #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUMI #NUMI #NUM! $2,500 #NUM! #NUM! #NUM! F Aggressive Growth Investment $27.500 Aggressive Growth Start $27,500 Aggressive Growth Retum (%) #NUMI Aggressive Growth End #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUM! #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUM #NUMI #NUMI $2,500 #NUM! #NUMI #NUMI $2,500 #NUMI #NUM #NUMI Year 10 Year 6 $2,500 $42,500 0.0% $42,500 Year 7 $2,500 $45,000 0.0% $45,000 Year 8 $2,500 $47,500 0.0% $47.500 Year 9 $2,500 $50,000 0.0% $50,000 $50,000 Uniform (Min, Max) #NUM! $2,500 #NUM! #NUM! #NUM! $2,500 #NUM! #NUMI #NUM! $2,500 #NUMI #NUM #NUMI $2,500 #NUM! #NUM! #NUM! Normal (Mean, St Dev.) #NUM! $2,500 #NUMI #NUM! #NUM! $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUM! #NUM! #NUMI Normal (Mean, St Dev.) #NUMI $2,500 #NUMI #NUMI #NUMI $2,500 #NUMI #NUMI #NUM! $2,500 #NUMI #NUM! #NUM $2,500 #NUMI #NUM #NUMI Normal (Mean, St. Dev.) Total Nest Egg Mean(Nest Egg) Std. Dev. (Nest Egg) #NUMI #N/A #N/A