Question: Please Solve on Excel Assuming the following returns and corresponding probabilities for asset ABC, compute its average return, risk and coefficient of variation. Asset ABC

Please Solve on Excel Please Solve on Excel Assuming the following returns and corresponding probabilities for

Assuming the following returns and corresponding probabilities for asset ABC, compute its average return, risk and coefficient of variation. Asset ABC Rate of Return Probability 10% 30% 15% 40% 20% 30% If the coefficient of variation of asset XYZ is 0.96, which asset should you prefer? Why? Question 3 _(20 points) You and your heirs have an investment opportunity to receive $1250 forever as a perpetuity if you invest today $15625. If the interest rate does not change, and you want to transform the perpetuity into an ordinary annuity of $1250 for twenty years, how much money would you need to invest today? Question 4 __(20 points) Suppose that you are considering investing in two stocks Arab Cotton (AC) and the Commercial International Bank (CIB). Your research results about these two stocks are: the average return of AC is 20% and the average return of CIB is 15%. The variance of AC and the CIB are 0.36 and 0.122 respectively and the covariance between them is 0.046.What is the average return and standard deviation of the portfolio that invests 50% in AC and the rest in CIB? What is the coefficient of variation of this portfolio? Would you choose it

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Given the table below, what are the expected value and the standard deviation of returns for asset A? (b) Given the table below, what are the expected value, standard deviation of returns, and...

Question 2 The table below shows key financial data for two supermarket chains that compete in the grocery retail industry: Alwi and Pemi Alwi Pemi Sales RM120,451 RM30,258 Cost of goods sold 62 523...

its 2) Assuming the following returns and corresponding probabilities for asset A, compute range, expected return, standard deviation and coefficient of variation. Asset A Rate of Return Probability...

answer with workings/solution pls. 4. Assuming the following returns and corresponding probabilities for Asset D: Rate of return Probability 10% 30% 15% 40% 20% 30% Compute for: a. Expected rate of...

Medjo Companys current liabilities are 60k, its long term liabilities are 180k, and its working capital is 90k. If Medjo Cos debt to equity ratio is 40%, how much should be its total long term...

Assuming the following returns and corresponding probabilities for asset A, compute its standard deviation and coefficient of variation. Asset A Rate of Return Probability 10% 30% 15 40 30 20

Assuming the following returns and corresponding probabilities for Asset A: Rate of return Probability 10% 30% 15% 40% 20% 30% Compute for the following: a) The standard deviation b) The Coefficient...

Question 2 Risk and Return a) Assuming the following returns and corresponding probabilities for asset A. Asset A Rate of Return Probability 109 30% 15 40 20 30 Calculate The standard deviation The...

a) Assuming the following returns and corresponding probabilities for asset A, if the expected return of Asset A is 15%, what is the standard deviation of Asset A? Asset A Rate of Return Probability...

JUDUIT to the problem 1. Page 231 Questions and Problem 1 & Page 232 problems 11 and 12. 2. A Common stock of General Motors closed at $38.16 today 11/07/19 The company paid 50.40 last quarter and...

Calculate E' for the following reaction: Succinate + 1/2 O2 ( Fumarate + H2O

Athletic Endurance Company had the following stockholders equity section on the December 31, 2010, balance sheet: Preferred stock, 6%, $120 par, cumulative ........$1,170,000 Common stock , $1.50 par...

includes conscious or unconscious errors in cognition that impact an individual's judgments, assumptions, and decision - making. Response 2 of 3 : includes the lack of complete representational data....

. Explain the difference between Interpolation and Extrapolation . Use an example like the one we used in class. ( Mississippi river length or Bitcoin prices ) make sure to indicate which points are:...