1. Prepare common size financial statements analysis for the current year vs the prior year (horizontal and vertical analysis) for the Company (similar to the class exercises using excel). (Ie You can download the comparative income statements to excel from the company website and compare the income statement items as a percentage of net sales for each year and the change in the items year over year a $ amount and a percentage as we demonstrated in class) 2. What is the percentage change in net sales for each year? Describe any trends that you believe to be developing. CVS consolidated statements in millions expect per share amounts net revenues cost of revenues gross profit operating expenses operating profits interest expense, net loss on early extinguishment of debt other expenses income before income tax provision income tax provision income from continuing operations incomes(Loss) from discontinued operations, net of tax net income net income attributable to noncontrolling interest net income attributable to CVS Health Basic Earning per share income from continuing operations attributable to CVS Health income (loss) from discontinued operations attributable to CVS Health Net income attributable to CVS health Weight average shares outstanding Diluted earnings per share income from continuing operations attributable to CVS Health income (loss) from discontinued operations attributable to CVS Health Net income attributable to CVS health Weight average shares outstanding Dividends decleared per share 2017 Common size 2016 Common size 2015 Common size 184765 156220 28545 19028 9517 1041 177526 148669 28857 18491 10366 1058 643 28 8637 3317 5320 153290 126762 26528 17053 9475 838 208 8268 1637 6631 -8 6623 -1 6622 21 8616 3386 5230 9 5239 5319 -2 5317 5237 4.93 0.01 6.47 1020 4.65 0.01 4.66 1118 4.93 1073 6.45 0.01 6.44 1024 4.91 4.62 0.01 4.63 1126 4.9 1079 1.7