(1) (ii) In your own words write a brief description of the operations of each of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(1) (ii) In your own words write a brief description of the operations of each of the six companies. Each description cannot be longer than two sentences. Use the data in the EXCEL Worksheet to calculate the expected return and risk of each of the companies and the correlation coefficients for each pair of companies. Summarise your estimates in tables. Explain in your own words whether or not you feel that your estimations in (ii) reflect the operations that you described in (i) for each of the six companies. Note: The following statistics need to be estimated - monthly average continuous returns for each of the entities, the ASX200 and cash rate; sample standard deviations of the monthly continuous returns for each of the companies and the ASX200; and sample correlations based on the monthly continuous returns for each pair of the six (6) companies. You have a risk aversion factor of 2.25 and inherit $1,000,000. Select two of the six companies from the EXCEL spreadsheet to create a two-asset portfolio that allows short selling to occur. (1) (ii) (iii) (iv) (v) (vi) (vii) In your own words briefly describe why you chose these two companies. Construct the optimum portfolio containing only shares in these two companies. In a table provide your estimates of the expected return and risk of this portfolio and the dollar amount and weights you invest in each of the companies. Write a brief description of how trial and error would estimate the weights in the portfolio in (ii). Explain in your own words why the weights on each company are different in (ii). Draw the position of the optimal portfolio you constructed in (ii) on a mean- standard deviation diagram using an efficient frontier and a utility curve. The diagram can be hand drawn. Provide a reason in your own words why the portfolio has this position on the diagram in (v). Construct the optimum portfolio if you now include a risk-free asset as well as the two companies in your portfolio. In a table provide your estimates of the expected return and risk of this portfolio and the dollar amount and weights you invest in each of the companies and the risk-free asset. (viii) Write a brief description of how trial and error would estimate the weights in the portfolio in (vii). (1) (ii) In your own words write a brief description of the operations of each of the six companies. Each description cannot be longer than two sentences. Use the data in the EXCEL Worksheet to calculate the expected return and risk of each of the companies and the correlation coefficients for each pair of companies. Summarise your estimates in tables. Explain in your own words whether or not you feel that your estimations in (ii) reflect the operations that you described in (i) for each of the six companies. Note: The following statistics need to be estimated - monthly average continuous returns for each of the entities, the ASX200 and cash rate; sample standard deviations of the monthly continuous returns for each of the companies and the ASX200; and sample correlations based on the monthly continuous returns for each pair of the six (6) companies. You have a risk aversion factor of 2.25 and inherit $1,000,000. Select two of the six companies from the EXCEL spreadsheet to create a two-asset portfolio that allows short selling to occur. (1) (ii) (iii) (iv) (v) (vi) (vii) In your own words briefly describe why you chose these two companies. Construct the optimum portfolio containing only shares in these two companies. In a table provide your estimates of the expected return and risk of this portfolio and the dollar amount and weights you invest in each of the companies. Write a brief description of how trial and error would estimate the weights in the portfolio in (ii). Explain in your own words why the weights on each company are different in (ii). Draw the position of the optimal portfolio you constructed in (ii) on a mean- standard deviation diagram using an efficient frontier and a utility curve. The diagram can be hand drawn. Provide a reason in your own words why the portfolio has this position on the diagram in (v). Construct the optimum portfolio if you now include a risk-free asset as well as the two companies in your portfolio. In a table provide your estimates of the expected return and risk of this portfolio and the dollar amount and weights you invest in each of the companies and the risk-free asset. (viii) Write a brief description of how trial and error would estimate the weights in the portfolio in (vii).
Expert Answer:
Answer rating: 100% (QA)
i Description of Company Operations To provide descriptions of the operations of the six companies I would require the names or some information about ... View the full answer
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these finance questions
-
re Regular Languages and Finite Automata (a) Let L be the set of all strings over the alphabet {a, b} that end in a and do not contain the substring bb. Describe a deterministic finite automaton...
-
Let r and s be solutions to the quadratic equation x 2 b x + c = 0. For n N, define d0 = 0 d1 = r s dn = b dn1 c dn2 (n 2) Prove that dn = r n s n for all n N. [4 marks] (b) Recall that a commutative...
-
What is the relationship between group norms and group cohesiveness? What roles do both cohesiveness and norms plan in shaping group performance?
-
Balance sheet information of Pop and Son Corporations at December 31, 2015, is summarized as follows (in thousands): On January 2, 2016, Pop purchases 80 percent of Son's outstanding shares for...
-
Propose structures and give IUPAC names for the following: (a) A diethyldimethyihexane (b) A (3-methylbutyl)-substituted alkane
-
Hardness can be defined as resistance to: (a) Wear (b) Local penetration (c) Scratching (d) All of the above
-
Find a story about a recent primary offering in The Wall Street Journal. Based on the information in the story, indicate the characteristics of the security sold and the major underwriters. How much...
-
Required information The following Information applies to the questions displayed below] Simon Company's year-end balance sheets follow At December 31 points Assets eflook 10 Cash Accounts...
-
Reconsider the Profit & Gambit Co. problem described in Section 2.6. Suppose that the estimated data given in Table 2.2 now have been changed as shown in the table that accompanies this problem....
-
You have been given data for the number of visitors to an open house for a property being sold in an attractive neighborhood for the last 7 weekends. Please forecast the number of visitors to that...
-
Miller with corporate and personal taxes ____________. Answer options are displayed below it. After Modigliani and Miller's (MM) original no-tax theory, they went on to develop another theory that...
-
How master's subjects like " analyzing and visualizing data " and " Introduction to Data Mining " helps in day to day life for Linux/Unix Systems Administrator. Explain briefly.
-
What is the kernel ? Define four styles of switching from the kernel mode to the user mode. 2. Discuss two unix system calls.
-
Referring to Fig. 2.26, give the value of AT. Referring to Fig. 2.26, give the value of BT. Referring to Fig. 2.26, give the value of CT.
-
For the function f(x,y)=x4 e 5xy, find fx. fy, fx(-1,-2), and f,(-2,1).
-
The stream of air and gasoline vapor, in the ratio of 14:1 by mass, enters a gasoline engine at a temperature of 300C and leaves as combustion products at a temperature of 7900C. The engine has a...
-
The value of a share of common stock depends on the cash flows it is expected to provide, and those flows consist of the dividends the investor receives each year while holding the stock and the...
-
Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram.
-
Create ColdFusion scripts to search, add, edit, and delete records for the VENDOR table in the RobCor database.
-
Modern businesses tend to provide continuous training to keep their employees productive in a fast-changing and competitive world. In addition, government regulations often require certain types of...
-
a. Suppose that General Hospital has a current ratio of 0.5. Which of the following actions would improve (increase) this ratio? Use cash to pay off current liabilities. Collect some of the current...
-
What is the role of internal control in an organization?
-
What are the elements and principles of the COSO framework?
Study smarter with the SolutionInn App