Värderingsmodell.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
2
BolagValuePotentialHistorikAntagandenKommentarSannolikhets värdering
3
DCF#DIV/0!#DIV/0!2017201820192020202120222023Market20192020202120222023
4
DDM0,00#DIV/0!Oms.tillväxt#DIV/0!#DIV/0!4,00%4,30%4,30%4,30%4,30%
Market value (DKK)
0000
5
DDM +5 år0,00#DIV/0!Omsättning00000Market growth
6
Medel#DIV/0!#DIV/0!EBITDA-marg#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Customers00000
7
His P/E (5y)#DIV/0!#DIV/0!EBITDA0000000Growth
8
His EV/EBIT (5y)#DIV/0!#DIV/0!EBIT-marg#DIV/0!#DIV/0!4,00%3,50%3,50%3,50%3,50%
9
His EV/EBITDA (5y)
#DIV/0!#DIV/0!EBIT0000000Sales
10
His P/S (5y)#DIV/0!#DIV/0!Vinst-marg#DIV/0!#DIV/0!Worst
11
His P/B (5y)#DIV/0!#DIV/0!Vinst0000000Worst-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
12
Peer a. P/E#DIV/0!#DIV/0!Worst-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
13
Peer a. EV/EBIT#DIV/0!#DIV/0!Sales per share#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
14
Peer a. P/S#DIV/0!#DIV/0!EBITDA per share#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base
15
Peer a. P/B#DIV/0!#DIV/0!EBIT per share#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
16
Medel#DIV/0!EPS#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
17
DPS0,000,000,000,000,00Sum of parts Best-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
18
AktiekursAktiepris till varje ratioBest#DIV/0!
19
P/S0,5#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!P/SMin#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
20
EV per share#DIV/0!1#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
21
P/E#DIV/0!2#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
22
EV/EBIT#DIV/0!#DIV/0!
23
EV/EBITDA#DIV/0!EV/EBITDA12#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
EV/EBITDA
Min#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!EBIT
24
P/S#DIV/0!18#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst
25
P/B#DIV/0!24#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
26
UtdelningWorst-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
27
Direktavkastning
#DIV/0!EV/EBIT10#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!EV/EBITMin#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
28
Utdelningsandel#DIV/0!14#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base
29
Prognos19#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
30
Vinst tillväxt 3år#DIV/0!Base-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
31
Vinst tillväxt 5år#DIV/0!P/E10#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!P/EMin#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
32
PEG+1#DIV/0!15#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best
33
PEG+2#DIV/0!20#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
34
PEG+3#DIV/0!Best-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
35
PEG+4#DIV/0!KurspotientialenKurspotientialenBest-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
36
PEG+5#DIV/0!P/S0,5#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!P/SMin#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Profit
37
P/E+1#DIV/0!1#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst
38
P/E+2#DIV/0!2#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
39
P/E+3#DIV/0!Worst-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
40
P/E+4#DIV/0!EV/EBITDA12#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
EV/EBITDA
Min#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Worst-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
41
P/E+5#DIV/0!18#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base
42
EV/EBIT+1#DIV/0!24#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
43
EV/EBIT+2#DIV/0!Base-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
44
EV/EBIT+3#DIV/0!EV/EBIT10#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!EV/EBITMin#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
45
EV/EBIT+4#DIV/0!14#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best
46
EV/EBIT+5#DIV/0!19#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-worst#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
47
EV/EBITDA+1#DIV/0!Best-base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
48
EV/EBITDA+2#DIV/0!P/E10#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!P/EMin#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Best-best#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
49
EV/EBITDA+3#DIV/0!15#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Base#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
50
EV/EBITDA+4#DIV/0!20#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Max#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
51
EV/EBITDA+5#DIV/0!
52
P/S+1#DIV/0!
53
P/S+2#DIV/0!
54
P/S+3#DIV/0!
55
P/S+4#DIV/0!
56
P/S+5#DIV/0!
57
72
73
74
Loading...