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

Demand and supply shocks, Demand and Supply Shocks The influence of the...

Demand and Supply Shocks The influence of the above macroeconomic factors on the economic performance can be analyzed by classifying their impact on the economy as a supply or

Difference between a parallel loan and back to back loan, Describe the diff...

Describe the difference between a parallel loan and a back-to-back loan. Answer:  A parallel loan contains four parties.  One MNC (multinational company) borrows and re-lends to

Tax consideration affect cost of debt and cost of equity, How do tax consid...

How do tax considerations affect the cost of debt and the cost of equity? As interest on debt is tax deductible to the issuing firm, as much higher the tax rate the lower the aft

Briefly explain what is trem card, Q. Briefly explain What is TREM Card? ...

Q. Briefly explain What is TREM Card? 1. As per National and international regulations, the drivers of vehicles carrying hazardous goods should have the documentation outlining

Bureaucratic management, nestle is an orgnization wether bureacratic approa...

nestle is an orgnization wether bureacratic approach approperiate for the organizational performance or not?

Describes the techniques of work breakdown structure, Due to the complexity...

Due to the complexity of the tasks involved in many projects, communication of responsibility for those tasks is often helped by means of graphical planning techniques.

Explain the term - yield to call, Illustrate the process of calculating cal...

Illustrate the process of calculating call/ put options yields Issuing corporation will use provision if interest rates fall substantially below coupon rates offered on the se

What are the ifrs 8 operating segments, What are the IFRS 8 operating segme...

What are the IFRS 8 operating segments IASB issued IFRS 8 operating segments in November 2006 (which replaced IAS 14). This continues IASB's work in its joint short-term conver

Deferred coupon bonds, Deferred coupon bonds are generally issu...

Deferred coupon bonds are generally issued at a discount price and are used for financing leveraged buyouts. The coupon payment on these types o

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