Discuss trends in ratios for CVS and Walgreens. Compare ratios. Discuss ratios in terms of if the companies are doing well or poorly
2015 5.67% 2016 3.6 2017 794 ROR 2011 4.50 2011 LIT 2016 2.00 LER 2017 3.5 Pet Maris RA 2011 3019 4.15 2.53% 2001 2090 21 2010 2017 2. Asal Turner 2018 2013 1.43 1. 2020 1.1 100 100004 N0000 VET 14.00 Reve Other Tuleve Colore mars 000 100 NOD 100 000 100.00 000 1.25 6 Receivables Turner very Tur Pued As Turnover 900 SMS ET 125 1.00 17.11 18 113 0.01 w SIZE ww KERET TA 12V 116 . 10 00 00 101 Os 10 10 00 000 0.00 son Generalne HADED Der A OC Orari 000% 00 000 S w 19745 12. 2013 GRE 4823 457 2014 1159 1199 0 DOIN 2014 ME VEO SD NORD estar com Nettet 491 06 -10 - SO DO GOIN 0001 0009 000 Ore Non Orang Currency Exchange Como Other in Operating in ESTE Unte WOOD 0.00 000 000 300 0004 200 WOO MOD WO DON 4.47% AT 4173 Other Non Operating Inc (Exp) Currency Exchange Gains (Loss) Other Non-Operating Inc (Exp.) EBT Excl. Unusual Items D -0.01% 0.00% 0.00% 5.80% E 0.00% 0.00% 0.00% 5.36% F 0.00% 0.00% 0.00% 4.72% G 0.00% 0.00% 0.00% 4.17% H 0.00% 0.00% 0.00% 3.83% 0.01% 0.00% 0.00% 4.47% Restructunng Charges Merger & Related Restruct. Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest Asset Whitedown Legal Settlements Other Unusual Items EBT Incl. Unusual Items 0.00% 0 18% 0.00% 0.00% 0.00% 0.00% 0.00% 5.62% -0.02% -0.16% 0.00% 0.00% 0.00% 0.05% -0.36% 4.87% -0.12% -0.04% - 10% 0.00% 0.00% 0.00% 0.00% 4.47% 0.00% -0.25% -3.17% 0.00% -0.02% 0.00% 0.00% 0.73% 0 09% -0.19% 0.00% 0.00% 0.00% 0.00% -0.03% 3.52% -0.04% -0.14% 0.00% 0.00% 0.00% 0.00% -0.03% 4.26% Income Tax Expense Earnings from Cont. Ops 2 21% 3.41% 1.87% 3.00% 0.89% 3.59% 1.03% -0.31% 0.93% 2.59% 1.12% 3.15% Earnings of Discontinued Ops. Extraord. Item & Account Change Net Income to Company Minority Int. in Earnings Net Income 0.01% 0.00% 3.42% 0.00% 0.00% 3.00% 0.00% 0.00% 3.58% 0.00% 0.00% -0.31% 0.00% 0.00% 2.59% 0.00% 0.00% 3.15% 0.00% 3.42% 0.00% 3.00% 0.00% 0.00% 3.58% 0.00% -0.31% 0.00% 2.59% 3.14% Pref Dividends and Other Ad) 0 02% 0.02% 0.01% 0.00% 0.00% 0.00% NI to Common Incl Extra Items NI to Common Excl. Extra Items 3.40% 3.39% 2.98% 2.98% 3.57% 3.58% -0.31% -0.31% 2.59% 2.59% 3.14% 3.14% Profit Margin for ROA 3.42% 3.00% 3.58% -0.31% 2.59% 3.14% Income Statement CS Balance Sheet CS Income Statement CVS Walgreens N O 2015 5.74% 2017 5.80% 2018 7.29% 2011 5.00% 2029 1.06% 7 8 2015 3.56% 2017 3.28% Pret Margin for ROA 2018 2018 3.77% 2.57% 2020 0.66% 2016 1:51 2017 1.79 Asset Turnover 2018 1.99 2012 203 2020 1.81 100.00% 0.00% 100.00% 10000 100 DON 0.00% 0.00N 100.00% 100.00% Receivables Tumove Inventory Turnover Fixed Asset Turnover 13.75 0.00 535 18.49 9.98 6.04 20.30 11.02 6:55 20.59 11.52 6.36 2007 1191 2.23 10 1 Revenue 100.00% 100.00% 12 Other Revenue 0.00% 0.00% 1 Total Revenue 100.00% 100.00% 14 5 Cost Of Goods Sold 0.00% 75.33% 16 Gross Profit 25.46% 24.67% 7 Seling General & Admin Exp 19.36% 10.90 1 R&D END 0.00% 000N Depreciation & Nort 000 0.00% Other Operating Expenseco 0.00% 000N 2 Other Operating Exp.. Total 19.95% 19.98% 76 59% 23.41% 78.035 21.97% 79 50N 20.50% 18.73% 000% 18.45 0.00% 0.00% 0.00% 000 0.00% 18.11% OOON 0.00% 0.DON 18,73% 18.49% 18.11% 5 Operating Income 5.50% 4.69% 4.68% 3.52% 2.39% Therest Expense interest and invest income 9 Nerinterest Eue. 0 40 000% -0.49% 0548 000 -0.54% 044% 000 -0.44% 0 499 0.00% -0.40% 046 0.00 -0.45% + 0.20% 0.05% 1 Other Non-Operating in Exp) 007% 2 Carrency Exchange Bains (Loss 001% Other Son Operating Exp) 0019 EBTExel Unusual tams 5.06% 0.12 -0.00N 00 4.31% 0194 0.00 OD0 452% 0 149 009 0.00% 3.25% 2.09% Income Statement CS Balance Sheet CS Income Statement CVS Walgreens * F -0.54% G -0.44% H -0.49% -0.45% 0.12% -0.03% 0.07% 4.31% 0.19% 0.03% 0.06% 4.52% 0.14% 0.09% 0.00% 3.25% 0.26% 0.05% -0.15% 2.09% D E 29 Net Interest Exp. -0.49% 30 31 Other Non-Operating Inc. (Exp.) 0.07% 32 Currency Exchange Gains (Loss 0.01% 33 Other Non-Operating Inc. (Exp.) -0.01% 34 EBT Excl. Unusual Items 5.06% 35 36 Restructuring Charges -0.36% 37 Merger & Related Restruct Char 0.00% 38 Impairment of Goodwill 0.00% 39 Gain (Loss) On Sale Of Invest -0.21% 40 Asset Writedown -0.07% 41 Legal Settlements 0.00% 42 Other Unusual Items 0.00% 43 EBT Incl. Unusual Items 4.42% 44 45 Income Tax Expense 0.85% 46 Earnings from Cont. Ops. 3.57% 47 48 Earnings of Discontinued Ops. 0.00% 49 Extraord Item & Account Chang 0.00% 50 Net Income to Company 3.57% 51 52 Minority Int. in Earnings -0.02% 53 Net Income 3.56% -0.20% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 4.11% 0.00% 0.00% 0.00% 0.11% -0.04% 0.00% 0.00% 4.58% 0.00% 0.00% 0.00% 0.00% -0.05% 0.00% 0.13% 3.32% 0.00% 0.00% -1.21% -0.05% -0.29% 0.00% 0.12% 0.67% 0.64% 3.47% 0.76% 3.82% 0.43% 2.89% 0.13% 0.54% 0.00% 0.00% 3.47% 0.00% 0.00% 3.82% 0.00% 0.00% 2.89% 0.00% 0.00% 0.54% -0.02% 3.45% -0.01% 3.82% 0.01% 2.91% 0.01% 0.55% 54 55 Pref. Dividends and Other Adj. 0.00% 0.00% 0.00% 56 0.00% 0.00% 3.45% 3.45% 3.82% 3.82% 57 NI to Common Incl Extra Item: 3.56% 58 NI to Common Excl. Extra Iter 3.56% 59 60 Profit Margin for ROA 3.56% 61 2.91% 2.91% 0.55% 0.55% 3.28% 3.77% 2.87% 0.66%