Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1) Rate of Return
Year   Asset A    Asset B   Market Index
1        8.0%       19.0%       9.0%
2      -11.0%      12.0%     14.0%
3       18.0%      19.0%       4.0%
4       -2.0%     -14.0%      -4.0%
5       12.0%      13.0%      17.0%

i) Compute Average Rate of Return on two Assets and = Market Index (Use the =Average function)

ii) Determine the Standard Deviation of Returns for two Assets and = Market Index? (Use the =STDEV function)

ii) Determine Correlation of Returns for Asset A and B, Asset A with Market Index and Asset B with the Market Index? (Use the =correl function)

iv) Compute Expected Return and Standard Deviation of Returns for Porfolios with given composition:

% Asset A                % Asset B
Expected Return   Std Dev of Returns
     0                       100%
   25%                     75%
   50%                     50%
   75%                     25%
  100%                     0%

v) Design a curve for Feasable Set of Portfolio outcomes by using data from (iv) with Portfolio Std Dev on X-Axis and Portfolio Expected Returns on the Y-Axis
(Use Insert and then Scatter Plot under the Chart functions)

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M914202

Have any Question? 


Related Questions in Basic Finance

1 why is motor carrier freight transportation the most

1. Why is motor carrier freight transportation the most preferred method of product shipment? 2. What is the economic justification for the recent rapid growth of premium package services? 3. Why is it important for a lo ...

What three criteria must be met to establish that one

What three criteria must be met to establish that one variable causes changes in behavior? Which of these criteria are met by quasi-experimental designs? Which of these criteria are not met, and why?

According to anbspsurvey 57of the residents of a city

According to a survey, 57%of the residents of a city oppose a downtown casino. Of these 57%about 8 out of 10 strongly oppose the casino. Complete parts(a) through(c). (a) Find the probability that a randomly selected res ...

1 a successive independent survey design and a longitudinal

1. A successive independent survey design and a longitudinal survey design both examine changes in responses over time. How do they differ in their approach? 2. Distinguish between demographic and epidemiological researc ...

At the first meeting of an american history class for new

At the first meeting of an American History class for new freshmen, the professor identifies 10 students who appear to be the most anxious individuals in the class. Based on their observed behaviors, the professor rates ...

1 how do scientists get ideas for research what are the

1. How do scientists get ideas for research? What are the advantages and potential disadvantages of each method for doing so? 2. What guidelines do scientists use to conduct an effective literature search? What specific ...

Go to one of the web sites that contain video clips such as

Go to one of the Web sites that contain video clips (such as www.youtube.com) and view some video clips about improving your credit. You can use search phrases such as "improving your credit" or "assessing your credit." ...

1 what is the source of most hazardous materials incidents2

1. What is the source of most hazardous materials incidents? 2. List and describe four categories of weapons of mass destruction. 3. What six steps are common to most risk assessment methodologies? 4. Name several of the ...

Assume that you have an opportunity to visit a civilization

Assume that you have an opportunity to visit a civilization in outer space. Its society is at roughly the same stage of development as U.S. society is now. Its economic system is virtually identical to that of the United ...

Ace investment company is considering the purchase of the

Ace Investment Company is considering the purchase of the Apartment Arms project. Next year's NOI and cash flow is expected to be $2,000,000, and based on Ace's economic forecast, market supply and demand and vacancy lev ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro