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
Treasury bills are the bills, the government issues with maturity period of one year or less than one year. Treasury bills are usually issued as discount securiti

Using details from table 8, let us compute the 6-month forward rate. Simple arbitrage principle, like the one used to compute the spot rates are used in this proc

Cash flow statement: The cash flow statement summarises the flow of cash into and out of the business over a certain period of time. The cash flow statement measures the liq

We need to have done some exploration work on all of the major projects for inclusion in our prospectus, but of our $4m we need at least $1m in the bank to pay for all the listing

What are some instances of restrictive covenants that might be fixed in a bond's indenture? An indenture might involve limitations on future borrowings, restrictions on dividen

What is logistics? Explain the important activities in logistics systems. Logistics - meaning . Working of logistics systems - three important activities - Order processing, I

What kinds of U.S. companies would benefit most from a stronger dollar in the foreign exchange market?  Explain. U.S. companies that import merchandise from other countries wou

Stepped spread floaters have a provision to change the quoted margin at certain intervals over a floater's life. The quoted margin could either step to a higher l

On January 1 a bond with face value of $1,000 is for sale in the market.  That bond has a coupon rate of 6%, pays interest only once a year and the end of the year, and matures at

Q. What is Dependent Care Expenses? Dependent Care Expenses - Qualified child care expenses would allow a taxpayer this computed credit against tax. Amounts can be found on the