Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Authentication
digital resources
191x Filetype XLSX File size 0.21 MB Source: www.merckgroup.com
Sheet 1: Merck KGaA, Darmstadt, Germany
| Contact | ||||||||||
| Merck KGaA, Darmstadt, Germany | ||||||||||
| Investor Relations | ||||||||||
| Frankfurter Strasse 250 | ||||||||||
| 64293 Darmstadt | ||||||||||
| Germany | ||||||||||
| Phone: +49 6151 72 3321 | ||||||||||
| e-mail: investor.relations@merckgroup.com | ||||||||||
| www.merckgroup.com | ||||||||||
| WKN: | 659990 | |||||||||
| ISIN: | DE0006599905 | |||||||||
| Ticker Symbol: | MRK | |||||||||
| Financial Statements Q1 2020 – Q2 2021 | ||||||||||
| Content | ||||||||||
| 1 Income statements | ||||||||||
| 1.1 | Group, quarterly | |||||||||
| 1.2 | Healthcare, quarterly | |||||||||
| 1.3 | Life Science, quarterly | |||||||||
| 1.4 | Electronics, quarterly | |||||||||
| 1.5 | Corporate/Others, quarterly | |||||||||
| 1.6 | Financial result, quarterly | |||||||||
| 2 Cash flow statement | ||||||||||
| 3 Balance sheet | ||||||||||
| EBITDA pre Merck KGaA, Darmstadt, Germany | |||||||||||||||||||||||||
| 2020 | 2021 | Change YoY | |||||||||||||||||||||||
| € million | Q1 | Q2 | H1 | Q3 | 9M | Q4 | H2 | FY | Q1 | Q2 | H1 | Q3 | 9M | Q4 | H2 | FY | Q1 | Q2 | H1 | Q3 | 9M | Q4 | H2 | FY | |
| Healthcare | 472.1 | 374.0 | 846.2 | 896.0 | 1,742.1 | 525.1 | 1,421.1 | 2,267.3 | 532.9 | 581.0 | 1,113.9 | 12.9% | 55.3% | 31.6% | |||||||||||
| in % of net sales | 27.8% | 24.9% | 26.4% | 52.7% | 35.5% | 30.2% | 41.3% | 34.1% | 32.5% | 32.5% | 32.5% | ||||||||||||||
| Life Science | 552.7 | 569.1 | 1,121.8 | 630.2 | 1,752.0 | 653.1 | 1,283.3 | 2,405.0 | 793.2 | 829.0 | 1,622.2 | 43.5% | 45.7% | 44.6% | |||||||||||
| in % of net sales | 31.2% | 31.5% | 31.4% | 33.0% | 31.9% | 32.2% | 32.6% | 32.0% | 37.2% | 37.3% | 37.2% | ||||||||||||||
| Electronics | 285.5 | 238.3 | 523.8 | 254.2 | 778.0 | 246.1 | 500.4 | 1,024.2 | 273.8 | 258.0 | 531.9 | -4.1% | 8.3% | 1.5% | |||||||||||
| in % of net sales | 31.7% | 29.3% | 30.6% | 30.4% | 30.5% | 29.6% | 29.6% | 30.3% | 31.8% | 30.1% | 30.9% | ||||||||||||||
| Corporate/Others | -129.1 | -107.2 | -236.2 | -79.7 | -315.9 | -179.1 | -258.8 | -495.1 | -89.3 | -91.8 | -181.1 | -30.8% | -14.4% | -23.3% | |||||||||||
| Group | 1,181.3 | 1,074.2 | 2,255.5 | 1,700.7 | 3,956.2 | 1,245.2 | 2,945.9 | 5,201.4 | 1,510.6 | 1,576.2 | 3,086.8 | 27.9% | 46.7% | 36.9% | |||||||||||
| in % of net sales | 27.0% | 26.1% | 26.6% | 38.2% | 30.6% | 27.1% | 32.6% | 29.7% | 32.6% | 32.4% | 32.5% | ||||||||||||||
| Sum of items may not foot due to rounding. | |||||||||||||||||||||||||
| Income Statement Merck KGaA, Darmstadt, Germany | |||||||||||||||||||||||||
| Group | 2020 | 2021 | Change YoY | ||||||||||||||||||||||
| € million | Q1 | Q2 | H1 | Q3 | 9M | Q4 | H2 | FY | Q1 | Q2 | H1 | Q3 | 9M | Q4 | H2 | FY | Q1 | Q2 | H1 | Q3 | 9M | Q4 | H2 | FY | |
| Net sales | 4,369.7 | 4,119.1 | 8,488.8 | 4,447.1 | 12,935.9 | 4,598.5 | 9,045.6 | 17,534.4 | 4,630.7 | 4,870.2 | 9,500.9 | 6.0% | 18.2% | 11.9% | |||||||||||
| Cost of sales | -1,653.5 | -1,610.3 | -3,263.9 | -1,776.1 | -5,040.0 | -1,795.2 | -3,571.2 | -6,835.1 | -1,720.6 | -1,813.0 | -3,533.5 | 4.1% | 12.6% | 8.3% | |||||||||||
| thereof amortization of intangible assets | -56.7 | -57.2 | -113.9 | -48.4 | -162.3 | -47.7 | -96.1 | -209.9 | -53.9 | -49.0 | -102.9 | -4.9% | -14.3% | -9.6% | |||||||||||
| Gross profit | 2,716.2 | 2,508.7 | 5,224.9 | 2,671.0 | 7,895.9 | 2,803.4 | 5,474.4 | 10,699.3 | 2,910.1 | 3,057.2 | 5,967.3 | 7.1% | 21.9% | 14.2% | |||||||||||
| in % of net sales | 62.2% | 60.9% | 61.6% | 60.1% | 61.0% | 61.0% | 60.5% | 61.0% | 62.8% | 62.8% | 62.8% | ||||||||||||||
| SG&A | -1,421.0 | -1,497.5 | -2,918.6 | -973.6 | -3,892.2 | -1,534.3 | -2,507.9 | -5,426.5 | -1,293.0 | -1,423.3 | -2,716.4 | -9.0% | -5.0% | -6.9% | |||||||||||
| in % of net sales | 32.5% | 36.4% | 34.4% | 21.9% | 30.1% | 33.4% | 27.7% | 30.9% | 27.9% | 29.2% | 28.6% | ||||||||||||||
| Marketing and selling expenses | -1,058.7 | -1,034.9 | -2,093.6 | -991.8 | -3,085.4 | -1,121.8 | -2,113.6 | -4,207.2 | -1,007.3 | -1,035.4 | -2,042.7 | -4.9% | 0.1% | -2.4% | |||||||||||
| thereof amortization of intangible assets (M&S) | -158.8 | -165.2 | -323.9 | -158.5 | -482.5 | -153.4 | -311.9 | -635.8 | -145.9 | -145.7 | -291.6 | -8.1% | -11.8% | -10.0% | |||||||||||
| Administration expenses | -288.5 | -298.3 | -586.8 | -279.7 | -866.6 | -321.6 | -601.3 | -1,188.2 | -272.9 | -307.3 | -580.2 | -5.4% | 3.0% | -1.1% | |||||||||||
| Impairment losses and reversals (IFRS 9) | 6.0 | -4.5 | 1.5 | -1.3 | 0.1 | -5.8 | -7.1 | -5.7 | -6.0 | -0.1 | -6.0 | n.m. | -98.6% | n.m. | |||||||||||
| Other operating expenses/income | -79.8 | -159.9 | -239.6 | 299.3 | 59.7 | -85.1 | 214.2 | -25.5 | -6.9 | -80.5 | -87.4 | -91.4% | -49.6% | -63.5% | |||||||||||
| Impairments** | -1.9 | -111.7 | -113.6 | -0.7 | -114.4 | -13.8 | -14.6 | -128.2 | -3.2 | -7.8 | -11.0 | 69.8% | -93.0% | -90.3% | |||||||||||
| Research and development | -579.2 | -520.0 | -1,099.2 | -531.0 | -1,630.1 | -658.0 | -1,188.9 | -2,288.1 | -573.9 | -584.5 | -1,158.5 | -0.9% | 12.4% | 5.4% | |||||||||||
| in % of net sales | 13.3% | 12.6% | 12.9% | 11.9% | 12.6% | 14.3% | 13.1% | 13.0% | 12.4% | 12.0% | 12.2% | ||||||||||||||
| thereof amortization of intangible assets (R&D) | -2.3 | -2.8 | -5.1 | -2.9 | -8.0 | -3.7 | -6.6 | -11.8 | -3.0 | -4.1 | -7.1 | 27.9% | 46.5% | 38.1% | |||||||||||
| EBIT | 715.9 | 491.2 | 1,207.1 | 1,166.5 | 2,373.6 | 611.1 | 1,777.6 | 2,984.7 | 1,043.1 | 1,049.3 | 2,092.5 | 45.7% | 113.6% | 73.3% | |||||||||||
| in % of net sales | 16.4% | 11.9% | 14.2% | 26.2% | 18.3% | 13.3% | 19.7% | 17.0% | 22.5% | 21.5% | 22.0% | ||||||||||||||
| Depreciation and amortization | 431.6 | 556.4 | 987.9 | 452.9 | 1,440.9 | 497.3 | 950.2 | 1,938.2 | 423.7 | 422.3 | 846.1 | -1.8% | -24.1% | -14.4% | |||||||||||
| EBITDA | 1,147.5 | 1,047.5 | 2,195.1 | 1,619.4 | 3,814.5 | 1,108.4 | 2,727.8 | 4,922.9 | 1,466.9 | 1,471.6 | 2,938.5 | 27.8% | 40.5% | 33.9% | |||||||||||
| in % of net sales | 26.3% | 25.4% | 25.9% | 36.4% | 29.5% | 24.1% | 30.2% | 28.1% | 31.7% | 30.2% | 30.9% | ||||||||||||||
| EBITDA pre | 1,181.3 | 1,074.2 | 2,255.5 | 1,700.7 | 3,956.2 | 1,245.2 | 2,945.9 | 5,201.4 | 1,510.6 | 1,576.2 | 3,086.8 | 27.9% | 46.7% | 36.9% | |||||||||||
| in % of net sales | 27.0% | 26.1% | 26.6% | 38.2% | 30.6% | 27.1% | 32.6% | 29.7% | 32.6% | 32.4% | 32.5% | ||||||||||||||
| Financial result | -98.5 | -102.3 | -200.7 | -101.6 | -302.3 | -52.0 | -153.6 | -354.4 | -59.1 | -94.8 | -153.9 | -40.0% | -7.3% | -23.3% | |||||||||||
| Profit before income tax from continuing operations | 617.5 | 388.9 | 1,006.4 | 1,064.9 | 2,071.3 | 559.0 | 1,623.9 | 2,630.3 | 984.1 | 954.6 | 1,938.6 | 59.4% | 145.4% | 92.6% | |||||||||||
| Income tax | -159.4 | -99.9 | -259.4 | -258.5 | -517.8 | -118.8 | -377.2 | -636.6 | -236.2 | -207.8 | -443.9 | 48.1% | 107.9% | 71.2% | |||||||||||
| Income tax rate | 25.8% | 25.7% | 25.8% | 24.3% | 25.0% | 21.2% | 23.2% | 24.2% | 24.0% | 21.8% | 22.9% | ||||||||||||||
| Profit after tax from continuing operations | 458.0 | 289.0 | 747.0 | 806.4 | 1,553.5 | 440.3 | 1,246.7 | 1,993.7 | 747.9 | 746.8 | 1,494.7 | 63.3% | 158.4% | 100.1% | |||||||||||
| Profit after tax from discontinued operations | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | n.m. | n.m. | n.m. | |||||||||||
| Profit after tax | 458.0 | 289.0 | 747.0 | 806.4 | 1,553.5 | 440.3 | 1,246.7 | 1,993.7 | 747.9 | 746.8 | 1,494.7 | 63.3% | 158.4% | 100.1% | |||||||||||
| of which: attributable to Merck KGaA shareholders (net income) | 456.1 | 289.8 | 746.0 | 805.5 | 1,551.4 | 435.8 | 1,241.2 | 1,987.2 | 746.6 | 745.2 | 1,491.8 | 63.7% | 157.1% | 100.0% | |||||||||||
| of which: attributable to non-controlling interests | 1.9 | -0.8 | 1.1 | 1.0 | 2.1 | 4.5 | 5.4 | 6.5 | 1.3 | 1.6 | 2.9 | -31.3% | n.m. | 164.4% | |||||||||||
| EPS in € | 1.05 | 0.67 | 1.72 | 1.85 | 3.57 | 1.00 | 2.85 | 4.57 | 1.72 | 1.71 | 3.43 | 63.8% | 155.2% | 99.4% | |||||||||||
| thereof from continuing operations | 1.05 | 0.67 | 1.72 | 1.85 | 3.57 | 1.00 | 2.85 | 4.57 | 1.72 | 1.71 | 3.43 | 63.8% | 155.2% | 99.4% | |||||||||||
| thereof from discontinued operations | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | n.m. | n.m. | n.m. | |||||||||||
| EPS pre in €* | 1.50 | 1.30 | 2.80 | 2.34 | 5.14 | 1.57 | 3.91 | 6.70 | 2.18 | 2.24 | 4.42 | 45.3% | 72.3% | 57.9% | |||||||||||
| Number of theoretical shares in million | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | 434.8 | ||||||||||||||
| Reconciliation to EBITDA pre | |||||||||||||||||||||||||
| EBITDA | 1,147.5 | 1,047.5 | 2,195.1 | 1,619.4 | 3,814.5 | 1,108.4 | 2,727.8 | 4,922.9 | 1,466.9 | 1,471.6 | 2,938.5 | 27.8% | 40.5% | 33.9% | |||||||||||
| Adjustments | |||||||||||||||||||||||||
| thereof: Cost of Sales | 20.2 | 2.5 | 22.7 | 21.1 | 43.8 | 9.1 | 30.2 | 52.9 | 4.4 | 7.48 | 11.9 | -78.2% | 197.9% | -47.6% | |||||||||||
| thereof: Marketing and selling expenses | 2.2 | 10.3 | 12.5 | 5.8 | 18.3 | 41.6 | 47.4 | 59.9 | 6.4 | 2.89 | 9.2 | 188.6% | -71.9% | -26.0% | |||||||||||
| thereof: Administration expenses | 16.4 | 32.8 | 49.2 | 18.2 | 67.4 | 31.1 | 49.3 | 98.4 | 20.4 | 20.07 | 40.5 | 24.5% | -38.7% | -17.6% | |||||||||||
| thereof: Other operating expenses/income | -3.8 | -18.6 | -22.3 | 35.3 | 13.0 | 27.8 | 63.1 | 40.7 | 10.8 | 73.08 | 83.9 | n.m. | n.m. | n.m. | |||||||||||
| thereof: Research and development | -1.2 | -0.3 | -1.6 | 0.8 | -0.8 | 27.3 | 28.1 | 26.6 | 1.7 | 1.02 | 2.7 | n.m. | n.m. | n.m. | |||||||||||
| Total | 33.8 | 26.7 | 60.5 | 81.3 | 141.7 | 136.8 | 218.1 | 278.6 | 43.7 | 104.6 | 148.3 | 29.4% | 292.0% | 145.2% | |||||||||||
| EBITDA pre | 1,181.3 | 1,074.2 | 2,255.5 | 1,700.7 | 3,956.2 | 1,245.2 | 2,945.9 | 5,201.4 | 1,510.6 | 1,576.2 | 3,086.8 | 27.9% | 46.7% | 36.9% | |||||||||||
| Sum of items may not foot due to rounding. | |||||||||||||||||||||||||
| * for continuing operations | |||||||||||||||||||||||||
| ** only reflects impairments which classified as adjustments | |||||||||||||||||||||||||
no reviews yet
Please Login to review.
