Essay Writing Service

Ratio Analysis for Building Company

Ratio Analysis for Building Company

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

  1. 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.

Get help with your essay today, from our professional essay writers!

Qualified writers in the subject of accounting are ready and waiting to help you with your studies.

  • Get help with your essay
  • View professionally written samples

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.

  1. 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.

  1. 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.

  1. 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

  1. 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.

  1. 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.

  1. 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

  1. 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.

Get help with your essay today, from our professional essay writers!

Qualified writers in the subject of accounting are ready and waiting to help you with your studies.

  • Get help with your essay
  • View professionally written samples
  1. 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.

  • Industry average

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

  1. 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%

  1. 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.

  1. 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

  1. 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.

  1. 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.

  1. 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.

  1. 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 //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 //www.teamlimited.co.uk/Assets/pdf/Building-Barriers.pdf
  • Yahoo finance, accessed from //finance.yahoo.com/q/pr?s=BWY.L
  • Hemscott website accessed from www.hemscott.com

Brief: 209439Page 1 of 13

Get help with your essay today, from our professional essay writers!

Qualified writers in the subject of accounting are ready and waiting to help you with your studies.

  • Get help with your essay
  • View professionally written samples

[1] Source: //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] //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



Most Used Categories

Testimonials
I order from this writer for quite a while, so we are having the chemistry going on between us. Great job as always!
Laura C., March 2018
Wow, ordering from EssayHub was one of the most pleasant experiences I have ever had. Not only was my work sent to me hours before the deadline, but the content was absolutely fantastic! Would order from them again!
Daniel L., March 2018
Professional Custom
Professional Custom Essay Writing Services
In need of qualified essay help online or professional assistance with your research paper?
Browsing the web for a reliable custom writing service to give you a hand with college assignment?
Out of time and require quick and moreover effective support with your term paper or dissertation?