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

Discussion 1 170 wordsidentify a futures commodity exchange

Discussion 1: (170 words) Identify a futures commodity, exchange, stock, or interest rate. Use the internet to find a short history of the performance of this futures contract. Then research the possible reasons for this ...

Assume that european call and put options exist on a stock

Assume that European call and put options exist on a stock. That stock, however, is the target of a takeover in which an acquiring firm offers a fixed price for the stock. The takeover is almost certain to occur shortly ...

1 what are the characteristics of the nordic and

1. What are the characteristics of the Nordic and Scandinavian management culture at TietoEnator? 2. What ways can a company use to leverage its knowledge resources globally? 3. How does a rapidly growing startup maintai ...

1 do outliers increase or decrease the magnitude of

1. Do outliers increase or decrease the magnitude of correlation coefficients? 2. What impact does reliability have on correlation? 3. Why can we infer causality from correlation?

You have a 1100 balance on your 15 credit card you have

You have a $1,100 balance on your 15% credit card. You have lost your job and been unemployed for 6 months. You have been unable to make any payments on your balance. However, you received a tax refund and want to pay of ...

How do international factors affect decision making

How do international factors affect decision making? Although the same basic principles of capital budgeting apply to both foreign and domestic operations, there are some key differences. For example, cash flows must be ...

Excel assignment you are going to purchase a new house

Excel Assignment You are going to purchase a new house valued at $250,000 by making the down payment of 20% and borrowing the rest as a 30-year fixed rate mortgage of 5.25%. Solve the problem by creating an Excel spreads ...

1 what are transition economies what are some of the

1. What are transition economies? What are some of the important changes occurring in transition economies? 2. Discuss some of the major legal systems that exist around the world. What are some of the most important diff ...

1 how did the cold war era contribute to the evolution of

1. How did the Cold War era contribute to the evolution of modern emergency management? 2. What disaster led to the creation of the National Flood Insurance Program? 3. Describe the events of the 1970s that led to the cr ...

A small droplet of liquid detergent falling through air in

A small droplet of liquid detergent, falling through air in a spray drying tower, has its diameter reduced as water evaporates from the surface. If we assume that the temperature of the liquid within the drop remains at ...

  • 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