2025 Revenue Forecast for Top 12 German Companies
Rani
2024-12-24
Inspect dataset
## [1] "Company" "Period"
## [3] "Revenue" "Net_Income"
## [5] "Liabilities" "Assets"
## [7] "Equity" "ROA_Percentage"
## [9] "ROE_Percentage" "Debt_to_Equity"
## [11] "Debt_to_Equity_Percentage"## Company Period Revenue Net_Income Liabilities Assets
## 1 Volkswagen AG 12/31/2017 9750496618 516889818 21354201295 54861302788
## 2 Siemens AG 12/31/2017 19716237464 1276840007 45009303223 75268101508
## 3 Allianz SE 12/31/2017 19458831198 1600107100 48538978480 69583711255
## 4 BMW AG 12/31/2017 18808147150 960184350 35382107627 67327482638
## 5 BASF SE 12/31/2017 16895580815 1797081911 28309420014 68036567115
## 6 Deutsche Telekom AG 12/31/2017 11505351408 1425682028 36680109736 61941763399
## Equity ROA_Percentage ROE_Percentage Debt_to_Equity
## 1 33507101493 942.175.618 1.542.627.668 637.303.746
## 2 30258798286 1.696.389.282 4.219.731.382 1.487.478.214
## 3 21044732775 2.299.542.624 7.603.361.452 2.306.466.848
## 4 31945375011 142.614.028 3.005.706.927 1.107.581.539
## 5 39727147101 2.641.347.127 4.523.561.449 71.259.635
## 6 25261653663 2.301.649.081 5.643.660.732 1.452.007.467
## Debt_to_Equity_Percentage
## 1 0,00%
## 2 283,68%
## 3 329,65%
## 4 0,00%
## 5 634,80%
## 6 388,68%Summarized Yearly Revenue
## # A tibble: 96 × 3
## Company Year Total_Revenue
## <chr> <dbl> <chr>
## 1 Allianz SE 2017 50,131,971,483
## 2 Allianz SE 2018 51,175,348,366
## 3 Allianz SE 2019 50,566,733,810
## 4 Allianz SE 2020 51,156,126,651
## 5 Allianz SE 2021 45,700,916,558
## 6 Allianz SE 2022 58,133,595,013
## 7 Allianz SE 2023 53,655,269,159
## 8 Allianz SE 2024 55,973,722,256
## 9 BASF SE 2017 59,419,253,672
## 10 BASF SE 2018 57,789,026,923
## 11 BASF SE 2019 50,668,995,175
## 12 BASF SE 2020 51,555,868,926
## 13 BASF SE 2021 55,016,180,732
## 14 BASF SE 2022 40,128,290,767
## 15 BASF SE 2023 45,565,803,193
## 16 BASF SE 2024 62,478,340,119
## 17 BMW AG 2017 62,609,573,916
## 18 BMW AG 2018 36,856,120,884
## 19 BMW AG 2019 45,506,533,240
## 20 BMW AG 2020 49,196,691,481
## 21 BMW AG 2021 52,882,801,540
## 22 BMW AG 2022 49,401,516,517
## 23 BMW AG 2023 55,024,458,624
## 24 BMW AG 2024 57,918,366,766
## 25 Bayer AG 2017 52,389,850,157
## 26 Bayer AG 2018 48,150,546,837
## 27 Bayer AG 2019 57,977,070,929
## 28 Bayer AG 2020 49,504,704,764
## 29 Bayer AG 2021 53,959,483,274
## 30 Bayer AG 2022 47,298,988,946
## 31 Bayer AG 2023 51,060,142,971
## 32 Bayer AG 2024 32,624,013,419
## 33 Daimler AG 2017 42,210,718,975
## 34 Daimler AG 2018 47,492,102,294
## 35 Daimler AG 2019 44,006,716,466
## 36 Daimler AG 2020 58,254,884,177
## 37 Daimler AG 2021 68,985,406,674
## 38 Daimler AG 2022 57,732,129,001
## 39 Daimler AG 2023 38,140,385,177
## 40 Daimler AG 2024 58,631,917,149
## 41 Deutsche Bank AG 2017 63,574,236,059
## 42 Deutsche Bank AG 2018 48,109,629,622
## 43 Deutsche Bank AG 2019 37,369,313,376
## 44 Deutsche Bank AG 2020 55,622,759,237
## 45 Deutsche Bank AG 2021 36,889,344,032
## 46 Deutsche Bank AG 2022 48,199,269,790
## 47 Deutsche Bank AG 2023 44,782,520,259
## 48 Deutsche Bank AG 2024 67,125,687,921
## 49 Deutsche Telekom AG 2017 54,976,580,700
## 50 Deutsche Telekom AG 2018 54,059,359,628
## 51 Deutsche Telekom AG 2019 54,437,830,986
## 52 Deutsche Telekom AG 2020 69,487,862,950
## 53 Deutsche Telekom AG 2021 44,922,914,869
## 54 Deutsche Telekom AG 2022 39,261,265,138
## 55 Deutsche Telekom AG 2023 39,244,557,273
## 56 Deutsche Telekom AG 2024 57,972,391,873
## 57 Merck KGaA 2017 47,290,956,838
## 58 Merck KGaA 2018 48,843,108,126
## 59 Merck KGaA 2019 65,190,416,313
## 60 Merck KGaA 2020 46,264,095,361
## 61 Merck KGaA 2021 56,415,492,342
## 62 Merck KGaA 2022 42,244,949,943
## 63 Merck KGaA 2023 54,167,100,214
## 64 Merck KGaA 2024 69,331,938,281
## 65 Porsche AG 2017 39,157,019,549
## 66 Porsche AG 2018 53,060,769,470
## 67 Porsche AG 2019 56,053,712,072
## 68 Porsche AG 2020 40,451,063,282
## 69 Porsche AG 2021 41,629,744,530
## 70 Porsche AG 2022 34,536,177,976
## 71 Porsche AG 2023 54,717,078,835
## 72 Porsche AG 2024 58,050,114,174
## 73 SAP SE 2017 49,000,618,158
## 74 SAP SE 2018 43,374,604,149
## 75 SAP SE 2019 54,198,899,311
## 76 SAP SE 2020 41,323,341,762
## 77 SAP SE 2021 39,253,365,553
## 78 SAP SE 2022 65,214,107,591
## 79 SAP SE 2023 55,894,107,283
## 80 SAP SE 2024 49,074,660,307
## 81 Siemens AG 2017 54,319,140,154
## 82 Siemens AG 2018 43,825,875,027
## 83 Siemens AG 2019 47,689,829,071
## 84 Siemens AG 2020 52,936,320,840
## 85 Siemens AG 2021 59,746,888,254
## 86 Siemens AG 2022 55,050,309,874
## 87 Siemens AG 2023 46,684,137,510
## 88 Siemens AG 2024 44,947,480,163
## 89 Volkswagen AG 2017 52,354,733,393
## 90 Volkswagen AG 2018 49,218,502,599
## 91 Volkswagen AG 2019 49,296,484,595
## 92 Volkswagen AG 2020 42,340,503,293
## 93 Volkswagen AG 2021 54,407,226,207
## 94 Volkswagen AG 2022 51,127,527,721
## 95 Volkswagen AG 2023 54,636,512,584
## 96 Volkswagen AG 2024 44,324,281,368Observations:
Most companies exhibited resilience and stability during the pandemic years (2020-2023), with minor fluctuations in revenue.
Companies in the healthcare and telecommunications sectors showed strong performance:
- Merck KGaA
- Deutsche Telekom AG
- Bayer AG
This is a reflection of the companies’ increased demand for their services during the pandemic.
Automotive companies, such as Daimler AG, BMW AG, and Volkswagen AG, faced challenges but managed to adapt and stabilize their revenues.
Average Yearly Revenue Per Company
## # A tibble: 12 × 2
## Company Average_Revenue
## <chr> <chr>
## 1 Merck KGaA 13,429,626,794
## 2 BASF SE 13,206,929,985
## 3 Allianz SE 13,015,427,603
## 4 Daimler AG 12,982,945,622
## 5 Deutsche Telekom AG 12,948,836,357
## 6 BMW AG 12,793,626,968
## 7 Siemens AG 12,662,499,403
## 8 Deutsche Bank AG 12,552,273,759
## 9 Volkswagen AG 12,428,305,368
## 10 SAP SE 12,416,678,254
## 11 Bayer AG 12,280,150,041
## 12 Porsche AG 11,801,739,996Profitability Analysis
## # A tibble: 12 × 2
## Company Average_Net_Income_Margin
## <chr> <chr>
## 1 Volkswagen AG 10.94188%
## 2 Bayer AG 10.28815%
## 3 BMW AG 9.97236%
## 4 Merck KGaA 9.96095%
## 5 Deutsche Bank AG 9.96006%
## 6 BASF SE 9.92135%
## 7 Allianz SE 9.88161%
## 8 Porsche AG 9.87134%
## 9 Deutsche Telekom AG 9.82873%
## 10 Daimler AG 9.78240%
## 11 SAP SE 9.05504%
## 12 Siemens AG 8.99431%Average Net Income Margin Per Company
## Observations:
Allianz SE stands out as the top performer in terms of net income margin, indicating strong profitability.
The other companies have relatively similar margins, showing consistent and stable performance
Predicted 2025 Revenue
## # A tibble: 12 × 2
## Company Predicted_Revenue_2025
## <chr> <chr>
## 1 Allianz SE 55,840,490,746
## 2 BASF SE 49,192,131,638
## 3 BMW AG 55,105,273,864
## 4 Bayer AG 41,010,296,023
## 5 Daimler AG 58,365,526,868
## 6 Deutsche Bank AG 51,386,652,372
## 7 Deutsche Telekom AG 45,195,453,685
## 8 Merck KGaA 60,266,105,128
## 9 Porsche AG 51,340,493,280
## 10 SAP SE 54,707,326,908
## 11 Siemens AG 49,449,017,378
## 12 Volkswagen AG 49,093,761,008Bar Graph of Predicted Revenue for 2025
## Analysis
Top Performers:
- Allianz SE, BASF SE, and Bayer AG is seen to have stronger market positions in the year ahead.
Mid-Range Performers:
- BMW AG
- Daimler AG
- Deutsche Telekom AG
- Merck KGaA
- Siemens AG
Lower Performers:
Deutsche Bank AG, Porsche AG, and SAP SE have lower predicted revenues compared to other companies.
This could indicate either a more niche market focus or challenges in revenue growth.
Volkswagen AG:
- Volkswagen AG’s predicted revenue is slightly lower than the top performers but still significant. This suggests strong brand presence and market reach, despite competition.