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

Advanced financial advice instructions to candidates-1nbsp

Advanced Financial Advice: Instructions to candidates- 1.  You should familiarise yourself with this fact find prior to sitting the March 2016 examination. The March 2016 examination paper will be based upon this fact fi ...

An annuity has an interest rate of 7 and makes a quarterly

An annuity has an interest rate of 7% and makes a quarterly payment of $2000. The annuity is to last for 5 years. What is the present value of the annuity?

Provide a short discussion or definition of the following

Provide a short discussion or definition of the following terms: economics, finance, the financial system, net lenders, net borrowers, direct and indirect finance, financial markets, financial intermediaries, liquidity, ...

How would you use preferred and convertible instruments as

How would you use preferred and convertible instruments as investments to strengthen your portfolio?

Questionsuppose there are 3 stocks with the same expected

Question: Suppose there are 3 stocks with the same expected return of 10% per year and the same risk (standard deviation) of 50%. The correlation between any 2 of them is 0.5. 1) What is the risk of equal-weighted portfo ...

We know that iqs are normally distributed with a mean of

We know that IQs are normally distributed with a mean of 100 and standard deviations of 15. Suppose you want to verify this, so you take 100 random samples of size four each and, for each sample, find a 95% confidence in ...

Speculate as to why there has been an increase in reporting

Speculate as to why there has been an increase in reporting requirements in the last ten (10) years. Also, give your opinion on whether the increase in reporting requirements has improved investors' and creditors' confid ...

Your company has just sold a piece of property for 500000

Your company has just sold a piece of property for $500,000, but under the sales agreement, it won't receive the $500,000 until ten years from today. What is the present value of $500,000 to be received ten years from to ...

The mean salary offered to students who are graduating from

The mean salary offered to students who are graduating from Coastal State University this year is $24,230, with a standard deviation of $3678. A random sample of 85 Coastal State students graduating this year has been se ...

Defend the following statement once an innovation appears

Defend the following statement: Once an innovation appears, it will remain even after the impetus for its development disappears. Give an example.

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate