Solution-Calculate the variance on a portfolio

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..

User Account

All Pages

Calculate the variance on a portfolio

Reference no: EM13852435

Reference no: EM13852435

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT