Construct an efficient portfolio

Assignment Help Financial Econometrics
Reference no: EM131348840

o Write a report which addresses the questions (a to f) below. Where relevant, base your analysis on the data provided.

Table 1: Asset returns on different asset classes over the period 1990 to 2010

Year

Australian Shares % return (ex dividends)

Australian Bonds % return

International Shares % return

Brent oil (USD) per barrel % return

Gold (USD) Troy ounce % return

1990

-20.1%

12.1%

-18.7%

34.7%

-3.1%

1991

22.2%

9.4%

16.0%

-37.4%

-8.6%

1992

-6.0%

8.9%

-7.1%

0.6%

-5.7%

1993

39.1%

6.7%

20.4%

-26.2%

17.7%

1994

-9.2%

10.0%

3.4%

23.1%

-2.2%

1995

16.5%

8.2%

18.7%

14.9%

1.0%

1996

7.2%

7.4%

11.7%

28.2%

-4.6%

1997

7.9%

6.1%

14.2%

-33.6%

-21.4%

1998

7.7%

5.0%

22.8%

-33.5%

-0.8%

1999

13.5%

7.0%

23.6%

136.5%

0.9%

2000

2.9%

5.5%

-14.1%

-9.4%

-5.4%

2001

2.6%

6.0%

-17.8%

-14.3%

0.7%

2002

-9.6%

5.2%

-21.1%

55.7%

25.6%

2003

8.7%

5.6%

30.8%

0.6%

19.9%

2004

22.8%

5.3%

12.8%

33.3%

4.6%

2005

15.7%

5.2%

7.6%

44.5%

17.8%

2006

19.8%

5.9%

18.0%

1.1%

23.2%

2007

17.9%

6.3%

7.1%

58.9%

31.9%

2008

-45.8%

4.0%

-42.1%

-61.8%

4.3%

2009

34.1%

5.7%

27.0%

117.5%

25.0%

2010

2.2%

5.5%

9.6%

19.7%

29.2%

Source: Brailsford et al. 2012; RBA 2016; MSCI World index 2016; gold USD per Troy ounce https://www.gold.org/research/download-the-gold-price-since-1978 (viewed on 11/11/2016);

Europe Brent spot price FOB in dollars per barrel https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=rbrte&f=D (viewed on 23/11/2016).

a) Briefly discuss the five asset classes in Table 1. Using the data from Table 1, calculate the Arithmetic Mean (AM), Geometric Mean (GM) and Standard Deviation (σ) of returns of each of the five asset classes. Briefly discuss the risk-return characteristics of each asset class with reference to these measures.

b) Construct an efficient portfolio. Assume the risk free rate over the period is 6.4%. Calculate the Efficient Frontier and Capital Allocation Line (CAL) for the five asset classes using the Excel Solver Tool (see prescribed Textbook Chapter 7, Appendix A for guidance). You will also need to calculate and provide ‘Bordered Covariance' and ‘Correlation Matrices'. Discuss the implications of these five assets on efficient frontier and CAL.

c) Briefly explain how fiscal and monetary policy can influence an economy. Discuss the three main factors that determine how sensitive a firm's earnings are to the business cycle.

d) Using the Black-Scholes formula and the cumulative normal distribution (i.e. see Table 21.2, p. 740 of the prescribed textbook), compute the call and put option prices using the data from Table 2.

Table 2: Option information

Stock price, S0

38

Exercise price, X

34

Interest rate, r

0.051 (5.1% per year)

Time to expiration, T

0.5 (6 months or half a year)

Standard deviation, σ

0.25 ( 25% per year)

First compute d1 and d2, then using Table 21.2 in the textbook, find the N(d)'s and use interpolation if needed to find the exact call and put prices.

e) Assume the current futures price for gold for delivery 10 days from 8 February is US$1,259.50 per ounce. Suppose that from 9 February 2017 to 22 February 2017 the gold prices were as in Table 3. Assume one futures contract consists of 100 ounces of gold. Also, assume the maintenance margin is 5% and the initial margin is 10%. Calculate the daily mark-to-market settlements for each contract held by the long position. Briefly discuss basis risk (i.e. you can give an example if it makes it easier to discuss) [Hint: see Chapter 22 and examples 22.1 and 22.2 of the textbook].

Table 3: Gold prices in US Dollars per ounce

Day

Futures Price (US Dollar per ounce)

8 Feb 2017

1,259.50

9 Feb 2017

1,253.50

10 Feb 2017

1,256.50

11 Feb 2017

1,261.10

12 Feb 2017

1,251.80

15 Feb 2017

1,254.80

16 Feb 2017

1,258.20

17 Feb 2017

1,269.10

18 Feb 2017

1,271.70

19 Feb 2017

1,266.10

22 Feb 2017 (delivery)

1,265.60

f) Evaluate a fund's portfolio performance in terms of the market (e.g. outperformance or underperformance) using the Sharpe ratio, Treynor measure, Jensen's alpha, and Information ratio using data from Table 4. Assume the risk-free rate is 5.3%. Briefly discuss each of the four measures plus the Morningstar risk-adjusted return model.

Table 4: Portfolio performance data


Fund Portfolio

Market

Average return, x¯

11%

8%

Beta, β

1.10

1.0

Standard deviation, σ

31%

25%

Tracking error (nonsystematic risk), σ(e)

13%

0

This assessment is an individual assessment (ie this is not a group assessment). Please ensure you avoid collusion and other practices which compromise individual assessment work.

Bodie Z, Kane A& Marcus AJ 2014, Investments, 10th edn, McGraw-Hill Education. (ISBN: 9780077861674) - Prescribed Textbook

The required word length for this assignment is atleast 2500 - 3000 words (excluding your cover page, executive summary, table of contents, list of references or appendices) with atleast 12 referencesdating 2011 - 2016, older than that would not do. All references must be from credible sources such as books, industry related journals, magazines, company documents and recent academic articles.

Also, In terms of structure, presentation and style we are normally required to use Microsoft Word settings (12 point Calibri; line spacing of 1.5 lines; language set as English(Australian); default Microsoft Word margin settings(usually 2.54cm top/bottom and 2.54 cm left/right) and Harvard style referencing (which includes in-text citations plus a reference list).

The assignment needs to be done properly with Cover Page, Executive Summary, TOC, Introduction, Discussion, Conclusion, Recommendations, References, etc.

The grade will be adversely affected if the assignment contains no/poor citations and/or reference list.

Reference no: EM131348840

Questions Cloud

Discuss your opinion on the matter with support : The topic is abortion. You must discuss your opinion on the matter with support. Whatever your view is on the topic is irrelevant. This paper is NOT a solely opinion-based. You must provide support with articles and cites.
Personnel roles and competencies required by company : Using APA format, write a three-five page paper that provides an outline of the proposed organization. Additionally,provide an organizational chart that indicates personnel roles and competencies required by the company.
Home computing environment : The CIA triad (confidentiality, integrity, and availability) offers three (3) security tenets that allow data owners the framework to secure data. Considering your place of employment or your home computing environment, discuss in detail the prima..
Write the given paper assignment : Will companies opt out in offering health insurance to employees if the Affordable Care Act is overturned and what will be pros and cons for companies if the bill is overturned?
Construct an efficient portfolio : Briefly explain how fiscal and monetary policy can influence an economy. Discuss the three main factors that determine how sensitive a firm's earnings are to the business cycle.
Discuss the pros and cons of genetically modified plants : Discuss the pros and cons of genetically modified plants. Your answer should discuss the potential impacts on public health and the environment.
Determine the best strategy to deploy to embrace : HAT202 The Hospitality and Tourism Market Business Case Study Assignment. Your group has been employed by park management to help them find possible solutions, especially in the future marketing for the venue. In particular, management is strugglin..
Discuss the issue and state your position about the issue : Discuss the issue and state your position about the issue. After you have addressed your position, also address the reasons why you are either for or against it, and what factors you considered to arrive at your conclusion.
Vulnerabilities and the severity : A short review of the different kinds of threats introduced to the information technology environment by social media, the threats and vulnerabilities and the severity of each. Discusses the threats and vulnerabilities and the severity of each.

Reviews

len1348840

1/10/2017 6:00:10 AM

The grade will be adversely affected if the assignment contains no/poor citations and/or reference list. Please, avoid Plagiarism, Collusion and Other issues Below is your assignment for this subject. Please read the brief and instructions thoroughly. Write a report which addresses the questions (a to f) below. Where relevant, base your analysis on the data provided.

len1348840

1/10/2017 5:59:19 AM

The questions (a-f) are already there in the assignment. They were not marked before but I have marked them now. The required word length for this assignment is atleast 2500 - 3000 words (excluding your cover page, executive summary, table of contents, list of references or appendices) with atleast 12 references dating, older than that would not do. All references must be from credible sources such as books, industry related journals, magazines, company documents and recent academic articles. Also, In terms of structure, presentation and style we are normally required to use Microsoft Word settings (12 point Calibri; line spacing of 1.5 lines; language set as English(Australian); default Microsoft Word margin settings(usually 2.54cm top/bottom and 2.54 cm left/right) and Harvard style referencing (which includes in-text citations plus a reference list). The assignment needs to be done properly with Cover Page, Executive Summary, TOC, Introduction, Discussion, Conclusion, Recommendations, References, etc.

Write a Review

Financial Econometrics Questions & Answers

  Write a matlab program to simulate the dice rolling game

Write a MATLAB program to simulate the dice rolling game. - Run program a large number of times and use the relative frequency to verify the answer.

  Compute the activity rates for each of the three activities

Prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. She knew that the total cost for the month was $307,000 and that 15,000 diners had been served.

  Determine what is the most lisa will pay for the investment

Lisa is offered an investment that will pay her $700 every year forever starting 8 years from now. Lisa requires a return of 5% on investments of this risk level. What is the most lisa will pay for this investment

  Defining new variables give the process followed by s

Defining new variables as necessary, give the process followed by S, and the corresponding market price of risk, in a world that is the traditional risk-neutral world for currency A.

  What is teh future value of $1000 invested for ten periods

Berkshire Hathaway owns over 50% of the common stock of Coca-Cola Inc - Warren Buffet's skill and the reason he is one of the wealthiest people in the world has been his ability to time the stock market.

  An experiment consists of rolling a die and flipping a coin

An experiment consists of rolling a die and flipping a coin. If the coin flip is heads, the value of the die is multiplied by -1, otherwise it is left as is. - What are the possible outcomes of this experiment?

  How many years will it take them to save up the amount

Ralph and Alice would like to have $22000 for a down payment on a house. Their budget only allows them to save $269.37 per month. How many years will it take them to save up the desired amount of $22000

  Determine how much must be remitted for the purchase

The current price of the $1,000 bond is $978. On February 1, you purchase $10,000 face amount, and your broker charges a $25 commission. How much must you remit for the purchase

  Should pettit relax collection efforts at opportunity cost

The Pettit Corporation has annual credit sales of $2 million. Current expenses for the collection department are $30,000, bad debt losses are 2% and the days sales outstanding is 30 days.

  Find out the stock prices

The order of your stock prices must be in the same order as that shown below, Also date must be in an ascending order

  Find what is the consumer price index-cpi for year 1

Suppose in the base year, a typical market basket purchased by an urban family cost $250. In year 1, the same market basket cost $950. What is the consumer price index (CPI) for year 1

  Determine what is the projects irr

A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost capital of 11%. What is the project's IRR

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd