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

Accounts receivable are sometimes not collected, Accounts receivable are so...

Accounts receivable are sometimes not collected.Why do companies extend trade credit when they could insist on cash for all sales? Extending trade credit almost for all the tim

Calculate debt or equity ratio, Calculate Debt or Equity Ratio XYZ LI...

Calculate Debt or Equity Ratio XYZ LIMITED Key data related to XYZ for last three years is as follows:   2011/12 2010/12

Dividends paper, one page paper reviewing "the Morgan Stanley Oil and Gas R...

one page paper reviewing "the Morgan Stanley Oil and Gas Report"

Market condition affecting cost of capital, Q. Market condition Affecting c...

Q. Market condition Affecting cost of capital? Market condition: if an investor is purchasing a security where the risk of the investment in significant the opportunity for add

Financial leverage, Financial Leverage In accounting and finance, ...

Financial Leverage In accounting and finance, the amount of long lasting debt that an organization has in relation to its equity the longer the ratio, the larger the lever

Compare the ifrs and gaap revenue recognition policies, SUPERVALU INC . ...

SUPERVALU INC . , a large US retail grocer, had $36.1 billion in sales for its fiscal year ended February 25, 2011. SUPERVALU currently reports using US GAAP. The controller of

Clemson software, Clemson Software is considering a latest project whose da...

Clemson Software is considering a latest project whose data are given below.  The needed equipment has a 3-year tax life, after which it will be worthless,and it will be depreciate

Debt and payment, Jane has agreed to sell her Porshe 911 Cabriolet worth RM...

Jane has agreed to sell her Porshe 911 Cabriolet worth RM1.3 million to Lim for the price of RM 500,000. The decision was made rather hastily as Jane need money to pay her creditor

Types of equity securities , Types of equaty Securities Equity securiti...

Types of equaty Securities Equity securities, traditionally, are classified into two types when they are issued. They are: Common Stock, and Preferred Stock.     Common Stoc

Compare and contrast j''s current style of management, When J was promoted ...

When J was promoted to be the new Sales and Marketing Manager for Company L, after working there in different capacities over the last ten years, it was a popular choice between he

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