Stock Return and Portfolio Analysis - Data Analysis Project - Accounting and Finance Assignment Help

Assignment Task:

Requirement:
Pls, finish the tasks according to the requirements. All the tasks need to be finished by using R. Pls present your results in the word file, copy all your R code in the end of this word file, and then submit your word file via the Turnitin link in iLearn.

Task 1: Stock Return and Portfolio Analysis

In the file named as “Stock.csv”, you have been provided with the daily prices of three stocks from 2012 to 2018.

a. Plot and present the stock prices in time series with appropriate labels. [1 mark]

b. Calculate the log-returns of all the three stocks and express them in percentages. Pls report the descriptive statistics of log returns of three stocks in Table 1. Pls change the names in Table 1 to the stock names in your file.

c. Pls, report the correlation matrix of log-returns of three stocks in Table 1. Pls change the names in Table 1 to the stock names in your file.

d. There is a file named as “FF3factors.csv” in your folder. Merge your stock data with the Fama French three factors data, which are all in percentages.  Pls create a new variable Stock.Rf for all the three stocks, which equals to the difference between log return of each stock and RF (available in the FF3factors.csv), and run a regression of 

Report the regression results for all the three stocks in tables (you can use only one table to summarize all the results or three separate tables).

e. Pls run regressions of:

Report the regression results for all the three stocks in tables (you can use only one table to summarize all the results or three separate tables).

f. Pls make your comments by comparing the results in d and e 

g. If an investor would like to form a portfolio with a targeted expected return of 0.08% and achieve the minimized standard deviation by investing in these three stocks in the “Stock.csv” file. If the daily risk free rate is 0.02%, what is the Sharpe ratio of this optimal portfolio, given there is no short sale constraint? [1 mark] [hint: can use the library of “quadprog”] [pls provide your R code used to form the optimal portfolio in the end of the word file].

h. If an investor would like to form a portfolio with a targeted expected return of 0.08% and achieve the minimized standard deviation by investing in these three stocks. If the daily risk free rate is 0.02%, what is the Sharpe ratio of this optimal portfolio, given there is short sale constraint (i.e., you cannot short sell the stocks)? [1 mark] [hint: can use the library of “quadprog”]

Task 2: Stock Market Reaction to FOMC Announcement

US monetary policy can be measured by changes in the Federal funds rate, which are announced by the Federal Open Market Committee (FOMC) meetings. Given the importance of monetary policy to the whole economy, investors pay special attention to the FOMC announcements. In the attached dataset (“Event Study.csv”), we have collected data on FOMC announcements from 1989 to 2007 and the aggregate stock market reactions to it.

Here is a list of variables:

• Date: FOMC announcement date
• Return: S&P 500 index return on the announcement date  (in percentage)
• Total change: change of Federal fund rate  (in bps)
• Expected:  investors’ expected change of Federal fund rate, which is estimated based on the futures contracts written on the Federal fund rate (in bps)
• Surprise: the difference between Total change and Expected, which measures the change that is out of expectation of investors (in bps)
• Scheduled: equals to 1 if the FOMC is scheduled, and 0 if not

This Accounting and Finance Assignment has been solved by our Accounting and Finance Experts 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 Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.