jagomart
digital resources
picture1_Excel Sample Sheet 33345 | Entire Basf Ar19


 196x       Filetype XLS       File size 1.72 MB       Source: report.basf.com


File: Excel Sample Sheet 33345 | Entire Basf Ar19
sheet 1 index index ndash basf report 2019 key data of the basf group ndash economic data key data of the basf group ndash sustainability data weighting of basf shares ...

icon picture XLS Filetype Excel XLS | Posted on 10 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Index
Index – BASF Report 2019
Key data of the BASF Group – Economic data
Key data of the BASF Group – Sustainability data
Weighting of BASF shares in important indexes as of December 31, 2019
Key BASF share data
Investments and acquisitions 2019 (Million €)
Factors influencing sales of the BASF Group
Special items (Million €)
ROCE (Million €)
Capital employed (Million €)
EBITDA before special items (Million €)
EBITDA (Million €)
Adjusted earnings per share (Million €)
Sales and earnings (Million €)
Sales and earnings by quarter in 2019 (Million €)
Sales and earnings by quarter in 2018 (Million €)
Assets
Equity and liabilities
Net debt (Million €)
Statement of cash flows (Million €)
Free cash flow (Million €)
Segment overview (Million €)
Sales (Million €)
Income from operations (EBIT) before special items (Million €)
Income from operations (EBIT) (Million €)
Factors influencing sales – Chemicals
Segment data – Chemicals (Million €)
Factors influencing sales – Materials
Segment data – Materials (Million €)
Factors influencing sales – Industrial Solutions
Segment data – Industrial Solutions (Million €)
Factors influencing sales – Surface Technologies
Segment data – Surface Technologies (Million €)
Factors influencing sales – Nutrition & Care
Segment data – Nutrition & Care (Million €)
Factors influencing sales – Agricultural Solutions
Segment data – Agricultural Solutions (Million €)
Financial data – Other (Million €)
Regions (Million €)
Costs and provisions for environmental protection in the BASF Group (Million €)
BASF Group’s greenhouse gas emissions according to the Greenhouse Gas Protocol (Million metric tons of CO2 equivalents)
Additional key indicators for energy and climate protection in BASF operations
Emissions to air (Metric tons)
Waste generation in the BASF Group (Million metric tons)
Leaders and professionals in the BASF Group
BASF Group new hires in 2019
BASF Group personnel expenses (Million €)
Forecast by segment (Million €)
Capex: selected projects
Compensation granted in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation granted in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation granted in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation granted in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation allocated in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation allocated in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation allocated in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Compensation allocated in accordance with the German Corporate Governance Code (GCGC) (Thousand €)
Number of options granted
(Thousand €)
Total compensation of former members of the Board of Executive Directors and their surviving dependents (Million €)
Compensation of the Supervisory Board of BASF SE (Thousand €)
Statement of income (Million €)
Statement of comprehensive income (Million €)
Development of income and expense recognized in equity attributable to shareholders of BASF SE (Million €)
Consolidated balance sheets of the BASF Group
Statement of cash flows (Million €)
Statement of changes in equity (Million €)
Selected exchange rates (EUR 1 equals)
Scope of consolidation
Overview of impact of changes to the scope of consolidation (excluding acquisitions and divestitures)
Financial information on the Wintershall Dea group, Kassel/Hamburg, Germany (100%) (Million €)
Financial information on BASF-YPC Company Ltd., Nanjing, China (100%) (Million €)
Non-material joint ventures accounted for using the equity method (BASF interest) (Million €)
Non-material associated companies accounted for using the equity method (BASF interest) (Million €)
Adjustment of the preliminary purchase price allocation for the acquisition of assets and liabilities from Bayer (Million €)
Effects of acquisitions and changes in the preliminary purchase price allocations
Effects of divestitures
Statement of income from the discontinued construction chemicals business (Million €)
Cash flows from the discontinued construction chemicals business (Million €)
Statement of income from the discontinued oil and gas business (Million €)
Calculation of disposal gain on the discontinued oil and gas business (Million €)
Cash flows from the discontinued oil and gas business (excluding effects from the divestiture) (Million €)
Calculation of disposal gain on the paper and water chemicals business (Million €)
Disposal groups as of December 31, 2019 (Million €)
Income from operations (EBIT) of Other (Million €)
Reconciliation of the assets of Other to the assets of the BASF Group (Million €)
Reconciliation of segment income to income before income taxes (Million €)
Segments 2019 (Million €)
Segments 2018 (Million €)
Regions 2019 (Million €)
Regions 2018 (Million €)
Earnings per share
Sales by division and by indication and sector (Million €)
Other operating income (Million €)
Other operating expenses (Million €)
Income from companies accounted for using the equity method (Million €)
Financial result (Million €)
Tax expense (Million €)
Reconciliation of income taxes and the effective tax rate
Deferred tax assets and liabilities 2019 (Million €)
Deferred tax assets and liabilities 2018 (Million €)
Tax loss carryforwards (Million €)
Noncontrolling interests (Million €)
Personnel expenses (Million €)
Number of employees as of December 31
Average number of employees
Average weighted amortization in years
Goodwill of cash-generating units (Million €)
Development of intangible assets 2019 (Million €)
Development of intangible assets 2018 (Million €)
Weighted average depreciation in years
Development of property, plant and equipment including right-of-use assets arising from leases in 2019 (Million €)
Development of property, plant and equipment 2018 (Million €)
Investments accounted for using the equity method (Million €)
Other financial assets (Million €)
Inventories (Million €)
Other receivables and miscellaneous assets (Million €)
Valuation allowances on receivables (financial instruments) 2019 (Million €)
Reserves and retained earnings (Million €)
Noncontrolling interests
Assumptions used to determine the defined benefit obligation as of December 31
Assumptions used to determine expenses for pension benefits in the respective business year
Sensitivity of the defined benefit obligation as of December 31 (Million €)
Composition of expenses for pension benefits (Million €)
Development of defined benefit obligations (Million €)
Development of plan assets (Million €)
Development of net defined benefit liability (Million €)
Regional allocation of defined benefit plans as of December 31 (Million €)
Structure of plan assets (%)
Current funding situation of the pension plans as of December 31 (Million €)
Other provisions (Million €)
Development of other provisions in 2019 (Million €)
Financial indebtedness (Million €)
Breakdown of financial indebtedness by currency (Million €)
Maturities of financial indebtedness (Million €)
Other liabilities (Million €)
Secured liabilities (Million €)
Other financial obligations (Million €)
Obligations arising from purchase contracts (Million €)
Exposure and sensitivity by currency (Million €)
Carrying amount of nonderivative interest-bearing financial instruments (Million €)
Nominal and fair values of interest rate swaps and combined interest rate and currency swaps (Million €)
Exposure to commodity derivatives (Million €)
Maturities of contractual cash flows from financial liabilities as of December 31, 2019 (Million €)
Maturities of contractual cash flows from financial liabilities as of December 31, 2018 (Million €)
Carrying amounts and fair values of financial instruments as of December 31, 2019 (Million €)
Carrying amounts and fair values of financial instruments as of December 31, 2018 (Million €)
Offsetting of derivative assets and liabilities as of December 31, 2019 (Million €)
Offsetting of derivative assets and liabilities as of December 31, 2018 (Million €)
Net gains and losses from financial instruments 2019 (Million €)
Net gains and losses from financial instruments 2018 (Million €)
Fair value of derivative instruments (Million €)
Hedge accounting effects in 2019 (Million €)
Hedge accounting effects in 2018 (Million €)
Adjusted opening balances as of January 1, 2019 (Million €)
Reconciliation of lease liabilities (Million €)
Lease liabilities (Million €)
Expenses and income in the statement of income from leases for BASF as lessee (Million €)
Liabilities from finance leases (Million €)
Future minimum payments from operating lease contracts (Million €)
Future lease payments to BASF from operating lease contracts (Million €)
Income from leases for BASF as lessor (Million €)
Statement of Cash Flows (Million €)
Reconciliation according to IAS 7 for 2019 (Million €)
Reconciliation according to IAS 7 for 2018 (Million €)
Fair value of options and parameters used as of December 31, 2019
Number of free shares to be granted
Compensation of the Board of Executive Directors and Supervisory Board (Million €)
Sales to related parties (Million €)
Trade accounts receivable from / trade accounts payable to related parties (Million €)
Other receivables from / liabilities to related parties (Million €)
Services provided by the external auditor (Million €)
Ten-year summary – Statement of income and other key data
Balance sheet (IFRS)

Sheet 2: key_data_economic
Back to index
BASF Report 2019
Key data of the BASF Group – Economic data







2019 2018 +/–
Salesa million € 59,316 60,220 (1.5)%
EBITDA before special itemsa million € 8,217 9,271 (11.4)%
EBITDAa million € 8,036 8,970 (10.4)%
EBIT before special itemsa million € 4,536 6,281 (27.8)%
EBITa million € 4,052 5,974 (32.2)%
Net income million € 8,421 4,707 78.9%
ROCEa % 7.7 12.0
Earnings per share 9.17 5.12 79.1%
Assets million € 86,950 86,556 0.5%
Investments including acquisitionsb million € 4,097 10,735 (61.8)%
a Restated figures; for more information, see the Notes to the Consolidated Financial Statements.
b Additions to intangible assets and property, plant and equipment

Sheet 3: key_data_sustainability
Back to index
BASF Report 2019
Key data of the BASF Group – Sustainability data







2019 2018 +/–
Employees at year-end
117,628 122,404 (3.9)%
Personnel expenses million € 10,924 10,659 2.5%
Research and development expensesa million € 2,158 1,994 8.2%
Greenhouse gas emissionsc million metric tons of CO2 equivalents 20.1 21.9 (8.2)%
Energy efficiency in production processes kilograms of sales product/MWh 598 626 (4.5)%
Accelerator sales million € 15,017 14,284 5.1%
Number of on-site sustainability audits of raw material suppliers
81 100 (19.0)%
a Restated figures; for more information, see the Notes to the Consolidated Financial Statements.
c Excluding sale of energy to third parties

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet index ndash basf report key data of the group economic sustainability weighting shares in important indexes as december nbsp share investments and acquisitions million euro factors influencing sales special items roce capital employed ebitda before adjusted earnings per by quarter assets equity liabilities net debt statement cash flows free flow segment overview income from operations ebit chemicals materials industrial solutions surface technologies nutrition amp care agricultural financial other regions costs provisions for environmental protection rsquo s greenhouse gas emissions according to protocol metric tons co equivalents additional indicators energy climate air waste generation leaders professionals new hires personnel expenses forecast capex selected projects compensation granted accordance with german corporate governance code gcgc thousand allocated number options total former members board executive directors their surviving dependents supervisory se comprehensive d...

no reviews yet
Please Login to review.