Cairn Homes (CRN)

Company name:	Cairn Homes Plc
EPIC:	CRN	Trading Currency:	GBX
Market Sector:	SMEU	ISIN:	IE00BWY4ZF18
Market Segment:	SSMU	Share Type:	DE
WWW Address:	https://www.cairnenergy.com/investors/	Description:	ORD EUR0.001
Industry Sector:	HOUSEHOLD GOODS & HOME CONSTRUCTION

Cairn Homes Key Figures

(at previous day's close)
Market Cap.	670.01	m
Shares In Issue	749.45	m
Prev. Close	90.60
PE Ratio	15.52
Dividend Yield	4.97	%
EPS - basic	5.76	p
Dividend PS	4.44	p
Dividend Cover	-
Cash Flow PS	11.20	p
Return On Equity (ROE)	6.73	%
Operating Margin	13.46	%
PEG Factor	0.25
EPS Growth Rate	62.50	%
Dividends PS Growth Rate	-	%
Net Debt	126.60	m
Gross Gearing	21.28	%
Quick Assets	58.53	m
Net Working Capital	773.41	m
Intangibles / Fixed Assets	46.95	%
Turnover PS	49.16	p
Pre-Tax Profit PS	6.62	p
Retained Profit PS	5.78	p
Cash PS	6.41	p
Net Cash PS	0.49	p
Net Tangible Asset Value PS *	85.76	p
Net Asset Value PS	86.24	p
Spread	2.40 (2.60%)
* 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.

Period ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	91.10	-1.70	-1.87	89.50	0.38		93.71
4 weeks	0.96	88.44	9,251.46	0.93	0.30		45.84
12 weeks	0.80	88.60	11,103.01	0.78	0.36		12.57
26 weeks	0.89	88.52	10,001.69	0.75	0.69		3.56
1 year	1.35	88.05	6,541.90	0.60	0.82		2.05
3 years	1.92	87.48	4,556.25	0.60	1.05		1.56
5 years	1.19	88.22	7,444.30	0.60	1.64		1.45
† periods calculated are whole weeks rather than calendar months

(Market value analysis) at previous day's close
PQ Ratio	2.72
PE Ratio	15.52
Tobin's Q Ratio	0.68
Tobin's Q Ratio (excl. intangibles)	0.68
Dividend Yield	4.97	%
Market-to-Book Ratio	1.04
Price-to-Pre-Tax Profit PS	13.51
Price-to-Retained Profit PS	15.46
Price-to-Cash Flow PS	7.98
Price-to-Sales PS	1.82
Price-to-Net Tangible Asset Value PS	1.04
Price-to-Cash PS	13.94
Net Working Capital PS	103.20
Price Pct to Working Capital PS	0.87	%
Earnings Yield	6.44	%
Average PE	1.66
Years in average	5
PE to PE average	935.44	%

(Leverage Ratios)
Debt Ratio	16.77	%
Debt-to-Equity Ratio	0.20
Debt-to-Equity Ratio (excl. Intgbl)	0.20
Debt-to-Equity Market Value	0.19
Net Gearing	15.42	%
Net Gearing (excl. Intangibles)	15.45	%
Gross Gearing	21.28	%
Gross Gearing (excl. Intangibles)	21.32	%
Gearing Under 1 Year	5.41	%
Gearing Under 1 Year (excl. Intgbl)	5.42	%
Assets/Equity	1.27
Cash/Equity	7.44
(Liquidity Ratios)
Net Working Capital to Total Assets	94.20	%
Current Ratio	18.41
Quick Ratio (Acid Test)	1.32
Liquidity Ratio	1.08
Cash & Equiv/Current Assets	5.88	%
(Solvency Ratios)
Enterprise Value	754.31	m
CFO/Sales	0.23
CFO/Attributable Profit	1.94
CFO/Assets	0.10
CFO/Debt	0.48
Total Debt/Equity Market Value	0.26
Total Debt/Sales	0.47
Total Debt/Pre-Tax Profit	3.52
Total Debt	174.68	m
Total Debt/Net Current Assets	0.23	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	121.27	%
5 yr Compound Earnings Growth	-	%
10 yr Compound Earnings Growth	-	%
Earn drops > 5% in 10yrs	1

Beta (60-Mnth)	Beta (36-Mnth)
0.0007	0.0005

(Profitability Ratios)
Return On Capital Employed (ROCE)	6.38	%
Return On Assets (ROA)	4.39	%
Net Profit Margin	11.77	%
Assets Turnover	0.37
Return On Equity (ROE)	6.73	%
Return On Investment (ROI)	4.74	%
Dividend Payout Ratio	80.77	%
Plowback Ratio	19.23	%
Growth from Plowback Ratio	1.10	%
Net Income Of Revenues	11.77	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	0.49
Fixed Assets Turnover	123.93
Current Assets Turnover	0.37
Net Working Capital Turnover
Inventory Turnover	0.40
(Other Operating Ratios)
Total Assets-to-Sales	2.68
Debtors-to-Sales	2.77	%
Debt Collection Period	10.10	Days

Name	Activity	Type	Mnemonic	Code
Winterflood Securities Ltd	Market Maker(MMF)	Broker/Dealer	WINS	WNTSGB2LBIC