1..With the Pfizer Inc. Financial Ratio Summary, you need to complete the Liquidity Ratios, Efficiency Ratios, Leverage Ratios, Profitability Ratios and Market Valuation Ratios for 2015-2019, utilizing the appropriate excel modeling format. This information should prove effective with evaluating trends in operating performance at Pfizer Inc.

This question was partially answered https://www.chegg.com/homework-help/questions-and-answers/1-pfizer-inc-financial-ratio-summary-need-complete-liquidity-ratios-efficiency-ratios-leve-q57410605 but leverage ratios and market valuation ratios weren't answered so please answer those.

4 5 PFIZER INC-PFE Financial Ratio Summary Worksheet 2015-2019 Fiscal year ends in December. USD in millions ercept per share data. 2019-12 Industry Average 2018-12 2017-12 2016-12 2015-12 8 9 0.88 1.57 135 1.25 1.49 NA 10 12 NA NA NA NA NA 13 NA NA NA NA NA NA NA Financial Ratios Liquidity Ratios Current Ratio = Current Assets/CurrentLiabilities Quick Ratio =(Cash + Marketable Securities + Accounts Receivable)/Current Liabilities 11 Cash Ratio = (Cash + Marketable Securities)/ Current Liabilities NWC = Current Assets - Current Liabilities NWC to Total Assets = Net Working Capital/Total Assets 14 Internal Measure - Current Assets/Average Daily Operating Costs 16 Efficiency Ratios 17 Asset Turnover = Total Revenue/Average Total Assets 18 Inventory Turnover = Cost of Goods Sold/Average Inventory 19 Days Sales In Inventory = 365 Days/Inventory Turnover 20 Receivables Turnover - Total Revenues/Average Accounts Receivable 21 Days Sales in Receivables = 365 Days/Receivables Turnover 22 Payables Turnover = Cost of Goods Sold/Average Accounts Payable 23 Days Sales in Accounts Payable = 365 Days/Payables Turnover 25 Leverage Ratios z& Long-Term Debt Ratio - LTDX(LTD + Equity) 27 Long-Term Debt Equity Ratio - LTD/Equity 28 Debt/Equity Ratio - Total Debt/Total Equity 29 Equity Multiplier = Total Assets/Total Equity 30 Total Debt Ratio - Total Liabilities/Total Assets 31 Times Interest Earned = EBIT/Interest Expense 32 Cash Coverage Ratio = EBITDAlInterest Expense 34 Profitability Ratios 35 Net Profit Margin = Net Income Total Revenue 36 Gross Profit Margin = Gross Profit/Total Revenue 37 Operating Profit Margin= Operating Income or EBIT/Total Revenue 38 Return on Assets - Net Incomel Total Assets 39 Return on Equity = Net Incomel Total Equity 41 Market Valuation Ratios 42 Price/Earnings = Market Price/EPS or Market Capitalization! Net Income 43 Price/Sales - Market Capitalization/Total Revenue 44 PricelBook = Market to Book Ratio - Market Capitalization/Total Equity 45 Price/Cash Flow = Market Capitalization/Operating Cash Flow NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 2019 $167,489 $32,803 $9,830 $1,305 $8,525 $8,283 $790 $4,743 $2,750 $12,068 $8,724 $9,251 ($527) $3,344 2018 $159,422 $49,926 $18,833 $1,139 $17.694 $7,508 $546 $4,701 $2,262 $11,399 $8,025 $8,566 ($541) $3,374 2017 $171,797 $41,141 $19,992 $1,342 $18,650 $7,578 $788 $3,808 $2,883 $11,271 $8,221 $8,805 ($584) $3,050 2016 $171,615 $38,949 $17,850 $2,595 $15,255 $6,783 $793 $3,696 $2,293 $11,266 $8,225 $8,834 ($609) $3,041 2015 $167,381 $43,804 $23,290 $3,641 $19,649 $7,513 $867 $3,932 $2,714 $10,838 $8,176 $8,560 ($384) $2,662 $21 $2,600 $9,725 $2.461 $12 $2.289 $801 $2,249 $2,154 date. Total Assets Total Current Assets Cash, Cash Equivalents and Short Term Investments Cash and Cash Equivalents Short Term Investments Inventories Raw Materials, Consumables and Supplies Work-in-Process Finished Goods and Merchandise Trade and Other Receivables, Current Trade/Accounts Receivable, Current Gross Trade/Accounts Receivable, Current Allowance/Adjustments for Trade/Accounts Receivable, Current Taxes Receivable, Current Loans Receivable, Current Assets Held for Sale/Discontinued Operations, Current Other Current Assets Deferred Tax Assets, Current Deferred Costs/Assets, Current Total Non-Current Assets Net Property, Plant and Equipment Gross Property, Plant and Equipment Properties Land and Improvements Buildings and improvements Machinery, Furniture and Equipment Plant and Machinery Furniture, Fixtures and Office Equipment Construction in Progress and Advance Payments Accumulated Depreciation and Impairment Accumulated Depreciation Net Intangible Assets Gross Goodwill and Other Intangible Assets Goodwill Intangibles other than Goodwill Trademarks and Patents Licences and Binhts $109,497 $13,385 $29,977 $10,420 $500 $134,685 $13,967 $30,756 $10,584 $516 $10,068 $17,211 $12,281 $4,930 $2,960 ($16,789 ($16,789) $94,022 $159,060 $58,653 $100,407 $2,913 +91575 $9,920 $16,564 $11,871 $4,693 $2,992 ($16,591) ($16,591) $88,622 $149,365 $53,411 $95,954 $2,914 +90 269 $130,654 $13,865 $30,037 $10,794 $540 $10,254 $16,563 $11.902 $4,661 $2,680 ($16,172) ($16,172) $104,692 $161,725 $55,952 $105,773 $9,063 +91461 $132,666 $13,318 $28,125 $10,340 $530 $9,810 $15,658 $11,248 $4,410 $2,127 ($14,807) ($14,807) $107,097 $158,784 $54,449 $104,335 $8,975 85259 $123,579 $13,766 $27.268 $10,192 $588 $9,604 $15,284 $10,933 $4,351 $1,791 ($13,502) ($13,502) $88,600 $137,639 $48,242 $89,397 $8.994 +79232 4 2 PFIZER INC-PFE Annual Financial Reports Fiscal year ends in Deceaber. USD in millions except per share data. 2019 2018 Gross Profit $41,531 $42,399 5 Total Revenue $51,750 $53,647 6 Business Revenue $51,750 $53,647 7 Cost of Revenue ($10,219) ($11,248) 2 Cost of Goods and Services ($10,219) ($11,248) 9 Operating Income Expenses ($27.610) ($27,354) 10 Selling, General and Administrative Expenses ($14,350) ($14,455) 11 Research and Development Expenses ($8,650) ($8,006) 2 Depreciation, Amortization and Depletion ($4,610) ($4,893) 13 Depreciation and Amortization ($4,610) ($4,893) Amortization ($4,610) ($4,893) 15 Total Operating Profit/Loss (EBIT) $13,921 $15,045 Non-Operating Income Expenses, Total $3,760 ($3,161) 17 Total Net Finance Income Expense ($1,348) ($983) 18 Net Interest Income Expense ($1,348) ($983) Interest Expense Net of Capitalized Interest ($1,574) ($1,316) 20 Interest Income $333 21 Net Investment Income 22 Gain/Loss on Investments and Other Financial Instruments $445 23 Income from Associates, Joint Ventures and Other Participating Interests $17 24 Share of Profit and Interest from Joint Ventures $17 25 Gain/Loss on Foreign Exchange 26 Irregular Income!Expenses $3,497 ($4,311) 27 Asset Disposals $31 $71 * Impairment/Write Off/Write Down of Other Assets ($2,843) ($3,115) 29 Gain/Loss on Extinguishment of Debt ($138) ($3) 30 Litigation Income/Expense ($554) ($157) 31 Merger and Acquisition Income/Expense $8,086 B2 Restructuring and Reorganization Income/Expense ($1,085) ($1,107) 33 Other Income/Expense, Non-Operating $1,140 $1,688 34 Pretax Income $17.682 $11,885 5 Provision for Income Tax ($1,384) ($706) 3* Net Income from Continuing Operations $16,298 $11,179 37 Discontinued Operations $10 ......... PFE FINANCIAL RATIOS PFE BALANCE SHEET 2015-2019 2017 $41,318 $52,546 $52,546 ($11,228) ($11,228) ($27.245) ($14,804) ($7,683) ($4,758) ($4,758) ($4,758) $14,073 ($1,768) ($879) ($879) ($1,270) $391 2016 $40,502 $52,824 $52,824 ($12,322) ($12,322) ($26,792) ($14,844) ($7,892) ($4,056) ($4,056) ($4,056) $13,710 ($5,359) ($716) ($716) ($1,186) $470 $53 $53 2015 $39,203 $48,851 $48,851 ($9,648) ($9,648) ($26,227) ($14,809) ($7,690) ($3,728) ($3,728) ($3,728) $12,976 ($4,010) ($728) ($728) ($1,199) $471 $226 $471 $454 $445 $269 ($806) $269 ($2,101) ($45) ($395) ($999) ($240) ($5,756) ($1,661) ($1,447) ($312) ($510) ($806) ($2,995) $232 ($818) ($975) ($422) $943 $12,305 $9,049 $21,353 $2 ($1,826) $1,060 $8,351 ($1,123) $7,229 $17 ($1,434) $519 $8,965 ($1.990) $6,975 $11 14.100 4.7 PFE INCOME STATEMENT 2015-2019 PFE MANAGERIAL FINANCE, PFIZER INC FINANCIAL RATIO SUMMARY 2015-2019 WORKSHEET FA20 (Ahmed Awad) [Protected View] - Excel (Unlicensed Product) Ahmed Awad X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share Enable Editing X i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate X A5 X fic Total Assets H 1 B $104,042 $37,304 $7,304 $7,304 $4,220 $2,104 $980 $95,664 $31,858 $7,986 $7,986 $4,674 $2,047 $1,265 D $100,141 $30,427 $7,162 $7,162 $4,656 $2,029 $477 E $111,775 $31,115 $6,917 $6,917 $4,536 $1,944 $437 F $102,383 $29,399 $5,890 $5,890 $3,620 $1,852 $418 $10,159 $10,159 $6,440 57 Total Liabilities 58 Total Current Liabilities 59 Payables and Accrued Expenses, Current 60 Trade and Other Payables, Current 61 Trade/Accounts Payable, Current 62 Dividends Payable, Current 63 Taxes Payable, Current 64 Accrued Expenses, Current 65 Financial Liabilities, Current 66 Current Debt and Capital Lease Obligation 67 Current Debt 68 Commercial Paper 69 Other Loans, Current Debt 70 Current Portion of Long Term Debt and Capital Lease 71 Current Portion of Long Term Debt 72 Provisions, Current 73 Provision for Employee Entitlements, Current 74 Liabilities Held for Sale/Discontinued Operations, Current 75 Other Current Liabilities 76 Total Non-Current Liabilities 77 Financial Liabilities, Non-Current 78 Long Term Debt and Capital Lease Obligation 79 Long Term Debt 80 Notes Payables, Non-Current 81 Other Loans Non-Current PFE FINANCIAL RATIOS PFE BALANCE SHEET 2015-2019 $10,687 $10,687 $6,486 $5,800 $686 $4,201 $4,201 $2,487 $2,487 $3,719 $3,719 $2,359 $2,359 $16,195 $8,831 $9,954 $16,195 $8,831 $9,954 $14,737 $4,050 $6,422 $13,915 $3,100 $6,100 $822 $950 $322 $1,458 $4,781 $3,532 $1,458 $4,781 $3,532 $2,720 $2,397 $2,196 $2,720 $2,397 $2,196 $0 $1,890 $0 $11,083 $10,753 $11,115 $66,738 $63,806 $69,714 $35,955 $32,909 $33,538 $35,955 $32,909 $33,538 $35,955 $32,909 $33,538 $35,950 $32,902 $32,783 $5 $7 $755 PFE INCOME STATEMENT 2015-2019 PFE STMT OF CASH FL ... $11,023 $80,660 $31,398 $31,398 $31,398 $30,520 $877 $10,990 $72,984 $28,740 $28,740 $28,740 $8,442 $20 298 + Ready 0 85% Type here to search A e O ) 10:48 PM 10/3/2020 4 5 PFIZER INC-PFE Financial Ratio Summary Worksheet 2015-2019 Fiscal year ends in December. USD in millions ercept per share data. 2019-12 Industry Average 2018-12 2017-12 2016-12 2015-12 8 9 0.88 1.57 135 1.25 1.49 NA 10 12 NA NA NA NA NA 13 NA NA NA NA NA NA NA Financial Ratios Liquidity Ratios Current Ratio = Current Assets/CurrentLiabilities Quick Ratio =(Cash + Marketable Securities + Accounts Receivable)/Current Liabilities 11 Cash Ratio = (Cash + Marketable Securities)/ Current Liabilities NWC = Current Assets - Current Liabilities NWC to Total Assets = Net Working Capital/Total Assets 14 Internal Measure - Current Assets/Average Daily Operating Costs 16 Efficiency Ratios 17 Asset Turnover = Total Revenue/Average Total Assets 18 Inventory Turnover = Cost of Goods Sold/Average Inventory 19 Days Sales In Inventory = 365 Days/Inventory Turnover 20 Receivables Turnover - Total Revenues/Average Accounts Receivable 21 Days Sales in Receivables = 365 Days/Receivables Turnover 22 Payables Turnover = Cost of Goods Sold/Average Accounts Payable 23 Days Sales in Accounts Payable = 365 Days/Payables Turnover 25 Leverage Ratios z& Long-Term Debt Ratio - LTDX(LTD + Equity) 27 Long-Term Debt Equity Ratio - LTD/Equity 28 Debt/Equity Ratio - Total Debt/Total Equity 29 Equity Multiplier = Total Assets/Total Equity 30 Total Debt Ratio - Total Liabilities/Total Assets 31 Times Interest Earned = EBIT/Interest Expense 32 Cash Coverage Ratio = EBITDAlInterest Expense 34 Profitability Ratios 35 Net Profit Margin = Net Income Total Revenue 36 Gross Profit Margin = Gross Profit/Total Revenue 37 Operating Profit Margin= Operating Income or EBIT/Total Revenue 38 Return on Assets - Net Incomel Total Assets 39 Return on Equity = Net Incomel Total Equity 41 Market Valuation Ratios 42 Price/Earnings = Market Price/EPS or Market Capitalization! Net Income 43 Price/Sales - Market Capitalization/Total Revenue 44 PricelBook = Market to Book Ratio - Market Capitalization/Total Equity 45 Price/Cash Flow = Market Capitalization/Operating Cash Flow NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 2019 $167,489 $32,803 $9,830 $1,305 $8,525 $8,283 $790 $4,743 $2,750 $12,068 $8,724 $9,251 ($527) $3,344 2018 $159,422 $49,926 $18,833 $1,139 $17.694 $7,508 $546 $4,701 $2,262 $11,399 $8,025 $8,566 ($541) $3,374 2017 $171,797 $41,141 $19,992 $1,342 $18,650 $7,578 $788 $3,808 $2,883 $11,271 $8,221 $8,805 ($584) $3,050 2016 $171,615 $38,949 $17,850 $2,595 $15,255 $6,783 $793 $3,696 $2,293 $11,266 $8,225 $8,834 ($609) $3,041 2015 $167,381 $43,804 $23,290 $3,641 $19,649 $7,513 $867 $3,932 $2,714 $10,838 $8,176 $8,560 ($384) $2,662 $21 $2,600 $9,725 $2.461 $12 $2.289 $801 $2,249 $2,154 date. Total Assets Total Current Assets Cash, Cash Equivalents and Short Term Investments Cash and Cash Equivalents Short Term Investments Inventories Raw Materials, Consumables and Supplies Work-in-Process Finished Goods and Merchandise Trade and Other Receivables, Current Trade/Accounts Receivable, Current Gross Trade/Accounts Receivable, Current Allowance/Adjustments for Trade/Accounts Receivable, Current Taxes Receivable, Current Loans Receivable, Current Assets Held for Sale/Discontinued Operations, Current Other Current Assets Deferred Tax Assets, Current Deferred Costs/Assets, Current Total Non-Current Assets Net Property, Plant and Equipment Gross Property, Plant and Equipment Properties Land and Improvements Buildings and improvements Machinery, Furniture and Equipment Plant and Machinery Furniture, Fixtures and Office Equipment Construction in Progress and Advance Payments Accumulated Depreciation and Impairment Accumulated Depreciation Net Intangible Assets Gross Goodwill and Other Intangible Assets Goodwill Intangibles other than Goodwill Trademarks and Patents Licences and Binhts $109,497 $13,385 $29,977 $10,420 $500 $134,685 $13,967 $30,756 $10,584 $516 $10,068 $17,211 $12,281 $4,930 $2,960 ($16,789 ($16,789) $94,022 $159,060 $58,653 $100,407 $2,913 +91575 $9,920 $16,564 $11,871 $4,693 $2,992 ($16,591) ($16,591) $88,622 $149,365 $53,411 $95,954 $2,914 +90 269 $130,654 $13,865 $30,037 $10,794 $540 $10,254 $16,563 $11.902 $4,661 $2,680 ($16,172) ($16,172) $104,692 $161,725 $55,952 $105,773 $9,063 +91461 $132,666 $13,318 $28,125 $10,340 $530 $9,810 $15,658 $11,248 $4,410 $2,127 ($14,807) ($14,807) $107,097 $158,784 $54,449 $104,335 $8,975 85259 $123,579 $13,766 $27.268 $10,192 $588 $9,604 $15,284 $10,933 $4,351 $1,791 ($13,502) ($13,502) $88,600 $137,639 $48,242 $89,397 $8.994 +79232 4 2 PFIZER INC-PFE Annual Financial Reports Fiscal year ends in Deceaber. USD in millions except per share data. 2019 2018 Gross Profit $41,531 $42,399 5 Total Revenue $51,750 $53,647 6 Business Revenue $51,750 $53,647 7 Cost of Revenue ($10,219) ($11,248) 2 Cost of Goods and Services ($10,219) ($11,248) 9 Operating Income Expenses ($27.610) ($27,354) 10 Selling, General and Administrative Expenses ($14,350) ($14,455) 11 Research and Development Expenses ($8,650) ($8,006) 2 Depreciation, Amortization and Depletion ($4,610) ($4,893) 13 Depreciation and Amortization ($4,610) ($4,893) Amortization ($4,610) ($4,893) 15 Total Operating Profit/Loss (EBIT) $13,921 $15,045 Non-Operating Income Expenses, Total $3,760 ($3,161) 17 Total Net Finance Income Expense ($1,348) ($983) 18 Net Interest Income Expense ($1,348) ($983) Interest Expense Net of Capitalized Interest ($1,574) ($1,316) 20 Interest Income $333 21 Net Investment Income 22 Gain/Loss on Investments and Other Financial Instruments $445 23 Income from Associates, Joint Ventures and Other Participating Interests $17 24 Share of Profit and Interest from Joint Ventures $17 25 Gain/Loss on Foreign Exchange 26 Irregular Income!Expenses $3,497 ($4,311) 27 Asset Disposals $31 $71 * Impairment/Write Off/Write Down of Other Assets ($2,843) ($3,115) 29 Gain/Loss on Extinguishment of Debt ($138) ($3) 30 Litigation Income/Expense ($554) ($157) 31 Merger and Acquisition Income/Expense $8,086 B2 Restructuring and Reorganization Income/Expense ($1,085) ($1,107) 33 Other Income/Expense, Non-Operating $1,140 $1,688 34 Pretax Income $17.682 $11,885 5 Provision for Income Tax ($1,384) ($706) 3* Net Income from Continuing Operations $16,298 $11,179 37 Discontinued Operations $10 ......... PFE FINANCIAL RATIOS PFE BALANCE SHEET 2015-2019 2017 $41,318 $52,546 $52,546 ($11,228) ($11,228) ($27.245) ($14,804) ($7,683) ($4,758) ($4,758) ($4,758) $14,073 ($1,768) ($879) ($879) ($1,270) $391 2016 $40,502 $52,824 $52,824 ($12,322) ($12,322) ($26,792) ($14,844) ($7,892) ($4,056) ($4,056) ($4,056) $13,710 ($5,359) ($716) ($716) ($1,186) $470 $53 $53 2015 $39,203 $48,851 $48,851 ($9,648) ($9,648) ($26,227) ($14,809) ($7,690) ($3,728) ($3,728) ($3,728) $12,976 ($4,010) ($728) ($728) ($1,199) $471 $226 $471 $454 $445 $269 ($806) $269 ($2,101) ($45) ($395) ($999) ($240) ($5,756) ($1,661) ($1,447) ($312) ($510) ($806) ($2,995) $232 ($818) ($975) ($422) $943 $12,305 $9,049 $21,353 $2 ($1,826) $1,060 $8,351 ($1,123) $7,229 $17 ($1,434) $519 $8,965 ($1.990) $6,975 $11 14.100 4.7 PFE INCOME STATEMENT 2015-2019 PFE MANAGERIAL FINANCE, PFIZER INC FINANCIAL RATIO SUMMARY 2015-2019 WORKSHEET FA20 (Ahmed Awad) [Protected View] - Excel (Unlicensed Product) Ahmed Awad X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share Enable Editing X i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate X A5 X fic Total Assets H 1 B $104,042 $37,304 $7,304 $7,304 $4,220 $2,104 $980 $95,664 $31,858 $7,986 $7,986 $4,674 $2,047 $1,265 D $100,141 $30,427 $7,162 $7,162 $4,656 $2,029 $477 E $111,775 $31,115 $6,917 $6,917 $4,536 $1,944 $437 F $102,383 $29,399 $5,890 $5,890 $3,620 $1,852 $418 $10,159 $10,159 $6,440 57 Total Liabilities 58 Total Current Liabilities 59 Payables and Accrued Expenses, Current 60 Trade and Other Payables, Current 61 Trade/Accounts Payable, Current 62 Dividends Payable, Current 63 Taxes Payable, Current 64 Accrued Expenses, Current 65 Financial Liabilities, Current 66 Current Debt and Capital Lease Obligation 67 Current Debt 68 Commercial Paper 69 Other Loans, Current Debt 70 Current Portion of Long Term Debt and Capital Lease 71 Current Portion of Long Term Debt 72 Provisions, Current 73 Provision for Employee Entitlements, Current 74 Liabilities Held for Sale/Discontinued Operations, Current 75 Other Current Liabilities 76 Total Non-Current Liabilities 77 Financial Liabilities, Non-Current 78 Long Term Debt and Capital Lease Obligation 79 Long Term Debt 80 Notes Payables, Non-Current 81 Other Loans Non-Current PFE FINANCIAL RATIOS PFE BALANCE SHEET 2015-2019 $10,687 $10,687 $6,486 $5,800 $686 $4,201 $4,201 $2,487 $2,487 $3,719 $3,719 $2,359 $2,359 $16,195 $8,831 $9,954 $16,195 $8,831 $9,954 $14,737 $4,050 $6,422 $13,915 $3,100 $6,100 $822 $950 $322 $1,458 $4,781 $3,532 $1,458 $4,781 $3,532 $2,720 $2,397 $2,196 $2,720 $2,397 $2,196 $0 $1,890 $0 $11,083 $10,753 $11,115 $66,738 $63,806 $69,714 $35,955 $32,909 $33,538 $35,955 $32,909 $33,538 $35,955 $32,909 $33,538 $35,950 $32,902 $32,783 $5 $7 $755 PFE INCOME STATEMENT 2015-2019 PFE STMT OF CASH FL ... $11,023 $80,660 $31,398 $31,398 $31,398 $30,520 $877 $10,990 $72,984 $28,740 $28,740 $28,740 $8,442 $20 298 + Ready 0 85% Type here to search A e O ) 10:48 PM 10/3/2020