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

Define earning per share -eps, Earning per share Earnings per share (E...

Earning per share Earnings per share (EPS) are computed as profit attributable to equity divided by the number of shares in issue and ranking for dividends. EPS therefore repr

Foreign exchange exposure, Using an appropriate 'factor model', assess (a) ...

Using an appropriate 'factor model', assess (a) the performance of the management in creating value for shareholders and (b) the extent of the foreign exchange exposure of a FTSE10

What is installment credit, Q. What is Installment Credit? This is anot...

Q. What is Installment Credit? This is another method by which the assets are purchased and the possession of goods is taken immediately but the payment is made in installments

Dual currency bonds, In the case of dual currency b...

In the case of dual currency bonds, the interest is paid in one currency, while the principal repayment is made in another currency. Deep Di

Marketing, How to use integrated promotional mix to achieve marketing objec...

How to use integrated promotional mix to achieve marketing objectives

Risk and advantages associated with company locations, What are some of the...

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

Just-in-time inventory management, Q. Just-in-time inventory management? ...

Q. Just-in-time inventory management? It considerably improves the short-term liquidity of the business with a maximum financing requirement of $138533 rather than $155640. The

Calculate the thai bhat and risk systematic, 1) Is foreign exchange risk sy...

1) Is foreign exchange risk systematic? What are the implications of your answer regarding corporate hedging policy with respect to foreign exchange risk? In your answers make sure

Just-in-time inventory management processes, Q. Just-in-time inventory mana...

Q. Just-in-time inventory management processes? Just-in-time (JIT) inventory management processes seek to eliminate any waste that arises in the manufacturing process as a resu

Secondary market organise exchanges-over the counter markets, How can secon...

How can secondary market organised the exchanges and over the counter markets? Exchanges and over-the-counter (OTC) markets: Secondary markets can be organised by exchanges

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