Calculate daily and annualised return and standard deviation

Reference no: EM133616099

Problem: You are to assess a 2-asset portfolio that consists of Westpac shares and Fortescue shares. You have been given the historical prices of these companies over the past 2 years (this spreadsheet Download this spreadsheet) in order to analyse historical performance. Assume that the risk-free rate is 3.5% per year and the forward-looking market return is expected to be 8.5% per year. Forecast adjustments: You note that the data you have used does not include dividend information, which you also want to include in your analysis. For Westpac, the annual dividend rate is 7.42%, and for Fortescue the annual dividend rate is 0.83% You also note that Westpac has suffered from a large one-off event in the recent past (compliance breaches) and, thus, in your return expectations you will adjust the historical return upwards by 1.5% p.a. Fortescue, on the other hand, has had relative good luck recently and, thus, in your return expectations you will adjust the historical return downwards by 1.5% p.a. Based on the daily closing prices, calculate the daily and annualised returns and standard deviations, as well as the correlations of these two stocks.

Reference no: EM133616099

Questions Cloud

What is the hpy on your investment : Two years from now, the YTM on your bond has declined by 1%, and you decide to sell. What price will your bond sell for? What is the HPY on your investment?

List the organs of the female and male reproductive : List the organs of the female and male reproductive systems and define the following terms: multigravida, preeclampsia, hysterectomy, and vasectomy

What does the regulation of health information ensure : What does the regulation of health information ensure? Privacy and to prevent aggregation Instruments are valid and accurate Accuracy and usability Information

What is the icd-10 code for hpi : What is the icd-10 code for HPI: This is a 5-year-old female with a 3cm lesion in the right upper lobe. She had an episode of bronchitis in January

Calculate daily and annualised return and standard deviation : Based on the daily closing prices, calculate the daily and annualised returns and standard deviations, as well as the correlations of these two stocks.

Why would why would being a medical diagnostic laboratory : Why would why would being a Medical Diagnostic Laboratory Intern be good for my deggre expaline

How might the information covered on sexuality : How might the information covered on Sexuality During Childhood and Adolescence be applied to or considered for diverse populations?

Identify three ways jenny''s complaint to the nurse manager : Identify three ways Jenny's complaint to the nurse manager may be handled appropriately and with sensitivity.

What is their required return : In a year, that stock will pay a dividend of $2.65. The dividend will increase 4.5% each year. What is their required return?

User Account

All Pages