Title: Ratio analysis for Bellway Company
About Bellway plc
The Bellway Group is one of the largest housebuilders in the U.K. It was established in 1946 by John T.Bells and his two sons[1].The Group’s operations are spread throughout the country.
The key activities of the Group include: land acquisition, finance, planning, architecture, design, build management, marketing and customer service. Bellway builds low-cost homes and apartment blocks on disused or abandoned sites.
Position and Strategy
Bellway sells around 6,000 houses every year and has till date provided more than 100,000 homes.
The houses are designed, built and marketed by local teams operating from regional offices. These offices are managed and staffed by local people. The company employs about 2,000 people with varying expertise.
Corporate Social Responsibility
The Group has adopted five principles in their day-to-day operations to minimise the environmental effects of the building process and create sustainable communities:
“Protection of the environment
Prudent use of natural resources
Creating environments that have the potential to add to economic growth and employment opportunities
Social considerations that recognise the needs for a changing and advancing population
The creation of communities that will endure and where people will aspire to live”
Source: Bellway p.l.c. Annual Report & Accounts 2007
The Group reports on these five principles in its Annual Report.
Performance Overview of Bellway Group
The housing industry has been facing challenging market conditions since the last few months. However the Chairman of the Group has made the following statement in the Annual Report of the Group for the year ended 31 July 2007.
“Bellway has, yet again, produced a very good set of results for the year ended 31 July. The Group continues to deliver organic growth in volumes and earnings despite the challenging market conditions experienced by the housing industry over the last twelve months.”
The present paper attempts to examine the reality of the statement by doing a ratio analysis to assess the financial health of the Group based on its Annual Reports for the year ended 31 July 2007.
Performance Overview
The key highlights of performance in the year ended July 2007 over the previous year are given in the table[2] below:
Revenue
Increased
+ 9.2%
Operating Profit
Increased
+5.8%
Profit before taxation
Increased
+6.4%
Total Equity
Increased
+14.6%
In the next section a detailed analysis of the financial performance and health of the Group has been examined on the basis of:
Performance Ratios
Working Capital Efficiency Ratios
Investment Ratios
Financial Status Ratios
PERFORMANCE RATIOS
Return on capital employed (ROCE)
Profit before Tax and Interest Payable
= x 100
Total Assets less Current Liabilities
2007
£000
2006
£000
Profit before Tax and Interest Payable*
258,126
242,281
Total Assets
1,636,622
1,494,203
Current Liabilities
473,947
396,029
Total Assets less Current Liabilities
1,162,675
1,098,174
ROCE
(258,126/ 1,162,675) x 100
= 22.2%
(242,281/ 1,098,174) x 100
= 22.1%
* This is taken as equal to operating profit plus interest income
The ROCE of the Group is around 22% in the year ended 2007. Despite a 6.5% increase in the Profit before Tax and Interest Payable in 2007, the ROCE stands at the same figure as in 2006. This only indicates that the net assets have also increased in the same proportion as profits. However, there has been no improvement in the efficiency in employing theses net assets to generate profits.
Moreover, ROCE for the Group is lower than five year average ROCE achieved by builders over UK which stands at 25–30%[3]. Thus, the efficiency in employing net assets to generate profits for the Group is lower than the Industry average.
Asset turnover
Sales Turnover
=
Total Assets less Current Liabilities
2007
£000
2006
£000
Sales Turnover
1,354,022
1,240,193
Total Assets
1,636,622
1,494,203
Current Liabilities
473,947
396,029
Total Assets less Current Liabilities
1,162,675
1,098,174
Asset Turnover
1,354,022 / 1,162,675
= 1.165 times
1,240,193 / 1,098,174
= 1.129 times
The asset turnover ratio of 1.165 indicates that a sale of £1.165 is generated from each £ invested in assets by the Group. This ratio has increased by around 3.6% in 2007 over 2006 which is a good sign. The increase is primarily due to an increase in total assets and also a corresponding increase in the sales turnover.
Net profit margin
Profit before Tax and Interest Payable
= x 100
Sales turnover
2007
£000
2006
£000
Profit before Tax and Interest Payable*
258,126
242,281
Sales Turnover
1,354,022
1,240,193
Net Profit Margin
(258,126/ 1,354,022)
x 100 = 19.1%
(242,281/ 1,240,193)
x 100 = 19.5%
*This is taken as equal to operating profit plus interest income
Despite the increase in profit before interest and taxes and also sales turnover, there is a slight decline in the net profit margin from 19.5% in the year ended 2006 to 19.1% in the year ended 2007. The decline indicates that proportionate increase in cost of operations has been higher than the increase in sales. Thus, there has been a decline in the efficiency of sales to generate profits.
Gross profit margin
Gross Profit
= x 100
Sales turnover
2007
£000
2006
£000
Gross Profit
311,920
292,272
Sales Turnover
1,354,022
1,240,193
Gross Profit Margin
(311,920 / 1,354,022) x 100
= 23%
(292,272/ 1,240,193) x 100
= 23.6%
There has been a decrease in the gross profit margin of the Group by 0.6% despite the increase in sales revenue. The decline in the gross profit margin has been due to a larger increase in cost of sales as compared to corresponding increase in sales. Sales revenue has increased by 9.2% over 2006. The corresponding increase in cost of sales has been 9.9%. The decline in the gross profit margin also explains to certain extent the decline in net profit margin.
WORKING CAPITAL EFFICIENCY RATIOS
Inventories (or stock) turnover
Stocks and Work in Progress
= x 365
Purchases (or Cost of Sales)
2007
£000
2006
£000
Stocks and Work in Progress
1,537,874
1,433,999
Cost of Sales
1,042,102
947,921
Inventories (or stock) turnover[4]
(1,537,874 / 1,042,102)
x 365 = 538.65 days
(1,433,999/ 947,921)
x 365 = 552.16 days
The housebuilding industry by its very nature has slow moving stock / inventory. In 2007, as compared to 2006, there has been a decline in the number of days the stock takes to be converted into sales. The stock is getting converted into sales in 538.65 days in 2007 as compared to 552.16 days. This is an improvement of around 2.4% over 2006.
Trade receivables (or trade debtors) turnover
Trade Debtors
= x 365
Sales Turnover
2007
£000
2006
£000
Trade Debtors[5]
15,948
12,084
Sales Turnover *
1,354,022
1,240,193
Trade receivables(or trade debtors) turnover
(15,948/ 1,354,022)
x 365 = 4.29 days
(12,084/ 1,240,193)
x 365 = 3.56 days
* All sales are assumed to be on credit
Though it takes less than 1 week to collect receivables, the increase in the time taken to receive payments from customers must be examined carefully before it gets out of hands. An increasing ratio also indicates that the company is taking more time for collecting its payments. Thus, each £1 of its sales revenue stays tied up in trade receivables for a longer period.
Trade payables (or trade creditors) turnover
Trade Creditors
= x 365
Cost of Sales
2007
£000
2006
£000
Trade Creditors[6] *
84,387
92,646
Cost of Sales **
1,042,102
947,921
Trade payables(or trade creditors) turnover
(84,387/ 1,042,102)
x 365 = 29.55 days
(92,646/ 947,921)
x 365 = 35.67 days
** All purchases are assumed to be on credit
There has been a decline in the average settlement period for trade creditors by almost 17%. This is not a good sign as trade credit is a type of free finance available to a company. A declining ratio indicates that suppliers in the year ended 2007 gave a lower credit period to the Group as compared to the previous year. This becomes a bigger cause of concern as the Stock Turnover ratio for the Group stands at a high figure. It may also have adverse implications for the Group’s liquidity position.
INVESTMENT RATIOS
Earnings per share (EPS)
Profit before Ordinary Dividend
=
No. of Ordinary Shares in issue
2007
2006
Profit before Ordinary Dividend
£166,714,000
£155,742,000
No. of Ordinary Shares in Issue
115,248,726
114,370,287
Earning per share (Diluted)[7]
166,714,000 / 115,248,726
=£ 1.447 or 144.7p
155,742,000 / 114,370,287
= £1.362 or 136.2 p
EPS reflects upon share performance. Thus EPS trend of the Group highlights the investment potential of its shares. It also highlights the possibility that the company will pay a dividend[8].
There has been a 6.2% growth in the diluted EPS of the Group in the year ended 2007 as compared to 2006. This indicates that the potential of the shares of the Group is growing. This increase in EPS is primarily due to an increase in the profits with no corresponding increase in tax rates.
Price earnings ratio(PE)
Market Value per Share
=
Earning per share
In general, if the PE ratio of a company is high it implies that investors are optimistic about the company’s future and are expectinghigher earningsgrowthin the future compared to companies with alower PE. However, the ratio can only be interpreted appropriately when compared to historical PE ratio or industry benchmarks.
Group’s historical PE ratio
The PE ratio for the Group has been constant over the previous two years.
31 July 2007
31 July 2006
Market Value per Share
1247p
1,174p
Earning per share
144.7p
136.2p
Price Earnings Ratio
1247 / 144.7
= 8.6
1,174 / 136.2
=8.6
The ratio needs to be examined in light of the deteriorating industry scenario over the last two months. The PE ratio calculated above may not hold true today and would have declined substantially. This is because housebuilding is a cyclical business where earnings fall exponentially as sales prices decline. Recent times have seen a substantial decline in sale prices. If the PE is calculated at the share price of 713.5p[9] as on 25 April 2008, assuming earnings to be constant at 31 July 2007 level, it will be only 4.9. Thus, actual PE will be lower.
The following diagram[10] highlights the PE ratios of 8 leading housebuilders in UK as on 21 July 2007.
The diagram clearly indicates that Bellway is towards the lower end of the selected companies in the industry UK with regard to its PE ratio
Dividend yield
Latest Annual Dividends
= x 100
Current market share price
The dividend yield at the current price as on 25 April 2008 = (43.125 / 713.5) %
= 6%
However, the market price of shares for the Group is much lower than it was a year ago.
Historically, the dividend yield has been as indicated in the table below:
31 July 2007
31 July 2006
Market share price
1247p
1,174p
Annual Dividend per share
43.125 p
34.55p
Dividend Yield
(43.125 / 1247)%
= 3.5%
(34.55 / 1174)%
=2.9%
Dividend cover
Profit on ordinary activities after taxation
=
Ordinary Dividend
2007
£000
2006
£000
Profit on ordinary activities after taxation
166,714
155,742
Ordinary dividend
49701
39988
Dividend cover
166,714 / 49701
= 3.35 times
155,742 / 39988
= 3.89 times
The dividend cover has fallen despite the fact that the profits have increased. A declining trend makes dividend less secure. However it is not a cause of concern for the Group as the dividend cover is much better than many other companies in the industry. For example, housebuilder Persimmon has cover of 2.69[11]. Thus, if the Group has a cover of more than 3, it could maintain its payout more than thrice over.
Return on equity (ROE)
Profit on ordinary activities after taxation
= x 100
Equity shareholders’ funds
2007
£000
2006
£000
Profit on ordinary activities after taxation
166,714
155,742
Equity shareholders’ funds
1,035,814
903,500
Return on Equity
(166,714 / 1,035,814 ) x 100
= 16.1%
(155,742/ 903,500) x 100
= 17.2%
The Group shows a decline in this ratio in 2007 over 2006. The decline may be primarily due to increase in equity shareholders’ funds.
FINANCIAL STATUS RATIOS
Working capital ratio (WCR)
Current Assets
=
Current liabilities
2007
£000
2006
£000
Current Assets
1,608,507
1,462,831
Current Liabilities
473,947
396,029
Working Capital Ratio
(1,608,507 / 473,947)
= 3.394
(1,462,831 / 396,029)
= 3.694
The accepted norm for the WCR ratio is that current assets should be double the current liabilities. However, the norm varies with industry. In the case of the Group the ratio has declined but it is higher than the accepted norm. However, a closer analysis indicates that the Group faces a liquidity crisis. A close examination of the current assets indicates that inventories constitute more than 95% of the current assets. This, added to a high stock turnover ratio, will not let the Group meet its current obligations. A clearer picture of the liquidity is provided by the Quick Asset ratio.
Quick assets ratio (QAR)
Current Assets – Stocks
=
Current liabilities
2007
£000
2006
£000
Current Assets
1,608,507
1,462,831
Stocks and Work in Progress
1,537,874
1,433,999
Current Asset – Stock
70,633
28832
Current Liabilities
473,947
396,029
Quick assets ratio
(70,633/ 473,947)
= 0.149
(28832/ 396,029)
= 0.07
The norm for this ratio is 1: 1. However, it again varies from business to business. The ratio is far below the norm. In other words, the Group has no way of covering up its current obligations. This is a cause of concern and can lead to survival problems also if the condition persists.
Gearing
Long-term Debt + Preference Shares
=
Total Assets less Current Liabilities
2007
£000
2006
£000
Long-term Debt + Preference Shares*
126,861
194,674
Total Assets less Current Liabilities
1,162,675
1,098,174
Gearing
126,861 / 1,162,675
= 0.11
194,674 / 1,098,174
= 0.18
*These include preference shares of £20,000,000 in both the years
The gearing or dependence on debt has decreased by about 7% for the Group. Thus, there has been a decline in the Group’s risk as lesser amount is committed for periodic interest and repayment commitments. This is especially welcome in the time of deteriorating housing market conditions.
Interest cover
Profit before Tax and Interest Payable
=
Interest payable
2007
£000
2006
£000
Profit before Tax and Interest Payable
258,126
242,281
Interest payable
22,961
21,339
Interest cover
258,126/ 22,961
= 11.24 times
242,281
/ 21,339
= 11.35 times
Despite the decline in gearing, the Group’s interest cover for the year ended 31 July 2007 also shows a slight decline. The decrease in interest cover from last year is due to a higher increase in net interest payable than increase in profit before tax and interest.
Conclusion:
To conclude it can be said that Bellway has performed well in the year ended July 2007 over 2006 in terms of profitability as well as increased sales. However, it faces a major short-term liquidity crisis. This is a cause of concern as the UK’s housebuilding industry, in general, is expected to be facing more difficult times ahead due to credit crunch and declining consumer demand.
References:
Atrill Peter & McLaney Eddie, Financial Accounting for Decision Makers, 5th ed. 2008 , FT Prentice Hall
Barker Review Interim Report, The Housebuilding Industry, accessed from http://www.hm-treasury.gov.uk/media/2/9/barkerreview_interim_chapters4to6.pdf
Bellway p.l.c. Annual Report & Accounts 2007
Elliott B. and J. Elliott, Financial Accounting and Reporting, 11th ed. 2007, FT Prentice Hall
HIFIC Barnard Report, Future Trends in Timber Construction and Implications for HIE Region, accessed from www.forestryscotland.com/pages/download2.asp?file=attachments/HIFIC_Forres%2007_Barnard.pdf
Steed, Alison, Five ‘safe’ shares for hard times, The Sunday Times 20 April, 2008
Team Limited, The Cartel- Like Industry, accessed from http://www.teamlimited.co.uk/Assets/pdf/Building-Barriers.pdf
Yahoo finance, accessed from http://finance.yahoo.com/q/pr?s=BWY.L
Hemscott website accessed from www.hemscott.com
Brief: 209439Page 1 of 13
[1] Source: http://finance.yahoo.com/q/pr?s=BWY.L
[2] Source: Bellway p.l.c. Annual Report & Accounts 2007
[3] HIFIC Barnard Report, Future Trends in Timber Construction and Implications for HIE Region, accessed from www.forestryscotland.com/pages/download2.asp?file=attachments/HIFIC_Forres 07_Barnard.pdf
[4] Ideally average stock and work in progress figures should be taken for calculating the ratio as they give more accurate ratios as average inventory accounts for any seasonality effects on the ratio. However, in the case of house building industry seasonality effect is not there. Moreover due to non-availability of 2005 figures, end of the year figures are used. .
[5] Ideally average trade debtors figures should be taken for calculating the ratio as they give more accurate ratios. However, due to non-availability of 2005 figures, end of the year figures are used.. Trade receivables do not include other receivables not arising from sales (Refer Note 13 of Bellway Annual Report pp 68)
[6] Ideally average trade creditors’ figures should be taken for calculating the ratio as they give more accurate ratios. However, due to non-availability of 2005 figures, end of the year figures are used. Trade payables do not include other payables not arising from purchases (Refer Note 15 of Bellway Annual Report pp 69)
[7] Diluted EPS is based on the total outstanding shares after all Options and awards have been exercised.
[8] EPS only indicates the possibility of a dividend. However, dividend decision is a corporate decision and there is no rule of thumb regarding its size and frequency.
[9] http://finance.yahoo.com/q?s=BWY.L
[10] Based on PE ratios published on 21 July 2007 by www.hemscott.com
[11] Steed, Alison, The Sunday Times, 20 April 2008
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download