The Board is asking you to produce a detailed analysis of the characteristics of the new...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Board is asking you to produce a detailed analysis of the characteristics of the new portfolio to be constructed according to this Strategic Asset allocation. You have been able to gather the information contained in the table included as attachment. Required: 1. For each asset category determine 1. 10-year arithmetic mean historical annual rate of return 2. 10-year geometrical mean historical annual rate of return 3. Standard deviation of arithmetic mean historical annual rate of return 4. Coefficient of variation (Std. Deviation/ Return) 5. Beta by formula (x= x m 'xm / m) 2. Determine and construct using Excel formulas 1. The covariance matrix 2. The coefficient correlation matrix 3. The Capital market Line (using the US Large Cap as a proxy for the market and US Treasury Bills for risk free rate) 4. The Security Market Line 3. Determine de Expected Return and Standard deviation for the portfolio, according to the strategic asset allocation. Parte II - tabla de rendimientos histricos.doc MERCADO DE VALORES (STOCK MARKET)-FINA 3300 Table 1 Asset Categories Historical Rates of Return ANNUAL RETURNS Asset Category US Large Cap 2007 5.77% US Small Cap -1.57% 2008 2009 -37.60% 28.43% -33.79% 27.17% 2010 16.10% 2011 2012 2013 2014 2015 2016 1.50% 16.42% 33.11% 13.70% 1.40% 12.10% 26.85% -4.18% 16.35% 38.82% 4.90% -4.40% 21.30% Non-US Developed 11.17% -43.38% 31.78% 7.75% -12.14% 17.32% 22.78% -4.90% -0.08% 4.50% Non-US Emerging 39.78% -53.18% 79.02% 19.20% -18.17% 18.63% -2.27% -1.80% -14.60% 11.20% US Govt & Credit 6.97% 5.24% 5.93% 6.54% 7.84% 4.21% -2.02% 6.00% 0.50% 2.60% High Yield 2.19% -26.39% 57.51% 15.19% 4.38% 15.58% 7.42% 3.50% -2.80% 17.10% US Treasury Bill 4.74% 1.80% 0.16% 0.13% 0.08% 0.07% 0.05% 0.00% 0.00% 0.26% Assume we are in January 2017: You have been hired as Investment Consultant for the University Endowment (UE) who has a tax-exempt $30 Million Fund. Historically UE' Board have been risk-averted and UE has been investing in fixed income securities only. Although, in the past years UE was able to generate income for its spending requirements, the UE's Fund needs to be repositioned to achieve, over a long-term period, a rate of return enough to grow over the inflation (2%) and its annual spending rate of 5%. Consequently, the recently appointed Board approved a new Investment Policy and Guidelines document. The new proposed asset allocation parameters are as follows: Lower Strategi Upper Asset Allocation Bench Limit C Limit mark Allocati on Domestic Large S&P 15% 20% 25% Cap Equities 500 Small Cap Russell 5% 10% 15% Equities 2000 International MSCI - 10% 15% 20% Equities EAFE Developed International MSCI - 5% 10% 15% Equities Emerging Emg Fixed Income US BC Agg. 20% 30% 50% Fixed Income BC High 5% 10% 15% High Yield Yield Cash & 3-m T- 2% 5% 100% Equivalents Bill The Board is asking you to produce a detailed analysis of the characteristics of the new portfolio to be constructed according to this Strategic Asset allocation. You have been able to gather the information contained in the table included as attachment. Required: 1. For each asset category determine 1. 10-year arithmetic mean historical annual rate of return 2. 10-year geometrical mean historical annual rate of return 3. Standard deviation of arithmetic mean historical annual rate of return 4. Coefficient of variation (Std. Deviation/ Return) 5. Beta by formula (x= x m 'xm / m) 2. Determine and construct using Excel formulas 1. The covariance matrix 2. The coefficient correlation matrix 3. The Capital market Line (using the US Large Cap as a proxy for the market and US Treasury Bills for risk free rate) 4. The Security Market Line 3. Determine de Expected Return and Standard deviation for the portfolio, according to the strategic asset allocation. Parte II - tabla de rendimientos histricos.doc MERCADO DE VALORES (STOCK MARKET)-FINA 3300 Table 1 Asset Categories Historical Rates of Return ANNUAL RETURNS Asset Category US Large Cap 2007 5.77% US Small Cap -1.57% 2008 2009 -37.60% 28.43% -33.79% 27.17% 2010 16.10% 2011 2012 2013 2014 2015 2016 1.50% 16.42% 33.11% 13.70% 1.40% 12.10% 26.85% -4.18% 16.35% 38.82% 4.90% -4.40% 21.30% Non-US Developed 11.17% -43.38% 31.78% 7.75% -12.14% 17.32% 22.78% -4.90% -0.08% 4.50% Non-US Emerging 39.78% -53.18% 79.02% 19.20% -18.17% 18.63% -2.27% -1.80% -14.60% 11.20% US Govt & Credit 6.97% 5.24% 5.93% 6.54% 7.84% 4.21% -2.02% 6.00% 0.50% 2.60% High Yield 2.19% -26.39% 57.51% 15.19% 4.38% 15.58% 7.42% 3.50% -2.80% 17.10% US Treasury Bill 4.74% 1.80% 0.16% 0.13% 0.08% 0.07% 0.05% 0.00% 0.00% 0.26% Assume we are in January 2017: You have been hired as Investment Consultant for the University Endowment (UE) who has a tax-exempt $30 Million Fund. Historically UE' Board have been risk-averted and UE has been investing in fixed income securities only. Although, in the past years UE was able to generate income for its spending requirements, the UE's Fund needs to be repositioned to achieve, over a long-term period, a rate of return enough to grow over the inflation (2%) and its annual spending rate of 5%. Consequently, the recently appointed Board approved a new Investment Policy and Guidelines document. The new proposed asset allocation parameters are as follows: Lower Strategi Upper Asset Allocation Bench Limit C Limit mark Allocati on Domestic Large S&P 15% 20% 25% Cap Equities 500 Small Cap Russell 5% 10% 15% Equities 2000 International MSCI - 10% 15% 20% Equities EAFE Developed International MSCI - 5% 10% 15% Equities Emerging Emg Fixed Income US BC Agg. 20% 30% 50% Fixed Income BC High 5% 10% 15% High Yield Yield Cash & 3-m T- 2% 5% 100% Equivalents Bill
Expert Answer:
Related Book For
Systems Analysis and Design
ISBN: 978-1285171340
10th edition
Authors: Shelly Cashman, Harry J. Rosenblatt
Posted Date:
Students also viewed these finance questions
-
Weatherford International The oilfield services industry includes thousands of companies large and small that provide drilling, seismic testing, transportation, and a wide range of other services to...
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
PROJECT SCENARIO You are recently appointed as the IT Consultant and Software Architect in BMS a Software Architect firm. As your first project, you are assigned by the Project Manager to propose and...
-
Ernie Gilmore began working as a part-time waiter on June 1, 2016, at Sporthouse Restaurant. The cash tips of $390 that he received during June were reported on Form 4070, which he submitted to his...
-
If you deposit money in an account today, how long will it take to triple your money based on the annual interest rates below? a. 2.5%. b. 7%. c. 4% d. 10%.
-
Identify and describe the key attributes that might mitigate a red flag, suggesting that no bad act or compliance issues exist.
-
The Bayside Art Gallery is considering installing a video camera security system to reduce its insurance premiums. A diagram of the eight display rooms that Bayside uses for exhibitions is shown in...
-
Consider the acceleration of a good sports car in real life . (1) Pick a certain car model, which could be the one you are driving, or the one you wish you were --- and search online for its...
-
Martin MFG company uses balance sheet approach to calculate allowance for doubtful accounts and bad debt expense. Current policy is to reserve 20% gross accounts receivable as an allowance for...
-
Find the x- and y-intercepts of the graph of the equation HOME HERMAN FACER ww COTTONE Op S 15 20 - dil L P O O TO S m S BESIDE P 18-zx x+9
-
Your lunch was made at 7:45am and contained 49 bacteria. This bacteria triples every 30 minutes. How many bacteria do you consume if you eat this sandwich at noon, rounded to the nearest hundred...
-
Find the following functions. Simplify your answers. 1 x - 4 Find the following functions. Simplify your answers. f(g(x)) = g(f(x)) = 4 and g(x) = +4. X Let f(x) =
-
Consider a function f(x) whose derivative f (x) is given below. Find (i) all critical values, (ii) all intervals on which f(x) is increasing and decreasing, and (iii) the x-value of all relative...
-
If x is not the square of an integer, then the value of 7 + x+ 1/(5-x) is a rational number for only one positive integer y. What is this value of ? (It cannot be 1 or 0)
-
The following object is dimensioned incorrectly. Identify the incorrect dimensions and list all mistakes associated with them. Then, dimension the object correctly using proper dimensioning...
-
1. Use these cost, revenue, and probability estimates along with the decision tree to identify the best decision strategy for Trendy's Pies. 2. Suppose that Trendy is concerned about her probability...
-
What is a SWOT analysis? Prepare a SWOT analysis of your school or your employer.
-
1. Identify the entities and their relationships. Then create an ERD for the reservations system. 2. Create 3NF table designs for the system. 3. For each of the entities identified, design tables and...
-
The data flow symbols shown on page 185 were designed by Ed Yourdon, a well-known IT author, lecturer, and consultant. Many IT professionals consider him to be among the most influential men and...
-
In a steam power plant, coal is burned at the rate of 50 lbm/min. The percentage of ash in the coal is 9% by mass. The combustion of coal takes place in a fluidized bed reactor and the ash in the...
-
2-Mercaptoethanol (C 2 H 6 OS) is produced by reacting ethylene oxide (C 2 H 4 O) with hydrogen sulfide (H 2 S) as per the following reaction equation. The reaction takes place in the presence of...
-
Chlorobenzene is produced by direct chlorination of benzene. However, a parallel reaction that produces dichlorobenzene hexachloride also occurs. The parallel reactions are shown here. The single...
Study smarter with the SolutionInn App