need help asap. thanks
need help asap. thanks
Industry Current Year Minus 1 Current Year Minus 2 Company: Air Products and Chemicals, Inc. (APD) Stock Price: 306.72 USD Shares Outstanding: 220.89 M Financial Ratios Most Current Year Current ratio Quick ratio Inventory turnover Fixed asset turnover Total asset turnover Total debt/equity Total debt/total capital Times interest earned (TIE) Operating margin Profit margin Return on total assets (ROA) Return on common equity (ROE) Return on invested capital (ROIC) Basic earning power (BEP) Price/earnings (P/E) Market/book (M/B) Quality of income ratio Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more TTM 9/30/2019 9/30/2018 9/30/2017 8,819,400 8,918,900 8,930,200 8,187,600 5,782,400 5,975,500 6,189,500 5.753,400 3,037.000 2.943,400 2.740.700 2,434,200 Breakdown > Total Revenue Cost of Revenue Gross Profit > Operating Expense Operating Income Net Non Operating Interest Inc... > Other Income Expense Pretax Income 790,200 773,600 778,100 693,000 2,246,800 2,169,800 1.962,600 1,741,200 -100,200 -137,000 -130,500 -119,100 332,500 256,700 182,900 -206,000 2,479,100 2,289,500 2,015,000 1,416,100 Tax Provision 509,700 480,100 524,300 260,900 > Net Income Common Stockhold... 1,903,100 1,760,000 1.497.800 3,000,400 Diluted NI Available to Com Stock... 1,903,100 1,760,000 1.497.800 3,000,400 Basic EPS 0.008 0.0068 0.0138 Diluted EPS 0.0079 0.0068 0.0137 Basic Average Shares 220,300 219,300 218,000 221,600 220.800 219,800 2,280,600 2.144,400 1,965,600 1,427,600 6,572,600 6,749,100 6,967,600 6,446,400 Diluted Average Shares Total Operating Income as Reported Total Expenses Net Income from Continuing & Dis.. Normalized Income Interest Income Interest Expense 1,903,100 1,760,000 1,497,800 3,000,400 1,890,549 1.780,066 1,453,380 1,391,522 0 1,500 100,200 137,000 130,500 120,600 Net Interest Income -100.200 -137,000 -130,500 -119,100 EBIT 2,579,300 2.426,500 2,145,500 1,536,700 EBITDA 3,747,400 5,782,400 5,975,500 6.189.500 5.753,400 Reconciled Cost of Revenue Reconciled Depreciation 1,168,100 1,082,800 970,700 865,800 1,917,400 1.760,000 1,455,600 1,134,400 Net Income from Continuing Oper... Total Unusual Items Excluding Goo... 33,800 -25.400 3,000 -315,100 Total Unusual Items 33,800 -25.400 3,000 -315,100 3,713,600 3,534,700 3,113,200 2,717,600 Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 0 0 0 0 6.949 -5,334 780 -57.978 Balance Sheet All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 9/30/2019 9/30/2018 9/30/2017 > Total Assets 18,942,800 19,178,300 18,467,200 7,554,500 8,002,000 8,281,700 > Total Liabilities Net Minority Int... > Total Equity Gross Minority Inte... 11,388,300 11,176,300 10,185,500 Total Capitalization 14,281,000 14,209,200 13,488,600 11,053,600 10,857,500 10,086,200 Common Stock Equity Net Tangible Assets 9,837,000 9,630,100 8,996,400 Working Capital 2,797,400 2,743,900 3,387,700 Invested Capital 14,379,600 14,670,100 14,049,000 Tangible Book Value 9,837,000 9,630,100 8,996,400 Total Debt 3,326,000 3,812,600 3,962,800 Net Debt 1,077.300 1,021,300 689,200 Share issued 249,456 249,456 249,456 Ordinary Shares Number 220,415 219,515 218,346 Treasury Shares Number 29,040 29,940 31,110 Cash Flow All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more TTM 9/30/2019 9/30/2018 9/30/2017 Breakdown > Operating Cash Flow 2.979.700 2,969,900 2,541,900 1,567.900 P -5,008,800 > Investing Cash Flow -2,113,400 - 1,630,500 2,332,900 > Financing Cash Flow 3,295,800 -1,370,500 -1,359,800 - 1,971,400 3,963,500 2,248,700 2,791,300 3,273,600 323,600 364,600 1,348,800 > End Cash Position Income Tax Paid Supplemental Data Capital Expenditure Issuance of Debt -2,527.300 -1,989,700 -1,568,400 -1,039,700 4,895,700 0 500 2.400 -426,600 Repayment of Debt -428,600 -418,700 -483,900 Free Cash Flow 452,400 980,200 973,500 528,200 2016 2017 2018 2019 2020 3.21B Assets Fiscal year is July June. Al values USD millions Cash & Short Term investments Cash Only Short-Term Investments 2.78B 2.17B 196B 1.918 3.198 2.788 2.17B 1.95B 1.91B 23,5M 3.2M 3.3M 10.5M Total Accounts Receivable 1.748 1.78 1.988 244B 2.443 1.748 1.78 1.988 Accounts Receivables, Net 2443 2448 1.783 2.048 2538 1.75B 2.488 34 1M) Accounts Receivables. Gross Bad Debt Doubtful Accounts Other Receivables (49.6M) (51.3M) (54.9M) (92.5M) Inventories Finished Goods Work in Progress Raw Materials Progress Payments & Other 34 548 28.17B 27.678 29.943 27218 Other Current Assets Top 34,548 Other Current Assets 28.173 27.678 29 94B 27 218 34,548 Miscellaneous Current Assets 28.17B 27.678 29.948 27.218 Total Current Assets 39 58 32.66B 31 82B 34 34B 31.568 2016 2017 2018 2019 2020 685M 779.9M 793.7M 784 2M 1.28 Net Property, Plant & Equipment Property. Plant & Equipment - Gross 1.848 2.038 2.14B 2.18B 2.72 745.7M 779 IM 791.8M Buildings 781.2M 737 21 Land & Improvements 440 1M Computer Software and Equipment Other Property, Plant & Equipment Accumulated Depreciation 599,6M 6371M 651.6M 643.6M 1.100 1.250 1.348 1.428 1528 7.8M 7,6M 7 2M 261.4M 13.0M Total investments and Advances 7.BM 70M 7.2M 261.4M 13.0M Other Long-Term investments 27 AM 28M 25.5M 23.8M 18.0M Long-Term Note Receivable 2.22B 2.36B 3.13B 3.39B Intangible Assets Net Goodwill 1.683 1.74B 2.24 2.32B Net Other Intangibles 534.2M 620.2M 586.4M 1.07B 1.13B 1.34B 3.07B 3.18 Other Assets Tangible Other Assets 826,7M 1.348 692.1M 673M Total Assets 43.678 37.18B 38.85B 41.898 Liabilities & Shareholders' Equity 2016 2017 2018 2019 2020 54 262M 1.11B 262M 1.118 1523M 149.7M 135.4M 125.5M 102M 38 1M 49M 43.5M 54.8M 40 M ST Debt Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt Accounts Payable Income Tax Payable Other Current Liabilities Dividends Payable Accrued Payroll Miscellaneous Current Liabies Total Current Liabilities Long-Term Debt 35.678 29.028 30.238 32.10B 28.878 238,4M 250.5M 298.0M 80 1MM 3873M 616.7M 502 5M 667.7M 7211M 557M 34.81B 28.88 29.278 31.128 27 933 35,858 20.825 30.418 32.63B 30.135 2.01B 20 2B 28 1.350 Long-Term Debt excl. Capitalized Leases 2018 28 2B 28 13 Non-Convertible Debt 2.018 28 28 2B TB 2018 2B 28 28 TB Non-Convertible Debt Convertible Debt 137.IM 137.2M 132.7M 142.8M 205.7M Capitalized Lease Obligations Provision for Risks & Charges Deferred Taxes 150,8M 163, 3M 522M 731.9M 659.9M 111 522M 659.9M 251 IM 731,8M Deferred Taxes - Credit 100.3M 1.08B 945M 1.048 1.068 18 Deferred Taxes. Debit Other Liabilities Other Liabilities (excl. Deferred Income) 583.9M 693 1M 655,9M 595.3M 831.3M 381 M 391.4M 445.1M 399.3M 370,6M Deferred Income 39.198 33.28 34.11B 38.49B 33.41B Total Liabilities Industry Current Year Minus 1 Current Year Minus 2 Company: Air Products and Chemicals, Inc. (APD) Stock Price: 306.72 USD Shares Outstanding: 220.89 M Financial Ratios Most Current Year Current ratio Quick ratio Inventory turnover Fixed asset turnover Total asset turnover Total debt/equity Total debt/total capital Times interest earned (TIE) Operating margin Profit margin Return on total assets (ROA) Return on common equity (ROE) Return on invested capital (ROIC) Basic earning power (BEP) Price/earnings (P/E) Market/book (M/B) Quality of income ratio Income Statement All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more TTM 9/30/2019 9/30/2018 9/30/2017 8,819,400 8,918,900 8,930,200 8,187,600 5,782,400 5,975,500 6,189,500 5.753,400 3,037.000 2.943,400 2.740.700 2,434,200 Breakdown > Total Revenue Cost of Revenue Gross Profit > Operating Expense Operating Income Net Non Operating Interest Inc... > Other Income Expense Pretax Income 790,200 773,600 778,100 693,000 2,246,800 2,169,800 1.962,600 1,741,200 -100,200 -137,000 -130,500 -119,100 332,500 256,700 182,900 -206,000 2,479,100 2,289,500 2,015,000 1,416,100 Tax Provision 509,700 480,100 524,300 260,900 > Net Income Common Stockhold... 1,903,100 1,760,000 1.497.800 3,000,400 Diluted NI Available to Com Stock... 1,903,100 1,760,000 1.497.800 3,000,400 Basic EPS 0.008 0.0068 0.0138 Diluted EPS 0.0079 0.0068 0.0137 Basic Average Shares 220,300 219,300 218,000 221,600 220.800 219,800 2,280,600 2.144,400 1,965,600 1,427,600 6,572,600 6,749,100 6,967,600 6,446,400 Diluted Average Shares Total Operating Income as Reported Total Expenses Net Income from Continuing & Dis.. Normalized Income Interest Income Interest Expense 1,903,100 1,760,000 1,497,800 3,000,400 1,890,549 1.780,066 1,453,380 1,391,522 0 1,500 100,200 137,000 130,500 120,600 Net Interest Income -100.200 -137,000 -130,500 -119,100 EBIT 2,579,300 2.426,500 2,145,500 1,536,700 EBITDA 3,747,400 5,782,400 5,975,500 6.189.500 5.753,400 Reconciled Cost of Revenue Reconciled Depreciation 1,168,100 1,082,800 970,700 865,800 1,917,400 1.760,000 1,455,600 1,134,400 Net Income from Continuing Oper... Total Unusual Items Excluding Goo... 33,800 -25.400 3,000 -315,100 Total Unusual Items 33,800 -25.400 3,000 -315,100 3,713,600 3,534,700 3,113,200 2,717,600 Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 0 0 0 0 6.949 -5,334 780 -57.978 Balance Sheet All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 9/30/2019 9/30/2018 9/30/2017 > Total Assets 18,942,800 19,178,300 18,467,200 7,554,500 8,002,000 8,281,700 > Total Liabilities Net Minority Int... > Total Equity Gross Minority Inte... 11,388,300 11,176,300 10,185,500 Total Capitalization 14,281,000 14,209,200 13,488,600 11,053,600 10,857,500 10,086,200 Common Stock Equity Net Tangible Assets 9,837,000 9,630,100 8,996,400 Working Capital 2,797,400 2,743,900 3,387,700 Invested Capital 14,379,600 14,670,100 14,049,000 Tangible Book Value 9,837,000 9,630,100 8,996,400 Total Debt 3,326,000 3,812,600 3,962,800 Net Debt 1,077.300 1,021,300 689,200 Share issued 249,456 249,456 249,456 Ordinary Shares Number 220,415 219,515 218,346 Treasury Shares Number 29,040 29,940 31,110 Cash Flow All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more TTM 9/30/2019 9/30/2018 9/30/2017 Breakdown > Operating Cash Flow 2.979.700 2,969,900 2,541,900 1,567.900 P -5,008,800 > Investing Cash Flow -2,113,400 - 1,630,500 2,332,900 > Financing Cash Flow 3,295,800 -1,370,500 -1,359,800 - 1,971,400 3,963,500 2,248,700 2,791,300 3,273,600 323,600 364,600 1,348,800 > End Cash Position Income Tax Paid Supplemental Data Capital Expenditure Issuance of Debt -2,527.300 -1,989,700 -1,568,400 -1,039,700 4,895,700 0 500 2.400 -426,600 Repayment of Debt -428,600 -418,700 -483,900 Free Cash Flow 452,400 980,200 973,500 528,200 2016 2017 2018 2019 2020 3.21B Assets Fiscal year is July June. Al values USD millions Cash & Short Term investments Cash Only Short-Term Investments 2.78B 2.17B 196B 1.918 3.198 2.788 2.17B 1.95B 1.91B 23,5M 3.2M 3.3M 10.5M Total Accounts Receivable 1.748 1.78 1.988 244B 2.443 1.748 1.78 1.988 Accounts Receivables, Net 2443 2448 1.783 2.048 2538 1.75B 2.488 34 1M) Accounts Receivables. Gross Bad Debt Doubtful Accounts Other Receivables (49.6M) (51.3M) (54.9M) (92.5M) Inventories Finished Goods Work in Progress Raw Materials Progress Payments & Other 34 548 28.17B 27.678 29.943 27218 Other Current Assets Top 34,548 Other Current Assets 28.173 27.678 29 94B 27 218 34,548 Miscellaneous Current Assets 28.17B 27.678 29.948 27.218 Total Current Assets 39 58 32.66B 31 82B 34 34B 31.568 2016 2017 2018 2019 2020 685M 779.9M 793.7M 784 2M 1.28 Net Property, Plant & Equipment Property. Plant & Equipment - Gross 1.848 2.038 2.14B 2.18B 2.72 745.7M 779 IM 791.8M Buildings 781.2M 737 21 Land & Improvements 440 1M Computer Software and Equipment Other Property, Plant & Equipment Accumulated Depreciation 599,6M 6371M 651.6M 643.6M 1.100 1.250 1.348 1.428 1528 7.8M 7,6M 7 2M 261.4M 13.0M Total investments and Advances 7.BM 70M 7.2M 261.4M 13.0M Other Long-Term investments 27 AM 28M 25.5M 23.8M 18.0M Long-Term Note Receivable 2.22B 2.36B 3.13B 3.39B Intangible Assets Net Goodwill 1.683 1.74B 2.24 2.32B Net Other Intangibles 534.2M 620.2M 586.4M 1.07B 1.13B 1.34B 3.07B 3.18 Other Assets Tangible Other Assets 826,7M 1.348 692.1M 673M Total Assets 43.678 37.18B 38.85B 41.898 Liabilities & Shareholders' Equity 2016 2017 2018 2019 2020 54 262M 1.11B 262M 1.118 1523M 149.7M 135.4M 125.5M 102M 38 1M 49M 43.5M 54.8M 40 M ST Debt Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt Accounts Payable Income Tax Payable Other Current Liabilities Dividends Payable Accrued Payroll Miscellaneous Current Liabies Total Current Liabilities Long-Term Debt 35.678 29.028 30.238 32.10B 28.878 238,4M 250.5M 298.0M 80 1MM 3873M 616.7M 502 5M 667.7M 7211M 557M 34.81B 28.88 29.278 31.128 27 933 35,858 20.825 30.418 32.63B 30.135 2.01B 20 2B 28 1.350 Long-Term Debt excl. Capitalized Leases 2018 28 2B 28 13 Non-Convertible Debt 2.018 28 28 2B TB 2018 2B 28 28 TB Non-Convertible Debt Convertible Debt 137.IM 137.2M 132.7M 142.8M 205.7M Capitalized Lease Obligations Provision for Risks & Charges Deferred Taxes 150,8M 163, 3M 522M 731.9M 659.9M 111 522M 659.9M 251 IM 731,8M Deferred Taxes - Credit 100.3M 1.08B 945M 1.048 1.068 18 Deferred Taxes. Debit Other Liabilities Other Liabilities (excl. Deferred Income) 583.9M 693 1M 655,9M 595.3M 831.3M 381 M 391.4M 445.1M 399.3M 370,6M Deferred Income 39.198 33.28 34.11B 38.49B 33.41B Total Liabilities
