please complete all the work correctlyPlease submit your Uni

please complete all the work correctlyPlease submit your Unit #8 Writing Assignment in MS Word format with the following file name: LastNameFirstInitial_Unit 08_WritingAssignment.docx. For example, if you name is John Smith, the file name of your Answer Sheet should be SmithJ_Unit08_Writing Assignment.docx.If you have any questions or comments, please do not hesitate to contact me.NAME: _____________________________________Robert and April Johnson have come to you with a portfolio of invesments that seem to be a mixture of past adviser’s uncoordinated recommendations. One positive is that some of the funds seem to be doing well, another is that all the funds are tax-deferred acounts held for specific purposes, and a third is that the Johnsons seem to be able to meet their goals. So your job is not so much financial planning as investment planning. Table 1.0 contains data on what the clients have brought to you.Robert and April have only two goals: the college education of their twins in six years and their retirement in 20 years. Ignore the amounts necessary to achieve their objectives. Assume that the allocation of their current funds is equal in ech accunt. Also assume the amount in the Education Savings Account is enough to fund their education goal. Assume that their current savings rate plus their 401(k) is just sufficient to meet their retirement goal with a high level of condifence. Your assignment is as follows:Evaluate the current investments of Robert and April. Make recommendations as to the viability and apropriateness of their current investments (for example, risk level, time horizon, and investment objectives.)Is the overall portfolio sufficiently differsified?Determine if the current invesments should be kept. Should one or more investments be sold. If so which ones?Decide which funds should be in the Retirement Portfolio and which should be in the Education Savings Account portfolio and construct two target portfolios that match their specific goals and have the best return prospects.Robert and April are not well educated about investing. Provide support for your your recommendations. Write your recommendations in a way that educates and explains portfolio risk and return to the Johnsons.FundClassPortfolioCurrentAllocationBeta(to S &P)Sharpe RatioTreynor RatioJensen’s Alpha1Domestic growth401(k)16.7%1.10.77315.4551.5%2Global growth401(k)16.7%0.80.62518.750.3%3Balanced401(k)16.7%0.60.66716.667-0.4%4U.S. bonds, mixed gradeEducation Savings Account16.7%3.6 years’ durationNMFNMF+1% (to bonds index5S & P 500 indexEducation Savings Account16.7%1.00.77017.0-.10%6Equity incomeEducation Savings Account16.7%0.81.0621.253.0%*MNF – No Meaningful Figure.