FINC3017-Asset Allocation and Portfolio Construction Report Writing - Accounting & Finance Assignment Help

Assignment Task

Task 

Objective
You are hired as an investment consultant by a hedge fund that focuses on the following six US stocks: Apple (ticker AAPL), Ford Motors (ticker F), Walter Disney (ticker DIS), Ralph Lauren (ticker RL), Microsoft (ticker MSFT), and Citigroup (ticker C). Your task is to submit a professional report for your manager which addresses the following investment issues. Your analysis is based on implementing the Markowitz approach and monthly returns of the six stocks over the sample period from January 2010 to December 2021, as contained in the spreadsheet ‘Assignment1_data’.

1. Come up with a name for the fund and clearly state it at the beginning of the report

2. Discuss the risk return characteristics of the six stocks. Generate a table that reports mean, standard deviation, skewness, maximum drawdown, Sharpe ratio, and variance and covariance matrix of these six stocks. You also need to prepare a cumulative return plot.

3. Plot and describe the investment opportunity set and efficient frontier of the six stocks with and without the risk-free asset. Clearly identify the weight of each stock in the tangency portfolio as well as the expected return and standard deviation of the tangency portfolio. Assume the risk-free rate is 1% per annum.

4. Investor Tom George wants to invest only in Apple because many stock analysts recommended it. You explain to the investor that he will be better off if he creates a portfolio of the six stocks rather than investing in only Apple.

5. There are two individual investors, Kendall Lee and Morgan Number who are interested in investing in this fund. Both investors’ utility is represented by: ???? = ????(????) ? Kendall has a risk aversion coefficient (????) of 6 and Morgan has a risk aversion coefficient of 10. Suppose each investor has $1 million USD to invest, calculate the portfolio allocation (in dollar amount) to the six stocks and risk-free asset you would recommend to the two investors to maximise their utilities and summarise the expected returns, standard deviations, and Sharpe ratios of these recommended portfolios. Are these portfolios still attainable if investors are not allowed to take short positions?

6. Another investor Amy Zhao is also interested in the fund. However, she is worried about the fact that parameters are all estimated from historical data. Provide a response to Amy’s concern. 

Additional Information
• Express returns, standard deviations, and Sharpe ratios in annual term.
• If using Solver, please set the initial weights to be equal weights when conducting each optimisation.
• Address the requirements of each question clearly. In preparing your report, it is recommended you consider how charts, tables, subheadings, and dot points can be used to enhance the way you present your findings.
• The data provided in this report is adapted from real stock market data. You should only use the data provided to you in completing this report (you are not required to gather any additional data). Further, ignore any potential transaction costs, fees, and taxes in determining your responses.
• Reports will be checked by Turnitin and actions will be taken if academic dishonesty or plagiarism is suspected.

This FINC3017-Accounting & Finance Assignment has been solved by our Accounting & Finance Expert at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.