1

Question 18 (30 points) 1. Using the data in the exhibit below, please calculate the following ratios for Starbucks. Has performance improved over the six-month period ending 3/30/2020 from 3/30/2017? (18 points) Show the ratios for each metric below in the space provided. (a) Gross profit margin in 2020 versus 2017 (i.e. in the six months ending 3/30/2020 versus 3/30/2017) (b) Operating profit margin in 2020 versus 2017 (c) Net profit margin in 2020 versus 2017 (d) Current ratio in 2020 versus 2017 (e) Debt-to-equity ratio in 2020 versus 2017 (f) Times-interest-earned in 2020 versus 2017 Income Statement (Smillions) Total Revenue Cost of Sales Gross profit Store operating expenses Other operating expenses Depreciation and amortization General and administrative Restructuring charges Income from equity investors Operating income Interest expense Other income, net Earnings before tax Income tax Net income Six Months Ending 3/30/2020 3/30/2017 13,092.8 11,027.0 4,2342 4,436.2 8,858.6 6,590.8 3,542.9 3,224.6 196.7 280.1 707.4 503.3 840.7 683.1 5.6 Balance sheet Cash & short-term investment Accounts receivable net Inventory Other, current assets Total current assets Long-term & other investments PPE, net Operating lease Goodwil Other assets Total assets 3/29/2020 3/30/2017 2,572.3 2,462.3 941.0 870.4 1,492.2 1,364.0 744.4 586.7 5,749.9 5,283.4 619.7 1,0239 6,387,0 4,919.5 8,260.8 3,493.0 1,539.2 2,968.5 1,599.6 27,478.9 14,365,6 141.9 1,707,2 191.1 18.0 1,534.1 324.0 168.6 2,068.3 46.7 92.0 2, 113.6 7090 1,404.6 782.5 1,934.5 1,288.5 1.210.1 Accounts payable Acrrued liabilities Stored vahe card liability Short-term debt Other, current libilities Total current liabilities Long-tem debt Operating lease liability Other liabilities Total Libilities Total Equity 997.7 1,539.0 1,436,3 2,356.5 1.936 3 8,265.8 11,658,7 7,650.4 7,436.9 35,011.8 (7.532.9) 215.2 4,220.7 3,932.6 7553 8.908.6 5.457.0