Assume that you recently graduated and landed a job as a financial planner with Cicero Services, an investment advisory company. Your first client recently inherited some assets and has asked you to evaluate them. The client has $2 million invested in the stock of Blandy, Inc., a company that produces meat-and-potatoes frozen dinners. Blandy's slogan is Solid food for shaky times. Unfortunately, Congress and the president are engaged in an acrimonious dispute over the budget and the debt ceiling. The outcome of the dispute, which will not be resolved until the end of the year, will have a big impact on interest rates one year from now. You have also gathered historical returns as follows for the past 10 years for Blandy, Gourmange Corporation (a producer of gourmet specialty foods), and the stock market. The risk-free rate is 4% and the market risk premium is 5%. + Historical Stock Returns Year Market Blandy Gourmange 1 30% 26% 47% 2 7 15 -54 3 18 -14 15 4 -22 -15 7 5 -14 2 -28 6 10 -18 40 17 26 42 17 8 -10 30 -23 9 -3 -32 -4 10 38 28 75 Average return: 8.00% ? 9.20% Standard deviation: 20.10%? 38.60% Correlation with market: 1 ? 0.678 Beta: 1 ? 1.3 Based on the information provided above, complete the following: 1. Suppose an investor starts with a portfolio consisting of one randomly selected stock. How to measure the risk and return given different scenarios for a particular stock? What are the criteria the investor should consider to choose a single stock to invest? As more and more randomly selected stocks are added to the portfolio, what happens to the portfolio's risk? How does correlation affect your portfolio return and risk? Calculate the numbers with questions marks and the estimated correlation between Blandy and Gourmange using the data in the above Table. Does this explain why the portfolio standard deviation was less than Blandy's standard deviation? 2. If you decided to hold a one-stock portfolio and consequently were exposed to more risk than diversified investors, could you expect to be compensated for all of your risk; that is, could you earn a risk premium on that part of your risk that you could have eliminated by diversifying? According to the Capital Asset Pricing Model, what measures the amount of risk that an individual stock contributes to a well-diversified portfolio? You may use financial calculator, or Excel to solve these problems, and present a report to explain your solutions. Only one member of your group should submit your group Excel project to the assignment link provided in Blackboard. Assume that you recently graduated and landed a job as a financial planner with Cicero Services, an investment advisory company. Your first client recently inherited some assets and has asked you to evaluate them. The client has $2 million invested in the stock of Blandy, Inc., a company that produces meat-and-potatoes frozen dinners. Blandy's slogan is Solid food for shaky times. Unfortunately, Congress and the president are engaged in an acrimonious dispute over the budget and the debt ceiling. The outcome of the dispute, which will not be resolved until the end of the year, will have a big impact on interest rates one year from now. You have also gathered historical returns as follows for the past 10 years for Blandy, Gourmange Corporation (a producer of gourmet specialty foods), and the stock market. The risk-free rate is 4% and the market risk premium is 5%. + Historical Stock Returns Year Market Blandy Gourmange 1 30% 26% 47% 2 7 15 -54 3 18 -14 15 4 -22 -15 7 5 -14 2 -28 6 10 -18 40 17 26 42 17 8 -10 30 -23 9 -3 -32 -4 10 38 28 75 Average return: 8.00% ? 9.20% Standard deviation: 20.10%? 38.60% Correlation with market: 1 ? 0.678 Beta: 1 ? 1.3 Based on the information provided above, complete the following: 1. Suppose an investor starts with a portfolio consisting of one randomly selected stock. How to measure the risk and return given different scenarios for a particular stock? What are the criteria the investor should consider to choose a single stock to invest? As more and more randomly selected stocks are added to the portfolio, what happens to the portfolio's risk? How does correlation affect your portfolio return and risk? Calculate the numbers with questions marks and the estimated correlation between Blandy and Gourmange using the data in the above Table. Does this explain why the portfolio standard deviation was less than Blandy's standard deviation? 2. If you decided to hold a one-stock portfolio and consequently were exposed to more risk than diversified investors, could you expect to be compensated for all of your risk; that is, could you earn a risk premium on that part of your risk that you could have eliminated by diversifying? According to the Capital Asset Pricing Model, what measures the amount of risk that an individual stock contributes to a well-diversified portfolio? You may use financial calculator, or Excel to solve these problems, and present a report to explain your solutions. Only one member of your group should submit your group Excel project to the assignment link provided in Blackboard