jagomart
digital resources
picture1_Excel Sample Sheet 33344 | Entire Basf Ar21


 247x       Filetype XLSX       File size 0.51 MB       Source: report.basf.com


File: Excel Sample Sheet 33344 | Entire Basf Ar21
sheet 1 index index ndash basf report 2021 weighting of basf shares in important indexes key basf share data investments and acquisitions gross domestic product growth in key customer industries ...

icon picture XLSX Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Index
Index – BASF Report 2021
Weighting of BASF shares in important indexes
Key BASF share data
Investments and acquisitions
Gross domestic product
Growth in key customer industries
Chemical production (excluding pharmaceuticals)
Factors influencing sales of the BASF Group
Special items
Return on Capital Employed (ROCE)
Capital employed
EBITDA before special items
EBITDA
Adjusted earnings per share
Sales and earnings
Sales and earnings by quarter in 2021
Sales and earnings by quarter in 2020
Consolidated balance sheets – Assets
Consolidated balance sheets – Equity and liabilities
Net debt
Statement of cash flows
Free cash flow
Segment overview
Segment – Sales
Segment – Income from operations (EBIT) before special items
Segment – Income from operations (EBIT)
Chemicals – Factors influencing sales
Chemicals – Segment data
Chemicals – Division sales by region
Materials – Factors influencing sales
Materials – Segment data
Materials – Division sales by region
Industrial Solutions – Factors influencing sales
Industrial Solutions – Segment data
Industrial Solutions – Division sales by region
Surface Technologies – Factors influencing sales
Surface Technologies – Segment data
Surface Technologies – Division sales by region
Nutrition & Care – Factors influencing sales
Nutrition & Care – Segment data
Nutrition & Care – Division sales by region
Agricultural Solutions – Factors influencing sales
Agricultural Solutions – Segment data
Agricultural Solutions – Division sales by region
Other – Financial data
Sales by Region
Sales, investments and operating expenses
Leaders and professionals in the BASF Group
BASF Group new hires
BASF Group personnel expenses
Costs and provisions for environmental protection in the BASF Group
BASF Group’s greenhouse gas emissions according to the Greenhouse Gas Protocol
Additional key indicators for energy and climate protection in BASF operations
Emissions to air
Waste generation in the BASF Group
Forecast by segment
Capital expenditures: Selected projects
Statement of income
Statement of comprehensive income
Consolidated balance sheet
Consolidated statement of cash flows
Consolidated statements of changes in equity 2021
Consolidated statements of changes in equity 2020
Accounting policies applied for the first time
IFRSs and IFRICs not yet to be considered but already endorsed by the E.U.
IFRSs and IFRICs not yet to be considered and not yet endorsed by the E.U.
Selected exchange rates
Scope of consolidation
Overview of impact of changes to the scope of consolidation
Preliminary purchase price allocation for the acquisition of assets and liabilities of the BASF Shanshan companies
Effects of acquisitions
Calculation of disposal loss on the global pigments business
Effects of divestitures
Disposal groups
Income from operations (EBIT) of Other
Reconciliation of the assets of Other to the assets of the BASF Group
Reconciliation of segment income to income before income taxes
Development by segments 2021
Development by segments 2020
Development by regions 2021
Development by regions 2020
Earnings per share
Sales by division and by indication and sector
Other operating income
Other operating expenses
Income from integral companies accounted for using the equity method
Reconciliation of the carrying amounts of integral shareholdings accounted for using the equity method
Financial information on BASF-YPC Company Ltd.
Reconciliation of the carrying amount of the shareholding in BASF-YPC Company Ltd.
Income from non-integral companies accounted for using the equity method
Reconciliation of the carrying amounts of non-integral investments accounted for using the equity method
Financial information on Wintershall Dea
Reconciliation of the carrying amount of the shareholding in Wintershall Dea
Net income from other shareholdings
Carrying amounts of other financial assets
Financial result
Tax expense
Reconciliation of income taxes and the effective tax rate
Deferred tax assets and liabilities 2021
Deferred tax assets and liabilities 2020
Noncontrolling interests in profits and losses
Noncontrolling interests
Intangible assets – Weighted average amortization in years
Intangible assets – Goodwill of cash-generating units
Intangible assets – Development 2021
Intangible assets – Development 2020
Property, plant and equipment – Weighted average depreciation in years
Development of property, plant and equipment including right-of-use assets arising from leases in 2021
Development of property, plant and equipment including right-of-use assets arising from leases in 2020
Lease liabilities
Expenses and income in the statement of income from leases for BASF as lessee
Future lease payments to BASF from operating lease contracts
Income from leases for BASF as lessor
Inventories
Other receivables and miscellaneous assets
Impairments on receivables
Retained earnings
Financial indebtedness
Breakdown of financial indebtedness by currency
Maturities of financial indebtedness
Other liabilities
Carrying amounts of assets used to secure liabilities
Assumptions used to determine the defined benefit obligation
Assumptions used to determine expenses for pension benefits in the respective business year
Sensitivity of the defined benefit obligation
Composition of expenses for pension benefits
Development of defined benefit obligations
Development of plan assets
Development of net defined benefit liability
Regional allocation of defined benefit plans
Structure of plan assets
Current funding situation of the pension plans
Other provisions
Development of other provisions
Other financial obligations
Obligations arising from purchase contracts
Exposure and sensitivity by currency
Carrying amounts of nonderivative interest-bearing financial instruments
Nominal and fair values of combined interest rate and currency swaps
Exposure due to commodity derivatives
Maturities of contractual cash flows from financial liabilities as of December 31, 2021
Maturities of contractual cash flows from financial liabilities as of December 31, 2020
Sensitivities virtual PPA contract for difference for electricity (United States)
Sensitivities physical PPAs (Europe)
Carrying amounts and fair values of financial instruments as of December 31, 2021
Carrying amounts and fair values of financial instruments as of December 31, 2020
Offsetting of derivative assets and liabilities as of December 31, 2021
Offsetting of derivative assets and liabilities as of December 31, 2020
Net gains and losses from financial instruments
Fair value of derivative instruments
Hedge accounting effects in 2021
Hedge accounting effects in 2020
Statement of cash flows
Reconciliation according to IAS 7 for 20211
Reconciliation according to IAS 7 for 2020
Personnel expenses
Number of employees
Average number of employees
Fair value of PSUs and parameters used
Number of free shares to be granted
Compensation of the Board of Executive Directors and Supervisory Board
Sales to related parties
Trade accounts receivable from/trade accounts payable to related parties
Other receivables from/liabilities to related parties
Services provided by the external auditor
Ten-year summary – Statement of income and other key data
Ten-year summary – Consolidated balance sheets (IFRS)

Sheet 2: sha-share-indices
Back to index
BASF Report 2021
Weighting of BASF shares in important indexes as of December 31, 2021


DAX 40 4.0%
EURO STOXX 50 1.8%
MSCI World Chemicals 4.6%

Sheet 3: sha-share-key-data
Back to index
BASF Report 2021
Key BASF share data









2017 2018 2019 2020 2021
Year-end price 91.74 60.40 67.35 64.72 61.78
Year high 97.46 97.67 74.49 68.29 72.61
Year low 79.64 58.40 56.20 39.04 57.88
Year average 88.16 80.38 64.77 53.31 66.20







Daily trade in sharesa






million € 185.7 229.6 187.6 219.2 170.8

million shares 2.1 2.9 2.9 4.1 2.6







Number of shares December 31 million shares 918.5 918.5 918.5 918.5 918.5
Market capitalization December 31 billion € 84.3 55.5 61.9 59.4 56.7







Earnings per share 6.62 5.12 9.17 –1.15 6.01
Adjusted earnings per share 6.44 5.87 4.00 3.21 6.76
Dividend per share 3.10 3.20 3.30 3.30 3.40
Dividend yieldb % 3.38 5.30 4.90 5.10 5.50
Payout ratio % 47 63 36 . 57
Price-earnings ratio (P/E ratio)b
13.9 11.8 7.3 . 10.3
a Average, Xetra trading
b Based on year-end share price

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

...Sheet index ndash basf report weighting of shares in important indexes key share data investments and acquisitions gross domestic product growth customer industries chemical production excluding pharmaceuticals factors influencing sales the group special items return on capital employed roce ebitda before adjusted earnings per by quarter consolidated balance sheets assets equity liabilities net debt statement cash flows free flow segment overview income from operations ebit chemicals division region materials industrial solutions surface technologies nutrition amp care agricultural other financial operating expenses leaders professionals new hires personnel costs provisions for environmental protection rsquo s greenhouse gas emissions according to protocol additional indicators energy climate air waste generation forecast expenditures selected projects comprehensive statements changes accounting policies applied first time ifrss ifrics not yet be considered but already endorsed eu exch...

no reviews yet
Please Login to review.