Carillion Fundamentals and Key Ratios

Company name:	Carillion Plc
Company Description:	Providing expertise in commercial and industrial building, refurbishment, civil engineering, road and rail construction and maintenance, mechanical and electrical services, facilities management and PFI Solutions
EPIC:	CLLN	Trading Currency:	GBX
Market Sector:	ON10	ISIN:	GB0007365546
Market Segment:	SET3	Share Type:	DE
WWW Address:	http://www.carillionplc.com/	Description:	ORD 50P
Industry Sector:	CONSTRUCTION & MATERIALS

Price	Price Change [%]	Bid	Ask	Open	High	Low	Volume
14.20	0.0 [0.00]	-	-	-	-	-	-
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
61.10	430.25	-0.00	28.90	18.45	0.49	-	-

Carillion Key Figures

Key Figures
(at previous day's close)
Market Cap.	61.10	m
Shares In Issue	430.25	m
Prev. Close	14.20
PE Ratio	0.49
Dividend Yield	-	%
EPS - basic	28.90	p
Dividend PS	18.45	p
Dividend Cover	1.57
Cash Flow PS	17.04	p
Return On Equity (ROE)	17.72	%
Operating Margin	2.81	%
PEG Factor	-0.08
EPS Growth Rate	-6.47	%
Dividends PS Growth Rate	1.10	%
Net Debt	3,233.40	m
Gross Gearing	83.54	%
Quick Assets	2,308.40	m
Net Working Capital	169.80	m
Intangibles / Fixed Assets	81.59	%
Turnover PS	1,211.89	p
Pre-Tax Profit PS	34.10	p
Retained Profit PS	10.53	p
Cash PS	109.19	p
Net Cash PS	-406.18	p
Net Tangible Asset Value PS *	-225.03	p
Net Asset Value PS	169.64	p
Spread	- (-%)
* Calculation based on Ordinary Capital figure as contained in last annual report, and the most recent shares in issue figure. Therefore the ratio might be exposed to inaccuracies.

Carillion Balance Sheet

%1$s Balance Sheet

Share Price Performance

Sorry No Data Available

Share Price Chart (5 years)

Carillion Historic Returns

Sorry No Data Available

Carillion Key Management Ratios

DEEPER ANALYSIS

Carillion Investment Ratios

%1$s Investment Ratios
(Market value analysis) at previous day's close
PQ Ratio	2.53
PE Ratio	0.49
Tobin's Q Ratio	0.01
Tobin's Q Ratio (excl. intangibles)	0.02
Dividend Yield	-	%
Market-to-Book Ratio	0.09
Price-to-Pre-Tax Profit PS	0.42
Price-to-Retained Profit PS	1.35
Price-to-Cash Flow PS	0.83
Price-to-Sales PS	0.01
Price-to-Net Tangible Asset Value PS	-0.07
Price-to-Cash PS	0.13
Net Working Capital PS	39.46
Price Pct to Working Capital PS	0.36	%
Earnings Yield	203.52	%
Average PE	10.53
Years in average	5
PE to PE average	4.67	%

Carillion Financial Ratios

%1$s Financial Ratios
(Leverage Ratios)
Debt Ratio	67.06	%
Debt-to-Equity Ratio	2.04
Debt-to-Equity Ratio (excl. Intgbl)	-1.58
Debt-to-Equity Market Value	24.32
Net Gearing	72.94	%
Net Gearing (excl. Intangibles)	116.99	%
Gross Gearing	83.54	%
Gross Gearing (excl. Intangibles)	133.99	%
Gearing Under 1 Year	50.02	%
Gearing Under 1 Year (excl. Intgbl)	80.23	%
Assets/Equity	6.07
Cash/Equity	64.36
(Liquidity Ratios)
Net Working Capital to Total Assets	3.83	%
Current Ratio	1.08
Quick Ratio (Acid Test)	1.04
Liquidity Ratio	0.21
Cash & Equiv/Current Assets	19.68	%
(Solvency Ratios)
Enterprise Value	1,105.90	m
CFO/Sales	0.01
CFO/Attributable Profit	0.59
CFO/Assets	0.02
CFO/Debt	0.02
Total Debt/Equity Market Value	60.61
Total Debt/Sales	0.71
Total Debt/Pre-Tax Profit	25.24
Total Debt	3,703.20	m
Total Debt/Net Current Assets	21.81	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	1.06	%
5 yr Compound Earnings Growth	-	%
10 yr Compound Earnings Growth	0.65	%
Earn drops > 5% in 10yrs	6

Beta coefficients
Beta (60-Mnth)	Beta (36-Mnth)
-0.0000	-0.0000

Carillion Operating Ratios

%1$s Operating Ratios
(Profitability Ratios)
Return On Capital Employed (ROCE)	6.62	%
Return On Assets (ROA)	2.99	%
Net Profit Margin	2.38	%
Assets Turnover	1.26
Return On Equity (ROE)	17.72	%
Return On Investment (ROI)	5.76	%
Dividend Payout Ratio	63.84	%
Plowback Ratio	36.16	%
Growth from Plowback Ratio	5.30	%
Net Income Of Revenues	0.87	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	6.15
Fixed Assets Turnover	2.60
Current Assets Turnover	2.43
Net Working Capital Turnover
Inventory Turnover	72.87
(Other Operating Ratios)
Total Assets-to-Sales	0.80
Debtors-to-Sales	30.82	%
Debt Collection Period	112.50	Days

Carillion Dividends

%1$s Dividends
Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
01 Mar 2017	Final	GBX	12.65	12/31/2015	12/31/2016	05/11/2017	05/12/2017	06/09/2017	18.45
24 Aug 2016	Interim	GBX	5.80	12/31/2015	12/31/2016	09/01/2016	09/02/2016	11/02/2016	-
03 Mar 2016	Final	GBX	12.55	12/31/2014	12/31/2015	05/12/2016	05/13/2016	06/10/2016	18.25
26 Aug 2015	Interim	GBX	5.70	12/31/2014	12/31/2015	09/03/2015	09/04/2015	11/04/2015	-
04 Mar 2015	Final	GBX	12.15	12/31/2013	12/31/2014	05/14/2015	05/15/2015	06/12/2015	17.75
14 Aug 2014	Interim	GBX	5.60	12/31/2013	12/31/2014	09/03/2014	09/05/2014	11/05/2014	-
05 Mar 2014	Final	GBX	12.00	12/31/2012	12/31/2013	05/14/2014	05/16/2014	06/13/2014	17.50
22 Aug 2013	Interim	GBX	5.50	12/31/2012	12/31/2013	09/04/2013	09/06/2013	11/06/2013	-
27 Feb 2013	Final	GBX	11.85	12/31/2011	12/31/2012	05/15/2013	05/17/2013	06/14/2013	17.25
22 Aug 2012	Interim	GBX	5.40	12/31/2011	12/31/2012	09/05/2012	09/07/2012	11/07/2012	-
08 Mar 2012	Final	GBX	11.60	12/31/2010	12/31/2011	05/16/2012	05/18/2012	06/15/2012	16.90
24 Aug 2011	Interim	GBX	5.30	12/31/2010	12/31/2011	09/07/2011	09/09/2011	11/09/2011	-
02 Mar 2011	Final	GBX	10.70	12/31/2009	12/31/2010	05/15/2011	05/17/2011	06/17/2011	15.50
26 Aug 2010	Interim	GBX	4.80	12/31/2009	12/31/2010	09/08/2010	09/10/2010	11/10/2010	-
04 Mar 2010	Final	GBX	10.00	12/31/2008	12/31/2009	04/21/2010	04/23/2010	06/18/2010	14.60
27 Aug 2009	Interim	GBX	4.60	12/30/2008	06/30/2009	09/09/2009	09/11/2009	11/11/2009	-
04 Mar 2009	Final	GBX	8.90	12/31/2007	12/31/2008	04/22/2009	04/24/2009	06/19/2009	13.00
28 Aug 2008	Interim	GBX	4.10	12/30/2007	06/30/2008	09/03/2008	09/05/2008	11/07/2008	-
07 Mar 2008	Final	GBX	7.55	12/31/2006	12/31/2007	04/23/2008	04/25/2008	06/20/2008	11.00
05 Sep 2007	Interim	GBX	3.50	12/30/2006	06/30/2007	09/12/2007	09/14/2007	11/09/2007	-
07 Mar 2007	Final	GBX	5.90	12/31/2005	12/31/2006	04/25/2007	04/27/2007	06/22/2007	9.00
06 Sep 2006	Interim	GBX	3.10	12/30/2005	06/30/2006	09/13/2006	09/15/2006	11/10/2006	-
08 Mar 2006	Final	GBX	5.20	12/31/2004	12/31/2005	04/26/2006	04/28/2006	06/23/2006	8.00
07 Sep 2005	Interim	GBX	2.80	12/30/2004	06/30/2005	09/14/2005	09/16/2005	11/11/2005	-
09 Mar 2005	Final	GBX	4.83	12/31/2003	12/31/2004	04/22/2005	04/24/2005	06/24/2005	7.50
09 Sep 2004	Interim	GBX	2.68	12/30/2003	06/30/2004	09/15/2004	09/17/2004	11/12/2004	-
10 Mar 2004	Final	GBX	3.48	12/31/2002	12/31/2003	04/28/2004	04/30/2004	06/25/2004	5.05
10 Sep 2003	Interim	GBX	1.58	12/30/2002	06/30/2003	09/17/2003	09/19/2003	11/14/2003	-
11 Mar 2003	Final	GBX	3.30	12/31/2001	12/31/2002	04/30/2003	05/02/2003	06/27/2003	4.80
11 Sep 2002	Interim	GBX	1.50	12/30/2001	06/30/2002	09/18/2002	09/20/2002	11/15/2002	-
13 Mar 2002	Final	GBX	3.02	12/31/2000	12/31/2001	05/01/2002	05/03/2002	06/28/2002	4.40
12 Sep 2001	Interim	GBX	1.38	12/30/2000	06/30/2001	09/19/2001	09/21/2001	11/16/2001	-
14 Mar 2001	Final	GBX	2.78	12/31/1999	12/31/2000	05/02/2001	05/04/2001	06/29/2001	4.12
19 Sep 2000	Interim	GBX	1.34	12/30/1999	06/30/2000	09/25/2000	09/29/2000	11/22/2000	-
14 Mar 2000	Final	GBX	2.70	12/31/1998	12/31/1999	03/20/2000	03/24/2000	07/07/2000	4.00
05 Oct 1999	Interim	GBX	1.30	12/30/1998	06/30/1999	10/11/1999	10/15/1999	12/01/1999	-

Carillion Fundamentals

Profit and Loss Account
	31 Dec 2013 (GBP)		31 Dec 2014 (GBP)		31 Dec 2015 (GBP)		31 Dec 2016 (GBP)
turnover	3,332.60	100.00%	4,071.90	100.00%	4,586.90	100.00%	5,214.20	100.00%	m
pre tax profit	174.70	5.24%	142.60	3.50%	155.10	3.38%	146.70	2.81%	m
attributable profit	100.20	3.01%	120.70	2.96%	132.80	2.90%	124.20	2.38%	m
retained profit	25.60	0.77%	45.00	1.11%	56.00	1.22%	45.30	0.87%	m
eps - basic (p)	23.30		28.00		30.90		28.90
eps - diluted (p)	23.20		25.40		28.20		25.90
dividends per share	17.50		17.75		18.25		18.45

Carillion Balance Sheet

Balance Sheet
	31 Dec 2013 (GBP)		31 Dec 2014 (GBP)		31 Dec 2015 (GBP)		31 Dec 2016 (GBP)


	31 Dec 2013 (GBP)		31 Dec 2014 (GBP)		31 Dec 2015 (GBP)		31 Dec 2016 (GBP)
ASSETS
fixed assets	128.20	3.52%	140.90	3.62%	140.80	3.64%	144.10	3.25%	m
intangibles	1,552.80	42.66%	1,610.80	41.40%	1,633.90	42.22%	1,669.30	37.66%	m
fixed investments	165.30	4.54%	146.00	3.75%	193.40	5.00%	232.50	5.24%	m
current assets - other	2.40	0.07%	1.90	0.05%	-	-%	-	-%	m
stocks	48.60	1.34%	50.10	1.29%	64.30	1.66%	78.80	1.78%	m
debtors	1,328.90	36.51%	1,468.70	37.75%	1,375.50	35.54%	1,838.60	41.47%	m
cash & securities	413.70	11.37%	472.00	12.13%	462.20	11.94%	469.80	10.60%	m

TOTAL	3,639.90	100%	3,890.40	100%	3,870.10	100%	4,433.10	100%	m

LIABILITIES
creditors - short	1,661.60	45.65%	1,801.90	46.32%	1,771.10	45.76%	2,217.40	50.02%	m
creditors - long	994.70	27.33%	1,194.00	30.69%	1,081.70	27.95%	1,485.80	33.52%	m
creditors - other	-	-%	-	-%	-	-%	-	-%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	2,656.30	72.98%	2,995.90	77.01%	2,852.80	73.71%	3,703.20	83.54%	m

EQUITY
ord cap, reserves	967.20	26.57%	872.70	22.43%	993.50	25.67%	701.10	15.82%	m
prefs, minorities	16.40	0.45%	21.80	0.56%	23.80	0.61%	28.80	0.65%	m

TOTAL	983.60	27.02%	894.50	22.99%	1,017.30	26.29%	729.90	16.46%	m

OTHER
NAV Basic	-		-		-		-
NAV Diluted	-		-		-		-

Carillion Cash Flow Statement

%1$s Cash Flow Statement
	31 Dec 2013 (GBP)	31 Dec 2014 (GBP)	31 Dec 2015 (GBP)	31 Dec 2016 (GBP)
Operating CF	-78.40	123.80	73.30	73.30	m
Pre-Financing CF	28.80	124.60	99.30	73.50	m
Retained CF	-237.10	52.90	-6.10	-10.90	m

Carillion Brokers

%1$s Brokers
Name	Activity	Type	Mnemonic	Code
Altium Capital Limited	Market Maker(MME)	Broker/Dealer	ALTI	APCFGB21
J.P. Morgan Cazenove Limited	Market Maker(MME)	Broker/Dealer	CAZR	CAZEGB2L
Deutsche Bank AG London Branch	Market Maker(MME)	Broker/Dealer	DEUT	DEUTGB2L
Evolution Securities Limited	Market Maker(MME)	Broker/Dealer	EVO	EVBGGB21MMT
Goldman Sachs International	Market Maker(MME)	Broker/Dealer	GSCO	GSILGB2X
HSBC Bank plc	Market Maker(MME)	Broker/Dealer	HSBC	JCAPGB2L
J.P. Morgan Securities Ltd	Market Maker(MME)	Broker/Dealer	JPMS	JPMSGB2L
Morgan Stanley Securities Ltd	Market Maker(MME)	Broker/Dealer	MOST	MSSEGB21
Oriel Securities Limited	Market Maker(MME)	Broker/Dealer	OREL	ORSNGB21
Panmure Gordon (UK) Limited	Market Maker(MME)	Broker/Dealer	PMUR	PMURGB2L
Citigrp Global Mkt UK Equities	Market Maker(MME)	Broker/Dealer	CITI	SBUKGB21
Merrill Lynch International	Market Maker(MME)	Broker/Dealer	MLSB	SNCSGB2LBIC
UBS AG	Market Maker(MME)	Broker/Dealer	UBS.	UBSWGB2LEQU
Winterflood Securities Ltd	Market Maker(MME)	Broker/Dealer	WINS	WNTSGB2LBIC

Boards:

Quotes:

Carillion Key Figures

Carillion Balance Sheet

Share Price Performance

Share Price Chart (5 years)

Carillion Historic Returns

Carillion Key Management Ratios

Carillion Investment Ratios

Carillion Financial Ratios

Carillion Operating Ratios

Carillion Dividends

Carillion Fundamentals

Carillion Balance Sheet

Carillion Cash Flow Statement

Carillion Brokers