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 what is meant by loan servicing2 identify the principal

1. What is meant by loan servicing? 2. Identify the principal sources of mortgage company income. 3. How does the Farm Credit System structure the various agencies that handle oversight of the farm mortgage lending funct ...

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 ...

1 how can partial correlation help researchers explore

1. How can partial correlation help researchers explore possible causal relationships among correlated variables? 2. When is the Spearman rank-order correlation used? 3. What is a dichotomous variable? What correlations ...

1 which type of error do researchers usually regard as more

1. Which type of error do researchers usually regard as more serious? Why? 2. Explain what it means if a researcher sets the alpha level for a statistical test at .05. 3. What does it mean if the difference between two m ...

Finance assignmentpoveide a sulotion with it i dont want

Finance Assignment Poveide a sulotion with it I don't want only the answer Suppose that the current spot exchange rate is €1.50/£ and the one-year forward exchange rate is €1.60/£. The one-year interest rate is 5.4% in e ...

1 what are the main reasons that lenders charge interest on

1. What are the main reasons that lenders charge interest on loans? 2. Give an example of a financial transaction that requires a payment in the future. 3. If you deposit $1,000 in a bank CD that pays interest of 3% per ...

According to an article in the new york times it was the

According to an article in the New York Times, "It was the near universal agreement that potential conflicts were embedded in the [bond] ratings model." What is the bond ratings model? What potential conflicts are embedd ...

Emphasize receiver benefits-revise the following sentences

Emphasize receiver benefits:- Revise the following sentences to emphasize receiver benefits. a. We have been in the business of repairing sewing machines for more than 40 years. b. We need donations so that we can expand ...

In 2013 the lissa company paid dividends of 10000000 on

In 2013, the Lissa Company paid dividends of $10,000,000 on after-tax income (cash flow) of $25,000,000. Capital budget projects totaled $15,000,000 in 2013.   2013 was a normal year for earnings, dividends, and capital ...

What is the accounting identity list at least three of the

What is the accounting identity? List at least three of the assumptions underlying financial statements? Identify at least three current asset accounts ? What is the operating cycle ? Identify three current liability acc ...

  • 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