ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Figures in $ MnHistorical Projected
2
201720182019202020212022202320242025
3
Sales154541554415693164711719017839184071888419262
4
Growth rate %0.6%1.0%5.0%4.4%3.8%3.2%2.6%2.0%0.6%
5
6
Cost of sales 6,174 6,313 6,368 6,454 6,890 7,150 7,378 7,569 7,720
7
Gross profit 9,280 9,231 9,325 10,017 10,300 10,689 11,029 11,315 11,541
8
GP margins %60%59%59%61%60%60%60%60%60%
9
10
Other operating expenses
5,098 5,026 5,252 5,593 5,725 5,946 6,140 6,303 6,432
11
12
Depreciation & Amortization
475511519539 536 551 564 575 583
13
Amrotization 35596288 81 79 77 75 73
14
Deprecriation 440452457451 455 472 487 500 510
15
16
Operating profits (EBIT)
370736943554388540394192432544374526
17
Operating profit margins (%)24.0%23.8%22.6%23.6%23.5%23.5%23.5%23.5%23.5%
18
19
Interest expenses102143145164160146138119108
20
21
Tax rates37.7%26.2%23.4%21.6%22.7%23.7%24.8%25.9%27%1.1%
22
PBT348734643301364738794046418743184418
23
Tax expesnes1313906774787879961104011191193
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
2.30%#REF!
52
53
Fixed asset schedule
54
Opening balance3840407238813750
55
Add: Net Purchases672261326417
56
Total Fixed assets4512433342074167
57
Less:Depreciation440452457451
58
Closing balance38404072388137503716
59
60
Rate of depreciation 10%10%11%11%
61
62
Fixed asset turnover ratio
3.43 3.59 3.73 3.95
63
64
Other intangible assets schedule
65
Opening balance1313134116372997
66
Add: Net Purchases633551422-15
67
Total Fixed assets1376169630592982
68
Less:Amortization 35596288
69
Closing balance13131341163729972894
70
71
Rate of amortization 3%3%2%3%
72
73
Working capital schedule
74
Debtors
75
Inventory
76
Other current assets
77
Creditors0000
78
Accured income tax payable
0000
79
Other accruals0000
80
Net Working capital0000
81
Changes in working capital
000
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100