Calculate the variance on a portfolio

Assignment Help Finance Basics
Reference no: EM13852435

Please provide a concise response in Excel (with the formulas), to answer the following question.

QUESTION 1

Consider the following returns:

Year End

Asus Realized Return

Dell  Realized Return

Oracle

Realized Return

2000

20.1%

-14.6%

0.2%

2001

72.7%

4.3%

-3.2%

2002

-25.7%

-58.1%

-27.0%

2003

56.9%

71.1%

27.9%

2004

6.7%

17.3%

-5.1%

2005

17.9%

0.9%

-11.3%

QUESTION: Calculate the variance on a portfolio that is made up of equal investments in Dell's and Oracle's stock.

Reference no: EM13852435

Questions Cloud

End-of-month adjusting entries : 1. After recording all the November transactions and the required end-of-month adjusting entries, the total expenses on the income statement for the month ending November 30, 2014 will be:
Accounting departments and companies operate : What is the Sarbanes-Oxley Act of 2002? Why did it come about? How have the new rules in the Sarbanes-Oxley Act of 2002 affected the way accounting departments and companies operate? What are some positive outcomes from these changes?
What is the material quantity variance : During the first quarter, 5,000 units were made, at an actual cost of $10.50 per unit (three pieces at $3.50 per piece). What is the material quantity variance?
Information for brisco corporation : The 2015 balance sheet and other information for Brisco Corporation revealed the following information:
Calculate the variance on a portfolio : Calculate the variance on a portfolio that is made up of equal investments in Dell's and Oracle's stock.
What would you set audit risk for the pti audit engagement : What would you set audit risk for the PTI audit engagement - Indicate four business risks associated with the factors that Sharon has identified and link each business risk to a specific risk
Describe issues that business should consider : A business is considering dropping a segment of its business. Describe the issues that the business should consider in making this decision.
Can the nominal interest rate ever be negative : Can the nominal interest rate ever be negative? Can the real interest rate ever be negative? Please thoroughly explain. What is the relationship between a bond's price and its yield to maturity?
Prepare a multistep income statement : Woozie Floozy Company decided to discontinue its entire wholesale operations and to retain its manufacturing operations. On September 15, Woozie Floozy sold the wholesale operations to Flippy-Floppy Company. During 2014, there were 200,000 shares..

Reviews

Write a Review

Finance Basics Questions & Answers

  Financing-valuation and rating agencies

Suppose you were given an opportunity to own a business of your choosing. First, briefly describe your business; then explain the most efficient way to raise capital to either start or expand your business. Provide support for your response.

  The more aggressive financing plan

The more aggressive financing plan instead of the more conservative?

  What was vaughn roe

Last year Vaughn Corp. had sales of $315,000 and a net income of $17,832, and its year-end assets were $210,000. The firm's total-debt-to-total-assets ratio was 42.5%. Based on the Du Pont equation, what was Vaughn's ROE?

  Why the quick ratio or acid-test ratio is a better measure

Explain why the quick ratio or acid-test ratio is a better measure of a firm's liquidity than the current ratio.

  Compute the predetermined overhead rate using the

artic company manufactures two products the arc and the ic. the company estimated it would incur 130890 in

  What is the company expected growth rate

What is the company's expected growth rate? Round your answer to two decimal places at the end of the calculations.

  Discuss the implications of purchasing power parity for

discuss the implications of purchasing power parity for operating

  Which of the following statements regarding mortgage-backed

Which of the following statements regarding mortgage-backed securities (MBS) and collateralized mortgage obligations (CMOs) is most correct.

  Calculate the accounting break-even point

Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the sales figure? Explain what your answer tells you about a 500-unit decrease in projected sales.

  What is the after tax cost of existing preferred stock

Mayknn is in the 25% tax bracket and has a credit rating of BBB. What is the after tax cost of existing preferred stock for Mayknn? (round at 2 decimal places)

  Construct stephensons market value balance sheet after both

stephenson real estate company was founded 25 years ago by the current ceo robert stephenson. the company purchases

  Calculate the profit or loss for the investment banker

How many shares of stock must be sold for the company to net $40 million after costs and expenses?

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