代做ACFI 3018 APPLIED PORTFOLIO MANAGEMENT代写留学生Matlab语言

- 首页 >> Database

ACFI 3018

APPLIED PORTFOLIO MANAGEMENT

PROBLEM SET

[This problem contributes 30% to your overall mark in this course. You should answer all the questions.] 

The spreadsheet Problem Set Data.xls contains financial markets data that is used for this assignment. The data is allocated into three tabs: Q3 relates to question 3, Q4 relates to Question 4 and Q5 relates to Question 5. You may not need to use all the data provided in the spreadsheet. You are required to submit both an Excel spreadsheet that shows your workings and a word file with a report that summarises your responses to each question. The word file should be a stand-alone report; the Excel spreadsheet is only submitted so that your working out can be checked as required. You may make reasonable assumption (if necessary) in answering the questions.

Question 1 (7 marks)

a) Your client is considering investment in one of the following assets. Probability distribution of returns on each security is given in the following table.

State

Probability

A

B

C

D

1

10%

15%

80%

40%

5%

2

40%

20%

20%

5%

5%

3

40%

30%

20%

8%

5%

4

10%

35%

-30%

-12%

5%

1) On the basis of excess returns per unit of risk, which security (A, B, or C) would you recommend to your client?             (2 marks)

2)  On the basis of skewness, which security would you recommend to your client? (2 marks)

3) In 200 words or less, explain the relationship between skewness of a return distribution and the following investors’ utility preferences.

(1) Mean-variance investors                                   (1.5 marks)

(2) Non-mean-variance investors                     (1.5 marks)

Question 2 (5 marks)

Suppose you are bearish on CBA and decide to sell short 100 shares at the current market price of $50 per share. If the broker’s initial margin requirement is 60% of the value of the short position and the maintenance margin is 35%.

1) How much in cash or securities must you put into your brokerage account?     (1 mark)

2) If the price of CBA immediately changes to: (i) $54; (ii) $58; (iii) $62, will you receive a marginal call? If so, please calculate the additional margin you need to deposit in the account      (2 marks)

3) How high can CBA’s price increase before you get a margin call?                         (2 marks)                                          

Question 3 (6 marks)

You are employed as a research analyst and have been given five stocks to analyse. The five stocks are the BHP Group (ASX code BHP), Commonwealth Bank of Australia (CBA), Westpac Banking (ASX code WBC), Australia and New Zealand Banking Group (ANZ), and Rio Tinto (RIO). Daily dividend adjusted price data for these five stocks for the period January 2010 to December 2023 are provided in the Problem dataset.xls Excel spreadsheet. The ASX200 index value and 10-year government bond rate (daily) are also provided in this spreadsheet. Using the data provided, you are required to undertake the following:

a) Use Microsoft Excel’s Solver add-in to derive the efficient frontier of risky assets for a portfolio comprising the five stocks that you have been asked to analyse. When calculating expected returns, you should use the Capital Asset Pricing Model. The market consensus forecast for the expected market return is 10% per annum and the expected risk-free rate of interest is 5% per annum. (5 marks)

b) Assume that your coefficient of risk aversion is 3. What is the combination of the optimal risky portfolio and risk-free asset that would maximise your utility?                               (1 mark)

Question 4 (6 marks)

US monthly stock returns across 30 industries for the period from 2009 to 2022 are provided. You have been asked to back test a cross-sectional momentum strategy using this data. Within this strategy, you are required to demonstrate the monthly returns on a portfolio of past winners and the returns on a portfolio of past losers. The momentum strategy that you should apply is the 12/12 strategy, whereby industries are allocated into portfolios based on their performance over the past 12 months and each portfolio is then held for the subsequent 12 months and rebalanced annually. Monthly returns on the market index (Mkt) and the monthly risk-free rate (RF) are also provided.

a) Create an equally weighted portfolio comprising five industries of past “winners” and five industries of past “losers” and report the historical mean and standard deviation of returns for these portfolios. Calculate and interpret the Sharpe ratio and Jensen’s alpha for these two portfolios.                                    (3 marks)          

b) Repeat the process in a) by using the 6/6 strategy (industries are allocated into portfolios based on their performance over the past 6 months and each portfolio is then held for the subsequent 6 months and rebalanced semi-annually for 6/6 strategy). Compare and comment on the results in a) and b).                 (3 marks)

Question 5 (6 marks)

You are required to construct an equal weighted value portfolio with 5 stocks by using the data from the Q5 spreadsheet.

a) Please identify the 5 value stocks for the value portfolio if the following screens are used (2 marks):

1) Price to cashflow ratio (P/CF)

2) Book-to-market ratio (B/M)

b) Login to FactSet database and obtain daily price observations for each equal weighted value portfolio constructed in a), and the market index (ASX200 index) for the period January 3rd 2012 – Dec 31st 2018. Please use appropriate performance measures to evaluate the performance of the above two value portfolios, assuming the daily risk-free rate is 0.01% (4 marks):

 

 

 


站长地图