Expected monthly return, Financial Management

In this exercise you will construct efficient portfolios with 5 risky assets using Excel's non-linear optimization routing "Solver". The questions are designed to be sequential and to lead up to the desired result. It is crucial to notice that you will be using past returns to estimate expected returns and risk. From Sakai download the file  data_question1.xlsx which contains monthly returns for AT&T, Ford, Google, Exxon Mobile, and Gold from 2005-2012. The monthly returns have been adjusted to reflect dividend payments and are provided in decimal form to make the necessary calculations easier.

a)  Using the monthly returns provided what is the expected monthly return for each asset and what is the corresponding standard deviation? In order to calculate the mean use the Excel function "AVERAGE"; in order to calculate the standard deviation use the Excel function "STDEV.S".

b)  We discussed in class that when we are analyzing the returns on a portfolio of assets, the covariance or correlations of each asset with the other ones will be crucial in determining the portfolio risk. Using the given monthly returns tabulate the pairwise covariances for each asset pair and tabulate the correlations for each asset pair. Use the Excel functions "COVARIANCE.S" and "CORREL".

Posted Date: 2/28/2013 5:53:21 AM | Location : United States







Related Discussions:- Expected monthly return, Assignment Help, Ask Question on Expected monthly return, Get Answer, Expert's Help, Expected monthly return Discussions

Write discussion on Expected monthly return
Your posts are moderated
Related Questions
XYZ Energy Solutions plc (XYZ) has spent €12m designing and developing a new generation of domestic air source heat pumps. These new domestic heat pumps can easily be fitted to exi

Explain how management goals are incorporated into pro forma financial statements. Management put a target goal and forecasters makes pro forma financial statements under the

How to calculate payment of expenses: SAIB, LLC is a US company that provides cell phone and internet service; it seeks to expand its international operations into Kyrgyzstan.

Following are return expectations on the S&P 500 index for the upcoming year with the corresponding probabilities: Expectation                                   Return

uses and limitations of the marginal weighting system

Fixed Costs The costs a rigid incurs doing business that do not change in relation to production. Rent, for example, is a fixed cost because it remains constant whether product

Bond management evolution to some extent is linked to the increased volatility of the interest rate term structures which is in existence since seventies. Bond valuatio

Question 1 What are the limitations of management accounting? Question 2 Explain the significance of financial analysis Question 3 What are the advantages of the value a

Role of Financial Intermediaries in the financial system: Having designed the instrument, the issuer should then ensure that these financial assets reach the ultimate investor

State a process for benchmarking 1.  Gain senior management commitment to establish benchmarking as a process within the organisation and educate stakeholders and staff about t