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

Relationship between bond price and time, Relationship between Bond Price a...

Relationship between Bond Price and Time   (If Interest Rates are Constant) The bond price changes as the bond moves closer to its maturity. If the bond is quoted

Example on controlling working capital, Q. Example on Controlling working c...

Q. Example on Controlling working capital? Describe how a manufacturing company could control its working capital levels and impact of the suggested control measures. Solut

Concept of yield spreads, The Central Bank is an authority responsible for ...

The Central Bank is an authority responsible for monetary policy of its country. It regulates money supply and credit, issues currency, and manages exchange rate.

What are the types of inventory cost, What are the types of Inventory cost?...

What are the types of Inventory cost? Explain the elements of inventory cost also. Types: 1. Ordering cost    2. Holding cost Elements: 1. Unit cost  2. Reordering

Explain the types of debt securities, Explain the Types of Debt Securities ...

Explain the Types of Debt Securities There are many types of debt securities available in market.  The range includes Government Securities, Deep discount bonds, Deben

How could we project exchange rates, How could we project exchange rates in...

How could we project exchange rates in order to be able to forecast exchange differences? If someone knew how to predict exchange rates, they would be a millionaire and would n

Determine the post-merger eps and post-mergershare price, Post-merger EPS a...

Post-merger EPS and post-mergershare price An estimated post-merger EPS can be calculated by: (Combined earnings) / total shares after merger An estimated post-merger s

Companies that would be best able to handle high debt levels, Give two exam...

Give two examples of types of companies that would be best able to handle high debt levels. Companies that manage local telephone service and those that manage natural gas deli

Explain about discount rate, Q. Explain about Discount Rate? Discount R...

Q. Explain about Discount Rate? Discount Rate - Rate at which INTEREST is deducted in advance of the issuance, selling, purchasing or lending of a financial instrument. Also, t

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