25 XP   0   0   10

Inmobiliaria Colonial SA
Buy, Hold or Sell?

Let's analyse Inmobiliaria Colonial SA together

PenkeI guess you are interested in Inmobiliaria Colonial SA. Buy, hold or sell? I don't know! However, I do recommend doing research before doing anything. I will help you with that.

I'm going to help you getting a better view of Inmobiliaria Colonial SA. At the end you don't have to ask anyone for trading advice. You can make your own decision, with more confidence, the odds in your favor, backed by data.

You can find me behind Let's Analyse Together in the top-right of each section.

Get notifications about Inmobiliaria Colonial SA

I send you an email if I find something interesting about Inmobiliaria Colonial SA.

Quick analysis of Inmobiliaria Colonial SA (30 sec.)










What can you expect buying and holding a share of Inmobiliaria Colonial SA? (30 sec.)

How much money do you get?

How much money do you get?
‚ā¨1.07
When do you have the money?
1 year
How often do you get paid?
100.0%

What is your share worth?

Current worth
‚ā¨11.18
Expected worth in 1 year
‚ā¨0.69
How sure are you?
90.0%

+ What do you gain per year?

Total Gains per Share
‚ā¨-9.50
Return On Investment
-171.7%

For what price can you sell your share?

Current Price per Share
‚ā¨5.53
Expected price per share
‚ā¨5.2032 - ‚ā¨6.44
How sure are you?
50%

1. Valuation of Inmobiliaria Colonial SA (5 min.)




Live pricePrice per Share (EOD)

‚ā¨5.53

Intrinsic Value Per Share

‚ā¨0.98 - ‚ā¨3.72

Total Value Per Share

‚ā¨12.16 - ‚ā¨14.90

2. Growth of Inmobiliaria Colonial SA (5 min.)




Is Inmobiliaria Colonial SA growing?

Current yearPrevious yearGrowGrow %
How rich?$6.3b$7.8b-$1.4b-23.5%

How much money is Inmobiliaria Colonial SA making?

Current yearPrevious yearGrowGrow %
Making money-$1b$53m-$1.1b-104.9%
Net Profit Margin-254.9%13.7%--

How much money comes from the company's main activities?

3. Financial Health of Inmobiliaria Colonial SA (5 min.)




What can you expect buying and holding a share of Inmobiliaria Colonial SA? (5 min.)

Welcome investor! Inmobiliaria Colonial SA's management wants to use your money to grow the business. In return you get a share of Inmobiliaria Colonial SA.

What can you expect buying and holding a share of Inmobiliaria Colonial SA?

First you should know what it really means to hold a share of Inmobiliaria Colonial SA. And how you can make/lose money.

Speculation

The Price per Share of Inmobiliaria Colonial SA is ‚ā¨5.53. The market price reflects what other people think it is worth; not what it's really worth. Your job is to find out if the market price is fair, overpriced, or underpriced. I will help you with that.

If you buy blind, there is a 50% chance of making or losing money by selling the stock in the future. However, we can look at a few things to determine the odds in our favor:

  • The fundamentals: the financial health trends of Inmobiliaria Colonial SA.
  • The technials: based on market psychology, we can make a calculated estimate of what the price will do in the future. We can do this through technical analysis. We can calculate the probabilities and the expected value (millionaire math). That's called speculation.
  • The book value: what is the market price compared to it's book value.

Investing

If you really want to invest in Inmobiliaria Colonial SA, you will have to let go of the thought of selling in the future. If you have to sell the share for less than you bought it, it can still be a good investment. Focus on what it means to hold the stock forever:

  • You own a part of the company. The equity of this part can grow or shrink. The current Book Value per Share is ‚ā¨11.18. Based on the TTM, the Book Value Change Per Share is ‚ā¨-2.62 per quarter. Based on the YOY, the Book Value Change Per Share is ‚ā¨0.30 per quarter.
  • You may receive quarterly/yearly dividend in the form of additional shares.
  • You may receive quarterly/yearly dividend in the form of cash. Based on the TTM the Dividend per Share is ‚ā¨0.25 per quarter.
Based on historical numbers we can estimate the returns while holding a share of Inmobiliaria Colonial SA.

How much money are you going to get?

 MRQTTMYOY5Y10Y
 ‚ā¨% of Price per Share‚ā¨% of Price per Share‚ā¨% of Price per Share‚ā¨% of Price per Share‚ā¨% of Price per Share
Usd Eps-2.05-37.1%-2.05-37.1%0.020.3%0.122.1%0.549.7%
Usd Book Value Change Per Share-2.81-50.7%-2.81-50.7%0.325.8%-0.06-1.1%1.0118.3%
Usd Dividend Per Share0.274.8%0.274.8%0.346.1%0.285.1%0.234.1%
Usd Total Gains Per Share-2.54-45.9%-2.54-45.9%0.6611.9%0.224.0%1.2422.4%
Usd Price Per Share7.01-7.01-6.43-8.60-6.89-
Price to Earnings Ratio-3.42--3.42-400.63-440.39-223.09-
Price-to-Total Gains Ratio-2.76--2.76-9.78-118.47-60.87-
Price to Book Ratio0.59-0.59-0.44-0.62-0.57-
Price-to-Total Gains Ratio-2.76--2.76-9.78-118.47-60.87-

When do you get the money?

Usd Investment
$.00
Usd Price Per Share5.915441
Number of shares169
Gains per QuarterTrailing 12 Months5 Year
Usd Dividend Per Share0.270.28
Usd Book Value Change Per Share-2.81-0.06
Usd Total Gains Per Share-2.540.22
Gains per Quarter (169 shares)-429.1337.57
Gains per Year (169 shares)-1,716.53150.29
YearsReturn on Investment (TTM)Return on Investment (5Y)
 DividendBook Value gainTotal gainsDividendBook Value gainTotal gains
Broker costs---10---10
1181-1897-1727192-42140
2361-3794-3444385-84290
3542-5692-5161577-126440
4723-7589-6878769-168590
5903-9486-8595962-210740
61084-11383-103121154-252890
71265-13280-120291346-2941040
81445-15177-137461539-3361190
91626-17075-154631731-3781340
101806-18972-171801923-4201490

How sure are you?

Based on the past periods, how sure are you to get value out of your investment.

Linear %
 Trailing 12 Months3Y5 Year10 YearALLTIME
  % % % % %
Earnings Per Share0.01.00.00.0%2.01.00.066.7%4.01.00.080.0%9.01.00.090.0%17.06.00.073.9%
Book Value Change Per Share0.01.00.00.0%2.01.00.066.7%3.02.00.060.0%8.02.00.080.0%17.06.00.073.9%
Dividend per Share1.00.00.0100.0%3.00.00.0100.0%5.00.00.0100.0%10.00.00.0100.0%20.00.03.087.0%
Total Gains per Share0.01.00.00.0%2.01.00.066.7%4.01.00.080.0%9.01.00.090.0%18.05.00.078.3%

Fundamentals of Inmobiliaria Colonial SA

About Inmobiliaria Colonial SA

Colonial is a Spanish listed REIT company (SOCIMI), leader in the European Prime office market with presence in the main business areas of Barcelona, Madrid, and Paris with a prime office portfolio of more than 1 million sqm of GLA and assets under management with a value of more than "11bn.

Fundamental data was last updated by Penke on 2024-06-06 05:26:04.

Financial Health

Profitability Details
 Compared to previous yearCompared to industry
The company is making a huge loss.
Using its assets, the company is very inefficient in making profit.
Using its investors money, the company is very inefficient in making profit.
Operating Efficiency Details
 Compared to previous yearCompared to industry
The company is operating very efficient.
The company is very efficient in keeping operating costs low.
Liquidity Details
 Compared to previous yearCompared to industry
The company is unable to pay all its short-term debts.
The company is just able to pay all its short-term debts with the most liquid assets.
Solvency Details
 Compared to previous yearCompared to industry
The company is very able to pay all its debts by selling its assets.
The company is able to pay all its debts with equity.

Valuation

Valuation Details
 Compared to previous yearCompared to industry
Based on the equity, the company is cheap.
Based on the earnings, the company is expensive.
Based on how much money comes from the company's main activities, the company is underpriced.

1.1. Profitability of Inmobiliaria Colonial SA.

1.1. Profitability
1.1.1. Net Profit Margin

Measures how much net profit¬†Inmobiliaria Colonial SA earns for each €1 of revenue.

  • Above 10% is considered healthy but always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • A Net Profit Margin of -254.9%¬†means that¬†€-2.55 for each €1¬†in revenue is generated as profit.

Let's take a look of the Net Profit Margin trends of Inmobiliaria Colonial SA:

  • The MRQ is -254.9%. The company is making a huge loss. -2
  • The TTM is -254.9%. The company is making a huge loss. -2
Trends
Current periodCompared to+/- 
MRQ-254.9%TTM-254.9%0.0%
TTM-254.9%YOY13.7%-268.7%
TTM-254.9%5Y32.0%-286.9%
5Y32.0%10Y106.5%-74.5%
1.1.2. Return on Assets

Shows how efficient Inmobiliaria Colonial SA is using its assets to generate profit.

  • Above 5% is considered healthy¬†but always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • -8.6% Return on Assets means that¬†Inmobiliaria Colonial SA generated¬†€-0.09 profit for each $1 in assets.

Let's take a look of the Return on Assets trends of Inmobiliaria Colonial SA:

  • The MRQ is -8.6%. Using its assets, the company is very inefficient in making profit. -2
  • The TTM is -8.6%. Using its assets, the company is very inefficient in making profit. -2
Trends
Current periodCompared to+/- 
MRQ-8.6%TTM-8.6%0.0%
TTM-8.6%YOY0.4%-9.0%
TTM-8.6%5Y0.5%-9.1%
5Y0.5%10Y3.1%-2.6%
1.1.3. Return on Equity

Shows how efficient Inmobiliaria Colonial SA is using its investors money to generate profit.

  • Above 15%-20% is considered healthy but always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • -20.6% Return on Equity means Inmobiliaria Colonial SA generated €-0.21¬†for each¬†€1 the owners (shareholders) invested.

Let's take a look of the Return on Equity trends of Inmobiliaria Colonial SA:

  • The MRQ is -20.6%. Using its investors money, the company is very inefficient in making profit. -2
  • The TTM is -20.6%. Using its investors money, the company is very inefficient in making profit. -2
Trends
Current periodCompared to+/- 
MRQ-20.6%TTM-20.6%0.0%
TTM-20.6%YOY0.8%-21.5%
TTM-20.6%5Y0.8%-21.5%
5Y0.8%10Y10.3%-9.5%

1.2. Operating Efficiency of Inmobiliaria Colonial SA.

1.2. Operating Efficiency
1.2.1. Operating Margin

Measures how efficient Inmobiliaria Colonial SA is operating .

  • Measures how much profit Inmobiliaria Colonial SA makes for each €1 of sales after paying variable costs (production costs, wages, etc) but before taxes.
  • Above 15% is considered healthy but always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • An Operating Margin of 76.9%¬†means the company generated €0.77 ¬†for each €1 in revenue (before taxes).

Let's take a look of the Operating Margin trends of Inmobiliaria Colonial SA:

  • The MRQ is 76.9%. The company is operating very efficient. +2
  • The TTM is 76.9%. The company is operating very efficient. +2
Trends
Current periodCompared to+/- 
MRQ76.9%TTM76.9%0.0%
TTM76.9%YOY9.0%+68.0%
TTM76.9%5Y121.0%-44.1%
5Y121.0%10Y184.4%-63.4%
1.2.2. Operating Ratio

Measures how efficient Inmobiliaria Colonial SA is keeping operating costs low.

  • Below 1 is considered healthy (always compare to¬†REIT - Office industry mean).
  • An Operation Ratio of 0.23 means that the operating costs are €0.23 for each €1 in net sales.

Let's take a look of the Operating Ratio trends of Inmobiliaria Colonial SA:

  • The MRQ is 0.231. The company is very efficient in keeping operating costs low. +2
  • The TTM is 0.231. The company is very efficient in keeping operating costs low. +2
Trends
Current periodCompared to+/- 
MRQ0.231TTM0.2310.000
TTM0.231YOY0.429-0.198
TTM0.2315Y0.358-0.127
5Y0.35810Y0.323+0.034

1.3. Liquidity of Inmobiliaria Colonial SA.

1.3. Liquidity
1.3.1. Current Ratio

Measures if Inmobiliaria Colonial SA is able to pay off Short-term Debt.

  • Above 1.5 is considered healthy (always compare to¬†REIT - Office industry mean).
  • A Current Ratio of -10.51¬†means the company has €-10.51 in assets for each €1 in short-term debts.

Let's take a look of the Current Ratio trends of Inmobiliaria Colonial SA:

  • The MRQ is -10.515. The company is unable to pay all its short-term debts. -2
  • The TTM is -10.515. The company is unable to pay all its short-term debts. -2
Trends
Current periodCompared to+/- 
MRQ-10.515TTM-10.5150.000
TTM-10.515YOY1.111-11.626
TTM-10.5155Y-1.458-9.057
5Y-1.45810Y0.106-1.564
1.3.2. Quick Ratio

Measures if Inmobiliaria Colonial SA is able to pay off Short-term Debt but only using the most liquid assets.

  • Above 1 is considered healthy but¬†always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • A Quick Ratio of 1.02¬†means the company can pay off €1.02 for each €1 in debt (using most liquid assets).

Let's take a look of the Quick Ratio trends of Inmobiliaria Colonial SA:

  • The MRQ is 1.018. The company is just able to pay all its short-term debts with the most liquid assets.
  • The TTM is 1.018. The company is just able to pay all its short-term debts with the most liquid assets.
Trends
Current periodCompared to+/- 
MRQ1.018TTM1.0180.000
TTM1.018YOY0.983+0.036
TTM1.0185Y0.779+0.240
5Y0.77910Y0.744+0.034

1.4. Solvency of Inmobiliaria Colonial SA.

1.3. Liquidity
1.4.1. Debt to Asset Ratio

Measures how much % of Inmobiliaria Colonial SA assets are financed with debt.

  • Below 1 (100%) is considered healthy but always compare¬†Inmobiliaria Colonial SA to REIT - Office industry mean.
  • A Debt to Asset Ratio of 0.50¬†means that Inmobiliaria Colonial SA assets are¬†financed with 49.7% credit (debt) and the remaining percentage (100% - 49.7%)¬†is financed by its owners/shareholders.¬†

Let's take a look of the Debt to Asset Ratio trends of Inmobiliaria Colonial SA:

  • The MRQ is 0.497. The company is very able to pay all its debts by selling its assets. +2
  • The TTM is 0.497. The company is very able to pay all its debts by selling its assets. +2
Trends
Current periodCompared to+/- 
MRQ0.497TTM0.4970.000
TTM0.497YOY0.455+0.043
TTM0.4975Y0.456+0.042
5Y0.45610Y0.476-0.021
1.4.2. Debt to Equity Ratio

Measures if Inmobiliaria Colonial SA is able to pay off its debts by using shareholders equity.

  • Below 2 is considered healthy but¬†always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • A Debt to Equity ratio of 119.3% means that company has €1.19 debt for each €1 in shareholders equity.

Let's take a look of the Debt to Equity Ratio trends of Inmobiliaria Colonial SA:

  • The MRQ is 1.193. The company is able to pay all its debts with equity. +1
  • The TTM is 1.193. The company is able to pay all its debts with equity. +1
Trends
Current periodCompared to+/- 
MRQ1.193TTM1.1930.000
TTM1.193YOY0.995+0.198
TTM1.1935Y1.026+0.167
5Y1.02610Y1.363-0.337

2. Market Valuation of Inmobiliaria Colonial SA

2.1. Earnings Per Share
2.1. Price to Earnings Ratio

Measures¬†how much money you pay¬†for each share for¬†every €1 in earnings Inmobiliaria Colonial SA generates.

  • Above 15 is considered overpriced but¬†always compare¬†Inmobiliaria Colonial SA to the¬†REIT - Office industry mean.
  • A PE ratio of -3.42 means the investor is paying €-3.42¬†for every €1 in earnings.

Let's take a look of the Price to Earnings Ratio trends of Inmobiliaria Colonial SA:

  • The EOD is -2.887. Based on the earnings, the company is expensive. -2
  • The MRQ is -3.419. Based on the earnings, the company is expensive. -2
  • The TTM is -3.419. Based on the earnings, the company is expensive. -2
Trends
Current periodCompared to+/- 
EOD-2.887MRQ-3.419+0.532
MRQ-3.419TTM-3.4190.000
TTM-3.419YOY400.631-404.050
TTM-3.4195Y440.392-443.811
5Y440.39210Y223.087+217.305
2.2. Price To Free Cash Flow Ratio

Let's take a look of the Price To Free Cash Flow Ratio trends of Inmobiliaria Colonial SA:

  • The EOD is 21.683. Based on how much money comes from the company's main activities, the company is underpriced. +1
  • The MRQ is 25.682. Based on how much money comes from the company's main activities, the company is underpriced. +1
  • The TTM is 25.682. Based on how much money comes from the company's main activities, the company is underpriced. +1
Trends
Current periodCompared to+/- 
EOD21.683MRQ25.682-3.999
MRQ25.682TTM25.6820.000
TTM25.682YOY12.827+12.855
TTM25.6825Y18.997+6.686
5Y18.99710Y16.519+2.478
2. Book Value per Share
2.3. Price to Book Ratio

Measures if the stock price of Inmobiliaria Colonial SA is to cheap or to expensive compared to its book value.

  • At or below 1 is considered healthy¬†(always compare to REIT - Office industry mean).
  • A PB ratio of 0.59 means the investor is paying €0.59¬†for each €1 in book value.

Let's take a look of the Price to Book Ratio trends of Inmobiliaria Colonial SA:

  • The EOD is 0.495. Based on the equity, the company is cheap. +2
  • The MRQ is 0.586. Based on the equity, the company is cheap. +2
  • The TTM is 0.586. Based on the equity, the company is cheap. +2
Trends
Current periodCompared to+/- 
EOD0.495MRQ0.586-0.091
MRQ0.586TTM0.5860.000
TTM0.586YOY0.435+0.150
TTM0.5865Y0.625-0.039
5Y0.62510Y0.569+0.056
2. Total Gains per Share

3. Summary

3.1. Key Performance Indicators

The key performance indicators of Inmobiliaria Colonial SA compared to the Most Recent Quarter (MRQ).

 End of day+/-Most Recent QuarterTrailing 12 Months+/-Year-Over-Year+/-5 Year+/-10 Year+/-
Book Value Change Per Share---2.624-2.6240%0.297-982%-0.058-98%0.944-378%
Book Value Per Share--11.18111.1810%13.805-19%12.885-13%10.586+6%
Current Ratio---10.515-10.5150%1.111-1046%-1.458-86%0.106-9999%
Debt To Asset Ratio--0.4970.4970%0.455+9%0.456+9%0.476+4%
Debt To Equity Ratio--1.1931.1930%0.995+20%1.026+16%1.363-12%
Dividend Per Share--0.2500.2500%0.317-21%0.266-6%0.212+18%
Eps---1.916-1.9160%0.015-12871%0.110-1845%0.504-480%
Free Cash Flow Per Share--0.2550.2550%0.469-46%0.439-42%0.371-31%
Free Cash Flow To Equity Per Share---0.010-0.0100%1.063-101%0.213-105%0.462-102%
Gross Profit Margin--1.0001.0000%1.0000%1.0000%1.0000%
Intrinsic Value_10Y_max--3.719--------
Intrinsic Value_10Y_min--0.983--------
Intrinsic Value_1Y_max--0.426--------
Intrinsic Value_1Y_min--0.306--------
Intrinsic Value_3Y_max--1.239--------
Intrinsic Value_3Y_min--0.744--------
Intrinsic Value_5Y_max--2.003--------
Intrinsic Value_5Y_min--0.989--------
Market Cap2941329668.480-18%3483853404.8003483853404.8000%3196634956.160+9%4275831682.624-19%3424548114.016+2%
Net Profit Margin---2.549-2.5490%0.137-1958%0.320-897%1.065-339%
Operating Margin--0.7690.7690%0.090+758%1.210-36%1.844-58%
Operating Ratio--0.2310.2310%0.429-46%0.358-35%0.323-29%
Pb Ratio0.495-18%0.5860.5860%0.435+35%0.625-6%0.569+3%
Pe Ratio-2.887+16%-3.419-3.4190%400.631-101%440.392-101%223.087-102%
Price Per Share5.530-18%6.5506.5500%6.010+9%8.039-19%6.439+2%
Price To Free Cash Flow Ratio21.683-18%25.68225.6820%12.827+100%18.997+35%16.519+55%
Price To Total Gains Ratio-2.330+16%-2.759-2.7590%9.784-128%118.467-102%60.865-105%
Quick Ratio--1.0181.0180%0.983+4%0.779+31%0.744+37%
Return On Assets---0.086-0.0860%0.004-2437%0.005-1754%0.031-377%
Return On Equity---0.206-0.2060%0.008-2663%0.008-2620%0.103-300%
Total Gains Per Share---2.374-2.3740%0.614-486%0.208-1242%1.156-305%
Usd Book Value--6361721979.4006361721979.4000%7854443402.000-19%7331285650.880-13%6023029500.540+6%
Usd Book Value Change Per Share---2.806-2.8060%0.318-982%-0.062-98%1.009-378%
Usd Book Value Per Share--11.96111.9610%14.767-19%13.784-13%11.324+6%
Usd Dividend Per Share--0.2670.2670%0.339-21%0.285-6%0.227+18%
Usd Eps---2.049-2.0490%0.016-12871%0.117-1845%0.539-480%
Usd Free Cash Flow--145105874.700145105874.7000%266574588.500-46%249819021.640-42%211168942.150-31%
Usd Free Cash Flow Per Share--0.2730.2730%0.501-46%0.470-42%0.397-31%
Usd Free Cash Flow To Equity Per Share---0.011-0.0110%1.137-101%0.228-105%0.494-102%
Usd Market Cap3146340346.373-18%3726677987.1153726677987.1150%3419440412.604+9%4573857150.903-19%3663239117.563+2%
Usd Price Per Share5.915-18%7.0077.0070%6.429+9%8.599-19%6.887+2%
Usd Profit---1089995418.100-1089995418.1000%53076374.600-2154%84314395.820-1393%297637927.710-466%
Usd Revenue--427539835.400427539835.4000%386817426.100+11%379571706.180+13%333727038.430+28%
Usd Total Gains Per Share---2.539-2.5390%0.657-486%0.222-1242%1.237-305%
 EOD+4 -4MRQTTM+0 -0YOY+8 -275Y+6 -2910Y+13 -22

3.2. Fundamental Score

Let's check the fundamental score of Inmobiliaria Colonial SA based on Penke's default stock scanner.

Penke's Stock Scanner

  
  
IndicatorConditionValue
Price to Earnings Ratio (EOD)Between0-15-2.887
Price to Book Ratio (EOD)Between0-10.495
Net Profit Margin (MRQ)Greater than0-2.549
Operating Margin (MRQ)Greater than00.769
Quick Ratio (MRQ)Greater than11.018
Current Ratio (MRQ)Greater than1-10.515
Debt to Asset Ratio (MRQ)Less than10.497
Debt to Equity Ratio (MRQ)Less than11.193
Return on Equity (MRQ)Greater than0.15-0.206
Return on Assets (MRQ)Greater than0.05-0.086
Total4/10 (40.0%)

3.3. Technical Score

Let's check the technical score of Inmobiliaria Colonial SA based on Penke's default Symbol scanner.

Penke's Symbol Scanner

  
  
IndicatorConditionValue
RsiGreater than5035.444
Ma 20Greater thanMa 506.100
Ma 50Greater thanMa 1005.880
Ma 100Greater thanMa 2005.546
OpenGreater thanClose5.710
Total3/5 (60.0%)



Reversals in quarterly reports

I have detected a reversal (positive to negative, negative to positive) in the following values of the quarterly reports.

 2019-12-312020-12-312021-12-312022-12-312023-12-31
Other Current Assets  318-1801382,8913,029-1,0881,941-610,889-608,948
Other Current Liabilities  55,896-32,24623,65011,06634,716183,540218,256-220,234-1,978
Total Current Assets  568,16282,395650,557-282,603367,954401,632769,586-6,079,586-5,310,000
Income before Tax  1,014,782-949,97564,807498,567563,374-521,38241,992-1,257,247-1,215,255
Net Income  826,799-763,98262,817411,025473,842-424,22449,618-1,068,591-1,018,973
Net Income from Continuing Operations  992,523-929,70662,817504,090566,907-517,28949,618-815,000-765,382



Latest Balance Sheet

Balance Sheet of 2023-12-31. All numbers in thousands.

Summary
Total Assets11,834,597
Total Liabilities5,887,395
Total Stockholder Equity4,935,556
 As reported
Total Liabilities 5,887,395
Total Stockholder Equity+ 4,935,556
Total Assets = 11,834,597

Assets

Total Assets11,834,597
Total Current Assets-5,310,000
Long-term Assets830,000
Total Current Assets
Cash And Cash Equivalents 437,790
Net Receivables 76,481
Other Current Assets -608,948
Total Current Assets  (as reported)-5,310,000
Total Current Assets  (calculated)-94,677
+/- 5,215,323
Long-term Assets
Property Plant Equipment 71,232
Long-term Assets Other 275,969
Long-term Assets  (as reported)830,000
Long-term Assets  (calculated)347,201
+/- 482,799

Liabilities & Shareholders' Equity

Total Current Liabilities505,000
Long-term Liabilities5,383,000
Total Stockholder Equity4,935,556
Total Current Liabilities
Short-term Debt 467,809
Accounts payable 37,191
Other Current Liabilities -1,978
Total Current Liabilities  (as reported)505,000
Total Current Liabilities  (calculated)503,022
+/- 1,978
Long-term Liabilities
Long-term Liabilities  (as reported)5,383,000
Long-term Liabilities  (calculated)0
+/- 5,383,000
Total Stockholder Equity
Common Stock1,349,039
Retained Earnings 1,725,573
Accumulated Other Comprehensive Income 462,272
Other Stockholders Equity 1,398,672
Total Stockholder Equity (as reported)4,935,556
Total Stockholder Equity (calculated)4,935,556
+/-0
Other
Cash and Short Term Investments 437,790
Common Stock Shares Outstanding 531,476
Current Deferred Revenue1,978
Liabilities and Stockholders Equity 11,834,597
Net Debt 4,826,703
Short Long Term Debt Total 5,264,493



Balance Sheet

All numbers in thousands.

 Trend2023-12-312022-12-312021-12-312020-12-312019-12-312018-12-312017-12-312016-12-312015-12-312014-12-312013-12-312012-12-312011-12-312010-12-312009-12-312008-12-312007-12-312006-12-312005-12-312004-12-312003-12-312002-12-312001-12-312000-12-31
> Total Assets 
2,937,251
24,103
290,277
274,473
4,351,953
4,654,952
11,419,187
15,052,099
10,160,401
8,638,029
7,863,275
7,936,961
7,253,460
6,519,831
5,925,477
7,129,526
8,227,651
10,507,519
11,487,314
12,501,511
12,354,976
12,727,524
13,469,613
11,834,597
11,834,59713,469,61312,727,52412,354,97612,501,51111,487,31410,507,5198,227,6517,129,5265,925,4776,519,8317,253,4607,936,9617,863,2758,638,02910,160,40115,052,09911,419,1874,654,9524,351,953274,473290,27724,1032,937,251
   > Total Current Assets 
0
0
0
0
760,621
745,467
2,635,909
4,235,537
3,602,798
2,690,958
2,077,853
2,020,629
1,773,415
965,727
215,079
340,030
267,284
1,227,960
262,000
568,162
650,557
367,954
769,586
-5,310,000
-5,310,000769,586367,954650,557568,162262,0001,227,960267,284340,030215,079965,7271,773,4152,020,6292,077,8532,690,9583,602,7984,235,5372,635,909745,467760,6210000
       Cash And Cash Equivalents 
0
48
240
5,811
5,754
3,038
124,086
201,917
113,253
118,735
77,435
65,926
42,667
53,557
111,391
203,794
91,485
58,933
66,516
215,004
266,776
217,165
158,575
437,790
437,790158,575217,165266,776215,00466,51658,93391,485203,794111,39153,55742,66765,92677,435118,735113,253201,917124,0863,0385,7545,811240480
       Short-term Investments 
0
0
0
0
73,787
32,017
21,416
95,131
7,076
40,259
24,549
25,923
-4,870,491
951
63
9
441
12
1,300
90
9
9
9
0
0999901,30012441963951-4,870,49125,92324,54940,2597,07695,13121,41632,01773,7870000
       Net Receivables 
0
0
0
0
146,453
161,229
0
0
0
53,256
0
0
0
66,298
71,342
109,042
160,867
122,961
146,320
304,554
331,225
87,062
521,933
76,481
76,481521,93387,062331,225304,554146,320122,961160,867109,04271,34266,29800053,256000161,229146,4530000
       Other Current Assets 
0
0
0
0
29,783
51,994
173,913
994,075
2,424,086
1,317,981
1,975,869
1,928,780
450
249
1,179
476
776
386
1,277
318
138
3,029
1,941
-608,948
-608,9481,9413,0291383181,2773867764761,1792494501,928,7801,975,8691,317,9812,424,086994,075173,91351,99429,7830000
   > Long-term Assets 
0
0
0
0
3,591,332
3,909,485
8,783,278
10,816,562
6,557,603
5,947,071
5,785,422
5,916,332
5,480,045
5,554,104
5,710,398
6,789,496
7,960,281
9,279,559
11,225,314
11,933,349
11,704,419
12,359,570
12,700,027
830,000
830,00012,700,02712,359,57011,704,41911,933,34911,225,3149,279,5597,960,2816,789,4965,710,3985,554,1045,480,0455,916,3325,785,4225,947,0716,557,60310,816,5628,783,2783,909,4853,591,3320000
       Property Plant Equipment 
0
0
0
0
28,661
28,060
52,315
651,124
46,138
43,772
38,798
37,170
34,269
32,952
32,985
33,118
44,061
39,369
43,332
63,687
67,279
74,048
72,209
71,232
71,23272,20974,04867,27963,68743,33239,36944,06133,11832,98532,95234,26937,17038,79843,77246,138651,12452,31528,06028,6610000
       Goodwill 
0
0
0
0
54,688
50,850
642,178
1,345,779
494,102
494,102
247,051
177,972
120,000
120,000
0
0
0
0
62,225
0
0
0
0
0
0000062,2250000120,000120,000177,972247,051494,102494,1021,345,779642,17850,85054,6880000
       Long Term Investments 
0
0
0
0
0
0
0
0
0
0
0
0
0
303,292
63
9
138,734
420,773
1,891
25,469
0
0
0
0
000025,4691,891420,773138,734963303,2920000000000000
       Intangible Assets 
1,941,071
19,033
3
21
2,598
2,498
2,256
1,736
1,051
494,698
680
997
1,498
2,035
2,486
3,090
2,549
3,037
3,759
4,900
4,633
5,010
4,882
0
04,8825,0104,6334,9003,7593,0372,5493,0902,4862,0351,498997680494,6981,0511,7362,2562,4982,59821319,0331,941,071
       Long-term Assets Other 
0
0
0
0
3,423,896
3,766,321
6,489,076
6,866,459
5,368,848
761,287
4,591,301
4,705,077
30,663
4,955,135
126
156
7,775,365
8,817,481
11,115,587
8,233
86,635
55,377
12,619,675
275,969
275,96912,619,67555,37786,6358,23311,115,5878,817,4817,775,3651561264,955,13530,6634,705,0774,591,301761,2875,368,8486,866,4596,489,0763,766,3213,423,8960000
> Total Liabilities 
2,471,388
14,550
200,516
149,063
3,400,813
3,231,490
7,917,962
10,797,110
8,779,692
7,412,438
5,570,075
5,605,938
5,861,495
5,591,002
3,126,526
3,680,059
4,219,732
4,827,821
5,385,519
5,541,014
5,521,812
5,543,095
6,126,953
5,887,395
5,887,3956,126,9535,543,0955,521,8125,541,0145,385,5194,827,8214,219,7323,680,0593,126,5265,591,0025,861,4955,605,9385,570,0757,412,4388,779,69210,797,1107,917,9623,231,4903,400,813149,063200,51614,5502,471,388
   > Total Current Liabilities 
0
0
0
0
1,640,270
646,994
4,401,632
3,699,254
1,510,826
1,128,228
1,946,759
2,310,095
2,018,378
3,758,334
208,759
340,642
507,283
235,906
442,130
839,030
704,310
719,098
692,540
505,000
505,000692,540719,098704,310839,030442,130235,906507,283340,642208,7593,758,3342,018,3782,310,0951,946,7591,128,2281,510,8263,699,2544,401,632646,9941,640,2700000
       Short-term Debt 
0
0
0
0
1,324,551
314,158
4,078,047
3,059,669
268,567
316,794
116,512
482,172
202,490
2,070,134
76,548
229,780
403,425
50,024
290,338
650,590
515,246
567,619
429,564
467,809
467,809429,564567,619515,246650,590290,33850,024403,425229,78076,5482,070,134202,490482,172116,512316,794268,5673,059,6694,078,047314,1581,324,5510000
       Short Long Term Debt 
0
0
0
0
0
0
0
0
0
0
0
0
0
3,623,881
79,073
205,717
403,425
50,024
290,338
648,459
513,273
564,360
426,160
0
0426,160564,360513,273648,459290,33850,024403,425205,71779,0733,623,8810000000000000
       Accounts payable 
385,646
1,636
4,509
6,758
104,882
94,847
303,069
528,058
315,411
205,012
83,607
81,455
15,841
22,923
26,058
20,291
27,326
26,487
45,219
38,202
42,698
41,992
42,533
37,191
37,19142,53341,99242,69838,20245,21926,48727,32620,29126,05822,92315,84181,45583,607205,012315,411528,058303,06994,847104,8826,7584,5091,636385,646
       Other Current Liabilities 
0
0
0
0
151,318
191,999
5,303
3,195
890,268
586,463
1,712,277
1,706,486
17,493
14,121
15,840
22,075
19,728
21,675
90,224
55,896
23,650
34,716
218,256
-1,978
-1,978218,25634,71623,65055,89690,22421,67519,72822,07515,84014,12117,4931,706,4861,712,277586,463890,2683,1955,303191,999151,3180000
   > Long-term Liabilities 
0
0
0
0
1,760,543
2,584,496
3,516,330
7,097,856
7,268,866
6,284,210
3,623,316
3,295,843
3,843,117
1,832,668
2,917,767
3,339,417
3,712,449
4,591,915
4,943,389
4,701,984
4,817,502
4,823,997
5,434,413
5,383,000
5,383,0005,434,4134,823,9974,817,5024,701,9844,943,3894,591,9153,712,4493,339,4172,917,7671,832,6683,843,1173,295,8433,623,3166,284,2107,268,8667,097,8563,516,3302,584,4961,760,5430000
       Long term Debt Total 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4,343,160
4,373,836
5,003,781
0
05,003,7814,373,8364,343,16000000000000000000000
       Long-term Liabilities Other 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
39,497
51,710
58,547
57,215
87,609
80,562
0
080,56287,60957,21558,54751,71039,49700000000000000000
> Total Stockholder Equity
465,863
9,553
89,761
125,410
692,545
1,079,320
2,840,055
3,633,095
718,038
255,765
1,300,223
1,293,262
172,328
-343,936
1,422,843
1,837,419
2,301,714
3,591,828
4,811,309
5,558,598
5,400,548
5,998,774
6,159,461
4,935,556
4,935,5566,159,4615,998,7745,400,5485,558,5984,811,3093,591,8282,301,7141,837,4191,422,843-343,936172,3281,293,2621,300,223255,765718,0383,633,0952,840,0551,079,320692,545125,41089,7619,553465,863
   Retained Earnings 
0
6,754
35,643
10,493
105,007
266,244
17,222
74,099
-3,980,614
-474,011
0
14,914
-1,129,005
-1,384,171
-452,590
-732,562
273,647
682,523
524,763
826,799
2,418,533
2,892,540
2,861,375
1,725,573
1,725,5732,861,3752,892,5402,418,533826,799524,763682,523273,647-732,562-452,590-1,384,171-1,129,00514,9140-474,011-3,980,61474,09917,222266,244105,00710,49335,6436,7540
   Accumulated Other Comprehensive Income 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,780,741
2,663,421
239,398
523,648
462,272
462,272523,648239,3982,663,4212,780,7410000000000000000000
   Capital Surplus 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,491,280
1,584,454
1,491,773
0
01,491,7731,584,4541,491,28000000000000000000000
   Treasury Stock000000-31,262-49,811-17,065-21,291-59,945-60,047-59,543-58,986-61,878-315,617-293,8220000000



Balance Sheet

All numbers in thousands.




Cash Flow

Currency in EUR. All numbers in thousands.




Income Statement

Currency in EUR. All numbers in thousands.