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
Assume that your company has an equity position in a French firm. Explain the condition under which the dollar/franc exchange rate uncertainty does not comprise exchange exposure f

What are the Market conditions of cost of capital Security may not be readily marketable when investor wants to sell; or even if a continuous demand for security does exist, p

a) Variable costs: Remuneration of flight attendants, Meals and drinks onboard, Fuel. Fixed costs: promotions and Advertising, Remuneration of administrative staff and Airport c

Mr. Lam holds title to an asset worth €125.72. In order to raise money for an unrelated purpose, he plans to sell the asset in nine months. But Mr. Lam is concerned about the uncer

Q. Definition of Capital Budgeting? Capital Budgeting is the procedure of making decisions for investment in long-term assets. It is a method of deciding whether or not to inve

Consistency - ACCOUNTING postulate that stipulates, except as otherwise noted in FINANCIAL STATEMENT, same accounting procedures and policies have been followed from period to peri

SEC is the Regulatory body for investor protection in the United States which is created through the Securities Exchange Act of 1934.

Q. Explain about economic order quantity? The economic order quantity (EOQ) model is basis on a cost function for holding inventory which has two terms: holding costs as well a

Q. Show the Graphic Presentation of Net Income Approach? Graphic Presentation of Net Income Approach: - Net Income approach is described graphically as follows: In the

Explain the four fundamental rights of ownership A shareholder, by virtue of being an owner, is generally entitled to four fundamental rights of ownership: 1. Claim on a sha