Fichiers publics, 13 Jan 2017

VeoliaJanv2017 (XLSX)

Identifiant du fichier:: 00043161
Nom original:: VeoliaJanv2017.xlsx
Type de fichier:: XLSX - Microsoft Excel (OpenXML)
Taille:: 158.27 KB
Envoyé le:: 13/01/2017 à 16:58
Vues:: 965 vues

Télécharger

Aperçu texte

a Base year 1 2 3 4 5 6 7 8 9 10 Terminal year n
Revenue growth rate  0.025 0.025 0.025 0.025 0.025 0.024 0.023 0.022 0.021 0.02 0.02 
Revenues 24603 25218.074999999997 25848.526874999996 26494.740046874995 27157.10854804687 27836.03626174804 28504.10113202999 29159.69545806668 29801.208758144145 30427.034142065168 31035.57482490647 31656.2863214046 
EBIT (Operating) margin 0.06118874787400462 0.06356987308660415 0.0659509982992037 0.06833212351180323 0.07071324872440277 0.07309437393700231 0.07547549914960185 0.0778566243622014 0.08023774957480093 0.08261887478740047 0.085 0.085 
EBIT (Operating income) 1505.4267639441357 1603.109827238465 1704.736151970046 1810.4418492961815 1920.3673713936428 2034.6576434401672 2151.361260750695 2270.2754557948874 2391.181925362334 2513.847323935241 2638.0238601170504 2690.7843373193914 1185.3575733752557
Tax rate 0.32 0.32 0.32 0.32 0.32 0.32 0.322 0.324 0.326 0.328 0.33 0.33 
EBIT(1-t) 1023.6901994820122 1090.1146825221563 1159.2205833396313 1231.1004575214033 1305.8498125476772 1383.5671975393138 1458.6229347889712 1534.706208117344 1611.656617694213 1689.3054016844821 1767.4759862784238 1802.8255060039921 
 - Reinvestment  449.7974999999979 452.4922353458958 455.35972703819476 458.39735838868046 461.6028599438334 446.37531218282186 430.6086644093272 414.32811072772995 397.56123917756173 380.3379267758146 600.9418353346639 4947.802769324521
FCFF  640.3171825221584 706.7283479937355 775.7407304832086 847.4524541589967 921.9643375954804 1012.2476226061493 1104.0975437080167 1197.328506966483 1291.7441625069205 1387.1380595026092 1201.8836706693282 
NOL 0 0 0 0 0 0 0 0 0 0 0 0 
             
Cost of capital  0.07671760780561973 0.07671760780561973 0.07671760780561973 0.07671760780561973 0.07671760780561973 0.07337408624449579 0.07003056468337185 0.06668704312224791 0.06334352156112397 0.06000000000000002 0.06 
Cumulated discount factor  0.9287486270778349 0.8625740122989632 0.8011144296756816 0.744033926693532 0.6910204879159483 0.6437834644710678 0.6016496030293929 0.5640357281066558 0.5304360412885004 0.5004113597061324  
PV(FCFF)  594.6937041618021 609.6055067343743 621.4570928772523 630.5333771539887 637.096246406333 651.6682813839888 664.2798488776559 675.3360562096954 685.1876599177002 694.1396424558266  
             
Terminal cash flow 1201.8836706693282            
Terminal cost of capital 0.06            
Terminal value 30047.09176673321            
PV(Terminal value) 15035.9060462059            
PV (CF over next 10 years) 6463.997416178618            
Sum of PV 21499.90346238452            
Probability of failure = 0            
Proceeds if firm fails = 10749.95173119226            
Value of operating assets = 21499.90346238452            
 - Debt 13675.485888446912            
 - Minority interests 1138            
 +  Cash 3862            
 + Non-operating assets 0            
Value of equity 10548.417573937606            
 - Value of options 0            
Value of equity in common stock 10548.417573937606            
Number of shares 549.5            
Estimated value /share 19.19639230925861            
Price 15.31            
Price as % of value 0.7975456926151606            
             
Implied variables            After year 10 
Sales to capital ratio  1.367448685241692 1.3932877202148375 1.4191267551879827 1.4449657901611281 1.4708048251342736 1.4966438601074188 1.522482895080564 1.5483219300537094 1.5741609650268549 1.6  
Invested capital 19426.185888446915 19875.98338844691 20328.47562379281 20783.835350831003 21242.232709219683 21703.835569163515 22150.21088134634 22580.819545755665 22995.147656483394 23392.708895660955 23773.04682243677  
ROIC 0.05269640707447458 0.05484582378730478 0.05702447172098133 0.05923355515189741 0.06147422591698208 0.06374758936641897 0.06585142428677017 0.067965035768855 0.07008681317337889 0.07221503970400908 0.07434789488616568 0.06000000000000002

Partager le fichier

Lien court vers la page de téléchargement du fichier:

Code HTML - Recopiez ce code pour partager votre fichier XLS sur un site Web:

Code BB-Code - Utilisez ce code pour partager votre tableau sur un forum Web compatible avec les tags BB:

Lien permanent vers la page de téléchargement du fichier:

Signaler un contenu illicite

VeoliaJanv2017 (XLSX)

Aperçu texte

Sur le même sujet..

Partager le fichier