Expected monthly return, Financial Management

Assignment Help:

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".


Related Discussions:- Expected monthly return

measuring yield spreads, A yield spread between any two bond issues ...

A yield spread between any two bond issues can be easily computed when the maturity date for both these issues is same. The yield spread between these two bond

Seasonal variation in time series analysis, Seasonal Variation Under th...

Seasonal Variation Under this variation, we observe that the variable under consideration shows a similar pattern during certain months of the successive years. An example of s

Major linen purchase on open account, that the business has far fewer linen...

that the business has far fewer linens than it needs, so he makes a major linen purchase on open account. Which of the following terms refers to the fact that partners Ma and Runni

Misconceptions about financial manmagement, What are the misconceptions abo...

What are the misconceptions about Financial Management?

Concepts of cost of capital, Concepts of Cost of Capital 1. Explicit ...

Concepts of Cost of Capital 1. Explicit Cost And Implicit Cost The explicit cost of any source of finance may be described as the discount rate that equates the current v

Option-adjusted spread (oas), Option-Adjusted Spread (OAS) The prime ob...

Option-Adjusted Spread (OAS) The prime objective of an investor is to buy securities which have values greater than their market prices. The discussion made on the above valuat

Define how do mergers affect small businesses, How do mergers affect small ...

How do mergers affect small businesses? A: As per to a recent study by Federal Reserve and Wharton Financial Institutions Center economists, not a big deal. Their analysis reve

Role of government in the financial markets, Role of Government in the Fina...

Role of Government in the Financial Markets Many countries felt that the government should regulate certain aspects of the financial markets. Based on the history and culture o

Define banks like to make short-term, Banks like to make short-term, self-l...

Banks like to make short-term, self-liquidating loans to businesses.  Why? Banks like to be capable to see where the funds are similarly to come from like the borrower is able to

Mortgage pass-through securities, The basic form of a mortgage back...

The basic form of a mortgage backed security is that of a mortgage pass-through security. Among the mortgage-related securities, the mortgage pass-through s

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd