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

  Free or unused capacity of freezer of ice cream

Inventory Decisions - Free or unused capacity of freezer of ice cream How much unused freezer space (in gallons) is leftover from part "a"?

  Find expected return of mm stock

Wolfrum technology has no debt. Its assets wiil be worth $450 million in one year if the economy is strong, but only $200 million in one year if the economy is weak.

  Discuss benefits & drawbacks of accumulating cash balance

Discuss the benefits and drawbacks of accumulating cash balances rather than paying dividends and what effects do dividend policy have on this type of decision?

  Influencing state revenue collections and expenditures

Explain why state governments cut spending or rising taxes when revenues fall short of expenditures?

  Interpret the slope as a rate of change

Suppose you work as a business consultant. Corporations and governmental entities employed your firm to make recommendations for streamlining business operations, such as to create firms more fiscally sound.

  Determination of portfolio standard deviation

Suppose you own a portfolio that has 35 percent invested in asset A, and 65 percent in asset B. Asset A's standard deviation is 12 percent and asset B's standard deviation is 18 percent.

  Prepare the journal entries on the appropriate dates

Prepare the journal entries on the appropriate dates to record the stock dividend and the stock split and Fill in the amount that would appear in the stockholders' equity section for Klein Corporation at December 31, 2002.

  Make a rough sketch of a spreadsheet model

The Pine Furniture Corporation makes fine country furniture. The firm's current product lines consist of coffee tables, end tables, & dining room tables.

  Purpose a statement of cash flows

Purpose a statement of cash flows for the year ended December 31, 2012 and what does this statement tell you that an income statement does not?

  Calculate the apr of investment

You purchased a stock 3 months ago for $32.81 per share. The stock paid no dividends. The current share value is $37.53. Calculate the APR of your investment?

  Determine of foreign currency exposure

Evaluation of Foreign Currency Exposure due to changes in currency rates - What is Rolls-Royce's dollar transaction exposure in dollar terms? In pound terms?

  The capital structure of campbell company

The capital structure of Campbell Company Long-Term debt, with an incremental borrowing rate of 8%

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