CIMA F2 AFR Chapter 17
CIMA F2 AFR Chapter 17
CIMA F2 AFR Chapter 17
17
Financial Analysis
Financial analysis
The objective of financial statements is to provide information to all the users of these accounts to
help them in their decision-making. Note that most users will only have access to published financial
statements.
Interpretation and analysis of financial statements involves identifying the users of the accounts,
examining the information, analysing and reporting in a format which will give information for
economic decision making.
Types of users
Investors look at the risk of their investment, profitability and future growth.
Managers / employees have access to more information and will want to know the stability of the
company and profitability.
Creditors are interested in the liquidity, as they just want to be paid on time.
Banks are interested in the performance and liquidity of organisations for lending purposes
Government departments - have various uses.
Other groups including the local community on green issues, jobs etc.
17.1
Ratios are an effective way of analysing the financial statements. A ratio is 2 figures compared to
each other, and can either be in % terms or in absolute terms.
When analysing performance through the use of ratios it is important to use comparisons. A single
ratio is meaningless and is only of use when compared with other ratios, competitors, and over time.
Ratio uses
Performance Position
Potential
-
PBIT
Turnover
Asset turnover
Turnover
Total assets
X 100%
X 100%
(number of times)
Current ratio
Current assets__
Current liabilities
Quick ratio
Gearing - equity
Gearing total
Debt capital________
Debt + equity (total capital)
Interest cover
Trade payables______
Cost of sales (or purchases)
Inventory days
(number of times)
(number of times)
X 100%
X 100%
(number of times)
x 365 days
P/E ratio
Share price___
Earnings per share
Dividend yield
Dividend cover
The above is not the complete list, but are the main ratios.
X 100%
Step 3
What has happened to the figures or ratios? Have they increased or decreased?
WHY
Explain why the changes may have occurred by giving examples (think creatively!).
WOW
How do these changes affect the user of the information WOW thats great or not so
great!
17.2
Ratios in detail
We shall now look at some of the ratios in detail explain how they can be interpreted.
Performance ratios
1
ROCE
The ROCE measures profitability and shows how well the business is utilising its capital to generate
profits. Capital employed is debt and equity. Equity is shareholders funds (share holders funds) and
debt is non current liabilities. Capital employed can be found from the statement of financial position
by taking the shareholders funds (share capital and reserves) and long term debt.
The ROCE can be broken down into 2 parts, operating profit margin and asset turnover.
A low ROCE is either caused by a low profit margin or high capital employed. A high ROCE is
either caused by high profit margin or low capital employed. It is therefore important to look at the
profitability, assets, liabilities and share capital when trying to give reasons for the change in ROCE.
2
PBIT x 100%
Turnover
This is the ratio of operating profit to sales or turnover. A high operating profit margin is due higher
sales prices or low costs. Other factors to consider include inventory valuation, overhead allocation,
bulk discounts and sales mix.
Low profit margins are not normally good news as it suggests poor performance. But there may be
other factors to consider relating to the business activities and industry. For example the company
may be entering a new market which requires low selling prices.
Other profit margin ratios can also be calculated:
Asset turnover
Asset turnover
Turnover___________
Total assets or capital employed
This shows how much sales are generated for every 1 of capital employed. A low asset turnover
indicates that the business is not using its assets affectively and should either try to increase its sales
or dispose of some of the assets.
A company with old non current assets that are almost completely depreciated will show a high asset
turnover, whereas a company with recently acquired non current assets will show a low asset turnover.
Different accounting policies will also give different ratios, for example using the cost model to or revaluation model.
The age of the non current assets is important in understanding the ratio. Recently acquired non
current assets will not be generating revenues to their full extent.
Interaction between ROCE, operating profit margin and asset turnover:
ROCE
PBIT
Turnover
Turnover
CE
PBIT
CE
Current assets
Current liabilities
(times)
The current ratio measures the short term solvency or liquidity; it shows the extent to which the claims
of short-term creditors are covered by assets. The current ratio is essentially looking at the working
capital of the company. Effective management of working capital ensures the organisation is running
efficiently. This will eventually result in increased profitability and positive cash flows. Effective
management of working capital involves low investment in non productive assets like trade
receivables, inventory and current account bank balances. Also maximum use of free credit facilities
like trade payables ensures efficient management of working capital.
The normal current ratio is around 2:1 but this varies within different industries. Low current ratio
may indicate insolvency. High ratio may indicate not maximising return on working capital.
Valuation of inventories will have an impact on the current ratio, as will year end balances and
seasonal fluctuations.
(times)
This ratio measures the immediate solvency of a business as it removes the inventories out of the
equation, which is the item least representing cash, as it needs to be sold. Normal is around 1: 1 but
this varies within different industries.
365 days
This is the length of time taken to pay the suppliers. The ratio can also be calculated using cost of
sales, as credit purchases are not usually stated in the financial statements.
High trade payable days is good as credit from suppliers represents free credit. If its too high then
there is a risk of the suppliers not extending credit in the future and may lose goodwill. High trade
payable days may also indicate that the business has no cash to pay which indicates insolvency
problems.
Limitations in the trade payable days ratio are:
Year-end trade payables may not be representative of the year.
Credit purchases are VAT exclusive in the income statement, whereas trade payables are
including VAT in the statement of financial position.
4
365 days
Inventory days
Average inventory
Cost of sales
365 days
Average inventory can be arrived by taking this years and last years inventory values and dividing
by 2 - (Opening inventories + closing inventories) / 2
This ratio shows how long the inventory stays in the company before it is sold. The lower the ratio
the more efficient the company is trading, but this may result in low levels of inventories to meet
demand.
A lengthening inventory period may indicate a slow down in trade and an excessive build up of
inventories, resulting in additional costs.
The disadvantage of this ratio is that the average calculation based on beginning and year-end
inventory may not represent actual average in year.
Other limitations in the stock ratios are:
Inclusion of obsolete stock
Different stock valuation policies
Inventory turnover is the reciprocal of inventory days
Cost of sales___
Average inventory
number of times
It shows how quickly the inventory is being sold. It shows the liquidity of inventories, the higher the
figure the quicker the inventory is sold.
This is the time between paying for goods supplied and final receipt of cash from their sale. It is
desirable to keep the cycle as short as possible:
The working capital cycle therefore should be kept to a minimum to ensure efficient and cost effective
management.
Working capital cycle for a trade
Inventories days (time inventories are held before being sold)
Plus
Trade receivables days (how long the credit customers take to pay)
Minus
Trade payables days (how long the company takes to pay its suppliers)
Equals
Working capital cycle (in days)
10
Overtrading
When a company is trading at a very fast pace, it will be generating sales on credit with speed,
therefore have a large volume of trade receivables. It will also be purchasing inventories on credit at a
fast pace and therefore have a large volumes of trade payables. If the company doesnt have enough
capital (finance), it will find it difficult to continue as there are insufficient funds to meet all the costs.
Overtrading occurs when a company has inadequate finance for working capital to support its level of
trading. The company is growing rapidly and is trying to take on more business that its financial
resources permit ie it is under-capitalised.
Symptoms of overtrading
Short-term solutions
Speeding up collection from customers.
Slowing down payment to suppliers.
Maintaining lower inventory levels
Long term solutions
Increase the capital by equity or long-term
debt.
Overtrading may result in insolvency which means companies have severe cash flow problems. This
means that a thriving company, which may look very profitable, is failing to meets its liabilities due to
cash shortages.
11
Over-capitalisation
This is the opposite of over trading. It means a company has a large volume of inventories, trade
receivables and cash balances but very few trade payables. The funds tied up could be invested
profitably.
Differences in working capital for different industries
Manufacturing
Retail
Service
Inventories
High volume.
WIP and finished goods
No or very little
inventories
Trade
receivables
Trade
payables
Low levels
payables
of
Gearing
Gearing is the relationship between debt and equity. Debt is normally long term liabilities that the
organisation has. Equity is all the share capital and reserves. There are two ways that the gearing
ratio can be calculated are:
Gearing (also known as capital gearing) is calculated from a company's financing structure as shown
in its statement of financial position.
Debt capital consists of:
The other question is do we use the book values of the capital (as it appears in the statement of
financial position) or the market values? Both are acceptable and depend on the information
available. Short term debt can also be incorporated into the gearing ratio if this is material and has an
impact on decision making.
The significance of gearing on shareholders is the financial risk for a geared and un-geared company.
It means that there is a greater volatility in returns for the shareholders. Highly geared companies
have higher proportion of their profits being used for obligatory interest payments and preference
dividends. This leaves fewer profits for distribution to the shareholders.
Other effects of highly geared company are cash flow problems as a result of obligatory payments and
share prices are often more volatile, as there is more financial risk.
8
Interest cover
Interest cover =
(no. of times)
Interest cover shows the safety of earnings, that shareholders look at. Interest cover looks at the
proportion of profits that must be allocated to meeting interest charges. Interest payable is on long
term finance.
13
Potential
1
EPS
This ratio shows the profitability of each share, i.e. the amount of potential dividend available per
share. The EPS is a very important ratio and is published in the annual accounts of companies (IAS
33).
2
PE
(no. of times)
The PE ratio is the most widely quoted investors ratio. It shows the market confidence in a company
by taking the current market share price in relation to the most recent EPS. A high PE ratio indicates
good growth prospects.
PE ratios of different industries are available as published information. If the PE and EPS are known,
the share price of a company can be established as follows:
EPS x PE ratio
This is useful when valuing shares for unlisted companies, by taking an industry similar PE ratio.
3
Dividend yield
Dividend yield =
x 100%
The dividend yield is the cash return on the share (not the whole return which is cash dividend and
capital growth). The dividend yield can only be calculated for listed companies as the share price is
required. The higher the share price, the lower the dividends yield.
4
Dividend cover
Dividend cover =
Or =
(no. of times)
EPS______
Dividend per share
Dividend cover shows the safety of the dividend payments. How many times can the company pay
the current level of dividends out of the profits currently being earned?
14
17.3
The cash flow statement is a primary financial statement and shows the cash generating ability of the
organisation.
Cash generated from operations can be compared against the operating profit. If there are high profits
and low cash being generated this may suggest over trading.
Cash generated from operating activities can also be compared to long term borrowings to see how
well the business is generating cash to meet its obligations. It can also be compared against the capital
expenditure to see how much of the investment on new non current assets was financed by the
operating activities.
Return on capital employed for cash can also be established as follows:
Cash generated from operating activities / capital employed x 100%
Difference between cash and profit
The cash flow statement shows all the cash in and cash out for the organisation for that period. It
shows the cash generating ability of the organisation. The income statement on the other hand shows
the profitability of the business during that period. The income statement is prepared using the
accruals concept. This is where expenses and revenue are recognised in the period that they are
incurred and not in the period the cash is paid or received. This is why you have a difference between
cash and profit.
18.4
A ratio on its own is meaningless. Accounting ratios must always be interpreted in relation to other
information, for example:
Budgeted or target figures
5 or 10 year trend
Industry averages
Against a company in a similar industry
Ratios based on historic cost accounts do not give a true picture of trends, because of the effects of
inflation and different accounting policies. Investors ratios particularly have a disadvantage, because
investment means looking into the future and the past may not always be indicative of the future.
Comparing the financial statements of similar businesses can be misleading:
1
Use of different accounting policies (depreciation, inventory valuation, non current asset
valuation, capitalisation of borrowing costs etc)
2
The companies may not be of similar size. One may be part of a large group and therefore
have access to economies of scale, which result in lower costs.
3
The companies may be operating in the same industry, but they may have different markets,
and therefore different product ranges and sales mix. Segmental accounts are useful in this
respect.
15
Accounting policies
Different accounting policies that can be adopted will have an impact on the ratios calculated and
therefore make comparisons more difficult. The different accounting policies affect the income
statement and the statement of financial position and these impacts on all the major ratios like ROCE
and gearing.
1
3
4
5
6
Non current assets can be valued using the cost model or revaluation model. This will have
an impact on the statement of financial position and income statement, with higher or lower
depreciation charges.
Capitalisation of borrowing costs is optional, resulting in the statement of financial position
and income statement being affected. Capitalisation reports higher profits (as less interest
expense) and higher capital employed (high non current assets).
Inventory valuation at the year end will result in higher or lower cost of sales and
therefore different profit figures. FIFO and weighted average method are allowed.
Finance leases are capitalised with the obligation being set up as well. This will have an
impact on both gearing and ROCE. Operating leases are not capitalised.
Defined benefit pension plan has different methods of dealing with actuarial gains and
losses which go through the income statement and therefore affect profitability.
Goodwill on acquisition used to be amortised through the income statement. It is not now
and only impairment losses go through the income statement. This will make profitability
more volatile. The statement of financial position will show the goodwill indefinitely and
therefore ROCE will be lower.
International company comparisons adds another layer of problems, where different
accounting policies are used.
Creative accounting
Creative accounting (also known as aggressive accounting or earnings management) distorts financial
analysis of company accounts. Creative accounting is done by organisations to perhaps enhance the
balance sheet or performance by either exploiting loopholes in the accounting standards or
deliberately not showing certain items. Listed companies especially have added pressures for the
maintenance and increase of share prices; this obviously has an impact on the valuation of the
company. As share prices are stipulated by the market, the information fed to the market can be
manipulated to ensure this.
There has been a severe crackdown on misleading accounts especially with the disasters like Enron
and WorldCom. In the USA there are now huge financial penalties and even jail sentences for
directors deliberately misleading users of the accounts. In the UK the directors are legally obliged to
produce true and fair accounts.
Some examples of creative accounting include:
1
Timing of transactions. Delaying or hurrying up the despatch of invoices at the year end
to increase or decrease sales. This will aid in profit smoothing which listed companies may
employ. Early recognition of revenue will also smooth profits
2
Choice of accounting policies may not reflect the true substance of the transactions.
Although these areas of abuse have been identified in the accounting standards and abuse of
things like setting up provisions are now not possible.
16
Capitalising of expenses as non current assets. This will lead to increased profits.
WorldCom did this type of creating accounting which amounted to billions of dollars
being capitalised.
Off balance sheet finance. This is where the company undertakes finance but excludes it
from the statement of financial position. A good example is using special purpose entities to
house the liabilities, which the company does not own. This would then exclude them from
consolidation so users of the accounts are unaware of the debt. Enron engaged in this type
of creative accounting. This has now been rectified with the accounting standards for
reporting substance over form.
Redeemable debt. The company will have to re-pay the debt at the redemption date or
between the two redemption dates (i.e. 20X5/20X9, means debt can be redeemed any time
between 20X5 and 20X9). If the company is having cash flow problems, then the users of
the accounts will need to know when the debt will be repaid.
Contingent liabilities. Under IAS 37 provisions, contingent liabilities and contingent
assets, contingent liabilities are not recognised in the financial statements. Contingent
liabilities are less than 50% probable but not remote. The users of the accounts need
information from the notes to make a proper assessment. Especially as the probability
figure can be manipulated.
Earn out arrangements.
These arrangements occur during acquisition of another
company. The parent company agrees to pay additional money if certain events are
achieved in the future (i.e. certain level of profit being achieved by the subsidiary). Again
IAS 37 will apply and it all rests on the probability of the event being achieved. If it is less
than 50% then the amount will not be recognised in the financial statements, so users of the
accounts will need to find that information from the notes to the accounts.
17
20X1
000
278
74
46
50
170
448
70
50
34
20
62
236
70
50
34
84
238
80
80
72
20
110
20
92
408
130
448
ROCE
Gross profit margin
Asset turnover
Current ratio
Quick ratio
Inventory turnover ratio
Inventory days
Trade receivable days
Trade payable days
Equity gearing
Total gearing
Interest cover
Dividend cover
EPS
PE if market value of ordinary shares is 240p in 20X2
19
Revenue
Cost of sales
Gross profit
Operating expenses
Profit from operations
Interest payable
Profit before tax
Income tax expense
Profit for the period
Attributable to:
Equity holders of the parent
Non controlling interest
20
20X5
$000
120,366
(103,024)
17,342
(11,965)
5,377
(1,469)
3,908
(1,125)
2,783
20X4
$000
121,351
(102,286)
19,065
(12,448)
6,617
(906)
5,711
(1,594)
4,117
2,460
323
2,783
3,676
441
4,117
BZJ Group: Summarised consolidated statement of changes in equity for the year ended 31
December 20X5 (attributable to equity holders of the parent)
Accum.Share Share
profit capital premium
$000 $000 $000
18,823 2,800 3,000
Opening balance
Surplus on revaluation of properties
Profit for the period
2,460
Issue of share capital
300 1,200
Dividends paid 31/12
(155)
Closing balance
21,128 3,100 4,200
3,100
4,200
2,000
21,128
$000
24,320
44,951
69,271
2,800
3,000
18,823
Minority interest
30,428
2,270
24,623
1,947
Non-current liabilities
Interest bearing borrowings
26,700
16,700
Current liabilities:
Trade and other payables
Income tax
Short-term borrowings
31,420
1,125
3,662
24,407
1,594
36,207
95,605
21
26,001
69,271
Required:
(a) Calculate the earnings per share figure for the BZJ Group for the years ended 31 December 20X5
and 20X4, assuming that there was no change in the number of ordinary shares in issue during 20X4.
(3 marks)
(b) Produce a report for the investor that
(i) Analyses and interprets the financial statements of the BZJ Group, commenting upon the groups
performance and position; and (17 marks)
(ii) Discusses the extent to which the chairmans comments about the potential for improved future
performance are supported by the financial statement information for the year ended 31 December
20X5. (5 marks)
(Total 25 marks)
22
Revenue
Cost of sales
Gross profit
Expenses
Finance costs
Profit before tax
Income tax expense
Profit for the period
$000
600
450
150
63
17
70
25
45
23
TYD: Statement of changes in equity for the year ended 30 September 20X6
Share
capital
$000
Retained
earnings
$000
Total
100
200
45
245
300
45
345
100
$000
95
72
6
173
100
245
345
Non-current liabilities:
Long-term borrowings
Current liabilities:
Trade and other payables
Bank overdraft
180
95
80
175
700
Required:
Prepare a report to the committee of lending officers that
(i) discusses the accounting treatment of the two significant areas identified in the interview with the
FD, with reference to the requirements of International Financial Reporting Standards (IFRS) and to
fundamental accounting principles;
(8 marks)
(ii) calculates any adjustments to the financial statements that are required in order to bring them into
compliance with IFRS (ignore tax);
(5 marks)
(iii) analyses and interprets the financial statements, calculating the key ratios before and after
adjustments, and making a recommendation to the lending committee on whether or not to grant
TYDs application for a commercial loan.
(12 marks)
(Total 25 marks)
24
17.5
Presentation of analysis
Financial analysis can be presented in various forms. A report can be written detailing the analysis.
In the exam the question will make it clear the format that is required. It is important that the report is
in the correct format. The ratios can be given as appendices.
Report format
Use of sub-headings, short paragraphs and clear spacing between each issue, within your solution,
will make your document easier to follow and more professional.
Label it REPORT
Report
To
From
Date
Re
To:
From:
Subject:
Date:
Memorandum Format
Memorandum/Internal Memorandum
Fao:
From
Date
25
Figures can also be presented in horizontal and vertical format. Common size statements can also be
given.
Horizontal
analysis
20X5
20X4
20X3
20X1
Turnover ($m)
280
300
150
100
100%
50%
20X5
20X4
% change
Turnover ($m)
150
135
11.1%
50
60
(16.7)%
With common size statements each balance sheet item is expressed as a percentage of the balance
sheet total. Each profit and loss account item is expressed as a percentage of sales (or earnings)
Common size analysis
$m
Non current assets
Current assets
20X5
150
50
200
%
75%`
25%
100%
26
20X4
120
80
200
%
60%
40%
100%
17.6
The IASB issued IFRS 8 operating segments in November 2006 (which replaced IAS 14). This
continues the IASBs work in its joint short-term convergence project with the US Financial
Accounting Standards Board (FASB) to reduce differences between IFRSs and US generally accepted
accounting principles (GAAP). IFRS 8 is now aligned with the US standard SFAS 131 disclosures
about segments of an enterprise and related information.
Many organisations now do business in lots of different geographical areas and carry on with different
classes of business. These different sections will have different levels of profitability, growth and
risk. Analysing the different business segments will give users of accounts more information for
their decision-making purposes.
Segmented accounts give the users information relating to the different areas of business or location
for the enterprise.
IFRS 8 requires an organisation to adopt the management approach to reporting on the financial
performance of its operating segments. The general idea is that:
Information that would be reported would be what management uses internally for decision
making of the segments (management accounts).
This therefore means that information may be different from what is used to prepare the
income statement and statement of financial position.
The IFRS therefore requires explanations of the basis on which the segment information is
prepared and reconciliations to the amounts recognised in the income statement and statement
of financial position.
Management approach to segmental reporting will allow users of financial statements to
review the operations from the managements point of view and see how the organisation
is controlled by the senior decision makers.
As this information is produced internally by the management it will incur few costs.
This will also allow interim reporting of the segment information, as internally this is
produced anyway for management accounts purposes.
Scope of IFRS 8
IFRS 8 applies to organisations who:
Debt or equity instruments are traded in a public market (stock market); or
Is in the process of obtaining a stock market listing.
With group accounts the segmented information needs to be presented in the consolidated financial
statements and not in the individual parent companys financial statements.
27
Operating segments
An operating segment is a component of an organisation
That engages in business activities from which it may earn revenues and incur expenses
(this also includes inter-company trading).
Whose operating results are reviewed regularly by the management who then assign resources
accordingly whilst reviewing the performance of the operating segment
For which discrete financial information is available. This means separate data is kept for
each operating segment.
Reportable segments
Reportable segments are operating segments or aggregations of operating segments that meet
specified criteria (core principle):
The segments revenue (internal and external) is 10% or more than the combined internal and
external revenue of all operating segments or
The segments profit is 10% or more than the combined operating segments profit. The
segments loss is 10% or more than the combined operating segments losses or
The segments assets are 10% or more than the combined assets of all operating segments.
If the total external revenue reported by operating segments is less than 75 per cent of the
organisations entire revenue, additional operating segments must be identified as reportable segments
(even if they do not meet the 10% criteria above) until at least 75 per cent of the organisations
revenue is included in reportable segments. IFRS 8 requires an entity to report financial and
descriptive information about its reportable segments.
Disclosure requirements
General information about how the operating segments were identified and the types of
products and services from which each operating segment derives its revenues;
Information about the reported segment profit or loss, segment assets and segment liabilities
and the basis of measurement.
Reconciliations of the totals of segment revenues, segments profit or loss, segment assets,
segment liabilities and other material items to corresponding items in the organisations
financial statements. Remember the segmented information is derived from the management
accounts which may differ from financial statements, hence reconciliation is required.
Information about each product and service or groups of products and services.
Analyses of revenues and certain non-current assets by geographical area.
Foreign country disclosures of revenues and assets (if material), regardless of whether there is
an operating segment identified.
Details about transactions with major customers.
Issuing considerable segment information at interim reporting dates.
28
IFRS 8 includes intangible assets as part of the non-current assets. SFAS 131 only refers to
tangible assets.
IFRS 8 requires the method of calculating the segments liabilities. This is not required by
SFAS 131.
SFAS 131 uses a matrix form to establish operating segments. IFRS 8 uses the 10% core
principle criteria.
IFRS 8 requires identification of operating segments based on internal reports that are
regularly reviewed by the management for decision making purposes in order to allocate
resources to the segment and assess its performance.
IFRS 8 requires reconciliations of total reportable segment revenues, total profit or loss, total
assets and other amounts disclosed for reportable segments to the external financial statements.
IFRS 8 requires an explanation of how segment profit or loss and segment assets are
measured.
IFRS 8 requires information about the revenues derived from its products or services (or
groups of similar products and services), about the countries in which it earns revenues and
holds assets, and about major customers, regardless of whether there is an operating segment
identified.
IFRS 8 requires detailed information about the way that the operating segments were
determined, the products and services provided by the segments.
Under IFRS 8, there is no primary and secondary format preference (either business or
geographical). Geographical disclosures are required on a country by country basis if material.
IFRS 8 requires disclosures of finance income, finance cost and tax, if these items are
reviewed by the management for segments.
IAS 14 had a risk and return approach to identifying segments. The risk and return approach
identifies segments on the basis of different risk and returns arising from different lines of business
and geographical areas.
IFRS 8 adopts the managerial approach. This approach identifies the segments based on the
information used internally for the decision making, so therefore is based on the internal organisation
structure.
29
30
Segment B
Inter segments
Total
Revenue
External sales
Inter-segment sales
Total revenue
Interest income
Interest expense
Depreciation and amortisation
Other material items
Share of associates profit
Share of joint ventures
Unallocated items
Profit for the year
Other information
Segment assets
Unallocated corporate assets
Total assets
Segment liabilities
Unallocated corporate liabilities
Total liabilities
In the exam normally segmented accounts will be provided and you will have to analyse them by
performing ratio analysis.
31
Performance Position
Potential
-
PBIT
Turnover
Asset turnover
Turnover
Total assets
X 100%
X 100%
(number of times)
32
Current ratio
Current assets__
Current liabilities
Quick ratio
Gearing - equity
Gearing total
Debt capital________
Debt + equity (total capital)
Interest cover
Trade payables______
Cost of sales (or purchases)
Inventory days
(number of times)
(number of times)
X 100%
X 100%
(number of times)
x 365 days
P/E ratio
Share price___
Earnings per share
Dividend yield
Dividend cover
33
X 100%
Step 3
Add value to the ratios by:
Interacting with other ratios and giving reasons
a)
State the significant fact or change (i.e. increase or decrease)
b)
Explain the change or how it may have occurred by looking at the business activities and
other information.
c)
Explain the significance of the ratio in terms of implications for the future and how it fits in
with the users needs.
d)
Limitations of the ratio analysis. Look at the 2 figures used to compute the ratio and
criticise them. Also look at other factors which may distort the information (creative
accounting, seasonal fluctuations etc.)
Limitations of ratio analysis
A ratio on its own is meaningless. Accounting ratios must always be interpreted in relation to other
information.
Ratios based on historic cost accounts do not give a true picture of trends, because of the effects of
inflation and different accounting policies. Investors ratios particularly have a disadvantage,
because investment means looking into the future and the past may not always be indicative of the
future.
Comparing the financial statements of similar businesses can be misleading.
Different accounting policies that can be adopted will have an impact on the ratios calculated and
therefore make comparisons more difficult. The different accounting policies affect the income
statement and the statement of financial position and these impacts on all the major ratios like ROCE
and gearing.
Creative accounting (also known as aggressive accounting or earnings management) distorts
financial analysis of company accounts. Creative accounting is done by organisations to perhaps
enhance the balance sheet or performance by either exploiting loopholes in the accounting standards
or deliberately not showing certain items. Listed companies especially have added pressures for the
maintenance and increase of share prices; this obviously has an impact on the valuation of the
company. As share prices are stipulated by the market, the information fed to the market can be
manipulated to ensure this.
Interpretation of financial obligations included in the accounts
Financial obligations reported in the accounts need to be understood properly.
redeemable debt, contingent liabilities and earn out arrangements.
These include
34
ROCE
PBIT / CE
(54+4) / (236+80)
(46+4) / (238 + 80)
x
x
100% =
100% =
18.4%
15.7%
20X2
20X1
The return on capital employed has increased over the year from 15.7% to 18.4%. The profit has
increased which may have resulted in the increase.
2
GP / Sales
=
=
24.9% 20X2
23.0% 20X1
The gross profit margin has increased from 23.0% to 24.9%, which could mean higher selling prices
or lower costs. This also explains the rise in ROCE
3
Asset turnover
T/o / CE
418 / 316
392 / 318
=
=
1.32 times
1.23 times
20X2
20X1
The asset turnover has increased indicating that the company is using its assets more effectively.
4
Current ratio
= 148 / 92
=170 / 130
=
=
1.61
1.31
for 20X2
for 20X1
The current ratio has increased, meaning that the organisation is more liquid. This is due to the fact
that inventory and trade receivables have increased (which are non productive assets), and trade
payables have been reduced. Although this may be better for the current ratio, it may not necessarily
mean that the company is operating more efficiently. Has it increased it inventory piles because it
anticipates higher sales and doesnt want to run out? Is it offering its credit customers longer time to
pay to increase sales? Why are they paying their suppliers quicker? Surely it would be better to take
as long as possible?
5
Quick ratio
=(148 84) / 92 =
=(170 74) / 130 =
0.70
0.74
for 20X2
for 20X1
The quick ratio is slightly better in 20X1, which proves that higher inventory levels are being
maintained for 20X2.
6
35
4.0 times
4.6 times
for 20X2
for 20X1
This ratio shows how quickly the inventory is being sold. In 20X1 it was being sold at a much higher
rate than in 20X2. Have the products changed? Has the customer base changed?
The nature of the business needs to be known to see whether these turnover times are line with the
normal industry.
Solution to Lecture Example 17.1 cont.
7
Inventory days
=
=
Alternatively this can be arrived at: 20X2 1/ 4 x 365 = 92 days. 20X1 1/ 4.6 x 365 = 80 days
This again highlights the fact that the stock is taking longer to shift into sales. It is spending more
time within the warehouse.
8
=
=
There is a worsening debt collection period. Is there a delay in issuing invoices, lack of screening new
customers? Are the year end figures representatives of the year? Perhaps there are seasonal
fluctuations that need to be considered.
9
72 / 324 x 365 =
110 / 318 x 365 =
The suppliers are being paid quicker, which is good for relationship with the suppliers, but bad for
cash flow purposes. Trade credit is a free source of finance, and the company must try to maximise
this.
10
Low geared = less than 100%, highly geared = more than 100% and neutrally geared if ratio is 100%.
The gearing remains at similar levels. The company is not highly geared.
11
Total gearing =
With total gearing, higher than 50% is high gearing, lower than 50% is lower gearing and 50% is
neutral.
12
Interest cover
=
=
=
As the company is low geared, the interest cover is high. This means there is less financial risk in
investing this company. Company is in a strong position to pay interest.
36
13
Dividend cover
14
EPS
15
PE ratio
=
Profit after tax and after preference divs / dividend paid
=
(34 4) / 12 =
2.5 times
20X2
=
(26 4) / 10 =
2.2 times
20X1
The dividend cover is after allowing for preference dividends. There is a reasonably comfortable
cover.
Solution to Lecture Example 17.1 cont.
=
=
=
11.21 times
20X2
The PE ratio is quite high, indicating that the market has confidence in the companys future growth.
However this needs to be compared with industry or similar companies.
With all the ratios it would be useful to compare against the industry averages.
Proportion
01/01 31/10
01/11 31/12
Basic EPS
=
=
=
Shares in issue
10/12
2/12
2,800,000
3,100,000
37
Bonus
element
n/a
Weighted average
2,333,333
516,667
2,850,000
Investor
Financial Adviser
May 20X6
Financial analysis of BZJ Group
Introduction
This report will analyse the financial performance and position of BZJ group. The financial statements
consisting of the income statement and balance sheet for 20X5 and 20X4 will be used for this
analysis. The accounting ratio calculations are in Appendix 1. I shall also discusses the extent to
which the chairmans comments about the potential for improved future performance are supported by
the financial statement information for the year ended 31 December 20X5
1.0
From the income statement it can be seen that the performance of BZJ group has declined. Revenue is
down by 1% from 20X4. The gross profit has also declined by 9% from 20X4 with profit from
operations falling by 18.7%. There is an increase in finance cost of 62% and the profit for the year
has reduced to $2,783,000 a fall of 32% from 20X4.
BZJ group has invested in property plant and equipment which came into use only in September
20X5. They have also increased their inventory levels and reduced their trade receivables. Long term
borrowings have increased by $10m from 20X4 and short term borrowings of $3.662m in 20X5 has
obviously increased the liabilities of BZJ group.
I will now review the accounting ratios calculated in the Appendix 1.
1.1
Performance
One of the most important accounting ratios ROCE has shown a decline of 40.5% compared with
20X4.
The ROCE measures profitability and shows how well the business is utilising its capital to generate
profits. Capital employed is debt and equity. Equity is shareholders funds (s/h funds) and debt is
long-term liabilities (LTL). One has to be careful when interpreting the ROCE because consideration
needs to be given to the age of the assets, any new investments and the timing of the new investments.
Accounting policies will also affect this ratio (e.g. revaluation policies).
For BZJ group the increased investment in the non current assets will reduce the ROCE initially and
hopefully in the future this should increase as the revenue from the new venture of storage solutions
increases.
38
Position
BZJ has invested heavily in non current assets during 20X5. Increase in property, plant and
equipment is just over $19 million which is almost double the value of the non current assets of 20X4.
The impact on the ROCE and additional depreciation needs to be considered when assessing the
profitability ratios.
The short term liquidity position of the group has declined in 20X5. The current ratio is 1.44
compared to 1.73 of 20X4. Short term borrowings of nearly $4million puts BZJ in difficult position
in relation to any further borrowings in the future. Cash flow problems may occur.
The management of working capital seems to have deteriorated suggesting BZJ is not managing its
working capital effectively. Inventory levels have increased and inventory days is now averaging 132
days, which means BZJ is taking longer to sell its inventory.
Trade receivable days have reduced suggesting either less credit is being offered to customers or
customers are paying up early. Perhaps a settlement discount is being offered which may explain the
decline in the gross profit margin.
Credit suppliers are being paid quicker than last year with average credit period being taken of 30.5
days. BZJ could negotiate better terms with its suppliers to take advantage of this free form of credit.
Overall the working capital cycle has increased by 132% to 146.2 days. This means the average time
taken from buy the goods to cash received from customers is 146 days compared to only 63 days in
20X4. This also explains the cash flow problem of BZJ.
39
Chairmans comments
The Chairman states that BZJ has shown growth which is not entirely true. It can be seen from the
balance sheets that BZJ has indeed increased its investment and inventories, but this has not
materialised into increased revenues and profitability by the end of 2005.
The successful issue of shares during 2005 suggests that the investors are confident in the organisation
and believe that good growth prospects are possible. However from the financial statements the
income statements shows performance which is declining and the balance sheet shows ineffective
management of working capital with high gearing levels. So the group really has to perform in 2006
and 2007 for the Chairmans comments to become true.
Conclusion
Usually investments through expansion are a sign that organisations are growing and if the expansion
is managed effectively then BZJ should achieve increasing profitability in the future. However the
short position needs to addressed urgently. The working capital management and increase gearing
may cause investors to go elsewhere unless profitability increases significantly.
40
PERFORMANCE
ROCE
PBIT x 100%
CE
Operating profit
margin
PBIT / turnover
Asset turnover
Turnover / CE
20X5
9.1%
20X4
15.3%
(9.1 15.3)
15.3
4.5%
5.5%
-18.2%
2.80 times
4.5 5.5
5.5
-27.5%
6,617 / 121,351
120,366 / (30,428 +
2,270 +,26,700)
2.03 times
(2.03 2.80
2.80
121,351 / (24,623 +
1,947 + 16,700)
17,342 / 120,366
14.4%
15.7%
-8.3%
10.3%
(14.4 15.7
15.7
-3.9%
19,065 / 121,351
11,965 / 120,366
9.9%
(9.9 10.3)
10.3
12,448 / 121,351
OE / Turnover x
100%
Net profit (NP)
margin
% Change
-40.5%
2,783 / 120,366
2.3%
3.4%
-32.4%
(2.3 3.4
3.4
4,117 / 121,351
NP / turnover x
100%
POSITION
Current ratio
52,030 / 36,207
CA / CL
Quick ratio
44,951 / 26,001
(52,030 37,108) /
36,207
(CA inventory) /
CL
(44,951 27,260) /
26,001
41
20X5
1.44:1
20X4
1.73:1
% Change
-16.8%
0.41:1
0.68:1
-39.7%
Inventory / COS x
365 days
Trade receivables
(TR) days
6,617 / 906
26,700 / (30,428
2,270)
Debt / Equity
16,700
1,947)
(24,623
42
131.5 days
97.3 days
+35.1%
45.2 days
52.7 days
-14.2%
30.5 days
87.1 days
-65.0%
146.2 days
62.9 days
+132.4%
3.66 times
7.30 times
-49.9%
81.7%
62.9%
+29.9%
To:
From:
Date:
Subject:
Report
Committee of bank lending officers
Accounting advisor
May 20X7
TYDs financial statement analysis
This report will analyse the financial statement of TYD for year ending 30 September 20X6. The
following will be dealt with:
1.1
Significant risks and rewards have been passed onto the buyer.
Ownership of the goods has been passed to the buyer, meaning that the business selling the
goods has no control over the goods, and therefore no influence over them.
Reasonably certain that the seller will be gaining economic benefit from selling the goods.
Dr Sales $85,000
Cr Cost of sales $85,000
Recognise the inventory back and recognise the Dr Inventory $85,000
loan
Cr Loan $85,000
43
Cr Loan $5,000
Dr Sales $40,000
Cr Trade receivables $40,000
Cr Cost of sales $32,000
Dr Inventory $32,000
The retained earnings in the statement of financial position will be reduced by $8,000.
1.2
Revised TYD income statement for the year ended 30 September 20X6
Revenue
Cost of sales
Gross profit
Expenses
Finance costs
Profit before tax
Income tax expense
Profit for the period
After Adjustment
$000
475
(333)
142
(63)
(17)
62
(25)
37
Adjustments
600 85 40
450 85 - 32
44
Before adjustment
$000
600
(450)
150
(63)
(17)
70
(25)
45
Assets
Non current assets
Property, plant and equipment
Current assets
Inventories (95+32+85)
Trade receivables (72-40)
Cash
After adjustments
$000
$000
Before adjustments
$000
$000
527
527
212
32
6
1.3
95
80
250
777
95
72
6
100
237
337
100
245
345
265
180
175
777
95
80
Key ratios
Gearing
Debt / debt and equity
(180 + 80) / (345 + 180 + 80)
(265 + 80) / (337 + 265 + 80)
Current ratio
CA / CL
173 / 175
250 / 175
Quick ratio
CA inventory / CL
(173 95) / 175
(250 212) / 175
Profit margin
PBT / revenue
70 / 600
62 / 475
Other analysis
Gross profit margin
GP / revenue
150 / 600
142 / 475
Before adjustment
43%
After adjustment
51%
0.99 :1
1.43 :1
0.45:1
0.22:1
12%
13%
25%
30%
45
173
700
175
700
Asset turnover
Revenue / Capital employed
150 / (345 + 180)
475 / (337 + 265)
Return on capital employed
PBIT / capital employed
(150 63) / (345 + 180)
(142 63) / (337 + 265)
0.3 times
0.8 times
17%
13%
Interest cover
PBIT / interest paid
(150 63) / 17
(142 63) / 17
5.1 times
4.6 times
After the adjustments for the 2 transactions, TYDs profit before tax is reduced by $8,000. In the
balance sheet after the adjustments the total assets have increased by $77,000 which is mainly due the
increases in inventory. However the equity has been reduced by $8,000 and long term borrowings
have increased by $80,000.
From the key ratios the gearing ratio worsens to 51% which is above our threshold of 45%. The sale
and repurchase agreement is going to last for 2 years which is going to result in higher finance costs
and lower profits.
The current ratio improves after the adjustments from 0.99 to 1.43; however this is only as a result of
increases in inventory due to the adjustments. The quick ratio shows this as after the adjustments the
quick ratio reduces to 0.22 (0.45 before adjustment). This means the short term liquidity is very low
for TYD and it may face severe cash flow problems.
The profit margin increases to 13% from 12% but going forward this is likely to reduce due to
additional finance charges.
Other analysis work shows an improvement in the profit margin which is good news but a reduction in
the return on capital employed. The interest cover is also reduced after the adjustments to 4.6 times
(5.1 times before the adjustment). This makes lending money to TYD very risky.
With this in mind, the initial application for a loan must be rejected for TYD due to its high gearing.
Signed
Accounting advisor
46