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
Q. Determinants of Working Capital? Determinants of Working Capital: - The working capital necessity is determined by a large number of factors but generally the following fa

Future V alue The value of an investment is based on the rate of interest paid at set time periods and at some point in the future. Future values incorporate both the i

QUESTION (a) "A promissory note is an instrument in writing (not being a blank or a currency note) containing an unconditional undertaking, signed by the maker, to pay a certai

List a few types of non-price rationing systems. (a) Queuing. (b) Favored customers. (c) Rationing coupons.

Buying and Selling Securities One of the key features that may occur while investing in financial markets is that sometimes investors overlook the essential factors they should c

Corporate Governance features Corporate compliance: The BOD should make sure that corporation obeys with all related laws, governance practices, regulations, accounting an

A company has total debt of $1,200 and a debt-equity ratio of 0.5. What will be  the value of the total assets?

State about the two types of Government Securities There are two types of Government Securities which are offered: Government Floating Rate Bonds which pay a floating rate

Why do you think the host country tends to resist cross-border acquisitions, rather as compared to green field investments? Answer: The host country is inclined to view green f

The consolidated income statement for AB Group for the year ended 30 June 2010: (all amounts in the workings are in $000, unless stated otherwise)