Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

image text in transcribedimage text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Connect For Financial Accounting

Authors: Author

6th Edition

1264140304, 9781264140305

More Books

Students also viewed these Accounting questions