Solve for all the ratios and Common Size Income Statement and Balance Sheet and other ratios as shown in the Spreedsheet. (Fill out the Blue Cells).

Ratio Computation Complete the ratios using the data available for CVS Health Corp (CVS US). Using actual financial statements introduces students to real world decisions Short-Term Solvency, or liquidity, Measures FY 2018 FY 2019 Current ratio Quick ratio: Cash ratio: Long-Term Solvency Measures Total debt ratio: Debt-equity ratio: Equity multiplier Times interest earned: Cash coverage: Asset Management, or Turnover, Measures Inventory turnover Days' sales in inventory: Receivables turnover: Days' salers in receivables: Total asset turnover PM TAT EM ROE Profitability Measures Profit margin Return on assets (RCA) Return on equity (ROE): Dupont identity Return on equity (ROE) CVS Health Corp (CVSUS). Adjusted CVS Health Corp (CVS US) - Adjusted Commonsite FY 2019 FY 2018 $ $ $ $ $ $ $ $ FY 2018 194,579,00 $ 165 735 00 15 8 844 00 IS 163.041 00 15 163041.00 S 31.638.00 $ 20,74700 FY 2019 256,776,00 192.64300 64133.00 211 248.00 211 24800 45,528.00 32 62500 395.00 Revenue + Sales & Services Revenue Other Reven Cost of Revenue Cost of Goods & Services Gross Profit Other Operating Income Operating Expenses Selling General Admin Sell & Marketing Research & Development Other Operating Epe Operating Income (Loss) Non Operating (Income) LOSS Interest Expense. Not +Interest Expense Interest income +Fordion Exch (Gan) LOSS Other Non-Op Income LOSS Pretax Income (Loss). Adjusted Abnormal Los Chis Mepocution Expense Early Fement of Debt At Write Down moment of Goodwill Gantosson Selection of Boss Lo sentiment -Restructure Other Abnormal Pretax income (Loss), GAAP Income Tax Expense (B) Core Income Tax - Dwored Income Tax Income (Loss) from Cont Ops - Extraordinary losses Descond Operations EXO Account Income (L066 Incl M Myres Net Income GAAP Preted as OM Net Income Avell to Common GAAP 5 5 $ 5 5 s S 5 5 S $ 5 S 32 229 00 12.903.00 2.911.00 3035 00 303500 36400 15 $ 20383 00 15 10,791.00 s 2615005 2.619.00 S 2.619 005 S $ 14.00) 8.176.00 6.770.00 IS 492.00 $ IS 4300 149.00 80005 (124.00) 9,99200 995.00 O 00 79.00 $ 5 S 20500 IS 231.00 $ 5 5 $ 8.997.00 206.00 301500 040 001 6.631.00 $ $ 5 1,405.00 $ 2002.00 1970 00 15 23.00 15 (596.00) 5 S 5 $ (596.00 12.00 169400) 5 5 S (594.00) 6,631.00 (3001 6.634.00 5 5 5 6 6,034.00 Commonsi FY 2018 FY 2019 FY 2018 Commonsi FY 2019 6,5810 40590 25220 17,6310 17.0310 00 16.450.0 8,0560 5.6800 2,373 0 19,6170 10 6170 00 17.5180 4,5810 5,113 01 Consolidated Balance Sheets - USD (S1 Sin Millions Total Assets + Cash Cash Equivals & STU - Cash & Cash Events +ST Invest Accounts & Notes RC Accounts Receivable Net Notes Receivable, Net Inventones Raw Materials Work in Process - Finished Goods Other inventory Oh ST Assets -Devative & Hedging Assets -Deferred Tax Assets Misc ST Assets Total Current Assets Property. Plant & Equip Net + Property Punt & EU Acumulated Depreciation *LT Investments & Receivables .LT Investments Other LT Assets Total Wangible Assets Goodwill Other Infang Asus Defned Tax Asses Derivative & Hoding Assets Meso LT A Total Noncurrent Assets Total Assets 4,5810 45,243.0 111490 25,000 15.52001 15,7320 15.739 01 124 1320 115 2020 78678 366240 5,1130 50,302.0 32,904 01 40.7940 16.890.0 173140 17 314 121 929 0 - 112,8700 79.7490 33 1210 39000 161,2130 196,4560 9,0590 172.147.0 222.449.0 37 1400 141350 01050 173710 Labies & Shareholders' Equity -Payables & Ac Acoounts Payable Accruedes & Dividends Payable Other Parts & Accruel - SED ST Bows + ST Lome Les +ST Finance Le + ST Ong L 230130 1,085 7200 25.70 5.3770 00 10930 21 2,090 00 1.6230 270 1595 3,7540 41210 00 12050 4876 Od 40700 44.0000 71.4440 70.86201 6420 6120 +ST Lease Labs +ST Finance Lease ST Operating Lease Curent Portion of LT Debt Other ST Labs Deferred Revenue + Derivatives & Hedging MSC ST Liabiti Total Current Liabilities LT Debt LT Borrowings LT Lease .LT Finance Lease LT Operating Leones Other LT Liabilities - Accrued Lises Pension -Deferred Revenu Deferred Tax Lates Derivatives & Hedge McLT Labs Total Noncurrent Liabilities Total Liabilities Preferred Equity and Honda Share Capital & AC - Common St Artional Padin Capital Treasury Stock Retained Earn Other Equity Before Minority Interest MinoryNon Controlling interest Total Equity Total Liabilities & Equity 43210 33.303.0 3.6250 63 9150 10.7070 7010 18.900 213510 00 250 co 72000 22.4600 00 20 00 7071 147710 93.0040 1379120 00 45 4400 170 45,4230 282280 40.9110 1030 38.9250 3180 685430 196.4540 140020 104.9760 150.279.0 00 45 0720 170 451550 282350 451000 OTO 30140 sos 141700 222.449.0