Homework: Chapter 12 Review Homework Question 4, 12.3.8 Part 1 of 2 HW Score: 179% 34 of 19 points O Points: 0 of 1 Save

[answerhappygod]

Homework Chapter 12 Review Homework Question 4 12 3 8 Part 1 Of 2 Hw Score 179 34 Of 19 Points O Points 0 Of 1 Save 1 (31.95 KiB) Viewed 28 times

Homework: Chapter 12 Review Homework Question 4, 12.3.8 Part 1 of 2 HW Score: 179% 34 of 19 points O Points: 0 of 1 Save Aformula in financial analysis Return on equity not profit margin total asset tumover x equity multiplier Suppose that the equity multiplier is fixed at 45, both the net profit margin is normally distributed with a mean of 4.1% and a standard deviation of 4% and that the total ansatturnover is normally distributed with a mean of 16 and a standard deviation of 0 3 Set up and conduct a sampling experiment to find the distribution of the return on oquity Show how the massa histogram would help explain your analysis and conclusions Place Equity Multiplier "Not Proft Margin Mean" "Net Profit Margin Sid Dev. "Total Asset Man and "Total Asset Std Der in colonn Ain row 1.2.3.4 and 5. respectively, and place their corresponding values in column B. Place the column headers "Net Pro Margin. Total Asset Turnove and "Retumon Equin cells C1, D1, and E1 respectively. To generate random numbers for the net profit margin based on the normal distribution. In the cells in the Net Profit Margin column enter the formula NORM INV RANDO $_$$$) in the calls in columbo C to generate random numbers for the total aset turnover based on the normal distribution in the cells in the Total Asset Turnover column, enter the fome =NORM INVO RANDO 100$ in the cells in column D below D1. To calculate taburn an equity distribution values in the cells in column E below Et multiply pairs of values in the Net Profr and "Total Asset Tumover" columns by the value in 5852