Answer Happy

stid Homework: Chapter 12 Review Homework Question 4, 12.3.8 Part 1 of 2 HW Score: 17.9%, 3.4 of 19 points O Points: 0 of 1 Save Help A formula in financial analysis in Return on equity net profit marginx total asset tumover equity multiplier Suppose that the equity multiplie is found at 45, but that the net profit margin is normally distributed with a mean of 41% and a standard deviation of 0.4%, and that the total asset tumover is normal distributed with a mean of 16 and a standard deviation of O 3 Set up and conduct a samping experiment to find the distribution of the return on equity Show how the results as a histogram would help explain your analysis and conclusions. CTD Place Equity Multiplier," "Net Profile Margin Mean" "Net Profit Margin Sud DevTotal Asset Mean" and "Total AssetSid Der in column A in rows 1. 2. 3. 4 and 5 respectively, and place their corresponding values in column B. Place the column headers "Net Profit Margin, Total Asset Turnover." and "Rotum on Equin cells C1, D1, and E1, respectively. To generate random numbers for the net profit margin based on the normal distribution in the colo in the Net Proft Margin column. enter the formula -NORM INV RANDO in the cells in column C below C1 To generate random numbers for the total asset turnover based on the normal distribution, in the cells in the "Total Asset Turnover column, enter the formule NORM.IN RANDO $D$0$$in the cells in column D below D1. To calculato return on aquily dobution values in the cells in column E below Et multiply pairs of values in the Net Profit" and "Total Asset Turnover coins by the value in cell 5852 Question Viewer