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

Show how a combination of interest rate caps and floors can

Show how a combination of interest rate caps and floors can be equivalent to an interest rate swap ? What are the advantages and disadvantages of an interest rate collar over an interest rate cap? Explain how the Black m ...

Question 1 diane carter is interested in buying a five-year

Question 1: Diane Carter is interested in buying a five-year zero coupon bond with a face value is $1,000. She understands that the market interest rate for similar investments is 9 percent. Assume annual coupon payments ...

A firm has previously issued fixed rate noncallable debt

A firm has previously issued fixed rate noncallable debt. Because interest rates are perceived to be temporarily high, the firm would like to have the flexibility of calling the debt later when rates are expected to fall ...

Us federal law regulates some futures market participants

U.S. federal law regulates some futures market participants, even though they do not directly participate in trading. Explain the difference between an introducing broker, a commodity trading advisor, a commodity pool op ...

Name at least four factors which can reduce in-service

Name at least four factors which can reduce in-service clamping force ? Name at least three factors which can be prevented or at least reduced by sufficient in-service clamping force ? Name at least four factors which de ...

Ne at least three ways to reduce the possibility of scc

Name at least three ways to reduce the possibility of SCC ? Which is better, a relatively small anode or a large one and why? Is coating a fastener always helpful in fighting corrosion resistance, even if there are minor ...

1 a 75000 mortgage is obtained at 9 it should be paid in 20

1. A $75,000 mortgage is obtained at 9%. It should be paid in 20 years. Find the payment at the start of each month. 2. Herb is a self-employed agent who is setting his own retirement fund. He is depositing $17,000 a yea ...

1 describe a special purpose building2 compare and contrast

1. Describe a special purpose building. 2. Compare and contrast two widely different types of commercial real estate loans that you had not previously had any experience discussed in this chapter? 3. Discuss each of the ...

1 present value of annuity what formula is used to

1. Present Value of Annuity. What formula is used to determine the present value of an annuity? What does the present value of an annuity indicate? 2. Future Value of Annuity. How would you modify the FVA equation to det ...

1 define external validity and indicate its importance to

1. Define external validity, and indicate its importance to scientific progress. 2. Why is it never possible to know whether a research finding will generalize to all populations of individuals? How do behavioral scienti ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen