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
Along the dimension of security, bonds can be classified into unsecured (straight) bonds and secured (mortgage) bonds. Unsecured bonds have no charge on any speci

What is a marginal cost of capital schedule (MCC)?  Is the schedule all the time a horizontal line?  Explain. The MCC schedule is a graphic depiction of the weighted average cost

There are some misconceptions about securitization: Poor quality originators end up in securitizing their assets. A bank's best mortgage

Aggregates Method Under the aggregates method of constructing an index number, we could have unweighted aggregates index and the weighted aggregates index. Unweighted Aggr

cost of capital, Financial Management The Nu-Nu Brothers Inc. (NNBI) has the following capital structure, which it considers to be optional: Debt 25% Preferred Stock 15% Common Equ

Financial Market: Being entrusted with different functions having macro level implications on the nation's economy, the financial system tries to fulfill its role through the f

Semi-Strong form level of Efficiency This level states that share prices reflects all available public information. (past and present information). If the market has achieved thi

Q. Barriers of SHRM Implementation? Barriers of SHRM: barriers to successful SHRM implementation are complex. The main reason is a lack of growth strategy or failure to impleme


Q. Explain Functions of Finance Financial Management? Functions of Finance or else Financial Management: - The functions of Financial Management are: (1) Determining the Fin