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
Franchise (licensing) - Granting or licensing of the right to use systems, expertise,brandsknow how etc. to another  organisation,  generally in  return  for  a  profit  share

The potato chip industry in the Northwest in 2007 was competitively structured and in long-run competitive equilibrium; firms were earning a normal rate of return and were competin

Q. Foreign exchange - Maximum loss? From Marton's point of view an adverse outcome is depreciation of the dollar against sterling as this lowers its income when converted into

Residual Method We know that a time series consisting of annual data for longer periods is depicted by trend lines. This facilitates us to isolate the component of secular tre

Issuing Procedure of treasury bills As discussed above, the RBI on behalf of central government, announces the auctioning of T-bills by tender notification through the press. T

Macro-Economic Analysis Measuring the Level of Economic Activity Gross National Product (GNP) and the Gross Domestic Product (GDP) are the two most widely used aggregates

Q. Describe the Dividend Yield Method? Dividend Yield Method: - This process is based on the assumption that when an investor invests in the equity shares of a company he expec

CLASSIFICATION OF SOURCES OF FINANCE In the market, there are several sources of finance, with conflicting risk characteristics and with conflicting cost structures. Numerous m

Yang Su is considering the following information on two stocks:                                                                              Rate of Return State of Economy