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
what is the relevance of virements to public sector accounting

the managing directors of three profitable listed companies discussed their company''''s dividend policies. company A has deliberately paid no dividends for the past five years. co

Problem: i) Assume a firm buys a new tooling machine for Rs 2000,000, installation costs net of taxes are Rs 300,000. An existing asset has a book value of Rs 400,000 and the

There are dissimilar views on how an organisation can gain competitive advantage, but contemporary research is placing greater emphasis on the resource-based view. Expl

Q. Show the benefits of JIT? Additionally to a higher price and quicker settlement by its major customer such a JIT agreement offers several benefits to the supplier of goods.

Derive and illustrate the monetary approach to exchange rate determination. Answer: The monetary approach is related with the Chicago School of Economics.  It is relies on two

What are the characteristics of an efficient market? The term market efficiency denotes to the ease, speed, and cost of trading securities. In an efficient market the securitie

Q. Evaluae new options within current organization? Evaluating having completed self marketing successfully to prospective employers it is time to analyze new options within cu

Assume we are in the midst of the financial crisis in October 2008. Your firm is considering the purchase of a 10 year put option on the S&P 500 Index. You are analyzing the pricin

Question 1 Financial planning is a process of assessing the goals of an investor. Discuss the meaning, need and scope of Financial planning Question 2 Money management is the