Hihf78605,

Would you be able to provide some input on the outcome of theratios in the spreadsheet youworked on for me? I have the following assignment due tomorrow and need some additional input?Below is the requirements of the assignment.

Write a 1000-word report that summarizes the results of the 3-year ratio analysis on the company you selected for the Excel project. Clearly state the implications of the ratio analysis concerning the following aspects of the organization:

1. Liquidity
2. Solvency
3. Financial Leverage
4. Asset Efficiency
5. Profitability
6. MarketValue
7. Pleaseletmeknowifyoucanprovideassistant.
8. Thankyou!
9. 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 $ 153,290 126,762 $ 26,528 17,074 9,454 838 0 8,616 3,386 5,230 $ 139,367 114,000 $ 25,367 16,568 8,799 600 521 7,678 3,033 4,645 $ 126,761 102,978 $ 23,783 15,746 8,037 509 0 7,528 2,928 4,600 9 5,239 (1) 4,644 (8) 4,592 (2) $ 5,237 0 $ 4,644 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 Income (loss) from discontinued operations, net of tax Net income Net income attributable to noncontrolling interest Net income attributable to CVS Health 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 Millions Assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Deferred income taxes Other current assets Total current assets Property and equipment, net Goodwill Intangible assets, net Other assets Dec. 31, 2015 Dec. 31, 2014 Dec. 31, 2013 Total assets $ 2,459 88 11,888 14,001 1,220 722 30,378 9,855 38,106 13,878 1,440 93,657 $ 2,481 34 9,687 11,930 985 866 25,983 8,843 28,142 9,774 1,445 74,187 $4,089 88 8,729 11,045 902 472 25,325 8,615 26,542 9,529 1,515 71,526 Liabilities: Accounts payable Claims and discounts payable Accrued expenses Short-term debt Current portion of long-term debt Total current liabilities 7,490 7,653 6,829 0 1,197 23,169 6,547 5,404 5,816 685 575 19,027 5,548 4,548 4,768 0 561 15,425 Long-term debt Deferred income taxes Other long-term liabilities Commitments and contingencies Redeemable noncontrolling interest Long -term liabilities 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 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 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 Dec. 31, 2015 Dec. 31, 2014 Dec. 31, 2013 CVS Historial Ratio Analysis 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 Market price /EPS = PE ratio But as Market price is not given it may not be clacualted. Do not average for any of the ratio as the average for 2013 is not possible therefore all three years ratios to be calculated wihtout using ratios to make comparison meaningful. $ 1.31 0.62 1.37 0.64 1.64 0.84 0.60 1.52 0.89 11.28 0.49 0.95 0.45 14.67 0.47 0.89 0.48 15.79 9.05 2.42 1.64 12.89 28.31 9.56 2.89 1.88 14.39 25.37 9.32 2.74 1.77 14.52 25.13 17.31% 6.17% 3.41% 5.58% 14.06% 4.66 $ 18.20% 6.31% 3.33% 6.26% 12.24% 3.98 $ 18.76% 6.34% 3.63% 6.43% 12.13% 3.77 12 Months Ended Dec. 31, 2015 Dec. 31, 2014 Dec. 31, 2013 CVS Historial Ratio Analysis 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 Market price /EPS = PE ratio But as Market price is not given it may not be clacualted. Do not average for any of the ratio as the average for 2013 is not possible therefore all three years ratios to be calculated wihtout using ratios to make comparison meaningful. $ 1.31 0.62 1.37 0.64 1.64 0.84 0.60 1.52 0.89 11.28 0.49 0.95 0.45 14.67 0.47 0.89 0.48 15.79 9.05 2.42 1.64 12.89 28.31 9.56 2.89 1.88 14.39 25.37 9.32 2.74 1.77 14.52 25.13 17.31% 6.17% 3.41% 5.58% 14.06% 4.66 $ 18.20% 6.31% 3.33% 6.26% 12.24% 3.98 $ 18.76% 6.34% 3.63% 6.43% 12.13% 3.77