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
Working of ASIC ASIC as an independent government body enforces and regulates company and financial services laws to protect consumers, investors and creditors. It keeps the pu

What are the main implications of ownership rights by equity claims? Ownership rights have two primary implications: a. First, equity holders can advantage by any raise in t

QUESTION (a) A financial fraud has happened in BABA Bank. Your services have been retained as forensic examiner to investigate the above case While investigating you receive

Relationship between Bond Price and Time   (If Interest Rates are Constant) The bond price changes as the bond moves closer to its maturity. If the bond is quoted

From a practical point of view, the feasibility of the project for Maribyrnong Council can be divided into three elements which are: logistical, operational and legal issues. First

A firm has $700 in inventory, $600 in fixed assets, $600 in accounts receivables, $800 in accounts payable, and $50 in cash. What is the amount of the present assets?

Q. Explain about Money Market Mutual Funds? Money Market Mutual Funds: Money market mutual funds (MMMFs) focus on short-term marketable securities such as TBs, CPs, CDs or call

Q. How cash flow problems arise? It is significant first to distinguish between profitability and cash availability. The key scheme relates to insolvency since even profitable

In financial analysis, interpolation is used widely in: Determination of internal rate of return of a project. Finding out the yield to maturity (ytm)

Q. Example on compound value of the single flow? Mr. X invests Rs. 1000 at 10% is compounded yearly for three years. Compute value after three years. FV = PV (1+i) n FV