I need help with excel formulas for ratios. I'm not sure if I am doing it correctly. I need someone to review my spreadsheet (sheet 4) and help me with the ratios. I need to calculate the ratios from the figures off of the other sheets.

Thanks,

Jonie

ACCT 370 - Excel Project Jonie Trevino CVS Health Corp. (CVS) Company Name CVS Health Corporation Ticker Symbol CVS Industry Retail and Drug Products or Services Offered Health, Medicine, Beauty, Houshold & Groceries Major Competitors Wal-Greens, Rite-Aid, Wal-Mart 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Dec. 31, 2015 Dec. 31, 2014 Dec. 31, 2013 Income Statement [Abstract] Net revenues Cost of revenues Gross profit Operating expenses Operating profit Interest expense, net Loss on early extinguishment of debt Income before income tax provision Income tax provision Income from continuing operations Income (loss) from discontinued operations, net of tax Net income Net income attributable to noncontrolling interest Net income attributable to CVS Health $ 153,290 126,762 $ 26,528 17,074 9,454 838 0 8,616 3,386 5,230 9 5,239 (2) $ 5,237 $ 139,367 114,000 $ 25,367 16,568 8,799 600 521 7,678 3,033 4,645 (1) 4,644 0 $ 4,644 $ 126,761 102,978 $ 23,783 15,746 8,037 509 0 7,528 2,928 4,600 (8) 4,592 0 $ 4,592 $ 4.65 $ 3.98 $ 3.78 0.01 0 (0.01) Net income attributable to CVS Caremark (in dollars per share) $ 4.66 $ 3.98 $ 3.77 Weighted average common shares outstanding (in shares) 1,118 1,161 1,217 $ 4.62 $ 3.96 $ 3.75 0.01 0 (0.01) Net income attributable to CVS Caremark (in dollars per share) $ 4.63 $ 3.96 $ 3.74 Weighted average common shares outstanding (in shares) 1,126 1,169 1,226 Dividends declared per common share (in dollars per share) $ 1.40 $ 1.10 $ 0.9 Basic earnings per share: Income from continuing operations attributable to CVS Caremark (in dollars per share) Loss from discontinued operations attributable to CVS Caremark (in dollars per share) Diluted earnings per share: Income from continuing operations attributable to CVS Caremark (in dollars per share) Loss from discontinued operations attributable to CVS Caremark (in dollars per share) Consolidated Balance Sheets - USD ($) $ in Dec. 31, 2015 Dec. 31, 2014 Dec. 31, 2013 Millions Assets: Cash and cash equivalents $ 2,459 $ 2,481 $4,089 Short-term investments 88 34 88 Accounts receivable, net 11,888 9,687 8,729 Inventories 14,001 11,930 11,045 Deferred income taxes 1,220 985 902 Other current assets 722 866 472 Total current assets 30,378 25,983 25,325 Property and equipment, net 9,855 8,843 8,615 Goodwill 38,106 28,142 26,542 Intangible assets, net 13,878 9,774 9,529 Other assets 1,440 1,445 1,515 Total assets 93,657 74,187 71,526 Liabilities: Accounts payable 7,490 6,547 5,548 Claims and discounts payable 7,653 5,404 4,548 Accrued expenses 6,829 5,816 4,768 Short-term debt 0 685 0 Current portion of long-term debt 1,197 575 561 Total current liabilities 23,169 19,027 15,425 Long-term debt Deferred income taxes Other long-term liabilities Commitments and contingencies Redeemable noncontrolling interest Long -term liabilities Shareholders' equity: Preferred stock, par value $0.01: 0.1 shares authorized; none issued or outstanding Common stock, par value $0.01: 3,200 shares authorized, 1,699 shares issued and 1,101 shares outstanding at December 31, 2015 and 1,691 shares issued and 1,140 shares outstanding at December 31, 2014 Treasury stock, at cost: 597 shares at December 31, 2015 and 550 shares at December 31, 2014 Shares held in trust: 1 share at December 31, 2015 and 2014 Capital surplus Retained earnings 26,267 5,437 1,542 0 39 33,246 11,630 4,036 1,531 0 0 17,197 12,841 3,901 1,421 0 17 17 17 (28,886) (24,078) (20,169) (31) (31) (31) 30,948 35,506 30,418 31,849 29,777 28,493 18,163 0 Accumulated other comprehensive income (loss) (358) (217) (149) Total CVS Health shareholders' equity Noncontrolling interest 37,196 7 37,958 5 37,938 0 Total shareholders' equity 37,203 37,963 37,938 $ 93,657 $ 74,187 $71,526 Total liabilities and shareholders' equity 2459 88 11888 14435 12 Months Ended CVS Historial Ratio Analysis Dec. 31, 2015 Liquidity Ratios Current Ratio Quick Ratio Leverage Ratios Debt to Total Assets Ratio Debt Equity Ratio Long-Term Debt to Equity Times Interest Earned Ratio Activity Ratios Inventory Turnover Fixed Assets Turnover Total Assets Turnover Accounts Receivable Turnover Average Collection Period Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Total Assets (ROA) Return on Stockholders' Equity (ROE) Earnings Per Share (EPS) Price Earnings Ratio Dec. 31, 2014 Dec. 31, 2013 4.04 0.62 3.90 0.64 4.64 0.84 0.25 0.62 0.89 11.28 0.26 0.50 0.45 13.80 0.22 0.41 0.48 15.79 2.68 4.10 0.46 9.16 2.76 3.99 0.48 9.92 4.66 7.36 0.89 14.52