8, 9, 10 PORTFOLIO ANALYSIS:
|
YEAR |
ASSET HOTDOGS |
BURGERS |
ASSET WINGS |
|
2016 |
3% |
7% |
14% |
|
2017 |
7% |
9% |
13% |
|
2018 |
10% |
12% |
12% |
|
2019 |
12% |
16% |
11% |
|
2020 |
13% |
15% |
10% |
|
ALTERNATIVE |
INVESTMENT |
|
8 |
60% OF ASSET BURGERS AND 40% OF ASSET WINGS |
|
9 |
55% OF ASSET HOTDOGS AND 45% OF ASSET BURGERS |
|
10 |
33% OF ASSET HOTDOGS, 33% OF ASSET BURGERS AND 34% OF ASSET WINGS |
PLEASE CALCULATE THE EXPECTED RETURN AND STANDARD DEVIATION FOR EACH OF THE THREE PORTFOLIO ALTERNATIVES.
In the questin it has given, 5 years return of 3 stocks namely Asset hotdogs, Burgers, Asset Wings.
Hence we have to calculate their Average Return on each portfolio..
Asset Hotdogs- (3+7+10+12+13)/5 = 45/5 = 9%.
Asset Burgers- (7+9+12+16+15)/5 = 59/5 = 11.8%
Asset Wings- (14+13+12+11+10)/5 = 60/5 = 12%
Caluculation of Average Deviation on each portfolio-
Formula = {(Return1- Average Return)2 + (Return2- Average Return)2........]1/2
Asset Hotdogs= [(3-9)2+(7-9)2+(10-9)2+(12-9)2+(13-9)2/5]1/2 = [13.2%]1/2 = 3.63%
Asset Burgers- [(7-11.8)2+(9-11.8)2+(12-11.8)2+(16-11.8)2+(15-11.8)2/5]1/2 = [11.76%]1/2 = 3.42%
Asset Wings- [(14-12)2+(13-12)2+(12-12)2+(11-12)2+(10-12)2/5]1/2 = [2%]1/2 = 1.41%
Formula-
Expected Return E(R) = W1*R1+W2*R2+ ...........+Wn*Rn
Alternative-8
Given, Weighted to Asset Burger- 60% and to Asset Wings- 40%
Expected Return =(Weight of Asset Burger * Return of Asset Burger) + (Weight of Asset Wings * Return of Asset Wings)
= (60%*11.8%) + (40%*12%) = 7.08%+4.80%= 11.88%
SD= (Weight of Asset Burger * SD of Asset Burger) + (Weight of Asset Wings * SD of Asset Wings)
= (60%*3.42%) + (40%*1.41%) = 2.052% + .564% = 2.616%
Alternative-9
Given, Weighted to Asset Burger- 45% and to Asset Hotdogs- 55%
Expected Return =(Weight of Asset Burger * Return of Asset Burger) + (Weight of Asset Hotdogs * Return of Asset hotdogs)
=(45%*11.8%)+(55%*9%) = 5.31%+4.95% = 10.26%
SD = (Weight of Asset Burger * SD of Asset Burger) + (Weight of Asset Hotdogs * SD of Asset hotdogs)
= (45%*3.42%)+(55%*3.63%) = 1.539% + 1.9965% = 3.536%
Alternative-10
Given, Weighted to Asset Hotdogs- 33%, Asset Burger- 33 % and to Asset Wings- 34%
Expected Return = (Weight of Asset Hotdogs * Return of Asset hotdogs) + (Weight of Asset Burger * Return of Asset Burger) + (Weight of Asset Wings * Return of Asset Wings)
= (33%*9%)+(33*11.8%)+(34%*12) = 2.97%+ 3.894% +4.08% = 10.944%
SD= (Weight of Asset Hotdogs * SD of Asset hotdogs) + (Weight of Asset Burger * SD of Asset Burger) + (Weight of Asset Wings * SD of Asset Wings)
= (33%*3.63%)+(33*3.42%)+(34%*1.41) = 1.198% + 1.123% + .480% = 2.801
8, 9, 10 PORTFOLIO ANALYSIS: YEAR ASSET HOTDOGS BURGERS ASSET WINGS 2016 3% 7% 14% 2017...
Please use excel. I can learn from that!!! Portfolio analysis - You have been given the expected return data shown in the first table on three assets - F, G and H, over the period 2016 - 2019. Expected Return Year Asset F Asset G Asset H 2016 11% 12% 9% 2017 12% 11% 10% 2018 13% 10% 11% 2019 14% 9% 12% Using these assets, you have isolated the three investment alternatives shown in the following table: Alternative Investment...
Portfolio analysis You have been given the expected return data shown in the first table on three assets-F, G, and over the period 2016-2019: Using these assets, you have isolated the three investment alternatives shown in the following table: a. Calculate the average return over the 4-year period for each of the three alternatives, b. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives, c. Use your findings in parts a and b...
Portfolio analysis You have been given the expected return data shown in the first table on three assets—F, G, and H-over the period 2016-2019: E. Using these assets, you have isolated the three investment alternatives shown in the following table: E. a. Calculate the expected return over the 4-year period for each of the three alternatives. b. Calculate the standard deviation of returns over the 4-vear period for each of the three alternatives c. Use your findings in parts a...
Portfolio analysis You have been given the historical return data shown in the first table on three assets-F, G, and H-over the period 2016-2019. 8-14 Historical return Year Asset F Asset G Asset H 2016 16% 2017 17 17% 16 15 14 14% 15 16 17 18 20 2019 18 19 Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 100% of asset F 50% of asset F and 50% of asset...
3. You have been given the expected return data shown in the first table on three assets—F, G, and H—over the period 2015-2018 Year Asset F Asset G Asset H 2015 9 12 15 2016 8 9 16 2017 5 21 19 2018 13 6 11 Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 1 100% of asset F 2 25% of asset F and 75% of asset G 3 50%...
Obs # Age Obs # Age Obs # Age Obs # Age Obs # Age 1 2019 11 2019 21 1976 31 2019 41 2006 2 1998 12 2019 22 2013 32 2018 42 2013 3 2019 13 2019 23 2019 33 2019 43 1982 4 1995 14 1980 24 1994 34 1997 44 2019 5 2018 15 2019 25 1979 35 2015 45 1988 6 2011 16 2016 26 1974 36 2019 46 2019 7 1974 17 1998 27...
Exercise 8-21 (Algorithmic) (LO. 2) Eudid acquires a 7-year dass asset on May 9, 2017, for $256,400. Eudid does not elect immediate expensing under 5 179. He does not claim any available additional first-year depreciation. Click here to access the depreciation table to use for this problem. If required, round your answers to the nearest dollar. Eudid's cost recovery deduction is $ E x for 2017 and $ x for 2018. Feedback Check My Work Under the modifiedlaccelerated cost recovery...
Projected Return Year Asset A Asset B Asset C 2018 10% 15% 11% 2019 12% 13% 13% 2020 14% 11% 15% You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following data: LOADING.... You have been told that you can create two portfolioslong dashone consisting of assets A and B and the other consisting of assets A and Clong dashby investing equal proportions (50 %) in each of the two...
What evidence of underperformance do you see in your analysis of the financial statements for Bob’s and is this suggestive that the management team is doing poorly? 2016 2017 2018 2019 2020 Revenue 191 186 210 248 272 Cost of Goods Sold 137 136 157 189 212 Gross Profit 54 50 53 59 60 Selling and General Expenses 19 29 38 48 47 Operating Profit 35 21 15 12 13 Net Interest Expense 1 0 7 6...
3 Existential Products started business in July 1, 2012 with the following purchases: Residual value Depr. Method 6 Land 7 Building 8 Parking Lot, Lighting & Fencing 9 Processing Equipment 10 Office Equipment Useful life $225,000 Indefinite $1,155,000 40 years $56,800 15 years $198,000 10 years $56,000 5 years $175,000 Straight Line $6,580 Double Declining Balance $19,800 Units of Production $8.500 Double Declining Balance 12 At the end of 2018, the company has come to the conclusion that the building...