Table 1

Download as pdf or txt
Download as pdf or txt
You are on page 1of 10

Fiscal Year Total Current Liabilities Non Current Liabilities Total Shareholder Equity Debt to Equity Ratio Total

Current Asset Total Non Current Asset Current Ratio


2019 8375.5 4327.5 4461.8 2.847057241 7682.5 9482.3 0.917258671
2020 9359.4 5616 3727.1 4.017976443 9230.2 9472.3 0.986195696
2021 10195.8 7663.7 3815.4 4.680898464 11885.3 9789.6 1.165705487
2022 14810.1 11169.2 6239.1 4.163949929 14630.6 17587.8 0.987879893
2023H1 13915.3 11227.9 6061 4.148358357 13863 16945.9 0.996241547
Fiscal Year Sales Operating Income Consolidated Net Income EBITDA DE Ratio Current Ratio
2019 17768.3 1226.9 664.9 2404.3 2.847057241 0.917258671
2020 14653.8 314.5 -321.5 1678.8 4.017976443 0.986195696
2021 15617.8 769.1 16.2 2109.4 4.680898464 1.165705487
2022 25458.2 896.3 -250.4 3011.9 4.163949929 0.987879893
2023H1 13620.6 577.3 102.9 1607.2 4.148358357 0.996241547
*EBITDA Adjusted
Unit In Million Euro Except for Ratio
Projection Using Data from 2019-2022
Fiscal Year 2019 2020 2021 2022
Sales 17768.3 14653.8 15617.8 25458.2
Net Income 664.9 -321.5 16.2 -250.4
Automotive Production -5.8% -17.2% 3.8% 6.7%
50000
43366.03
45000 40468.21
40000 37565.14
34656.33 34007.85574
35000 31365.09085
28722.32596
30000 25458.20
25458.2 26079.56108
24649.69
25000 22261.97
19879.51
17768.3 17502.79
20000 15617.8
14653.8
15000
10000
5000
0
2019 2020 2021 2022 2023 2024 2025 2026

Sales Forecast(Sales) Lower Confidence Bound(Sales) Upper Confidence Bound(Sales)


1000 664.9

500 159.45
16.2
-136.37
0 -321.5 -250.40
-250.4
-415.21
-577.8531344 -672.58
-500
-888.1350442
-1000 -1198.416954
-1315.16
-1508.698864
-1639.90
-1500
-1981.63
-2000 -2344.82

-2500
2019 2020 2021 2022 2023 2024 2025 2026

Net Income Forecast(Net Income)


Lower Confidence Bound(Net Income) Upper Confidence Bound(Net Income)
50.0% 43.5%
38.0%
40.0% 33.0%
28.3%
30.0% 24.2%
19.9%
20.0% 15.6%
11.3%
6.7% 4.9%
10.0% 3.8% 1.8%
-1.8%
0.0% -5.8% -5.7%

-10.0% -17.2%
-20.0%

-30.0%
2019 2020 2021 2022 2023 2024 2025 2026

Automotive Production Forecast(Automotive Production)


Lower Confidence Bound(Automotive Production) Upper Confidence Bound(Automotive Production)
Sales Automotive Production
Sales 1
Automotive Production 0.658559844 1
Net Income Automotive Production
Net Income 1
Automotive Production 0.027385956 1
 Auto recovery contains some recovered files that haven't been opened. Power BI Desktop

Fiscal Year Sum of Non Current Liabilities Sum of Total Non Current Asset Sum of Total Current Asset Sum of Total Current Liabilities

2019 4,327.50 9,482.30 7,682.50 8,375.50


2020 5,616.00 9,472.30 9,230.20 9,359.40
2021 7,663.70 9,789.60 11,885.30 10,195.80
2022 11,169.20 17,587.80 14,630.60 14,810.10
2023H1 11,227.90 16,945.90 13,863.00 13,915.30
Total 40,004.30 63,277.90 57,291.60 56,656.10

Fiscal Year Sum of Total Shareholder Equity Sum of Debt to Equity Ratio Sum of Current Ratio

2019 4,461.80 2.85 0.92


2020 3,727.10 4.02 0.99
2021 3,815.40 4.68 1.17
2022 6,239.10 4.16 0.99
2023H1 6,061.00 4.15 1.00
Total 24,304.40 19.86 5.05
 Auto recovery contains some recovered files that haven't been opened. Power BI Desktop

Sum of EBITDA, Sum of Operating Income and Sum of Sales by Fiscal Year
Sum of EBITDA Sum of Operating Income Sum of Sales
30K

Sum of EBITDA, Sum of Operating Income and Sum …


25K

20K

15K

10K

5K

0K
2022 2019 2021 2020 2023H1
Fiscal Year

You might also like