FINC 340 & 440 WEEK 1

profilebarkersbaseball
comparablesranking-eyroce-example.xlsx

Comps-Rank

yPeriod ABC_EY TTEK_EY FLR_EY FWLT_EY ENG_EY JEC_EY URS_EY ABC_ROCE ENG_ROCE FLR_ROCE FWLT_ROCE JEC_ROCE TTEK_ROCE URS_ROCE
2009 9.25% 7.8% 8.3% 9.0% 4.6% 8.5% 7.3% -25.0% 6.5% 31.7% 30.0% 24.3% 23.6% 35.6%
Rank 1 5 4 2 7 3 6 7 6 2 3 4 5 1
2010 7.73% 7.9% 9.3% 10.3% 8.8% 8.6% 7.3% 36.2% -32.7% 12.9% 16.8% 15.9% 17.7% 37.4%
Rank 6 5 2 1 3 4 7 2 7 6 4 5 3 1
2011 7.26% 7.2% 8.3% 9.6% 15.7% 7.8% 9.8% 21.0% -8.2% 21.7% 18.7% 17.8% 22.1% -14.6%
Rank 6 7 4 3 1 5 2 3 6 2 4 5 1 7
2012 7.5% 7.6% 8.2% 9.2% 9.6% 7.9% 6.3% 54.8% -46.7% 17.6% 19.8% 17.9% 22.9% 22.4%
Rank 6 5 3 2 1 4 7 1 7 6 4 5 2 3
Total 19 22 13 8 12 16 22 13 26 16 15 19 11 12
5 6 3 1 2 4 6 3 7 5 4 6 1 2
ABC TTEK FLR FWLT ENG JEC URS
Grand Total 32 33 29 23 38 35 34
Rank by EY - ROCE 3 4 2 1 7 6 5
Price/Earnings 14.6 14.9 13.8 0 14.4 12.7
Price/Book 1.8 3.3 212.8 2.1 1.9 0.8
Price/Sales 0.7 0.5 1 0.3 0.7 0.3
Price/Cash Flow 11.3 16.2 17.7 4.3 15.9 5.8
2013 4.4% 8.2% 9.4% 14.3 8.2% 6.3% -0.8 3.4% 6.5% 3.8% 43.9% 7.2% -0.0 25.7% 16.4% 18.0% 2.7% 26.6%
Rank
2014 [TTM] 5.4% 7.3% 7.5% 0.2 7.4% 7.4%
Rank
Great Grand Total
Rank by EY - FCFY - ROCE
EV/EBIT Ratio by Sector
[Industrial Services | Engineering & Construction]
R-T: Damodaran, Value Multiples by Sector [ev/ebit(DA) ratio] list: http://people.stern.nyu.edu/ADAMODAR/New_Home_Page/datafile/vebitda.html
12.52 10.42
12.52
Earnings Yield [EBIT/EV]
ROCE [EBIT/CE]
FCF Yield [FCF / MV]
Market Value-MV [EBIT * EV/EBIT Ratio]
Interest-bearing debt [ST+LT]
Excess Cash [Cash-(Rev * 5%)]
Enterprise Value-EV [MV + Debt - Excess Cash]
Capital Employed-CE [Cash + AR + INV - AP + NFA]

Comps Rank

GrandTotal ABC TTEK FLR FWLT ENG JEC URS 32 33 29 23 38 35 34 Rank by EY-FCFY-ROCE 3 4 2 1 7 6 5