You work as the assistant to Mark Bates, a CFP with A&G Services, Inc., an Atlanta...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
What Methods of data collection for research topic "Exploring the economic impact of supply chain disruption in the UK automotive industry" Include a commentary on why you have chosen those methods...
-
Using the course dataset and SPSS run a correlational analysis for the following hypothesis: Provide the SPSS output data with the written interpretation in a word document. People who exercise...
-
Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...
-
Describe a setting (either real or fictitious) that you have been in where either your emotions or the emotions of someone else had more impact on what was being communicated than it should have had....
-
The sensitivity of a performance measure is the rate at which the expected value of the performance measure increases as the manager works harder. Precision, or noise, is the reciprocal of the...
-
Considering the slope m and the y-intercept b, explain how to determine if there is (a) A unique solution, (b) An inconsistent solution, or (c) A dependent solution.
-
Preparing a cost of production report when there are lost units. The South Boston Company makes parts for textile machinery. The first producing department is the Machine Shop. The average cost...
-
Biscaynes Rent-A-Ride rents two models of automobiles: the standard and the deluxe. Information follows: Biscaynes total fixed cost is $18,500 per month. Required: 1. Determine the contribution...
-
I'm doing a lab report and I need help with how of these each are measured. I'll be adding the more information Procedure: l. Measure the length of the piece of copper wire with the metric ruler....
-
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned....
-
1. What's a good evaluation of Halstead's career based on the Rebecca S. Halstead: Steadfast Leadership case. 2. What are two or three crucible moments, their impact and implications. What are...
-
Discuss the eight character strengths and identify which strengths you have developed and which strengths you would like to develop further. Explain at least three ways to develop leadership virtues...
-
$ 2 5 , 0 0 0 in bad debts written off ( after a major customer Steve died leaving no assets from which to recover the debt. Steve had previously purchased, on credit, a bulk order of business shirts...
-
Include as a minimum a cultural analysis based on particular framework as well as industry appropriate analysis of infrastructure and current capabilities. Remember to demonstrate your analysis of...
-
Draw five line angle structures of isomers with molecular formula C4H8O and one pair of stereoisomers. A. For each pair of structures, which of A and B would have the larger Molecular dipole moment?...
-
9. [-/5 Points] DETAILS ASWSBE14 6.E.022. MY NOTES You may need to use the appropriate appendix table to answer this question. Suppose that the mean daily viewing time of television is 8.35 hours....
-
a. Why does the Wi-Fi Alliance release compatibility testing profiles in waves instead of combining the entire standards features initially? 27a1.) An 802.11ac Wi-Fi compatibility testing profile...
-
How have the data breaches discussed in this article (Home Depot, Target, and JPMorgan Chase) influenced your perception of cyberattacks and cybercrimes? Have you changed your behavior to help...
-
Explain why large organizations are attractive targets for attackers. On December 18, 2013, Target Corporation announced that it had lost 40 million credit and debit card numbers to attackers. Less...
-
Suppose you own a company that makes smart refrigerators. Your smart refrigerators can tell you exactly what is in your refrigerator and let you know when you need to buy more of certain items. They...
Study smarter with the SolutionInn App