1. Using the data in the exhibit below, please calculate the following ratios for BMW. Has performance improved over the quarter ending Q1-2020 from Q1-2017? (18 points) (a) Gross profit margin in Q1-2020 versus Q1-2017 (b) Operating profit margin in Q1-2020 versus Q1-2017 (c) Net profit margin in Q1-2020 versus Q1-2017 (d) Current ratio in Q1-2020 versus Q1-2017 (e) Debt-to-equity ratio in Q1-2020 versus Q1-2017 (1) Times-interest-earned in Q1-2020 versus Q1-2017 2. Based on these ratios and our case discussion, what initiatives would you recommend BMW implement to address autonomous driving? Please describe. (12 points) Balance Sheet Q1-2020 Q1-2017 13.990 7.143 18,594 13.656 59.005 17.732 91,589 68,531 2.178 Income Statement (Emillion) Q1-2020 Q1-2017 Total revenue 23.252 23.448 Cost of revenue 19.718 18.637 Gross profit 3,534 4.811 SG&A 2,165 Other expense, net (6 (13) Operating income 1.375 2.646 Interest expense 80 98 Othernet (497 457 Income before tax 798 3,005 Tax provision 224 856 Net income $74 2.119 Cash Inventories Other current assets Total Current Assets PPE, Net Other assets Total Assets Total Current Liabilities Non-current liabilities Total Liabilities Shareholders' equity 22.731 112,942 227.262 80.272 85.742 166,014 61.248 17.704 105.365 191,600 69.881 72.138 142.019 49.581 1. Using the data in the exhibit below, please calculate the following ratios for BMW. Has performance improved over the quarter ending Q1-2020 from Q1-2017? (18 points) (a) Gross profit margin in Q1-2020 versus Q1-2017 (b) Operating profit margin in Q1-2020 versus Q1-2017 (c) Net profit margin in Q1-2020 versus Q1-2017 (d) Current ratio in Q1-2020 versus Q1-2017 (e) Debt-to-equity ratio in Q1-2020 versus Q1-2017 (1) Times-interest-earned in Q1-2020 versus Q1-2017 2. Based on these ratios and our case discussion, what initiatives would you recommend BMW implement to address autonomous driving? Please describe. (12 points) Balance Sheet Q1-2020 Q1-2017 13.990 7.143 18,594 13.656 59.005 17.732 91,589 68,531 2.178 Income Statement (Emillion) Q1-2020 Q1-2017 Total revenue 23.252 23.448 Cost of revenue 19.718 18.637 Gross profit 3,534 4.811 SG&A 2,165 Other expense, net (6 (13) Operating income 1.375 2.646 Interest expense 80 98 Othernet (497 457 Income before tax 798 3,005 Tax provision 224 856 Net income $74 2.119 Cash Inventories Other current assets Total Current Assets PPE, Net Other assets Total Assets Total Current Liabilities Non-current liabilities Total Liabilities Shareholders' equity 22.731 112,942 227.262 80.272 85.742 166,014 61.248 17.704 105.365 191,600 69.881 72.138 142.019 49.581