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
How can we measure Total return- Measuring the Rate of Return Total return can be defined as: Total returns = (Cash payment received + Price change over the period) / Purcha

Briefly outline the necessities of the UK version of ISA 700/ 750/ 706 and discuss the factors which would manipulate you as the external auditor in forming an opinion on the finan

Q. Explain Discounting or Present Value Concept? Discounting or Present Value Concept: - According to this concept rupee one of today is more valuable than rupee one a year lat

Prepare a capital budget analysis of the following data, your analysis should determine WACC, Net Operating Cash Flow, NPV, IRR, PI, and Payback analysis. This analysis is for t

what is the criteria for a good international financial system

who are the participants in the hedge funds industries

Q. What is Capital recovery? sometimes one may be interested to find out the annual amount paid in the order to redeem a loan of a specific amount over a specific period togeth

Rate of return of a Bond In case of bonds, rather than dividends, investor is entitled to payments of interest yearly or semi-annually. Investor also benefits if there is an ap

Q. Explain about Temporary or Variable Working Capital ? Temporary or else Variable Working Capital - Any amount over and above the permanent level of working capital is called

Harmonisation of Accounting Standards Recognising the required for international harmonisation of accounting standards, in year 1973, the International Accounting Standards Co