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
What is the present value of an annuity that makes a quarterly payment of $37,110 for 11 years, assuming an annual yield to maturity of 5%?

Q. How to develop career strategy? in this step employees need to focus on developing the knowledge experience and skills necessary to market self to prospective organizations.

Q. Explain Marginal cost of capital? The calculation of cost of capital focused when the firms total financing and its paten of financing is given and remains constant. However

Weighted Aggregates Index   In a weighted aggregates index, weights are assigned according to their significance and consequently the weighted index improves the accuracy of the

State the term- Dealing with general risk Part  of  the  strategic  decision  making  process  is  to  analyse  all  risk  factors  involved  with pursuing a specific course of

Engagement Completion Document - A document whereby AUDITOR identifies all significant findings or issues. Document must be as specific as essential in the circumstances for a revi

importance of Leverage

Tactics can be used by company to protect itself. Before the bid Types of Shareholder Having the right shareholders on board who can be

Stock A has settled into a constant dividend growth pattern of 6 percent per year. The current dividend is $1.50, its current price is $15.90. You are an analyst and believe that

Harley Davidson purchases components from three suppliers. Components purchased from Supplier A are priced at $ 5 each and used at the rate of 240,000 units per year. Components pu