You work as the assistant to Mark Bates, a CFP with A&G Services, Inc., an Atlanta based medium- sized financial services firm. One of Mark's clients, Mr. Willey, recently inherited $250,000. Mr. Willey is a real estate developer whose current projects are fully funded; so, he considers investing the inheritance money in stocks. Nevertheless, he will need the money in slightly more than a year from now when he initiates a new real estate project. Furthermore, Mr. Willey has expressed a keen interest in three U.S. stocks. The first one, ALG, is a manufacturer of high-end leather goods. The second one, CCS, specializes in the collection of past-due credit card and medical bills. The third one, AF, is a furniture manufacturer. The three companies do business nationwide and are traded on major U.S. stock exchanges. In about a week Mark plans to meet with and suggest a portfolio to Mr. Willey for his one year investment horizon. Using several economic reports, Mark has developed probability estimates for the five states of the economy over the coming year. In addition, the security analysts at A&G Services have provided estimates of the rate of return on each of the three stocks under each state of the economy. Upon Mark's request, the analysts have also provided estimates of the rate of return under each state of the economy on the computer-run, market-weighted Index Fund" A&G Services uses in-house to gauge the performance of the stock market as a whole. Finally, the security analysts have provided estimates of the return on T-Bills over the coming year. The following table summarizes the above information. Estimated Rate of Return on Alternative Investments Economy State Probability T-Bills ALG CCS AF Index Fund Recession 0.10 2.0% (20.0%) 26.5% 10.0% (13.0%) Below average 0.15 2.0 (2.0) 13.0 (10.0) 1.0 Average 0.50 2.0 23.3 (2.7) 7.0 15.0 Above average 0.15 2.0 37.3 (12.0) 45.0 25.0 Expansion 0.10 2.0 48.0 (20.0) 30.0 40.0 In preparation for his meeting with Mr. Willey, Mark wants you to work on providing him within the next two days with a substantial amount of information which he has sorted into three different groups. First, to gain a better understanding of the three stocks and the stock market as a whole, Mark asked you to: Calculate the expected rate of return, variance and standard deviation of the rate of return of each of the three stock and the Index Fund; (ALG) Calculate the expected beta of each of the three stocks and intuitively explain to Mr. Willey the difference between a stock's standard deviation and beta; (ALG) Calculate the covariance and the correlation between ALG and CCS, between ALG and AF, as well as between CCS and AF. (ALG and CCS) Second, Mark wants to assess the benefits of investing in portfolios as opposed to individual stocks. He is interested in combining the three stocks to create three two-stock portfolios; portfolio P1 includes ALG and CCS, portfolio P2 includes ALG and AF, while portfolio P3 includes CCS and AF. (Note: ALG is the first stock in P1 and P2, while CCS is the first stock in P3.) Mark is also interested in portfolio P4 which includes all three securities. Hence, Mark asked you to: Calculate the standard deviation of each of the three portfolios P1, P2, and P3 assuming its expected rate of return is 8%; (P1) Calculate and tabulate the expected return and the standard deviation of each of the three portfolios P1, P2, and P3 assuming the weight assigned to the first stock of each portfolio takes values between 30% and 60% in steps of 1% (in other words, the weight assigned to the first stock of each portfolio is 30%, 31%, 32%, ..., 59%, 60); (P1, 50%) Intuitively explain which one of the three portfolios is more effective in reducing total risk (Hint: To answer this you should rely on your findings in the previous two bullets); Calculate the expected return and standard deviation for P1 (with 1/2 weight for each of the stocks) and P4 (with 1/3 weight for each stock); (P4) Calculate the covariance and correlation between AF and equally weighted P1; Explain/rationalize/justify the change in expected return and standard deviation as investment shifts from 100% in CCS, to an equally weighted portfolio of ALG and CCS, to finally an equally-weighted portfolio of ALG, CCS, and AF; Third, to assess whether the three stocks, as well as the equally-weighted portfolios P1, P2, P3, and P4 are valued properly, Mark asked you to: Prepare a table in which you report the expected rate of return, beta, and required rate of return for each of the three securities, each of the four equally-weighted portfolios, and the Index Fund; Perform any additional calculations you Ideem appropriate to explain whether each of the three securities and the four equally-weighted portfolios is overvalued or undervalued; Based on your analysis in the three groups of questions above, prepare a brief report explaining whether is most appropriate for Mr. Willey overall to invest in ALG, CCS, AF, or any of the four equally-weighted portfolios P1, P2, P3, and P4.