(Answered) Please provide a concise response in excel with the

Finance

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.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M91422204
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Question - dr bueller had recently overheard a few of his

Question - Dr. Bueller had recently overheard a few of his colleagues discussing possible investments in the international marketplace. Wanting to explore all of his potential investment options, he has asked you to expl ...

Johnson family has found that the current cost of attending

Johnson family has found that the current cost of attending college is $27,000 per year. How much lump sum amount they should have in their education account so that the 4 years of college is funded? Assume education inf ...

The global network has sales of 421945 cost of goods sold

The Global Network has sales of $421945, cost of goods sold of $270002, and inventory of $33598. What is the inventory turnover rate? Round your answer to the nearest hundredth.

Assume that your brother wants to buy shares of either

Assume that your brother wants to buy shares of either Company A or B and is looking for your advice on how to use the financial statements of the companies to make his investment decisions. Which information in the fina ...

Find the future value of the following income stream as of

Find the future value of the following income stream as of year 30, assuming that the appropriate interest rate is 15% per year. Year 1 2---------9 10 11----30 Income $100 $100-----$100 $100 $300-----$300

Why is environmental analysis important for an organization

Why is environmental analysis important for an organization? Please be detailed.

Assume that you put 37341 dollars in an account that earns

Assume that you put 373.41 dollars in an account that earns simple interest at a 13.2 percent annual rate. How much is in your account after 13 years from now?

Matt johnson delivers newspapers and is putting away 15 at

Matt Johnson delivers newspapers and is putting away ?$15 at the end of each month from his paper route collections. Matt is 10 years old and will use the money when he goes to college in 8 years. What will be the value ...

What is marketing discipline what is most peoples

What is marketing discipline? What is most people's perception of marketing discipline? Name an organization that has done a great job marketing. What did they do to make you feel this way?

You have inherited an apple orchard and want to sell it in

You have inherited an apple orchard and want to sell it in the next four years. An expert in apple orchard valuation has estimated the after-tax cash flow you would receive if you sold at the end of each of the next four ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert