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

Explain the strategic alliance, Explain the Strategic alliance Two  or ...

Explain the Strategic alliance Two  or  more  organisations  agree  to  work  and  collaborate  informally  together  however remaining  independent  from  one  another. Simila

Why do analysts calculate financial ratios, Why do analysts calculate finan...

Why do analysts calculate financial ratios? Ratios are comparative measures.  For the reason that the ratios show relative value, they permit financial analysts to compare inf

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

APR and EAR, Assume a bank charges a 15.5% APR (annual percentage rate) on ...

Assume a bank charges a 15.5% APR (annual percentage rate) on credit card holder compounds quarterly. What EAR (effective annual rate) is the bank is charging? What if they change

Determine current cost of equity, Your task is to determine CDW's current c...

Your task is to determine CDW's current cost of equity. Since the company is not yet publicly traded , you need to estimate its cost of equity from a set of comparable companies. U

Financial equivalent of the balance, The Federal Minister for the Environme...

The Federal Minister for the Environment is worried about the Greenhouse Effect, one outcome of which would be that Adelaide would have a subtropical climate by the year 2015. This

Financial ratio analysis, 1. Calculate the compound average annual growth r...

1. Calculate the compound average annual growth rate in sales and profit after tax

Approaches to financial management, mention the advantages and disadvantage...

mention the advantages and disadvantages of the traditional approach

Explain how a country can run an overall balance of payments, Explain how a...

Explain how a country can run an overall balance of payments deficit or surplus. Answer:  A country can run a whole BOP (balance of payments) deficit or surplus by engaging in th

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