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

Capital budget relate to pro forma financial statements, Explain how the ca...

Explain how the cash budget and the capital budget relate to pro forma financial statements. The cash budget demonstrates the projected flow of cash in and out of the firm fo

measuring yield spreads, A yield spread between any two bond issues ...

A yield spread between any two bond issues can be easily computed when the maturity date for both these issues is same. The yield spread between these two bond

Net present value (npv), Net Present Value (NPV) : In this technique, f...

Net Present Value (NPV) : In this technique, future cash flows are discounted to the present and then compared with the investment outlay. The basic discount rate is generally

What does weighted average cost of capital, What does the "weight" refer to...

What does the "weight" refer to in the weighted average cost of capital? The weight pass on to in weighted average cost of capital refers to the portion of the total capital in

Common-size balance sheet and income statement, The question to be answere...

The question to be answered is : "Since the 1990 opening of stock exchanges, China started to use financial statements to determine the performance of listed companies. What were c

Observation of capital structure, Q. Observation of capital structure? ...

Q. Observation of capital structure? Droxfol Co has long-term funding provided by ordinary shares preference shares and loan notes. The rate of return necessary by each source

Calculate the net income-asset intensity-return on assets, Analyze a Startu...

Analyze a Startup How would you select an organizational form for a business? Think about this question as you read the following scenario. Joe Jones has created a business

Microsoft''s Partenership Strategies, I have a presentation to give on ''Ne...

I have a presentation to give on ''New ways'' Microsoft can improve its ''Partnership Strategies''. Can some one please give some good links or insights into the same.

Relationship between spot rates and short-term forward rates, Assume ...

Assume that an investor invests $X in a 3-year zero coupon Treasury security. Three years from now, the total return received would be:

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