Average Historical Return and Standard Deviation of Returns
Not what you're looking for?
In planning for your retirement, you came across two potential blue-chip stocks i.e. DBS Ltd and Singtel Ltd which you are considering accumulating in your retirement fund. From your research, you noted the historical returns were as follows:
Year ABC Return (%) Mango Return (%)
2008 -18.0 21.8
2009 33.0 -14.5
2010 15.0 30.5
2011 -0.5 -7.6
2012 27.0 26.3
Calculate the average historical return and standard deviation of returns for (i) DBS, (ii) Singtel and (iii) a portfolio consisting of 50% of DBS and 50% of Singtel.
If you are a risk-averse investor, would you prefer to hold DBS, Singtel or the portfolio and why?
Purchase this Solution
Solution Summary
This solution helps in computing average historical return and standard deviation of returns with step-by-step workings and all formulas shown in excel file.
Solution Preview
Please see the attached file.
In planning for your retirement, you came across two potential blue-chip stocks i.e. DBS Ltd and Singtel Ltd which you are considering accumulating in your retirement fund. From your research, you noted the historical returns were as follows:
Year ABC Return (%) Mango Return ...
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.