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

Reinforced concrete design, Q. Reinforced concrete design? In BS8110 fo...

Q. Reinforced concrete design? In BS8110 for reinforced concrete design, it is stated that longer tension lap lengths have to be provided at the top of concrete members. The mo

Define the price and earning ratio valuation method, Define the P/E valuati...

Define the P/E valuation method. Under what circumstances should a stock be valued using this method? The P/E ratio points out how much investor are willing to pay for each dol

Types of government stocks, Types of Government Stocks Issue of Stock t...

Types of Government Stocks Issue of Stock through AuctionThe RBI, on behalf of the government, issues notification to auction government securities, stating the amount and time

Explain contingent exposure, Explain contingent exposure and define the adv...

Explain contingent exposure and define the advantages of using currency options to manage this type of currency exposure. Answer: Companies may come across a state where they m

Show the signs of overtrading, Q. Show the Signs of Overtrading? There ...

Q. Show the Signs of Overtrading? There are a number of usually recognised signs that a company may be overtrading. These are considered mutually with relevant financial data f

What is the bonds value, Third Inc. wishes to issue a perpetual callable bo...

Third Inc. wishes to issue a perpetual callable bond. The current interest rate is 6%. Next year, there is a 30% chance that the interest rate will be 4.5% and a 70% chance that th

Capital Budgeting Decision Problem, SCL Ltd., a highly profitable company, ...

SCL Ltd., a highly profitable company, is engaged in the manufacture of power intensive products. As part of its diversification plans, the company proposes to put up a windmill to

Normal spread, After the calculation of cash flow yield and the...

After the calculation of cash flow yield and the average life of the asset-backed and mortgage-backed security based on default, prepayment and recovery ass

Price volatility characteristic of bond with embedded option, The price of ...

The price of the embedded option comprises two components. The first is the value of the same bond assuming it has no embedded option (option-free bond), th

Zero-coupon bonds, All the bonds are not making periodic coupon payments. ...

All the bonds are not making periodic coupon payments. Zero-coupon bonds are those bonds where the bondholder realizes interest by buying it at a deep discount to its face

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