Compare each firms ratios to the available industry ratios for the most recent year. One source to find sector or industry level data for comparisons is https://csimarket.com. Analyse the performance of your company vs the industry. It is also acceptable if you choose the major competitor instead of industry data. Identify and explain any strengths or weaknesses you find for your company of study. It could be that for some ratios, industry averages are not available (such as for EBITDA). You may look for alternative sources or skip industry comparison for that data.task would be to calculate certain financial ratios for the company, for the three most recent years (please use year-end values instead of averages), interpret them, identify the trends and compare with the industry averages or suitable peer company.

The financial ratios you will need to compute are listed below:

1. Current ratio and quick ratio
2. Net working capital and change in net working capital for the most recent year.
3. EBITDA (or EBITD) margin, net profit margin (PM) and ROE.
4. Total asset turnover ratio
5. Total debt (liabilities) to asset (D/A), times interest earned (TIE) ratios and Net debt/EBITDA ratio.
6. P/E and EV/EBITDA ratios only for the most recent year (with current market price). Note: For debt, include long-term and short-term debt; for cash, include marketable securities.).
7. Three more ratios of your choice (explain shortly what motivated you to choose these ratios e.g. choose wiselyJ).

Do all calculations in Excel by linking formulas directly to the statements.

Start your report with a description of the company you have been assigned to analyse. Please write your interpretations for the ratios you have calculated and a separate conclusion highlighting your main findings. Note that, in order to receive full points it is not enough to present the calculations and comments such as good, bad or smth. alike. Note that I am pretty sure that you can calculate the values for the ratios, therefore your main contribution should be your comments and interpretations. The assignment should end with the conclusion of main findings.

Note: I have mostly chosen companies (many included in DJIA) which have performed well or bad in terms of stock price performance in 2019.

18 Sales, General and administrative A B D 2015-12 2016-12 2017-12 2018-12 2019-12 3641 2595 1342 1305 8525 19649 18650 9830 23290 8176 7513 4825 43804 15255 17850 8225 6783 6091 38949 19992 8221 7578 5350 41141 1139 17694 18833 8025 7508 15560 49926 8724 8283 5966 32803 1 PFIZER INC (PFE) CashFlowFlag BALANCE SHEET 2 Fiscal year ends in December. USD in millions except per share data. 3 Assets 4 Current assets 5 Cash 6 Cash and cash equivalents 7 Short-term investments 8 Total cash 9 Receivables 10 Inventories 11 Other current assets 12 Total current assets 13 Non-current assets 14 Property, plant and equipment 15 Gross property, plant and equipment 16 Accumulated Depreciation 17 Net property, plant and equipment 18 Equity and other investments 19 Goodwill 20 Intangible assets 21 Deferred income taxes 22 Other long-term assets 23 Total non-current assets 24 Total assets 25 Liabilities and stockholders' equity 26 Liabilities PFE Statements 30756 27268 - 13502 13766 15999 48242 28125 -14807 13318 7116 54449 30037 -16172 13865 7015 55952 48740 29976 -16591 13385 2767 53411 - 16789 13967 20147 40358 1794 52648 1812 58653 35369 2099 1855 3227 3499 123658 167462 3323 132666 171615 35211 1924 2799 109497 159423 130654 171795 4450 134685 167488 Type here to search 136 D E 2015-12 2016-12 2017-12 2018-12 2019-12 10160 10688 9954 4536 3620 418 8831 4674 1265 4656 477 15340 16195 4220 980 437 15454 31115 15201 15909 17088 31858 29399 30427 37304 31398 35955 33538 3900 30753 8172 A 25 Liabilities and stockholders' equity 26 Liabilities 27 Current liabilities 28 Short-term debt 29 Accounts payable 30 Taxes payable 31 Other current liabilities 32 Total current liabilities 33 Non-current liabilities 34 Long-term debt 35 Deferred taxes liabilities 36 Pensions and other benefits 37 Minority interest 38 Other long-term liabilities 39 Total non-current liabilities 40 Total liabilities 41 Stockholders' equity 42 Preferred stock 43 Common stock 44 Additional paid-in capital 45 Retained earnings 46 Treasury stock 47 Accumulated other comprehensive income 48 Total stockholders' equity 49 Total liabilities and stockholders' equity 50 28818 26877 8119 278 9249 73341 102740 7430 348 24846 32909 3700 6610 351 20587 5578 6762 303 296 10337 80956 112071 70062 64157 18443 67041 104345 100489 96015 24 21 17 26 459 464 461 82685 81016 71993 -79252 -9522 64720 167460 71774 -84364 -11036 59544 84278 85291 -89425 -9321 71308 19 467 86253 89554 -101610 -11276 63407 159422 468 87428 97670 -110801 - 11639 63143 167488 171615 171797 H P K M N O PFIZER INC (PFE) CashFlowFlag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data 2015-12 2016-12 2017-12 2018-12 2019-12 TTM Revenue 48851 52824 52546 53647 51750 49197 Cost of revenue 9648 12329 11240 11248 10219 9868 Gross profit 39203 40495 41306 42399 41531 39329 Operating expenses Research and development 7690 7872 7657 8006 8650 8962 Sales, General and administrative 14809 14837 14784 14455 14350 13403 Restructuring, merger and acquisition 1434 1985 558 1048 -7001 -6763 Other operating expenses 2294 2071 4200 3845 11611 10796 Total operating expenses 26227 26765 27199 27354 27610 26398 Operating home 12976 13730 14107 15045 13921 12931 Interest Expense 1199 1186 1270 1316 1574 1586 Other income (expense) -2812 -4193 -532 -1844 5335 5712 Income before taxes 8965 8351 12305 11885 17682 17057 Provision for income taxes 1990 1123 -9049 706 1384 2858 Other income 1 -1 -1 Net income from continuing operations 6975 7229 21353 11179 16298 14198 Net income from discontinuing ops 11 17 2 10 4 4 Other -26 -31 -47 -36 -29 -30 Net income 6960 7215 21308 11153 16273 14172 Preferred dividend 1 1 1 1 1 1 Net income available to common shareholders 6959 7214 21307 11152 16272 14171 Earnings per share Basic 1.13 1.18 3.57 1.9 2.92 256 Diluted 1.11 1.17 3.52 1.87 2.87 253 Weighted average shares outstanding Basic 6176 6089 5970 5872 5569 5545 Diluted 6257 6159 6058 5977 5675 5628 EBITDA 15321 15294 19844 19585 25266 24049 18 Sales, General and administrative A B D 2015-12 2016-12 2017-12 2018-12 2019-12 3641 2595 1342 1305 8525 19649 18650 9830 23290 8176 7513 4825 43804 15255 17850 8225 6783 6091 38949 19992 8221 7578 5350 41141 1139 17694 18833 8025 7508 15560 49926 8724 8283 5966 32803 1 PFIZER INC (PFE) CashFlowFlag BALANCE SHEET 2 Fiscal year ends in December. USD in millions except per share data. 3 Assets 4 Current assets 5 Cash 6 Cash and cash equivalents 7 Short-term investments 8 Total cash 9 Receivables 10 Inventories 11 Other current assets 12 Total current assets 13 Non-current assets 14 Property, plant and equipment 15 Gross property, plant and equipment 16 Accumulated Depreciation 17 Net property, plant and equipment 18 Equity and other investments 19 Goodwill 20 Intangible assets 21 Deferred income taxes 22 Other long-term assets 23 Total non-current assets 24 Total assets 25 Liabilities and stockholders' equity 26 Liabilities PFE Statements 30756 27268 - 13502 13766 15999 48242 28125 -14807 13318 7116 54449 30037 -16172 13865 7015 55952 48740 29976 -16591 13385 2767 53411 - 16789 13967 20147 40358 1794 52648 1812 58653 35369 2099 1855 3227 3499 123658 167462 3323 132666 171615 35211 1924 2799 109497 159423 130654 171795 4450 134685 167488 Type here to search 136 D E 2015-12 2016-12 2017-12 2018-12 2019-12 10160 10688 9954 4536 3620 418 8831 4674 1265 4656 477 15340 16195 4220 980 437 15454 31115 15201 15909 17088 31858 29399 30427 37304 31398 35955 33538 3900 30753 8172 A 25 Liabilities and stockholders' equity 26 Liabilities 27 Current liabilities 28 Short-term debt 29 Accounts payable 30 Taxes payable 31 Other current liabilities 32 Total current liabilities 33 Non-current liabilities 34 Long-term debt 35 Deferred taxes liabilities 36 Pensions and other benefits 37 Minority interest 38 Other long-term liabilities 39 Total non-current liabilities 40 Total liabilities 41 Stockholders' equity 42 Preferred stock 43 Common stock 44 Additional paid-in capital 45 Retained earnings 46 Treasury stock 47 Accumulated other comprehensive income 48 Total stockholders' equity 49 Total liabilities and stockholders' equity 50 28818 26877 8119 278 9249 73341 102740 7430 348 24846 32909 3700 6610 351 20587 5578 6762 303 296 10337 80956 112071 70062 64157 18443 67041 104345 100489 96015 24 21 17 26 459 464 461 82685 81016 71993 -79252 -9522 64720 167460 71774 -84364 -11036 59544 84278 85291 -89425 -9321 71308 19 467 86253 89554 -101610 -11276 63407 159422 468 87428 97670 -110801 - 11639 63143 167488 171615 171797 H P K M N O PFIZER INC (PFE) CashFlowFlag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data 2015-12 2016-12 2017-12 2018-12 2019-12 TTM Revenue 48851 52824 52546 53647 51750 49197 Cost of revenue 9648 12329 11240 11248 10219 9868 Gross profit 39203 40495 41306 42399 41531 39329 Operating expenses Research and development 7690 7872 7657 8006 8650 8962 Sales, General and administrative 14809 14837 14784 14455 14350 13403 Restructuring, merger and acquisition 1434 1985 558 1048 -7001 -6763 Other operating expenses 2294 2071 4200 3845 11611 10796 Total operating expenses 26227 26765 27199 27354 27610 26398 Operating home 12976 13730 14107 15045 13921 12931 Interest Expense 1199 1186 1270 1316 1574 1586 Other income (expense) -2812 -4193 -532 -1844 5335 5712 Income before taxes 8965 8351 12305 11885 17682 17057 Provision for income taxes 1990 1123 -9049 706 1384 2858 Other income 1 -1 -1 Net income from continuing operations 6975 7229 21353 11179 16298 14198 Net income from discontinuing ops 11 17 2 10 4 4 Other -26 -31 -47 -36 -29 -30 Net income 6960 7215 21308 11153 16273 14172 Preferred dividend 1 1 1 1 1 1 Net income available to common shareholders 6959 7214 21307 11152 16272 14171 Earnings per share Basic 1.13 1.18 3.57 1.9 2.92 256 Diluted 1.11 1.17 3.52 1.87 2.87 253 Weighted average shares outstanding Basic 6176 6089 5970 5872 5569 5545 Diluted 6257 6159 6058 5977 5675 5628 EBITDA 15321 15294 19844 19585 25266 24049