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

Determine the cost of capital in emerging nation, How can we measure a comp...

How can we measure a company's cost of capital in emerging nations, especially when there is no state bond which we could take as a reference? Although there is no state bond w

Evaluate annual compound interest, Question : (a) A company wants to pu...

Question : (a) A company wants to purchase a plant for its expanding operations. The desired plant is available at Rs 300,000 in cash. Alternatively, the company has the option

Domestic bonds, They are issued in the local market by a domestic bor...

They are issued in the local market by a domestic borrower and are usually denominated in the local currency. For example, US companies issuing bonds to US reside

Standard & poor’s analyze in determining the credit rating, What factors do...

What factors does Standard & Poor’s analyze in determining the credit rating it assigns a sovereign government? Answer: In rating a sovereign government, Standard & Poor’s anal

How will you conclude the cost of capital, Q. How will you conclude the cos...

Q. How will you conclude the cost of capital from different sources? Ans. Implication of Cost of Capital: - Cost of capital of a firm is the least rate of return expected by it

Briefly explain non financial objectives, Briefly Explain Non Financial Obj...

Briefly Explain Non Financial Objectives Monetary statements of any sort are only an expression of organisational activities that can be measured. Lots of the activities of an

Variable costs, V ariable Costs It is an expense that varies direct...

V ariable Costs It is an expense that varies directly with changes in business activities for example the cost of raw materials rise and decreases as the volume of producti

Segment margin, Segment Margin This is the amount in which a business s...

Segment Margin This is the amount in which a business segment in a company contributes toward the common or indirect cost of the company. Therefore, it represents that segment'

Caselets, caselets of bajaj electronics

caselets of bajaj electronics

Shareholders'' wealth maximization, Shareholders' wealth maximization S...

Shareholders' wealth maximization Shareholders' wealth maximization refers to maximization of the net present value of every decision made in the firm. Total present value is e

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