You work as a junior portfolio manager position with ABC Capital. As part of the normal...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You work as a junior portfolio manager position with ABC Capital. As part of the normal portfolio review process, the company provides a list of 20 possible investments. You must select at least 6, but not more than 12 investments to create a fully asset-allocated portfolio that will have the characteristics of an 8% expected return, a beta of 0.5 or less, a correlation of less than 60% to the stock market. You will create the portfolio and present it to the company, explaining: Show the calculations for achieving required characteristics (expected return) Calculations for the risk-adjusted rate of return (including Sharpe Ratio and Treynor Ratio) Show your calculations in this spreadsheet. Enter your final answers in the blue area below. 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A B Investment 1 Electric Company 2 Telephone Company 3 Chemical Company 4 IT Company 5 Airline Company 6 Healthcare Company 7 The Bank 8 Oil Drillers 9 Food Company 10 Car Company 11 High Yield Bond 12 Corporate Bond 13 Treasury Bond 14 Municipal Bond 15 Real Estate 16 Managed Futures 17 Agriculture 18 Oil 19 Gold 20 Cash C E F Beta Standard Deviation Correlation Dividend Yield 4% 5% 2% 3% 1% 2% 2% 3% 3% 5% 0.02 0.51 1.5 3.18 1.2 2.62 2.89 4.09 1.04 1.3 0.7 0.55 0.33 0.4 2.1 0.08 0.7 1.96 0.42 0 D 8% 12% 18% 20% 18% 24% 20% 20% 15% 18% 11% 4% 3% 5% 12% 5% 18% 36% 19% 0% 1 1 1 1 1 1 1 1 1 1 0.7 -0.31 -0.28 -0.06 0.75 -0.05 0.124 0.5 0.04 0 4% G Coupon 5% 3% 1% 3% 0.25% H Actual Return 2.35% 6.85% 7.39% 29.96% 10.17% 26.92% 20.42% 30.56% 6.06% 4.06% 6.12% 4.17% 2.75% 5.64% 13.04% 1.62% 3.76% 10.31% 5.20% 1.77% 1 2 3 4 5 6 7 8 9 10 11 12 Your Portfolio Investment Portfolio Beta Standard Deviation Correlation Sharpe Ratio Treynor Ratio Weighting K Expected Return Instructions: 1) Copy and paste the name, beta, standard deviation, and correlation for each selected investment. You should have at least 6 listed, but no more than 12. 2) Calculate the Sharpe Ratio, Treynor Ratio, Weight, and Expected Return for each investment. 3) Finally, calculate the required numbers for the entire portfolio. You work as a junior portfolio manager position with ABC Capital. As part of the normal portfolio review process, the company provides a list of 20 possible investments. You must select at least 6, but not more than 12 investments to create a fully asset-allocated portfolio that will have the characteristics of an 8% expected return, a beta of 0.5 or less, a correlation of less than 60% to the stock market. You will create the portfolio and present it to the company, explaining: Show the calculations for achieving required characteristics (expected return) Calculations for the risk-adjusted rate of return (including Sharpe Ratio and Treynor Ratio) Show your calculations in this spreadsheet. Enter your final answers in the blue area below. 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A B Investment 1 Electric Company 2 Telephone Company 3 Chemical Company 4 IT Company 5 Airline Company 6 Healthcare Company 7 The Bank 8 Oil Drillers 9 Food Company 10 Car Company 11 High Yield Bond 12 Corporate Bond 13 Treasury Bond 14 Municipal Bond 15 Real Estate 16 Managed Futures 17 Agriculture 18 Oil 19 Gold 20 Cash C E F Beta Standard Deviation Correlation Dividend Yield 4% 5% 2% 3% 1% 2% 2% 3% 3% 5% 0.02 0.51 1.5 3.18 1.2 2.62 2.89 4.09 1.04 1.3 0.7 0.55 0.33 0.4 2.1 0.08 0.7 1.96 0.42 0 D 8% 12% 18% 20% 18% 24% 20% 20% 15% 18% 11% 4% 3% 5% 12% 5% 18% 36% 19% 0% 1 1 1 1 1 1 1 1 1 1 0.7 -0.31 -0.28 -0.06 0.75 -0.05 0.124 0.5 0.04 0 4% G Coupon 5% 3% 1% 3% 0.25% H Actual Return 2.35% 6.85% 7.39% 29.96% 10.17% 26.92% 20.42% 30.56% 6.06% 4.06% 6.12% 4.17% 2.75% 5.64% 13.04% 1.62% 3.76% 10.31% 5.20% 1.77% 1 2 3 4 5 6 7 8 9 10 11 12 Your Portfolio Investment Portfolio Beta Standard Deviation Correlation Sharpe Ratio Treynor Ratio Weighting K Expected Return Instructions: 1) Copy and paste the name, beta, standard deviation, and correlation for each selected investment. You should have at least 6 listed, but no more than 12. 2) Calculate the Sharpe Ratio, Treynor Ratio, Weight, and Expected Return for each investment. 3) Finally, calculate the required numbers for the entire portfolio.
Expert Answer:
Answer rating: 100% (QA)
Portfolio Optimization Investment Beta Standard Deviation Correlation Weighting Expected Return Shar... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
? ????????? 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 50 Use your 44 use is 45 46 47 48 49 Made sales of product Cost for the inventory that was sold Amount of the invoice (above) that returns and...
-
34 35 36 37 38 39 40 40 A 41 42 43 43 44 45 46 47 48 49 50 51 52 53 SA 54 EE 55 56 57 58 59 60 61 62 A 01/08/19 01/09/19 01/10/19 01/11/19 01/12/19 01/01/20 01/02/20 01/02/20 01/02/20 01/03/20...
-
You work as a marketing research manager for a major New York City bank. Management would like to know if the banking habits of different ethnic groups differ. They wonder whether, given the varied...
-
Consider the Boolean function given below where X1, X2, X3, X4 and X5 are the attributes and Y is the class variable. Your task is to implement the neural network architecture and implement it for...
-
What is a decision statement? How does the focus on an irrelevant decision affect the research process?
-
Reynaldo and Sonya, a married couple, had flood damage in their home due to a dam break near their home in 2019, which was declared a federally designated disaster area, which totally ruined the...
-
Ortiz Automotive ended December 2009 with Accounts Receivable of $20,000 and Allowance for Uncollectible Accounts of $5,900. During January 2010, Ortiz Automotive completed the following...
-
The trial balance of Roman Company at the end of its fiscal year, August 31, 2014, includes these accounts: Inventory $17,200; Purchases $149,000; Sales Revenue $190,000; Freight-In $5,000; Sales...
-
Dream Resorts makes wine, which it bottles and sells in its on-location Restaurant/Wine Shop. It costs $1100 to set up, brew and bottle a batch of the wine. The annual cost to store the wine is $2.75...
-
A pulpwood loader as shown in Figure P5-63 is to be designed to lift 2.5 kip. Select a steel and determine a suitable tubular cross section for the main upright member BF that has attachments for the...
-
16. What is the geometric closure on a closed polygon traverse with 18 sides?
-
Enter the following in the three-column cash book of an office supply shop. Balance-off the cash book at the end of the month and show the discount accounts in the general ledger. 2015 June 1...
-
G. Clark has a job as a car salesman. He is paid a basic salary of 1,200 per month, plus commission of 2 per cent on the value of his car sales. During the month of April 2016 he sells 240,000 worth...
-
F. Moore has a basic working week of 40 hours, paid at the rate of 10 per hour. For hours worked in excess of this he is paid 11/2 times basic rate. In the week to 12 March 2016 he worked 46 hours....
-
R. Kennedy is a security van driver. He has a wage of 200 per week, plus danger money of 2 per hour extra spent in transporting gold bullion. During the week ended 15 June 2016 he spends 20 hours...
-
T. Penketh is an accountant with a salary of 2,000 per month plus bonus, which for May 2016 was 400. He pays superannuation contributions of 5 per cent of gross pay, and these are allowed as reliefs...
-
Consider a one period model in which a representative agent maximises the utility function: U (c, 1) = Inc + 5lnl subject to the budget constraints: c = (1 t)w(1 1) + v where c is consumption and is...
-
Presented below are income statements prepared on a LIFO and FIFO basis for Kenseth Company, which started operations on January 1, 2024. The company presently uses the LIFO method of pricing its...
-
Cooper Company (CC), a public company based in Western Canada, recently acquired the leasehold interests in 220 sites and the website of Messer Corporation (MC), a company operating a chain of...
-
Transactions and items for a public sector entity applying the CICA PSA Handbook (not referring to Sections PS 4200 to PS 4270) are as follows: 1. Issue of a debenture 2. Inventories of goods for...
-
What are the three main criteria to determine control?
-
Think of an organizationa place of employment, a club, a sports team, a musical group, an academic societythat provided you with a significant work experience, and answer the following questions. 1....
-
What factors determine whether behavior in organizations is ethical or unethical? Divide up into small groups, and each person think of some unethical behaviors or incidents that you have observed in...
-
Now that you understand the nature of OB and management, and the kinds of issues they address, debate the following topic: Team A. The best way to increase organizational effectiveness is to clearly...
Study smarter with the SolutionInn App