Dcf Model1
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Dcf Model1 as PDF for free.
More details
- Words: 248
- Pages: 1
Tabella1
Free risk rate
2.90%
Coeff. Rischio specifico
2.50%
Coef. Rischio settoriale
2.50%
Beta
Patrimonio netto
Posizione finanziaria netta
73.66%
77,401
26.34%
100.00%
1.20
Costo del capitale proprio
Costo del capitale di terzi
7.70%
Tax rate
41.00
0.41
1.20%
6.56%
Wacc % di crescita perpetua “g”
2006 Ricavi
2007 0
Ebit Tax rate
216,494
2008
1,100,000
8.90%
Capitale investito
293,895
4.54%
N° azioni
140,000
7.75%
0.0775
1.0775
2.50%
0.0250
1.0250
2009
1,150,000
2010
1,170,000
2011
1,190,000
0.053
2012
1,200,000
2013
1,230,000
2014
1,250,000
2015
1,260,000
1,270,000
5,421
5,800
6,100
6,400
7,000
7,500
8,100
8,800
9,500
10,200
50.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
Imposte
2,711
2,610
2,745
2,880
3,150
3,375
3,645
3,960
4,275
4,590
14,000
15,000
15,500
15,000
14,000
13,000
13,000
12,000
12,000
12,000
Accantonamenti
0
0
0
0
0
0
0
0
0
0
Variaz. CCN
0
0
0
0
0
0
0
0
0
0
Investimenti
-7,500
-7,500
-7,500
-7,000
-7,000
-7,000
-7,000
-7,000
-7,000
-7,000
Ammortamenti
Free Cash Flow Anno Discount
9,211 1
10,690 2
11,355 3
11,520 4
10,850 5
10,125 6
10,455 7
9,840 8
10,225 9
10,610 10
1.0775
1.1611
1.2511
1.3481
1.4526
1.5652
1.6865
1.8173
1.9582
D. F. cash Flow
8,548
9,207
9,076
8,546
7,470
6,469
6,199
5,415
5,222
5,029
Somma dfcf
8,548
17,755
26,831
35,377
42,846
49,315
55,514
60,929
66,151
71,179
Media dfcf
7,118
Valore finale
138,902
Somma dfcf
71,179
PFN
77,401
Minority Surplus assets Valore equity
Valore per azione
0.00 0.00 132,680
0.948
Pagina 1
2.1100
Free risk rate
2.90%
Coeff. Rischio specifico
2.50%
Coef. Rischio settoriale
2.50%
Beta
Patrimonio netto
Posizione finanziaria netta
73.66%
77,401
26.34%
100.00%
1.20
Costo del capitale proprio
Costo del capitale di terzi
7.70%
Tax rate
41.00
0.41
1.20%
6.56%
Wacc % di crescita perpetua “g”
2006 Ricavi
2007 0
Ebit Tax rate
216,494
2008
1,100,000
8.90%
Capitale investito
293,895
4.54%
N° azioni
140,000
7.75%
0.0775
1.0775
2.50%
0.0250
1.0250
2009
1,150,000
2010
1,170,000
2011
1,190,000
0.053
2012
1,200,000
2013
1,230,000
2014
1,250,000
2015
1,260,000
1,270,000
5,421
5,800
6,100
6,400
7,000
7,500
8,100
8,800
9,500
10,200
50.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
45.00%
Imposte
2,711
2,610
2,745
2,880
3,150
3,375
3,645
3,960
4,275
4,590
14,000
15,000
15,500
15,000
14,000
13,000
13,000
12,000
12,000
12,000
Accantonamenti
0
0
0
0
0
0
0
0
0
0
Variaz. CCN
0
0
0
0
0
0
0
0
0
0
Investimenti
-7,500
-7,500
-7,500
-7,000
-7,000
-7,000
-7,000
-7,000
-7,000
-7,000
Ammortamenti
Free Cash Flow Anno Discount
9,211 1
10,690 2
11,355 3
11,520 4
10,850 5
10,125 6
10,455 7
9,840 8
10,225 9
10,610 10
1.0775
1.1611
1.2511
1.3481
1.4526
1.5652
1.6865
1.8173
1.9582
D. F. cash Flow
8,548
9,207
9,076
8,546
7,470
6,469
6,199
5,415
5,222
5,029
Somma dfcf
8,548
17,755
26,831
35,377
42,846
49,315
55,514
60,929
66,151
71,179
Media dfcf
7,118
Valore finale
138,902
Somma dfcf
71,179
PFN
77,401
Minority Surplus assets Valore equity
Valore per azione
0.00 0.00 132,680
0.948
Pagina 1
2.1100
Related Documents
Dcf Model1
November 2019 12
Dcf
October 2019 14
01402-dcf
October 2019 14
Dcf Summary
June 2020 5
Dcf Marazzi Multpipli
November 2019 8