21 

S

ENSITIVITY 

A

NALYSIS

 

 

 

 

 

 

 

 

 

Year 1 

Year 2

Year 3

Year 4

Year 5

Revenue

6,267,799.0

€                 

 

200,100,000.0

€              

 

1,365,648,000.0

€               

 

4,128,592,000.0

€             

 

3,512,468,000.0

€          

 

Cost of Goods Sold

960,279.9

€                    

 

60,030,000.0

€                

 

384,394,400.0

€                 

 

1,137,377,600.0

€             

 

965,190,400.0

€             

 

Gross Margin

5,307,519.1

€                 

 

140,070,000.0

€              

 

981,253,600.0

€                 

 

2,991,214,400.0

€             

 

2,547,277,600.0

€          

 

Gross Margin/Revenue

85%

70%

72%

72%

73%

Operating Expenses

3,587,908.0

€                 

 

7,210,924.0

€                 

 

538,540,788.0

€                 

 

1,864,389,568.0

€             

 

1,598,822,208.0

€          

 

EBIT

1,719,611.1

€                 

 

132,859,076.0

€              

 

442,712,812.0

€                 

 

1,126,824,832.0

€             

 

948,455,392.0

€             

 

EBIT/Revenue

27%

66%

32%

27%

27%

Year 1 

Year 2

Year 3

Year 4

Year 5

Revenue

4,632,721.0

€                 

 

147,900,000.0

€              

 

1,009,392,000.0

€               

 

3,051,568,000.0

€             

 

2,596,172,000.0

€          

 

Cost of Goods Sold

709,772.1

€                    

 

44,370,000.0

€                

 

284,117,600.0

€                 

 

840,670,400.0

€                

 

713,401,600.0

€             

 

Gross Margin

3,922,948.9

€                 

 

103,530,000.0

€              

 

725,274,400.0

€                 

 

2,210,897,600.0

€             

 

1,882,770,400.0

€          

 

Gross Margin Revenue

85%

70%

72%

72%

73%

Operating Expenses

3,587,908.0

€                 

 

7,210,924.0

€                 

 

538,540,788.0

€                 

 

1,864,389,568.0

€             

 

1,598,822,208.0

€          

 

EBIT

335,040.9

€                    

 

96,319,076.0

€                

 

186,733,612.0

€                 

 

346,508,032.0

€                

 

283,948,192.0

€             

 

EBIT/Revenue

7%

65%

18%

11%

11%

Worst Case Scenario 

(Revenue Decrease by 15%)

Best Case Scenario 

(Revenue Increase by 15%)

€-

€500,000,000.00 

€1,000,000,000.00 

€1,500,000,000.00 

€2,000,000,000.00 

€2,500,000,000.00 

€3,000,000,000.00 

€3,500,000,000.00 

€4,000,000,000.00 

€4,500,000,000.00 

Year 1

Year 2

Year 3

Year 4

Year 5

Revenue

Best Case

Most Likely

Worst Case