Using the spreadsheets for Pfizer and Moderna calculate the following eight ratios:
Current Ratio, Quick Ratio, Debt Ratio, Debt to Net Worth Ratio, Net Sales to Total Assets Ratio, Accounts Receivables Ratio, Net Profit on Assets, Net Profit on Equity,. (16 points 1 point each)
Calculate them for each company and provide an answer for which you would invest in and why Properly calculate your ratios. Use the 2019 data.
Pfizer $35.65/share 1-20-21
Moderna $124.61 1-20-21
BALANCE SHEET O QUARTERLY ANNUAL 2019 12/3119 1,305 8.525 2018 12/31/18 1139 2017 12/3117 1,342 18.650 2016 12/31/16 2.595 17694 15.255 9,830 8.724 790 19.992 8.221 Short Term Investments ASSETS Cash & Short Term Investments Receivables.Net Raw Materials Work in Progress Finished Goods Progress Payments Other Inventories - Total Prepaid Expenses Other Current Assets 18.830 8.025 546 4.701 2.262 (1 7.508 17,850 8.225 793 3.696 2.293 4.743 2.750 3.908 2.880 1 8.283 7.578 6.783 5.966 15,560 5.350 6.091 32.803 38.949 CURRENT ASSETS. TOTAL Land Buildings Machinery & Equipment Other Property, Plant & Equipment Property. Plant and Equipment - Gross Accumulated Depreciation Property. Plant and Equipment - Net Investments in Associated Companies Other Investments Other Tangible Assets Total Intangible Other Assets - Net Other Assets - Total 516 10.068 12,281 6,244 32,069 (16,789) 15.280 17.133 3.014 3.137 94,023 99.259 49.926 500 9.920 11.871 4.693 29,976 (16.591 13.285 0 2.767 2,798 88.622 93.344 40541 540 10.254 11.902 4,661 30,037 (16.172) 13.865 0 7,015 3.228 104,693 109.776 530 9.810 11,248 4.410 28.125 (14,807) 13.318 0 7.116 3,323 107,097 112.232 165.390 157498 169.942 169,803 4.220 TOTAL ASSETS LIABILITIES Accounts Payable Short Term Debt & Current Portion of Long Term Debt Income Taxes Payable Dividends Payable Other Current Liabilities 4,674 8,831 4,656 9.953 4,536 10,688 16.195 980 2104 1265 2.0-47 15,0-41 2029 13.312 13. OS 19-04 13.510 37,304 35.955 6762 5.578 2.099 31,858 32.909 6.610 2.700 1924 1776 20.587 93.740 30.427 33.538 7430 2.900 1855 2045 24,846 98.286 31,115 31.398 8,172 30.750 1812 28.941 10,337 3.479 18,443 101.943 109.963 CURRENT LIABILITIES - TOTAL Long Term Debt Provision for Risks and Charges Deferred Taxes - Credit Deferred Taxes. Debit DEFERRED TAXES Other Liabilities TOTAL LIABILITIES EQUITY Non-Equity Reserves Minority interest Preferred Stock Common Stock Capital Surplus Other Appropriated Reserves Retained Earnings Unrealized Foreign Exchange Gain/Loss Unrealized Gain Loss on Marketable Securities Treasury Stock COMMON EQUITY TOTAL LIABILITIES & SHAREHOLDERS' EQUITY 0 303 468 87428 (5.671) 97.670 (5.932) o 351 19 467 86,253 (5.300) 89.554 (5,908) (68) (101610) 63.388 348 21 464 84.278 (4,512) 85.291 (5.210) 401 (89.425) 71287 296 24 461 82.685 (4,594) 71774 16.31 (110,801) 62.127 165.390 (84.364) 59.520 157.498 169,942 169.803 INCOME STATEMENT O QUARTERLY ANNUAL 2019 12/31/19 2018 12/31/18 2017 12/31/17 2016 12/31/16 52.824 52,546 9.327 10,224 51,750 8.611 6.010 1.400 4,610 53.647 9,637 6,384 1.491 6.269 1.511 5,757 1,701 4,893 4.758 NET SALES OR REVENUES Cost of Goods Sold (Excl Depreciation) Depreciation, Depletion And Amortization Depreciation Amortization of Intangibles GROSS INCOME Selling, General & Admin Expenses Other Operating Expenses Research and Development Expense 4,056 37129 37.626 36.950 36,843 22.023 22,459 22.441 22,709 64 0 0 0 7,984 8.006 7,657 7,872 15.042 15.167 14.509 14,134 OPERATING INCOME Extraordinary Credit - Pretax Extraordinary Charge - Pretax Non-Operating Interest Income Other Income/Expenses - Net Interest Expense On Debt Interest Capitalized 9.441 (6.878) 226 1,075 (4.939) 333 79 (2.766) 391 1 (6,167) 470 1.408 1,565 1,362 1.099 1,389 1,662 88 1,342 72 1.247 61 73 17,665 11.885 12.305 8.351 (1,123) 291 (1.706) (1.995) 2.900 1.720 (919) (1.502) 3,115 2.831 (3.886) (558) 36 (351) 246 2.709 (2,632) 28 1,532 (525) (175) 31 47 PRETAX INCOME Income Taxes Current Domestic Income Tax Current Foreign Income Tax Deferred Domestic Income Tax Deferred Foreign Income Tax Minority Interest Equity in Earnings After Tax Other Income/Expense Discontinued Operations NET INCOME BEFORE EXTRA ITEMS/PREFERRED DIVIDENDS Extra Items & Gain/Loss Sale of Assets Preferred Dividend Requirements 29 17 0 0 2 o o (1) (1) 1 4 10 17 15.953 10.357 11.905 7.215 322 796 9,403 0 1 1 1 NET INCOME USED TO CALCULATE BASIC EARNINGS PER SHARE Shares used in computing earnings per share - Fully Diluted 15.952 10.356 11,904 7,214 5.675 5,977 6,058 6.159 BALANCE SHEET O QUARTERLY ANNUAL 2019 12/3119 237 867 2018 12/3118 659 863 2017 12/31/17 136 621 2016 12/31/16 50 1,008 1.104 1522 1,058 16 31 18 0 757 17 0 10 0 0 10 o 0 11 0 0 1.563 783 1.087 1.129 o 10B 140 0 0 97 77 63 16 13 12 276 187 Cash Short Term Investments ASSETS Cash & Short Term Investments Receivables.Net Inventories - Total Prepaid Expenses Other Current Assets CURRENT ASSETS. TOTAL Buildings Machinery & Equipment Other Property. Plant & Equipment Property. Plant & Equipment under Capitalized Leases Property, Plant and Equipment - Gross Accumulated Depreciation Property, Plant and Equipment - Net Other Investments Other Tangible Assets Other Assets - Total TOTAL ASSETS LIABILITIES Accounts Payable Accrued Payroll Other Current Liabilities CURRENT LIABILITIES - TOTAL Capitalized Lease Obligations Long Term Debt Deferred Income (48) 242 10 382 195) 288 171 2 2 109 (28) 81 139 (64) 212 185 3 248 158 5 5 753K 753K 1589 1.962 1.084 1.417 7 31 21 27 23 18 28 12 123 109 168 153 143 223 191 163 39 16 13 39 33 33 165 13 16 243 139 394 DEFERRED TAXES Other Liabilities 94 10 9 6 TOTAL LIABILITIES 415 432 459 575 33K 2.538 1.210 GK 38 1.196 6K 12 (403) (366) 0 (1.007) EQUITY Non-Equity Reserves Minority Interest Preferred Stock 0 Common Stock 34K Capital Surplus 2,669 Other Appropriated Reserves Retained Earnings (1.496) Unrealized Gain/Loss on Marketable Securities 2 COMMON EQUITY 1.175 TOTAL LIABILITIES & SHAREHOLDERS' EQUITY 1.589 SHARE INFORMATION Common Shares Outstanding 337 O-Negative Values In U.S. Dollars Values are displayed in Millions except for earnings per share and where noted (622) 1.530 (585) (354) 1.962 1,084 1.417 329 324 324 INCOME STATEMENT O QUARTERLY ANNUAL 2019 12/31/19 2018 12/31/18 2017 12/31/17 2016 12/31/16 NET SALES OR REVENUES Depreciation, Depletion And Amortization Depreciation 60.209 31,021 31,021 135,068 24,862 24,862 205,825 20.537 20.537 108,396 15.114 15.114 110,206 185,288 93,282 29.188 574,908 496,309 523.472 454,082 454.644 410,459 317,053 274,717 (545,720) (223.771) 38.530 5,643 (413.266) (269.356) 27.023 15,235 4.931 (1.085) 3.096 790 11,312 (2.399) 310 13.169 (514,716) (384.408) (255,996) 695 (326) 80 505 326 (80) (1.200) 0 (4,127) 0 (215,168) (1,043) 755 GROSS INCOME Selling, General & Admin Expenses Research and Development Expense OPERATING INCOME Non-Operating Interest Income Other Income/Expenses - Net Interest Expense On Debt PRETAX INCOME Income Taxes Current Domestic Income Tax Deferred Domestic Income Tax After Tax Other Income/Expense NET INCOME BEFORE EXTRA ITEMS/PREFERRED DIVIDENDS Preferred Dividend Requirements NET INCOME USED TO CALCULATE BASIC EARNINGS PER SHARE Shares used in computing earnings per share - Fully Diluted Earning per Common Share - Basic Earning per Common Share - Fully Diluted 0 = Negative Values In U.S. Dollars Values are displayed in Thousands except for earnings per share 288 0 (216.211) (514.021) (388,861) (255,916) 0 12,996 13.925 14.103 (269.841) (514,021) (401,857) 330,802 328,799 (1.55) (1.22) (1.55) (1.22) 324,411 (0.83) (0.83) (230.314) 324,411 (0.71) (0.71)
