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

Risks and advantage when a company has operation in country, What are some ...

What are some of the primary advantages when a corporation has operations in countries other than its home country?  What are some of the risks? Foreign operations may decrease a

Rating elements and symbols, Rating Elements A rati...

Rating Elements A rating agency earns its reputation by assessing the client's operational performance, managerial competence, management and organiza

Capital budgeting, identify and explain the key stages in the capital inves...

identify and explain the key stages in the capital investment decision-making process and the role of investment appraisal in this processs..

Cash flow estimation and risk ananlysis.., as a financial analyst, you must...

as a financial analyst, you must evaluate a proposed project to produce printer ink. the equipment would cost 60000 plus 10000 for installation. annual sales would be 5000 units at

Floating-rate securities that have adjustable quoted margin, Floaters ...

Floaters that can be classified under this head are: 1. Stepped Spread Floaters 2.  Extendible Reset Bonds

Functions of treasurer, Functions of Treasurer:- (1) Cash Management: -...

Functions of Treasurer:- (1) Cash Management: - It comprises the managing of cash receipts and cash payments of the business. (2) Banking Relations: - It comprises operating

Features of treasury bills, Features of Treasury Bills Treasury Bills a...

Features of Treasury Bills Treasury Bills are short-term, rupee denominations issued by the Reserve Bank of India (RBI) on behalf of the Government of India. T-bills are issued

Size of the business, Size of the business / scale of the operation : the ...

Size of the business / scale of the operation : the working capital requirement of the concern are directly influence the by the size of the business which may be measured in the

No title, discuss the steps in the controlling process

discuss the steps in the controlling process

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