I need help filling this out and with the questions besides #1

1 Time 2. 3 4 5 6 7 8 9 10 11 12 B SASMX US Equity FKASX US Equity DFFVX US Equity FDVLX US Equity IALAX US Equity 12/31/2010 25.2371 31.608 29.0133 22.2655 12/30/2011 0.5242 - 14.1775 -6.2913 -6.7133 12/31/2012 18.8942 21.271 19.188 21.9033 12/31/2013 45.0495 40.3497 43.0255 37.0721 12/31/2014 3.2894 5.6597 2.9407 11.7165 12/31/2015 -4.8335 4.9788 -5.7211 -6.5085 12/30/2016 5.7551 5.7661 26.8639 16.0607 12/29/2017 24.9518 37.8789 9.5895 15.6698 12/31/2018 4.1634 6.8762 - 15.7801 - 17.3445 12/31/2019 25.2227 33.9749 21.4727 31.6209 G OHYFX US Equity 27.6206 -5.7054 14.665 48.2163 5.6951 11.556 -3.0794 43.8917 6.6786 21.5863 FSPHX US Equity 14.6693 16.9641 2.6493 7.8207 14.8077 21.3887 6.9427 56.2688 2.6666 32.8808 -4.5417 6.5704 13.748 -10.6754 6.6536 24.0154 -2.8552 7.4384 13.4669 31.4595 E 1 FDVLX US Equity IALAX US Equity 2 22.2655 3 -6.7133 4 21.9033 5 37.0721 6 11.7165 7 -6.5085 8 16.0607 9 15.6698 10 -17.3445 11 31.6209 12 G OHYFX US Equity 27.6206 -5.7054 14.665 48.2163 5.6951 11.556 -3.0794 43.8917 6.6786 21.5863 H FSPHX US Equity VEIPX US Equity MKHCX US Equity 14.6693 16.9641 14.8813 2.6493 7.8207 10.6049 14.8077 21.3887 13.4867 6.9427 56.2688 30.0713 2.6666 32.8808 11.2898 -4.5417 6.5704 0.7739 13.748 -10.6754 14.7004 6.6536 24.0154 18.3841 -2.8552 7.4384 -5.716 13.4669 31.4595 25.2163 TRMCX US Equity 11.1204 16.4545 4.9597 -4.8193 12.1919 19.6292 5.3175 31.5357 0.4891 10.6031 -2.5213 -3.4111 14.5746 24.3248 5.6863 11.6415 -2.5608 -10.6062 11.6765 19.6133 B D E G H 13 Descriptive Statistics 14 SASMX US Equity FKASX US Equity DFFVX US Equity 15 IALAX US Equity VEI FDVLX US Equity OHYFX US Equity FSPHX US Equity 14.82539 16 Average 17.41858 12.43011 12.57425 17.11248 6.82072 19,41314 17 Variance 216.9127228 297.3007194 312.0743417 279.7637064 301.9464606 47.49792564 306.3949034 18 Stdev 14.72795718 17.24241049 17.66562599 16.72613842 17.3766067 6.891873885 17.50413961 19 Geo 20 Beta 21 22 Correlation 23 24 SASMX US Equity FKASX US Equity DFFVX US Equity FDVLX US Equity IALAX US Equity OHYFX US Equity FSPHX US Equity VEI 25 SASMC US Equity 1 26 FKASX US Equity 1 27 DFFVX US Equity 1 28 FDVLX US Equity 1 1 29 IALAX US Equity 1 30 OHYFX US Equity 1 31 FSPHX US Equity 32 VEIPX US Equity 33 MKHCS US Equity 34 TRMCX US Equity 35 L M E H 13 14 15 FDVLX US Equity IALAX US Equity OHYFX US Equity FSPHX US Equity VEIPX US Equity MKHCX US Equity TRMCX US Equity 16 12.57425 17.11248 6.82072 19.41314 13.36927 6.09339 11.49655 17 279.7637064 301.9464606 47.49792564 306.3949034 98.33871909 34.81336294 170.0530236 18 16.72613842 17.3766067 6.891873885 17.50413961 9.916588077 5.900284988 13.04043802 19 20 21 22 23 24 FDVLX US Equity IALAX US Equity OHYFX US Equity FSPHX US Equity VEIPX US Equity MKHCX US Equity TRMCX US Equity 25 26 27 28 1 29 1 30 1 31 1 32 1 33 1 34 1 35 AGE 2 Eine Bowman D Page Layout Formula Data Com Review View wa Ama AF Margins Orientation Se Break Badground Tiles Forward Bada Pure CB PSEUS MOUSE 7/2010 C D DIPVX USB -56 21271 25.171 0.530 564545 FONLEUSE 2013 1918 GHEXUS Route -3.7054 12/31/2012 0.0013 31 7/2014 C 31. CE 1 7 SHOTS 1100/0/ 11.5 . 25 145 4511 2. ISES IS MET 56. -306754 FY 100 5.18 9 10 11 12 /1/2019 156 14 15 CHEXUS SAIMUSED FEATUSE DEPVX Sty 23:12722 3.SI 14.72727 173040 17. INSTE MEN 12 PAUSE 60012 42. 6.87 1 170.05.2008 19 G FALUSE MORXUS 24 25 IMUS ASUS Equity 22 ONTV 11 Equity 12 VERSE 33 MOSUS Sheet! Type here to search O 11/2000 Share Com AG 2 Dew Page Layout Formula Data Review View Help wa Ama Margins Orion Se Bras Badground Ties Forward Bawa Pune 3 SAVUS D 23 22 Completion IM HALUS DIVX y FOL CHEXUS PAUSE May 25 IASI RASKUS OSTIKUS 19 Equity 33 MOSS THMIKUS re FOLK May 40 MM 42 OSTVU ROVK SEY 45 42 YER 40 MOUSEquity TIMES 33 WIM DIVUL CH Type here to search E 7MM 11/2000 Kayline Com AG 2 D Page Layout Formula Data Review View Help wa Ama AF Margins Orion Se Bras Badground Ties Bea Forward Bada Pure Sheet 3 SASKUS D 33 DRIVIRUS O Buy w 5 60 Come 65 Sale 6 71 34 75 11 . Type here to search O E c 11/2000 Background: You are acting as a consultant to an individual who is 45 years old, in good health, and has plans to retire in 15 years. Your client is a manager at the local office of a large multinational corporation. Her salary and incentive compensation are currently $225,000 per year. Although she and her family live well, she has been modest in her expenditures and managed to accumulate a portfolio valued at $1 million during her 12 years at the firm. Her current salary affords her an opportunity to continue adding to her portfolio, however, she plans to direct her disposable funds to a vacation home near Hilton Head, SC rather than continuing to accumulate funds in her portfolio. This will allow her to pay off the mortgage on the home at Hilton Head and be debt-free by the time she retires. She is the primary source of funds for her family and her children will be finished with college and established as independent adults at the time of her retirement. She needs her current portfolio to grow in value over the next 15 years such that she has at least $2 million at that time to generate income for her future. Assignment: Your client does not have the time to analyze individual companies for stock investments and prefers mutual funds. She is looking at 10 mutual funds for consideration and has plans to place $100,000 in each of these 10. You will analyze the 10 funds that your client is considering and prepare a report for her consideration. Your report should include the following: a W Paragraph Styles 2 - 3 - 4 - 5 Assignment: Your client does not have the time to analyze individual companies for stock investments and prefers mutual funds. She is looking at 10 mutual funds for consideration and has plans to place $100,000 in each of these 10. You will analyze the 10 funds that your client is considering and prepare a report for her consideration. Your report should include the following: 1. A description of each of the 10 mutual funds to include, investment objective, inception date, minimum investment, fund family, fund manager(s), how long the manager(s) has been in place, annual turnover of the fund, fees (front, back, management fee, 126-1). Explain what each of these terms means in simple terms. (5 points) 2. Descriptive statistics for each of the 10 mutual funds to include, average return over the past - 10 years, standard deviation of returns (population), correlation among the 10 funds over the 10 year period, covariance of the 10 inds over the 10 year period. Explain what each of these terms means in simple terms. (10 points) 3. Analysis of the nave portfolio with 1/10th invested in each of the 10 funds. This analysis should include return, variance, and standard deviation of this equally-weighted portfolio. Calculate the Sharpe ratio for this portfolio assuming a risk-free rate of three percent. Does this portfolio perform better than the individual funds? If yes, why? If no, why not? Explain what each of these terms means in simple terms. (10 points) i a what 4. Determination of the optimized portfolio with the return, variance, standard deviation and Sharpe ratio for this portfolio. Explain the difference between the Sharpe ratio you find in the optimized portfolio relative to the equally-weighted portfolio in part three above. Does this portfolio perform better than the individual funds? If yes, why? If no, why not? Explain what each of these terms means in simple terms. (10 points) 5. Determination of the complete portfolio (Risky is based on the 10 mutual funds and Risk-free is based on an allocation to the security yielding three percent used in part three above). How will you determine the level of risk aversion for this client given the information presented in the Background section above? Explain what each of these terms means in simple terms. (10 points) 6. Concluding recommendation with allocations to the 10 mutual funds and to cash with considerations for potential risks to your suggested allocation. Explain what each of these terms means in simple terms. (5 points) What You'll Turn In 1 a 1 Time 2. 3 4 5 6 7 8 9 10 11 12 B SASMX US Equity FKASX US Equity DFFVX US Equity FDVLX US Equity IALAX US Equity 12/31/2010 25.2371 31.608 29.0133 22.2655 12/30/2011 0.5242 - 14.1775 -6.2913 -6.7133 12/31/2012 18.8942 21.271 19.188 21.9033 12/31/2013 45.0495 40.3497 43.0255 37.0721 12/31/2014 3.2894 5.6597 2.9407 11.7165 12/31/2015 -4.8335 4.9788 -5.7211 -6.5085 12/30/2016 5.7551 5.7661 26.8639 16.0607 12/29/2017 24.9518 37.8789 9.5895 15.6698 12/31/2018 4.1634 6.8762 - 15.7801 - 17.3445 12/31/2019 25.2227 33.9749 21.4727 31.6209 G OHYFX US Equity 27.6206 -5.7054 14.665 48.2163 5.6951 11.556 -3.0794 43.8917 6.6786 21.5863 FSPHX US Equity 14.6693 16.9641 2.6493 7.8207 14.8077 21.3887 6.9427 56.2688 2.6666 32.8808 -4.5417 6.5704 13.748 -10.6754 6.6536 24.0154 -2.8552 7.4384 13.4669 31.4595 E 1 FDVLX US Equity IALAX US Equity 2 22.2655 3 -6.7133 4 21.9033 5 37.0721 6 11.7165 7 -6.5085 8 16.0607 9 15.6698 10 -17.3445 11 31.6209 12 G OHYFX US Equity 27.6206 -5.7054 14.665 48.2163 5.6951 11.556 -3.0794 43.8917 6.6786 21.5863 H FSPHX US Equity VEIPX US Equity MKHCX US Equity 14.6693 16.9641 14.8813 2.6493 7.8207 10.6049 14.8077 21.3887 13.4867 6.9427 56.2688 30.0713 2.6666 32.8808 11.2898 -4.5417 6.5704 0.7739 13.748 -10.6754 14.7004 6.6536 24.0154 18.3841 -2.8552 7.4384 -5.716 13.4669 31.4595 25.2163 TRMCX US Equity 11.1204 16.4545 4.9597 -4.8193 12.1919 19.6292 5.3175 31.5357 0.4891 10.6031 -2.5213 -3.4111 14.5746 24.3248 5.6863 11.6415 -2.5608 -10.6062 11.6765 19.6133 B D E G H 13 Descriptive Statistics 14 SASMX US Equity FKASX US Equity DFFVX US Equity 15 IALAX US Equity VEI FDVLX US Equity OHYFX US Equity FSPHX US Equity 14.82539 16 Average 17.41858 12.43011 12.57425 17.11248 6.82072 19,41314 17 Variance 216.9127228 297.3007194 312.0743417 279.7637064 301.9464606 47.49792564 306.3949034 18 Stdev 14.72795718 17.24241049 17.66562599 16.72613842 17.3766067 6.891873885 17.50413961 19 Geo 20 Beta 21 22 Correlation 23 24 SASMX US Equity FKASX US Equity DFFVX US Equity FDVLX US Equity IALAX US Equity OHYFX US Equity FSPHX US Equity VEI 25 SASMC US Equity 1 26 FKASX US Equity 1 27 DFFVX US Equity 1 28 FDVLX US Equity 1 1 29 IALAX US Equity 1 30 OHYFX US Equity 1 31 FSPHX US Equity 32 VEIPX US Equity 33 MKHCS US Equity 34 TRMCX US Equity 35 L M E H 13 14 15 FDVLX US Equity IALAX US Equity OHYFX US Equity FSPHX US Equity VEIPX US Equity MKHCX US Equity TRMCX US Equity 16 12.57425 17.11248 6.82072 19.41314 13.36927 6.09339 11.49655 17 279.7637064 301.9464606 47.49792564 306.3949034 98.33871909 34.81336294 170.0530236 18 16.72613842 17.3766067 6.891873885 17.50413961 9.916588077 5.900284988 13.04043802 19 20 21 22 23 24 FDVLX US Equity IALAX US Equity OHYFX US Equity FSPHX US Equity VEIPX US Equity MKHCX US Equity TRMCX US Equity 25 26 27 28 1 29 1 30 1 31 1 32 1 33 1 34 1 35 AGE 2 Eine Bowman D Page Layout Formula Data Com Review View wa Ama AF Margins Orientation Se Break Badground Tiles Forward Bada Pure CB PSEUS MOUSE 7/2010 C D DIPVX USB -56 21271 25.171 0.530 564545 FONLEUSE 2013 1918 GHEXUS Route -3.7054 12/31/2012 0.0013 31 7/2014 C 31. CE 1 7 SHOTS 1100/0/ 11.5 . 25 145 4511 2. ISES IS MET 56. -306754 FY 100 5.18 9 10 11 12 /1/2019 156 14 15 CHEXUS SAIMUSED FEATUSE DEPVX Sty 23:12722 3.SI 14.72727 173040 17. INSTE MEN 12 PAUSE 60012 42. 6.87 1 170.05.2008 19 G FALUSE MORXUS 24 25 IMUS ASUS Equity 22 ONTV 11 Equity 12 VERSE 33 MOSUS Sheet! Type here to search O 11/2000 Share Com AG 2 Dew Page Layout Formula Data Review View Help wa Ama Margins Orion Se Bras Badground Ties Forward Bawa Pune 3 SAVUS D 23 22 Completion IM HALUS DIVX y FOL CHEXUS PAUSE May 25 IASI RASKUS OSTIKUS 19 Equity 33 MOSS THMIKUS re FOLK May 40 MM 42 OSTVU ROVK SEY 45 42 YER 40 MOUSEquity TIMES 33 WIM DIVUL CH Type here to search E 7MM 11/2000 Kayline Com AG 2 D Page Layout Formula Data Review View Help wa Ama AF Margins Orion Se Bras Badground Ties Bea Forward Bada Pure Sheet 3 SASKUS D 33 DRIVIRUS O Buy w 5 60 Come 65 Sale 6 71 34 75 11 . Type here to search O E c 11/2000 Background: You are acting as a consultant to an individual who is 45 years old, in good health, and has plans to retire in 15 years. Your client is a manager at the local office of a large multinational corporation. Her salary and incentive compensation are currently $225,000 per year. Although she and her family live well, she has been modest in her expenditures and managed to accumulate a portfolio valued at $1 million during her 12 years at the firm. Her current salary affords her an opportunity to continue adding to her portfolio, however, she plans to direct her disposable funds to a vacation home near Hilton Head, SC rather than continuing to accumulate funds in her portfolio. This will allow her to pay off the mortgage on the home at Hilton Head and be debt-free by the time she retires. She is the primary source of funds for her family and her children will be finished with college and established as independent adults at the time of her retirement. She needs her current portfolio to grow in value over the next 15 years such that she has at least $2 million at that time to generate income for her future. Assignment: Your client does not have the time to analyze individual companies for stock investments and prefers mutual funds. She is looking at 10 mutual funds for consideration and has plans to place $100,000 in each of these 10. You will analyze the 10 funds that your client is considering and prepare a report for her consideration. Your report should include the following: a W Paragraph Styles 2 - 3 - 4 - 5 Assignment: Your client does not have the time to analyze individual companies for stock investments and prefers mutual funds. She is looking at 10 mutual funds for consideration and has plans to place $100,000 in each of these 10. You will analyze the 10 funds that your client is considering and prepare a report for her consideration. Your report should include the following: 1. A description of each of the 10 mutual funds to include, investment objective, inception date, minimum investment, fund family, fund manager(s), how long the manager(s) has been in place, annual turnover of the fund, fees (front, back, management fee, 126-1). Explain what each of these terms means in simple terms. (5 points) 2. Descriptive statistics for each of the 10 mutual funds to include, average return over the past - 10 years, standard deviation of returns (population), correlation among the 10 funds over the 10 year period, covariance of the 10 inds over the 10 year period. Explain what each of these terms means in simple terms. (10 points) 3. Analysis of the nave portfolio with 1/10th invested in each of the 10 funds. This analysis should include return, variance, and standard deviation of this equally-weighted portfolio. Calculate the Sharpe ratio for this portfolio assuming a risk-free rate of three percent. Does this portfolio perform better than the individual funds? If yes, why? If no, why not? Explain what each of these terms means in simple terms. (10 points) i a what 4. Determination of the optimized portfolio with the return, variance, standard deviation and Sharpe ratio for this portfolio. Explain the difference between the Sharpe ratio you find in the optimized portfolio relative to the equally-weighted portfolio in part three above. Does this portfolio perform better than the individual funds? If yes, why? If no, why not? Explain what each of these terms means in simple terms. (10 points) 5. Determination of the complete portfolio (Risky is based on the 10 mutual funds and Risk-free is based on an allocation to the security yielding three percent used in part three above). How will you determine the level of risk aversion for this client given the information presented in the Background section above? Explain what each of these terms means in simple terms. (10 points) 6. Concluding recommendation with allocations to the 10 mutual funds and to cash with considerations for potential risks to your suggested allocation. Explain what each of these terms means in simple terms. (5 points) What You'll Turn In 1 a