You are provided with five possible portfolios to select. The portfolios are made up of a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are provided with five possible portfolios to select. The portfolios are made up of a combination of three assets: Share A, Share B, and REIT A. The weightings of each asset per portfolio are shown in Table 1. A portfolio risk and return calculator is provided for you to calculate the portfolio return, portfolio standard deviation, and standard deviation of the portfolio's excess return given a specific portfolio weighting. Table 1: Potential portfolio investments. Portfolio 1 Share A Share B REIT A 58% 20% 22% Share A Share B REIT A Portfolio 2 Portfolio risk and return calculator 40% 45% 15% Return 16% 22% 18% Portfolio 3 Portfolio return Risk-free rate Standard deviation of portfolio's excess return Sharpe ratin Portfolio return Portfolio standard deviation Standard deviation of portfolio's excess return Standard deviation of return 26% 74% 0% 10% 16% 12% Portfolio 4 Portfolio 1 67% 15% 18% Standard deviation of excess return 10% 16% 11% 0,00% 0,00% 0,00% Portfolio 5 Weight 1 Use the asset weightings provided in Table 1 and the portfolio risk and return calculator above to calculate the following: > Portfolio return (rounded to the nearest two decimal places) > Portfolio standard deviation (rounded to the nearest two decimal places) > Standard deviation of portfolio's excess return (rounded to two decimal places) Portfolio 2 100% 0% 0% For example, include the asset weights provided in Table 1 for Portfolio 1 in the grey blocks in the portfolio risk and return calculator. The portfolio return, portfolio standard deviation, and standard deviation of portfolio's excess return for Portfolio 1 will be calculated automatically in the blue blocks. Enter the answers that appear in the blue blocks for Portfolio 1 in the grey blocks in the table below. Repeat for each of the other portfolios. Portfolio 1 Portfolio 2 Portfolio 4 0% Should always sum to 100% Portfolio return Portfolio standard deviation Standard deviation of portfolio's excess return .2 Using your calculations in Question 1.1, calculate the Sharpe ratio for each portfolio, assuming a risk-free rate of 2.6%. Portfolio 3 Portfolio 3 Portfolio 4 Portfolio 5 Portfolio 5 1.3 Assume that you are a rational investor (i.e. you wish to maximise your return at a given risk level). Based on the calculations you performed in Question 1.2, which of the five portfolios would you choose to invest in and why? Limit your answer to 20 words. Start writing here: 1.4 Based on the calculations you performed in Question 1.2: 1.4.1 Which portfolio has the lowest Sharpe ratio? Insert the portfolio number into the grey block alongside. 1.4.2 Why do you think the portfolio you identified in 1.4.1 has the lowest Sharpe ratio? Limit your answer to 20 words. Start writing here: Question 2 You are provided with five possible portfolios to select. The portfolios are made up of a combination of three assets: Share A, Share B, and REIT A. The weightings of each asset per portfolio are shown in Table 1. A portfolio risk and return calculator is provided for you to calculate the portfolio return, portfolio standard deviation, and standard deviation of the portfolio's excess return given a specific portfolio weighting. Table 1: Potential portfolio investments. Portfolio 1 Share A Share B REIT A 58% 20% 22% Share A Share B REIT A Portfolio 2 Portfolio risk and return calculator 40% 45% 15% Return 16% 22% 18% Portfolio 3 Portfolio return Risk-free rate Standard deviation of portfolio's excess return Sharpe ratin Portfolio return Portfolio standard deviation Standard deviation of portfolio's excess return Standard deviation of return 26% 74% 0% 10% 16% 12% Portfolio 4 Portfolio 1 67% 15% 18% Standard deviation of excess return 10% 16% 11% 0,00% 0,00% 0,00% Portfolio 5 Weight 1 Use the asset weightings provided in Table 1 and the portfolio risk and return calculator above to calculate the following: > Portfolio return (rounded to the nearest two decimal places) > Portfolio standard deviation (rounded to the nearest two decimal places) > Standard deviation of portfolio's excess return (rounded to two decimal places) Portfolio 2 100% 0% 0% For example, include the asset weights provided in Table 1 for Portfolio 1 in the grey blocks in the portfolio risk and return calculator. The portfolio return, portfolio standard deviation, and standard deviation of portfolio's excess return for Portfolio 1 will be calculated automatically in the blue blocks. Enter the answers that appear in the blue blocks for Portfolio 1 in the grey blocks in the table below. Repeat for each of the other portfolios. Portfolio 1 Portfolio 2 Portfolio 4 0% Should always sum to 100% Portfolio return Portfolio standard deviation Standard deviation of portfolio's excess return .2 Using your calculations in Question 1.1, calculate the Sharpe ratio for each portfolio, assuming a risk-free rate of 2.6%. Portfolio 3 Portfolio 3 Portfolio 4 Portfolio 5 Portfolio 5 1.3 Assume that you are a rational investor (i.e. you wish to maximise your return at a given risk level). Based on the calculations you performed in Question 1.2, which of the five portfolios would you choose to invest in and why? Limit your answer to 20 words. Start writing here: 1.4 Based on the calculations you performed in Question 1.2: 1.4.1 Which portfolio has the lowest Sharpe ratio? Insert the portfolio number into the grey block alongside. 1.4.2 Why do you think the portfolio you identified in 1.4.1 has the lowest Sharpe ratio? Limit your answer to 20 words. Start writing here: Question 2
Expert Answer:
Answer rating: 100% (QA)
Answer Portfolio 1 Portfolio return 162 Portfolio standard deviation 1000 Standard deviation of port... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
You are provided with the following information regarding events that occurred at Moore Corporation during 2017 or changes in account balances as of December 31, 2017. Instructions Moore prepares its...
-
You are provided with the following information taken from Washburne Inc.s March 31, 2012, balance sheet. Cash ..................... $ 11,000 Accounts receivable ............... 20,000 Inventory...
-
You are provided with the following transactions that took place during a recent fiscal year. Instructions Complete the table indicating whether each item (1) affects operating (O) activities,...
-
1) The mast on the boat is held in place by the rigging, which consists of rope having a diameter of 25 mm and a total length of 50m. Assuming the rope to be cylindrical, determine the drag it exerts...
-
In the credit-scoring system presented in this chapter, would a loan applicant who is a skilled worker, lives with a relative, has an average credit rating, has been in his or her present job and at...
-
(Pension Funding) You have been hired as a benefit consultant by Maugarite Alomar, the owner of Attic Angels. She wants to establish a retirement plan for herself and her three employees. Maugarite...
-
What is the purpose of timelines in an investigation?
-
Fancy Foods produces two types of microwavable products: beef-flavored ramen and shrimp-flavored ramen. The two products share common inputs such as noodle and spices. The production of ramen results...
-
Consider an object falling through air, where po is the density of the object, Pair is the density of the air, m is the mass of the object, A is the effective cross-sectional area of the object, or...
-
For jet aircraft flying out of Houston on a summer afternoon (T = 95 F, 70% relative humidity) and Palm Springs on a winter morning (T = 40 F, 55% relative humidity), determine for both locations: a)...
-
Explain why the following integral is improper. Then evaluate the improper integral and state whether it converges or diverges. 2x (x + 1)2 dx
-
Top Hatters sold $38.9 million worth in men's hats last year inits local market. Their largest competitor, Lidz Inc., sold $28.3million, and other firms sold $53.4 million in this market.Calculate...
-
In a file called `BigO.java`, implement `BigOInterface` and write methods that have the following runtime requirements: - `cubic` must be O(n^3) - `exp` must be O(2^n) - `constant` must be O(1) Where...
-
Come up with your own speech in which you sell an investment in which you use all of the influencers. NextGen
-
Java code file. This class contains a name and IdNumber of a Sales Agent. SalesAgentTest the test program that tests all the classes and methods. 1. make a new class called SalesSupervisor that...
-
JIFFY Inc. paid annual dividends per share of $0.47, 10 years ago, and is paying $1.25 annual dividends per share today. What is the average dividend growth rate, expressed as a percent? Round to 2...
-
Longhall Co. has $40 million in excess cash in USD to invest in Canada. The canadian dollar is expected to depreciate 12% over the next year. The US interest rate is 5%. How much return is required...
-
4. Jobe dy -Y 2 et by
-
Is the standard deviation a sufficient measure of risk in emerging markets? Explain your answer.
-
Suppose the following chart illustrates the domestic prices of three items (shoes, watches, and electric motors) of similar quality in the United States and Mexico. If one dollar exchanges for five...
-
An investor is evaluating a venture capital project that will require an investment of $1.4 million. The investor estimates that she will be able to exit the venture successfully in eight years. She...
-
One difference between accounting for a governmental (not-for-profit) unit and a commercial (for-profit) enterprise is that a governmental unit should a. Not record depreciation expense in any of its...
-
Carson Citys general fund issued purchase orders of $630,000 to vendors for supplies. Which of the following entries should the city make to record this transaction? Debit Credit Q. ENCUMBRANCES...
-
Belle Valley incurred $100,000 of salaries and wages for the month ended March 31, 20X2. How should this be recorded on that date? c. Expenditures Salaries and Wages Debit Vouchers Payable Salaries...
Study smarter with the SolutionInn App