User Account

All Pages

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

  Calculate the price of a zero coupon bond

Calculate the price of a zero coupon bond that matures in 20 years if the market interest rate is 6.5 percent. Assume semi-annual compounding.

  Risk is a major concern of almost all investors

Risk is a major concern of almost all investors. When shareholders invest their money in a firm, they expect managers to take risks with those funds.

  Slighty used goods has cash of 2150 inventory of 28470

slighty used goods has cash of 2150 inventory of 28470 fixed assets of 9860 accounts payable of 11900 and account

  When state farm entered the banking field

What kind of diversification took place when State Farm entered the banking field?

  Acceptance sampling accepts or rejects an entire lot based

In acceptance sampling, a manager can reach the wrong conclusion if the sample is not representative of the population it was drawn from.

  For the futures prices calculate the difference between the

assignment download some futures prices with at least 6 expirations and 6 call option prices on the same underlying.

  What is the value of a preferred stock

What is the value of a preferred stock when the dividend rate is 14 percent on a $100 oar value? The appropriate discount rate for a stock of this risk level is 12 percent.

  Explain margin buying of common stocks

Discuss and explain margin buying of common stocks. Include in your discussion the advantages and disadvantages, the types of margin requirements,

  Price is usually called the futures price of the stock

One specialized type of security is called an equity futures. This is a contract that guarantees you a share of a particular company to be delivered to you not today, but sometime in the future, at a price that is determined by the market right now. ..

  Which indicates that the firm value will decline

You should recommend that the project be rejected because, although its NPV is positive, it has an IRR that is less than the WACC.

  How much will the five points cost them

Randall and Augustine are financing $148,000 to purchase a condominium. They obtained a 15-year, fixed-rate loan with a rate of 4.95%. They have been given the option of purchasing up to five points to lower their rate to 4.73%. How much will..

  Create a schedule of expected cash collections for april

jodi horton president of the retailer crestline products has just approached the companyu2019s bank with a request for

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