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
You must analyze how the company is financed through equity and debt financing. You will discuss the level of leverage and how it compares to similar companies in the Industry.

Limitations of participation: 1. Technology and organization today are so complex that specialized work roles are required making it difficult for people to participate succes

Describe the sales forecasting process. Sales assumptions are a group effort. Marketing and Sales personnel usually provide assessments of demand and the competition.  Producti

Present V alue This is the current value of a future payment or stream of payments. The present value is calculated by applying a discount (capitalization) rate to the

Q. Three-phase source voltages and phase sequence? The elementary three-phase, two-pole generator shown in Figure has three identical stator coils (aa, bb, and cc) of one or

In the Index Amortizing note, the principal is repaid according to an amortization schedule linked to a specific reference rate. It is structured in such a manner

Telephone service costs the Eggleston Motor Hotel $250 per week. The business pays its phone service bill on the fifteenth day of each month, but it prepares its financial statemen

(a).At the end of three years, how much is an initial deposit of $100 worth, assuming a compound annual interest rate of (i) 100 percent? (ii) 10 percent? (iii) 0 percent? (b).b. A

how to calculate trend analysis?

Alternative summarised version of tests of controls · Segregation of duty (staff records are separate from wages department) · Documentation ( written evidence ) ·