Question

DISCUSS QUESTION #1 SolarSun Corporation is evaluating asset A. The annual rate of return and probabilities associated with Asset A are as follows RATE OF RETURN PROBABILITY 10% 13% 16% ASSET 10% 70% PRIMARY POST: Question 1 -Calculate the expected return, the standard deviation, the coefficient of variation and the range of returns for Asset A. Carry all values out 2 decimal places-ex. 3.45% 1) EXPECTED RETURN 2) STANDARD DEVIATION= 3) COEFFICIENT OF VARIATION = 4) RANGE OF RETURNS- 68% 95% 99%

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home Page Layout FormulasData Review View dd-Ins Define Name e Use in Formula- Trace Precedents Q Show Formulas Trace Dependents ◆ Error Checking Remove Arrows Calculate Now Watch Calculation Calculate Sheet Insert Autosum Recently Financial Logical Tet Date & Lookup & Math More Function Name Evaluate Formula Window Options ? Create from Selection Defined Names Used Time Reference ▼ & Tng Functions ▼ Manager Function Library Formula Auditing Calculation BD458 BC BD BE BF BG BH BI BJ BK 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 4EMV MEAN STDV RETURN EXPECTED VARIANCE PROB RETURN PROB *(R-E(R))A2 10 2.304 0.648 1.008 0.7 16 11.2 14.80 ANS EXPECTED RETURN - E(R)- VARIANCE 3.96 ANS ANDARD DEVIATION OF RETURN ANS COEEFICIENT OF VARIATION-STANDARD DEVIATION/MEAN 0.13 1.99/14.80 ANS RANGE OF RETURN FORMULA: EXPECTED RETURN t/- Z VALUE*(STANDARD DEVIATION) 68% 95% 99% 14.80 t/- (1.96) (1.99) 14.80 +/- (2.58)(1.99) (14.80-1.99, 14.801.99) (14.80 -3.9, 14.80 3.9) (14.80-5.13, 14.80+5.13) (12.81, 16.79) (10.90, 18.70) (9.67, 19.93) DEAR Sheet2 TIME SERIES Corr REGRESSIONCAMERAEXP RETURN TREND MATRDX INTERVAL, NORMALHYPOTHESIS 01-02-2019

Add a comment
Know the answer?
Add Answer to:
DISCUSS QUESTION #1 SolarSun Corporation is evaluating asset A. The annual rate of return and probabilities...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • SolarSun Corporation is evaluating asset A. The annual rate of return and probabilities associated with Asset...

    SolarSun Corporation is evaluating asset A. The annual rate of return and probabilities associated with Asset A are as follows: RATE OF RETURN PROBABILITY 10% 13% 16% 10% 20% 70% ASSET PRIMARY POST Question 1 . Calculate the expected return, the standard deviation, the coefficient of variation and the range of retums for Asset A. Carry all values out 2 decimal places-ex. 3.45% 1) EXPECTED RETURN 2) STANDARD DEVIATION 3) COEFFICIENTOF VARIATION- 4) RANGE OF RETURNS= 68% 95% 99% 2...

  • Asset A has an expected return of 15% and Asset B has an expected return of...

    Asset A has an expected return of 15% and Asset B has an expected return of 12%. Based on a probability distribution, the standard deviation for Asset A is 10% and the standard deviation for Asset B is 5%. a.) Based only on the standard deviation, which investment is less risky? Discuss your reasons for your selection including why you feel that asset is less risky. b.) Calculate the coefficient of variation for each asset and post your answers. Based...

  • Swift manufacturing must choose between two asset purchases. The annual rate of return and the related...

    Swift manufacturing must choose between two asset purchases. The annual rate of return and the related probabilities given in the following table summarises the firms analysis to this point Rate of return Probability Rate of return Probability -10% .01 10% .05 10 .04 15 .010 20 .05 20 .10 30 .10 25 .15 40 .015 30 .20 45 .30 35 .15 50 .15 40 .10 60 .10 45 .10 70 .05 50 80 .04 100 .01 For each project compute...

  • Asset A has an expected return of 26% and a standard deviation of 18% Asset has...

    Asset A has an expected return of 26% and a standard deviation of 18% Asset has an expected return of 22% and a standard deviation of 16%. What is the coefficient of variation for Asset A? carry to four decimal places

  • Excel Online Activity: Evaluating risk and return Question 1 0/10 Submit Excel Online Structured Activity: Evaluating...

    Excel Online Activity: Evaluating risk and return Question 1 0/10 Submit Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below....

  • Integrative-Expected return, standard deviation, and coefficient of variation An asset is currently being considered by Perth...

    Integrative-Expected return, standard deviation, and coefficient of variation An asset is currently being considered by Perth Industries. The probability distribution of expected returns for this asset is shown in the following table, EEB a. Calculate the expected value of return, r, for the asset. b. Calculate the standard deviation, σ, for the asset's returns c. Calculate the coefficient of variation, CV, for the asset's returns a. The expected value of return, r, for the asset is 13%. (Round to two...

  • Problem 8.01 (Expected Return) Question 1 Check My Work (No more tries availal eBook A stock's...

    Problem 8.01 (Expected Return) Question 1 Check My Work (No more tries availal eBook A stock's returns have the following distribution: Demand for the Probability of This Rate of Return If Company's Products Demand Occurring This Demand Occurs Weak (30%) (10) Below average Average Above average Strong Assume the risk-free rate is 4% Calculate the stock's expected return, standard deviation coefficient of variation, and Sharpe ratio. Do not round Intermediate calculations. Round your answers to two decimal places. Stock's expected...

  • Having difficulty arriving at the solution of this question. 9. Risk and Return 9. Risk &...

    Having difficulty arriving at the solution of this question. 9. Risk and Return 9. Risk & Return Situation Situation Probability Returns Recession 0.15 Asset A Asset B Probability Returns Exp Ret Deviation Deviations Exp Ret 2% -30 % 0.15 Normal 0.55 10% 0.55 18 % Boom 31% 0.30 15% 0.30 Expected Return= Expected Return Risk= Risk Coefficient of Variation Coefficient of Variation Asset B Asset A Parameters Asset B Asset A Expected returns Risk Coefficient of Variation

  • Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 6.7 pe...

    Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 6.7 percent and the standard deviation was 12.6 percent. a. What is the probability that your return on this asset will be less than -10.1 percent in a given year? Use the NORMDIST function in Excel to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b.What range of...

  • The following are the expected outcomes for a corporation and the probabilities associated with each outcome....

    The following are the expected outcomes for a corporation and the probabilities associated with each outcome. If demand is               Outcome                                Probability Poor                            0%                                           .10 Average                      10%                                         .40 Good                           15%                                         .30 Excellent                     20%                                         .20 First, Calculate the expected rate of return, r^, r with a hat.   Show all work!!!! 10 points Next, Calculate the Standard Deviation, sigma    Show all work!!!!! 15 points Finally, Calculate the Coefficient of Variation   Show all work!!!!!  2 points

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT