One more time with ... tables!

I learnt a new skill.  It's how to create tables in html. I then learnt an even better skill, how to get Excel to create tables in html, so here is my first table created by Excel:

		2010	2009	2008
	Notes	$'000	$'000	$'000
Premium revenue	5	901,370	829,486	758,238
Claims expense		(635,929)	(599,297)	(553,910)
HBRTF/RETF Levy		(109,898)	(86,978)	(73,128)
State levies		(22,045)	(21,177)	(19,922)
Claims handling expenses	6	(14,407)	(18,384)	(17,683)
Net claims incurred		119,091	103,650	93,595
Acquisition costs	6	(32,512)	(26,642)	(25,625)
Other underwriting expenses - ongoing	6	(39,514)	(36,847)	(34,916)
Other underwriting expenses - demutualisation and listing costs	6	0	0	(10,858)
Underwriting expenses		(72,026)	(63,489)	(71,399)
Underwriting result		47,065	40,161	22,196
Investment income	5	45,794	(1,167)	8,783
Other income	5	1,291	1,183	1,463
Investment expenses	6	(1,344)	(651)	(1,325)
Other expenses - ongoing	6	(5,840)	(7,931)	(3,548)
Other expenses - donation to nib foundation	6	0	0	(25,000)
Other expenses - demutualisation and listing costs		0	0	(7,640)
Profit/(loss) before income tax		86,966	31,595	(5,071)
Income tax expense/(benefit)	7	(25,441)	(7,809)	5,421
Profit/(loss) from continuing operations		61,525	23,786	350
Profit/(Loss) from discontinued operations			0	54
Revaluation of land and buildings			(3,156)
Available for sale financial assets			(88)
Income tax related to components of other comprehensive income			26
Profit/(Loss) for the year attributable to equity holders		61,525	20,568	404

This table sets out the Profit and Loss statements for the years 2008 to 2010 as they appear in the financial statements.  I've added it here because I re-read my last two posts and I couldn't understand them.  I figured if I, being the one who wrote them, couldn't understand them then what hope does anyone else have.  So here is a summary of the two posts with tables, which hopefully will make things much easier to understand.

So, we use the historical P&L to work out the "indicated earning power" or in other words, how much money we think the company can make.

Step One is to remove the non-recurrent items, that means anything that is a one off.  The presence of zeros is a good indicator of this, ie the items "Other underwriting expenses - demutualisation and listing costs", "Other expenses - demutualisation and listing costs" and "Other expenses - donation to nib foundation" only appear in 2008, so we can take them out. There are also a few items listed below the line "Profit/(loss) from continuing operations" which are once-offs, so we can also take them out.  If we do that, we get to here:

		2010	2009	2008
	Notes	$'000	$'000	$'000
Premium revenue	5	901,370	829,486	758,238
Claims expense		-635,929	-599,297	-553,910
HBRTF/RETF Levy		-109,898	-86,978	-73,128
State levies		-22,045	-21,177	-19,922
Claims handling expenses	6	-14,407	-18,384	-17,683
Net claims incurred		119,091	103,650	93,595
Acquisition costs	6	-32,512	-26,642	-25,625
Other underwriting expenses - ongoing	6	-39,514	-36,847	-34,916
Underwriting expenses		-72,026	-63,489	-60,541
Underwriting result		47,065	40,161	33,054
Investment income	5	45,794	-1,167	8,783
Other income	5	1,291	1,183	1,463
Investment expenses	6	-1,344	-651	-1,325
Other expenses - ongoing	6	-5,840	-7,931	-3,548
Profit/(loss) before income tax		86,966	31,595	38,427
Income tax expense/(benefit)	7	-25,441	-7,809	5,421
Profit/(loss) from continuing operations		61,525	23,786	43,848

So can I identify a figure for indicated earnings from this? I might be able to conclude that the underwriting result will increase next year, but the investment result is anyone's guess.

So was there any point in doing this exercise? Yes, because:
1. I now have a better understanding of the risks the business is subjected to - low on the insurance side, high on the investment side.
2. I also have to question the capability of management when they can spend a entire report only talking about one part of the business (insurance) and completing ignorning the other (investment).
2. I have a base for comparision with other companies, which may prove more or less volatile in their earnings.