Unit title & code :- Financial Markets and Portfolio Management AAF040-6
Assignment number and title :- 2 Individual Written Report
Assignment type :- WR-I
Weighting of assignment :- 60%
Size or length of assessment :- 3000 Words
Unit learning outcomes :-
1. A deep and systematic understanding of the structure and role of financial markets,the role of intermediaries, and determine optimal portfolio selection balancing risks and return.
2.Manifest the ability to review, critique and evaluate knowledge of financial markets and portfolio
selection in order to meet the required return and minimise the risk
AAF040-6 Financial Markets And Portfolio Management Assignment 2 – UK.
What am I required to do in this assignment?
Suppose you are working in an Investment Bank, a client with limited investment knowledge asks you to create a portfolio with a minimum required annual return of 10%. The client claims he is a risk-averse investor and his initial investment is £100,000. Please propose an investment plan for your client based on his expectation and the following requirements.
This project requires you to use 3 years (15/10/2017 to 16/10/2020) daily adjusted-closing prices of real UK listed company stocks. The data can be obtained from Thomson Reuters Eikon or other sources. Please use MS Excel to perform the calculations (Include all the calculations in Excel and written part in Word document. Please note that the Excel will be used ONLY to check the calculations and you must discuss all the important calculation in word document. Marks will be deducted if the calculated numbers are not discussed in the word document. You are required to submit both the files).
The risk-free asset is assumed with an annual rate of return of 2%.
Section 1: Please start your analysis by selecting four companies from the London Stock Exchange that could be used to construct the portfolio. For the selected companies please you are required to:
a) Comment on the share price performance of the selected companies by including key statistics such as average share price, average return and highest/lowest price.
(Hint: Daily returns can be annualised by multiplying it by (1+R)^(252/no of observations), while daily standard deviations can be annualised by multiplying them by the square root of 360.)
b) Calculate the covariance and correlation between the stocks. Comment on your results.
AAF040-6 Financial Markets And Portfolio Management Assignment 2 – UK.
c) Assume Capital Assets Pricing Model (CAPM) holds and FTSE All-shares is the market portfolio; calculate the beta for each company stock selected and comment on your calculated beta and its impact on the portfolio.
d) Use CAPM to estimate the mean return of each stock and analyze whether they are over- or under priced. What action would you suggest?
Section 2: Based on your analysis of the selected companies’ stocks in Section 1, construct Portfolio A that comprises of two company stocks from the four. This portfolio’s annual return should meet the client’s 10% expected return.
You are required to:
a) Critically explain to your client the two stocks are worth investing compared to others (Use the statistics that you calculated in section 1 to justify your selection).
b) Using excel solver identify the portfolio mix that represents the minimum-variance portfolio. What is the risk and return of this portfolio? Explain the meaning of minimum-variance portfolio. Show graphically the combinations of risk and return for portfolios comprising the two stocks (i.e. the efficient frontier).
c) According to your client’s required annual return rate, find the portfolio that suits him best, this should be Portfolio A.Decide the weighting of each stock in the portfolio; show the portfolio mean return and the standard deviation.
d) Estimate the Sharpe ratio and Jensen’s Alpha of Portfolio A. Explain and comment on these performance measures to your client.
What do I need to do to pass? (Threshold Expectations from UIF)
In order to pass Assessment 2 you will need to:
1.Use real world cases and financial data to demonstrate the ability to solve the complicated problem of generating optimal portfolios that achieve both a reduced risk and a required return
2.Demonstrate a clear application of your skills to the contemporary financial environment and make sound and informed judgments and decisions.
3.Collect data of financial assets from Reuters Eikon or Data stream and critically evaluate the performance of financial assets based on financial analysis and statistical techniques, explaining the implication of these variables.
How do I produce high quality work that merits a good grade?
AAF040-6 Financial Markets And Portfolio Management Assignment 2 – UK.
How does this assignment relate to what we are doing in scheduled sessions?
During weeks 4-6,we have explored important concepts in portfolio management which you will use to complete this assessment.In specific, you will use your understanding of important stock indicators, calculation of variance, covariance and correlation among selected stocks, calculation of CAPM and its implication for investment, creation of various portfolio mix and identification of minimum-variance portfolio and portfolio performance analysis.
ORDER This AAF040-6 Financial Markets And Portfolio Management Assignment 2 NOW And Get Instant Discount
Read More :-
ACFI7016 Financial Modeling Practical Skills Assessment – UK.
