Question: please help me and I will rate you D E F G B Expected Returns: Discrete Distribution Probability Distributions: Probability IM 0.3 16.00% 0.4 9.00%

B Expected Returns: Discrete Distribution Probability Distributions: Probability IM 0.3 16.00% 0.4 please help me and I will rate you

D E F G B Expected Returns: Discrete Distribution Probability Distributions: Probability IM 0.3 16.00% 0.4 9.00% 0.3 19.00% 19.00% 7.00% 10.00% ancov O WN- Formulas #N/A #N/A #N/A #N/A 10 Expected return 11 12 Standard deviation 13 14 15 16 Video Excel Online Tutorial Excel MC OLULUI CU RUCIVIC Expected Returns: Discrete Distribution The market and Stock I have the following probability distributions: Probability IM ry 0.3 16.00 % 19.00 % 0.4 9.00 7.00 0.3 19.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places. Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places. % b. Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places. Calculate the standard deviation for Stock ). Do not round intermediate calculations. Round your answer to two decimal places. %

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!

Home Insert Arial X fx A B Expected Returns: Discrete Distribution Probability Distributions: Probability 0.3 rj 21.00% 6.00% 10.00% 0.4 0.3 rj 10 Expected return 11 12 Standard deviation 13 14 15 16...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Hi You are now working on P9 and T9 and I owe you 70 dollars for Friday 22 April Kindly find P10 and T10 - due 25 April and offering 30 dollars Kindly find ASSIGNMENT 2 - My offer for this is 70...

Video Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock have the following probability distributions: Probability IM 0.3 12.00 % 22.00 % 0.4 9.00 4.00 0.3...

ge learning X berline Student Wort ex.html/deploymentid-5932632365234278943577737914&SON=9781337909606994538661&snapshotid=20663308 M Connect login Log in to Carwas Scentsy Dashbowd uncp emal North...

3 Answer Sheet Due by midnight December 3rd 2015. Copy and paste the part of this answer sheet below the dotted into a Course Message titled Assignment 3 Answer Sheet. Enter the letter of the best...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability r M r J 0.3 14.00 % 21.00 % 0.4 8.00 5.00...

I need question one answered. Attached are documents from the chapter to help add in the question. A 1 D E F Final Examination FINC 5880 3 5 6 7 8 9 10 11 C Question 6. (15 points) Your portfolio is...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability j 0.3 14.00 % 21.00 % 0.4 8.00 3.00 0.3...

please answer correctly, will rate b. What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. c. What is the required return of Fund P? Do not...

Draw the cash flow diagram for the following statements: $70K Purchase price with 20% down ($14K) Monthly expenses (utilities, maintenance, insurance, etc..) = $200 Monthly P&I = $345 (starts in...

IRC issues a note with no stated interest rate in exchange for a machine. In accounting for the transaction, which of the following statements is true? A. Both the note and machine are recorded at...

16. McCormick and Company, Inc., reported the following in its annual report for the fiscal year ended November 30, 2021: Analyze: 1. Based on the information presented above, which categories might...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...