Details for (NG.) / Market data / Selftrade

NATIONAL GRID

(NG. GB00B08SNH34 GBX)

Value 666.500

Change Today 0.00

Updated18/05 16:35

TRADE NOW

WATCHLIST

REG INV

ALERTS

PROFILE

Registered Number	4031152
Registered Address	1-3 Strand London United Kingdom WC2N 5EH
Phone Number	+44 (0) 207 0043000
Fax Number
Website	http://www.nationalgrid.com
Activities	Operates and ownes regulated electricity and gas infrastructure
Country of Register	GB
Currency	GBX
Short Name	TIOL GRID
First Day Traded	13/01/2006
Industrial Sector
Number of shares	3.51b

Key People

Sir John Parker	Chairman
Steven Holliday	Chief Executive Officer
Sir Peter Gershon	Non Executive Director
Steve Lucas	Financial Director
Ruth Kelly	Non Executive Director
Stephen Pettit	Non Executive Director
Philip Aiken	Non Executive Director
John Allan	Non Executive Director
Paul Golby	Non Executive Director
Maria Richter	Non Executive Director
Mark Fairbairn	Director
Nick Winser	Director
Andrew Bonfield	Financial Director

Major Shareholders

Capital World Investors	5.41%
BlackRock Investment Management (UK) Ltd.	5.12%

Director Deals

Director	Date	Buy/Sell	Quantity	Price
You need to be a Selfrade customer to access this data. Find out more >

Director

Date

Buy/Sell

Quantity

Price

You need to be a Selfrade customer to access this data.

Find out more >

Income Statements £1K

	AR 2007	AR 2008	AR 2009	AR 2010	AR 2011
Fiscal Year End	31/03/2007	31/03/2008	31/03/2009	31/03/2010	31/03/2011
Duration (months)	12	12	12	12	12
Accounting Format	IFRS	IFRS	IFRS	IFRS	IFRS
Sales/Revenue	8,695	11,041	15,624	13,988	14,343
Cost of Goods Sold (COGS) incl. D&A	5,846	7,900	11,881	9,788	6,808
COGS excluding D&A	4,975	6,896	10,759	8,594	5,538
Depreciation & Amortization Expense	871	1,004	1,122	1,194	1,270
Depreciation	830	954	1,058	1,131	1,200
Amortization of Intangibles	41	50	64	63	70
Amortization of Deferred Charges	0	0	0	0	0
Gross Income	2,849	3,141	3,743	4,200	7,535
Selling, General & Administrative Expense	0	0	0	0	0
Research & Development	6	13	10	19	16
Other Selling, General & Administrative	0	0	0	0	0
Other Operating Expense	478	621	891	926	3,935
Non Operating Income/Expense	86	98	4	-257	-85
Non-Operating Interest Income	218	211	61	18	22
Equity in Affiliates (Pretax)	0	0	0	0	7
EBIT	0	0	0	0	0
Unusual Expense	158	-347	376	-47	-136
EBIT after Unusual Expense	-158	0	0	0	0
Interest Expense	768	988	1,152	897	1,056
Gross Interest Expense	838	1,107	1,285	996	1,185
Interest Capitalized	70	119	133	99	129
Pretax Income	1,749	2,188	1,389	2,185	2,624
Income Tax	441	611	472	804	461
Income Tax - Current Domestic	38	58	-17	166	7
Income Tax - Current Foreign	-40	244	339	-290	103
Income Tax - Deferred Domestic	177	109	143	254	10
Income Tax - Deferred Foreign	266	200	7	674	341
Income Tax Credits	0	0	0	0	0
Minority Interest Expense	2	3	3	3	4
Equity in Affiliates	2	4	5	8	0
Other After Tax Income (Expense)	0	0	0	0	0
Net Income	1,308	1,578	919	1,386	2,159
Extraordinaries & Discontinued Operations	86	1,618	25	0	0
Extra Items & Gain/Loss Sale Of Assets	0	1,582	16	0	0
Cumulative Effect - Accounting Chg	0	0	0	0	0
Discontinued Operations	86	36	9	0	0
Net Income After Extraordinaries	1,394	3,196	944	1,386	2,159
Preferred Dividends	0	0	0	0	0
Net Income available to Common	1,308	1,578	919	1,386	2,159
Operational EPS	46.61	45.75	43.00	49.00	60.75
EPS (basic)	46.13	55.66	33.99	50.44	63.90
EPS (diluted)	42.97	54.08	33.43	50.19	63.56
EBITDA	3,242	3,524	3,974	4,468	4,870
EBIT	0	0	0	0	0
+Depreciation & Amortization Expense	871	1,004	1,122	1,194	1,270

Balance Sheet £1K

	AR 2007	AR 2008	AR 2009	AR 2010	AR 2011
Fiscal Year End	31/03/2007	31/03/2008	31/03/2009	31/03/2010	31/03/2011
Duration (months)	12	12	12	12	12
Accounting Format	IFRS	IFRS	IFRS	IFRS	IFRS
Cash & Short Term Investments	3,968	2,732	3,527	2,365	3,791
Cash Only	50	174	87	0	94
Short-Term Investments	3,918	2,558	3,440	0	3,697
Total Accounts Receivable	698	1,320	1,657	1,356	1,213
Accounts Receivables, Net	638	1,162	1,569	1,296	1,163
Accounts Receivables, Gross	740	1,317	1,872	1,607	1,446
Bad Debt/Doubtful Accounts	-102	-155	-303	-311	-283
Other Receivables	60	158	88	60	50
Inventories	106	310	556	407	320
Finished Goods	20	178	341	198	114
Work in Progress	17	16	13	12	12
Raw Materials	69	116	163	162	152
Progress Payments & Other	0	0	39	35	42
Other Current Assets	540	1,094	1,021	944	1,003
Prepaid Expenses	0	0	6	7	4
Miscellaneous Current Assets	540	1,094	1,015	937	999
Total Current Assets	5,312	5,456	6,761	5,072	6,327
Net Property, Plant & Equipment	18,895	24,333	29,545	30,855	31,956
Property, Plant & Equipment - Gross	28,987	35,207	42,394	44,369	46,123
Buildings	778	1,158	1,504	1,572	1,758
Land & Improvements	0	0	0	0	0
Machinery & Equipment	25,466	30,580	37,516	39,230	40,898
Construction in Progress	1,972	2,626	2,485	2,541	2,415
Leases	0	0	0	0	0
Computer Software and Equipment	0	0	0	0	0
Leased Property	0	0	0	0	0
Transportation Equipment	771	843	889	1,026	1,052
Other Property, Plant & Equipment	0	0	0	0	0
Accumulated Depreciation	10,092	10,874	12,849	13,514	14,167
Buildings	192	202	242	283	409
Land & Improvements	0	0	0	0	0
Machinery & Equipment	9,433	10,179	12,084	12,624	13,100
Construction in Progress	0	0	0	2	0
Leases	0	0	0	0	0
Computer Software and Equipment	0	0	0	0	0
Leased Property	0	0	0	0	0
Transportation Equipment	467	493	523	605	658
Other Property, Plant & Equipment	0	0	0	0	0
Total Investments and Advances	517	1,372	1,902	2,064	1,957
LT Investment - Affiliate Companies	5	71	168	250	356
Other Long-Term Investments	512	1,301	1,734	1,814	1,601
Long-Term Note Receivable	30	190	92	71	37
Intangible Assets	1,624	4,110	5,761	5,491	5,277
Net Goodwill	1,480	3,838	5,391	5,102	4,776
Net Other Intangibles	144	272	370	389	501
Other Assets	2,011	2,361	269	0	846
Deferred Charges	43	853	269	0	556
Tangible Other Assets	1,968	1,508	0	0	290
Total Assets	28,389	37,822	44,467	43,553	46,400
ST Debt & Curr. Portion LT Debt	1,031	3,882	3,253	2,806	2,952
Short Term Debt	6	572	783	150	499
Current Portion of Long Term Debt	1,025	3,310	2,470	2,656	2,453
Accounts Payable	1,246	1,708	1,653	1,702	1,720
Income Tax Payable	75	298	383	391	503
Other Current Liabilities	1,008	1,234	1,737	1,660	1,651
Dividends Payable	0	0	0	0	0
Accrued Payroll	0	0	0	0	0
Miscellaneous Current Liabilities	1,008	1,234	1,737	1,660	1,651
Total Current Liabilities	3,360	7,122	7,026	6,559	6,826
Long-Term Debt	14,686	17,121	23,540	22,318	20,246
Long-Term Debt excl. Capitalized Leases	14,594	16,956	23,335	22,145	20,064
Non-Convertible Debt	14,594	16,956	23,335	22,145	20,064
Convertible Debt	0	0	0	0	0
Capitalized Lease Obligations	92	165	205	173	182
Provision for Risks & Charges	1,709	2,689	4,531	4,505	4,035
Deferred Taxes	2,389	3,407	2,524	3,324	3,766
Deferred Taxes - Credit	2,389	3,407	2,661	3,324	3,766
Deferred Taxes - Debit	0	0	-137	0	0
Accumulated Minority Interest	11	18	14	12	9
Other Liabilities	2,109	2,103	2,725	2,636	2,458
Deferred Tax Liability-Untaxed Reserves	0	0	0	0	0
Other Liabilities (excl. Deferred Income)	978	817	1,185	1,070	894
Deferred Income	1,131	1,286	1,540	1,566	1,564
Total Liabilities	24,253	32,442	40,483	39,342	37,331
Non-Equity Reserves	0	0	0	0	0
Preferred Stock (Carrying Value)	0	0	0	0	0
Redeemable Preferred Stock	0	0	0	0	0
Non-Redeemable Preferred Stock	0	0	0	0	0
Preferred Stock issues for ESOP	0	0	0	0	0
ESOP Guarantees - Preferred Stock	0	0	0	0	0
Common Equity (total)	4,125	5,362	3,970	4,199	9,060
Common Stock Par/Carry Value	308	294	294	298	416
Additional Paid-In Capital/Capital Surplus	1,332	1,371	1,371	1,366	1,361
Retained Earnings	7,635	3,784	1,970	2,151	6,988
ESOP Debt Guarantee	0	0	0	0	0
Cumulative Translation Adjustment/Unrealized For. Exch. Gain	-22	-115	312	317	216
Unrealized Gain/Loss Marketable Securities	1	9	4	48	60
Revaluation Reserves	0	0	0	0	0
Other Appropriated Reserves	-5,129	19	19	19	19
Unappropriated Reserves	0	0	0	0	0
Treasury Stock	0	0	0	0	0
Total Shareholders' Equity	4,125	5,362	3,970	4,199	9,060
Liabilities & Shareholders' Equity	28,389	37,822	44,467	43,553	46,400

Cash Flow £1K

	AR 2007	AR 2008	AR 2009	AR 2010	AR 2011
Fiscal Year End	31/03/2007	31/03/2008	31/03/2009	31/03/2010	31/03/2011
Duration (months)	12	12	12	12	12
Accounting Format	IFRS	IFRS	IFRS	IFRS	IFRS
Net Income before Extraordinaries	2,513	2,964	2,623	3,293	3,745
Depreciation, Depletion & Amortization	871	990	1,122	1,188	1,245
Depreciation and Depletion	830	940	1,058	1,131	1,245
Amortization of Intangible Assets	41	50	64	57	0
Deferred Taxes & Investment Tax Credit	0	0	0	0	0
Deferred Taxes	0	0	0	0	0
Investment Tax Credit	0	0	0	0	0
Other Funds	-1,064	-1,333	-1,362	-1,360	-1,247
Funds from Operations	2,320	2,621	2,383	3,121	3,743
Extraordinaries	0	0	0	0	0
Changes in Working Capital	18	-150	54	431	185
Receivables	0	0	0	0	0
Inventories	0	0	0	0	0
Accounts Payable	0	0	0	0	0
Income Taxes Payable	0	0	0	0	0
Other Accruals	0	0	0	0	0
Other Assets/Liabilities	0	0	0	0	0
Net Operating Cash Flow	2,338	2,471	2,437	3,552	3,928
Capital Expenditures	2,218	2,877	3,185	3,111	3,134
Capital Expenditures (Fixed Assets)	2,185	2,832	3,107	3,007	2,958
Capital Expenditures (Other Assets)	33	45	78	104	176
Net Assets from Acquisitions	-269	-3,502	0	0	0
Sale of Fixed Assets & Businesses	21	81	27	15	26
Purchase/Sale of Investments	-1,706	19	26	725	-1,701
Purchase of Investments	-3,699	-8,814	-6,246	-2,918	-1,712
Sale/Maturity of Investments	1,993	8,833	6,272	3,643	11
Other Uses	-132	0	0	0	0
Other Sources	27	3,050	1,049	0	0
Net Investing Cash Flow	-4,277	-3,229	-2,083	-2,371	-4,809
Cash Dividends Paid - Total	-730	-780	-838	-688	-858
Common Dividends	-730	-780	-838	-688	-858
Preferred Dividends	0	0	0	0	0
Change in Capital Stock	-153	-1,475	-619	11	3,229
Repurchase of Common & Preferred Stk.	-169	-1,498	-627	-7	-3
Sale of Common & Preferred Stock	16	23	8	18	3,232
Proceeds from Stock Options	16	23	8	18	3,232
Other Proceeds from Sale of Stock	0	0	0	0	0
Issuance/Reduction of Debt, Net	3,048	1,593	2,281	-312	-2,098
Change in Current Debt	-160	675	7	12	13
Change in Long-Term Debt	3,208	918	2,274	-324	-2,111
Issuance of Long-Term Debt	5,519	1,568	4,892	1,933	767
Reduction in Long-Term Debt	-2,311	-650	-2,618	-2,257	-2,878
Other Funds	-71	-26	-633	-208	275
Other Uses	-71	-26	-633	-208	-73
Other Sources	0	0	0	0	348
Net Financing Cash Flow	2,094	-688	191	-1,197	548
Exchange Rate Effect	-14	4	18	-1	-3
Miscellaneous Funds	0	0	0	0	0
Net Change in Cash	141	-1,442	563	-17	-336
Free Cash Flow	-577	-1,141	-1,508	-143	112

Analysis Data

	2007	2008	2009	2010	2011
Fiscal Year End	2007-03-31	2008-03-31	2009-03-31	2010-03-31	2011-03-31
Valuation
Market Capitalisation	21,540.95	17,393.34	13,012.50	16,788.07	20,837.52
Price/Earnings	15.55	11.17	14.17	11.44	9.30
Price/Sales	2.49	1.63	0.84	1.13	1.40
Price/Book Value	5.22	3.24	3.28	4.00	2.30
Price/Cash Flow	9.34	7.34	5.43	4.48	5.14
Enterprise Value/EBIT	14.17	14.46	12.80	11.82	11.00
Enterprise Value/EBITDA	10.36	10.34	9.19	8.66	8.13
Enterprise Value/Sales	3.86	3.30	2.34	2.77	2.76
Total Debt/Enterprise Value	0.47	0.58	0.73	0.65	0.59
Total Debt/EBITDA	4.85	5.96	6.74	5.62	4.76
EPS (basic)	46.13	55.66	33.99	50.44	63.90
EPS (diluted) as stated	42.97	54.08	33.43	50.19	63.56
Profitability
Gross Margin (%)	32.77	28.45	23.96	30.03	52.53
Operating Margin (%)	27.27	22.82	18.25	23.41	25.10
Pretax Margin (%)	20.12	19.82	8.89	15.62	18.29
Net Margin (%)	15.04	14.29	5.88	9.91	15.05
Return on Assets (%)	4.82	4.77	2.23	3.15	4.80
Return on Equity (%)	34.39	33.27	19.70	33.93	32.57
Return on Avg. Total Capital (%)	7.18	6.83	3.22	4.61	7.01
Return on Avg. Invested Capital (%)	8.03	7.64	3.68	5.13	7.74
Efficiency
Revenue/Employee	0.46	0.40	0.56	0.50	0.53
Receivables Turnover	9.65	10.94	10.50	9.29	11.17
Days of Sales Outstanding (DSO) (%)	37.84	33.36	34.77	39.31	32.69
Inventory Turnover	54.64	37.98	27.44	20.33	18.73
Days of Inventory on Hand (DIO)	6.68	9.61	13.30	17.96	19.49
Total Asset Turnover	0.32	0.33	0.38	0.32	0.32
Working Capital Turnover	4.45	0.00	0.00	0.00	0.00
Liquidity
Current Ratio	1.58	0.77	0.96	0.77	0.93
Quick Ratio	1.55	0.72	0.88	0.71	0.88
Capital Structure
Debt-to-Total Equity (%)	381.02	391.70	674.89	598.33	256.05
Debt-to-Total Capital (%)	79.21	79.66	87.09	85.68	71.91
Debt-to-Total Assets (%)	55.36	55.53	60.25	57.69	50.00
Interest Coverage	2.83	2.28	2.22	3.29	3.04

Market data

Name	Latest	Var
FTSE 100	5,267.62(c)	+0.00%
FTSE 250	10,431.90(c)	+0.00%
DOW INDUSTRIALS	12,369.38(c)	-0.59%
HONG KONG HANG SENG INDIC	18,852.94	-0.52%
Nikkei 225	8,633.89(c)	+0.26%

Name	Latest	Var

Name	Latest	Var

Buys

Name	Latest	Var
AVIVA	264.90(c)	-1.05%
RED EMPEROR RES	14.88(c)	-17.36%
LLOYDS GRP.	25.95(c)	-6.15%
BP	391.95(c)	-1.18%
VODAFONE GRP.	164.30(c)	-0.96%

Sells

Name	Latest	Var
LLOYDS GRP.	25.95(c)	-6.15%
RED EMPEROR RES	14.88(c)	-17.36%
PV CRYSTALOX	9.45(c)	+121.31%
BARCLAYS	176.10(c)	-3.19%
AVIVA	264.90(c)	-1.05%

Selftrade is a trading name and Selftrade® a registered trademark of Talos Securities Limited, which is authorised and regulated by the Financial Services Authority (FSA Register number 208271) and is a member of the London Stock Exchange and PLUS Markets. Talos Securities Ltd is incorporated in England and Wales (Registration No. 4196325, Registered Address: Boatman's House, 2 Selsdon Way, London E14 9LA). VAT No. 629 2807 22.

Data: include Bondscape, Dow Jones, Factset, FTSE, Morningstar. Conditions may apply.

NATIONAL GRID

PROFILE

Key People

Major Shareholders

Director Deals

Income Statements £1K

Balance Sheet £1K

Cash Flow £1K

Analysis Data

Help

FTSE 100 chart

Market data

Today's News

Account applications

Dealing account and ISA

CFDs and Spread Betting

Other Investment Accounts and Transfers

Important Information