User Account

All Pages

What is the expected return and variance of portfolio

Assignment Help Corporate Finance
Reference no: EM1375673

1. You have decided to invest in a portfolio that includes all companies in the Dow Jones Industrials Index. A list of the companies in the index can be found in Yahoo Finance (go to Market Data, then Stocks, select Dow Jones Industrial Average, and then look for "Index Components"). You should find 30 companies.

2. Compute monthly returns for the last five years for each of the companies in the portfolio. Use the data in Adj Close when you download monthly prices from Yahoo Finance. Your sample of historical returns should have 60 observations.

3. Compute the Mean and Standard Deviation of the Returns.

4. Estimate the variance-covariance matrix using both the covariance.s function in excel and matrix multiplication. Check that you get the same values using either approach.

5. Generate and plot the envelope curve using the following alternative approaches:

5A. Maximize the ratio (E(rx) - c)/σx for an arbitrary c (use solver)

5B. Minimize the portfolio variance for an arbitrary return (use solver). Assume the same portfolio return you obtained under approach

5A. Check that the portfolios are the same using both approaches.

6. Estimate the Minimum-Variance Portfolio.

7. Estimate the Optimal Portfolio. Use the current value of the 6 month T-bill as a proxy for the risk free rate. Find the expected return and variance for this portfolio.

8. Estimate the Optimal Portfolio assuming that no short sales are allowed. What is the expected return and variance of this portfolio?

9. Estimate the Optimal Portfolio assuming that no short sales are allowed and no more than 20% should be invested in a single stock. What is the expected return and variance of this portfolio?

Reference no: EM1375673

Questions Cloud

Calculation of us trade surplus and deficit : Determine the top 5-exports and imports from Japan and what is the computation of last month's United States trade surplus, deficit, or balance with Japan?
Question related to international trade : Choose a United States multinational firm. In terms of currency denomination, discuss how the company values its revenues and costs.
Impact of per unit tax on the firm output : The manager of a paper mill is making for her most important test yet. On Tuesday morning, she must testify before a senate committee to justify company's high value.
Determine textbook publishers strategy : Textbook publishers have traditionally manufactured both United States and international editions of most leading textbooks. The United States version typically sells at a higher value than international edition.
What is the expected return and variance of portfolio : Estimate the Optimal Portfolio assuming that no short sales are allowed and no more than 20% should be invested in a single stock. What is the expected return and variance of this portfolio? AF 426: Financial Modeling - Portfolio Models
Real exchange rate and the nominal exchange rate : Differentiate the real exchange rate and the nominal exchange rate and describe two reasons why purchasing power parity does not hold for all goods and services.
Trade sanctions - suitable foreign policy weapon : When international hostilities increase, the United States government will sometime use trade sanctions instead of military action.
Determine documented mistakes made in the past in marketing : Determine some documented mistakes made in the past in marketing existing North American items to international markets?
Find equilibrium income and interest rate : Think that the following model of a small open economy, and Where X = exports, M = imports, e = the real exchange rate=50, Yf = foreign income = 2000.

Reviews

Write a Review

Corporate Finance Questions & Answers

  The country ability to combat the great recession

Great Britain is the second biggest economy within the European Union yet does not utilize Euro, opting instead to retain the pound sterling as its national currency.

  Determine the additional finances value

Based on the sustainable growth model, if a company finances its assets with 75 percent debt and 25 percent equity, and retains 3 million dollar in earnings in a given year,

  Explain business plan to gain attention of the loan

What components would you include in business plan to gain attention of loan officer at a commercial lending financial institution?

  Find the amount for common stockholders

Written, Corporation has 300,000 outstanding shares of $2 par common stock and 60,000 shares of no-par 8 percent preferred stock with a stated value of dollar 5.

  Evaluation of break even number of students

Evaluation of break even number of students of a college - How many students does the college need to enroll to break even?

  Find the amount of airfare

Kimberly is a self employed taxpayer. She recently spent 1,000 dollar for airfare to travel to Italy. Find the amount of airfare is she allowed to reduce in every of given alternative scenarios?

  Find present value of all the shops future profits

Past year, a barber shop created $100,000 in profit. Suppose that the shop's profits grow at 5% per year and that cash flows are discounted at 10 percent per year.

  Find what was the firms economic val added

How much value did management add to stockholders' wealth during 2012 - What was the firms Economic Val Added

  Calculate return on stockholders equity

Calculate return on stockholders equity for both company using ROE-ratio Net income or stockholders equity. Which company has the higher return?

  Discuss the results of the sensitivity analysis

Discuss the results of the sensitivity analysis and the implications of changes in revenue.

  Calculate monthly payment for the loan

You get small business loan in the amount of 50,000 is the value you require to buy the restaurant location. After researching banks to find the best interest rate.

  Find how much are you willing to pay for one share

Multiple choice questions on stock valuation - Pluto's is offering a preferred stock for sale. This stock will pay an annual dividend of $6. If your required return is 6 percent, Find how much are you willing to pay for one share of this stock ?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd