Financial statements analysis is the first analysis most Case Study requirements ask for, and the one that tells the financial story of the business. It is also a skill that must be explained, not just calculated. This topic covers what the analysis is for, the types of analysis, and the four techniques you will use, with worked examples.
In 30 seconds
Financial statements analysis evaluates and explains the information in the financial statements, together with management accounts, budgets, forecasts and the context around them. It diagnoses past and present performance and position and gives an insight into prospects. The main techniques are comparative statements (absolute and percentage changes), common size statements, trend analysis against a base year and ratio analysis.
Whichever you use, the marks come from explaining what the numbers mean for the client.
Where it fits in the case
The Case Study looks at a business from three perspectives. Financial statements analysis and financial data analysis are both core professional skills. The third perspective is operational and strategic analysis, including business trust and ethical awareness. Each can be viewed alone, but your skill as an independent professional is to combine them into one whole.
The three are linked in scope and in time. Financial statements analysis looks at how the business has performed in its recent past. It informs the financial data analysis, which usually looks at a current issue. Both sit inside the operational and strategic analysis, which looks from the present into the future.
Financial analysis as a whole therefore runs from past performance, through the current viability of a project, to future proposals. It covers everything from one revenue stream to an investment that affects the entire organisation.
What financial statements analysis is
Financial statements analysis is an evaluation and explanation of the financial and related information in the financial statements of a business. That includes summary statements, management accounts, budgets and forecasts. It covers financial performance (the statement of comprehensive income and the statement of changes in equity), financial position (the statement of financial position) and cash flow (the statement of cash flows).
It also considers all the contextual information given about the company and its environment.
The statements alone are not enough to draw conclusions or make judgements. Analysis shows strengths and weaknesses by establishing relationships between the items in the statements. It is how liquidity, solvency, profitability and efficiency are measured, and how short-term and long-term prospects are judged.
Because the statements alone give no judgement, an analyst always adds three things: a comparison, a cause and a consequence. A comparison puts a figure in context, a cause links it to the facts of the case and a consequence says what it means for the client.
The focus depends on who asked and why. An investor wants to predict future performance. Management wants to understand present condition as a base for planning. The analysis should help to:
- evaluate strengths and weaknesses;
- measure profitability;
- show the pattern and trend of performance over the years;
- judge future earning capacity;
- compare the entity with others;
- judge liquidity and solvency; and
- assess growth potential.
In the Case Study, the purpose is to test whether you can select relevant information, analyse it and interpret it to make an informed judgement about past, current and future condition. Use the financial statements, but also market, economic and operational data, and any events that explain the present position or bear on the future.
Types of financial statements analysis
| Type | What it is |
|---|---|
| External analysis | Done by outsiders, based on the published financial statements |
| Internal analysis | Done by the entity’s financial managers to inform top management decisions |
| Short-term analysis | Looks at working capital, current assets against current liabilities, to see whether short-term cash commitments can be met |
| Horizontal analysis | Compares statements over a number of years. Also called dynamic analysis |
| Vertical analysis | Analyses a single year’s statements, for example through ratios and percentages of one base figure. Also called static analysis |
The four techniques
Comparative statements. Compare the income statement and the statement of financial position over at least two years. Work out the absolute and percentage change in each item. The income statement comparison shows the direction of operating performance. The statement of financial position comparison shows how operations have affected assets and liabilities. You can also compare two or more entities.
An analysis of changes in working capital, current assets less current liabilities, belongs here too.
Common size statements. Convert figures to percentages. In the income statement, revenue is 100% and every other line is a percentage of revenue. In the statement of financial position, total assets are 100%.
Trend analysis. Choose a base year, usually the first, and set every figure for that year at 100. Express later years as an index against it. Trend analysis shows whether financial health and operating results are improving or declining.
Ratio analysis. This is the most popular technique. Ratios show relationships between items in the two main statements. They fall into five groups: profitability, liquidity, activity or efficiency, gearing and shareholders’ return or investment. The next topic sets them out.
Worked example: the income statement
Scenario (fictitious figures). Okafor Plastics Ltd reports the following in ₦ million. Analyse the income statement using three techniques and state what it shows.
| Item | Year 1 | Year 2 | Change | Change % | Common size Y1 | Common size Y2 | Index Y2 (Y1 = 100) |
|---|---|---|---|---|---|---|---|
| Revenue | 800 | 1,000 | +200 | +25.0% | 100% | 100% | 125 |
| Cost of sales | 480 | 700 | +220 | +45.8% | 60% | 70% | 146 |
| Gross profit | 320 | 300 | −20 | −6.3% | 40% | 30% | 94 |
| Expenses | 200 | 240 | +40 | +20.0% | 25% | 24% | 120 |
| Operating profit | 120 | 60 | −60 | −50.0% | 15% | 6% | 50 |
- Comparative statements. Revenue grew by ₦200 million, but cost of sales grew by ₦220 million, so gross profit fell by ₦20 million.
- Common size. Gross margin dropped from 40% to 30%. Expenses were broadly steady at about a quarter of revenue, so operating margin fell from 15% to 6%.
- Trend. Against a base of 100, revenue rose to 125 and cost of sales to 146. Operating profit halved to 50.
- Conclusion. Growth in sales has hidden a serious fall in margin. The cause lies in direct costs, so management should review pricing and purchasing before it looks at overheads.
Worked example: working capital
For the same company, current assets rose from ₦300 million to ₦520 million, of which receivables rose by ₦150 million and inventory by ₦70 million. Current liabilities rose from ₦200 million to ₦400 million. Working capital moved from ₦100 million to ₦120 million, a rise of ₦20 million, and the current ratio fell from 1.50 (300 divided by 200) to 1.30 (520 divided by 400). The rise looks healthy until you break it down.
Customers and stock are absorbing the cash, and short-term borrowing and suppliers are financing it. That is a pressure on liquidity, not a strength.
How to comment on a number
A table of figures earns few marks. The marks come from the comment. Use four steps for every important movement.
- State what moved, in naira and in percentage.
- Compare it with the previous year, the industry or the target.
- Explain the likely cause, using facts from the case.
- Judge the effect on the business and say what management should do.
| Weak comment | Strong comment |
|---|---|
| Gross profit fell. | Gross profit fell by ₦20 million (6.3%) although revenue rose 25%, because cost of sales rose 45.8%. The margin dropped from 40% to 30%, which points to higher input costs or discounting, so management should review pricing and suppliers. |
Choosing the technique for the question
You rarely need every technique. Let the question decide which one to use first.
| The question | Start with |
|---|---|
| Is performance improving? | Trend analysis and comparative statements |
| Where did the margin go? | Common size statements |
| How do we compare with the industry? | Ratio analysis against industry figures |
| Can the business meet its short-term debts? | Changes in working capital and liquidity ratios |
| Which part of the business drives the change? | Common size statements by product or division |
Then confirm the finding with a second technique, because two methods that agree make a far stronger point than one.
Common mistakes
- Calculating figures and leaving them without explanation.
- Using only one technique, so that a falling margin hidden by rising sales is missed.
- Mixing the base for common size percentages. Revenue is the base for the income statement and total assets for the statement of financial position.
- Ignoring non-financial data, such as market, economic and operational events.
- Analysing the past only, with no view of prospects.
Quick revision
- Three perspectives: financial statements, financial data, operational and strategic.
- Analysis covers performance, position and cash flow, plus context.
- Types: external, internal, short-term, horizontal, vertical.
- Techniques: comparative, common size, trend (base year 100), ratios.
- Comment in four steps: state, compare, explain, judge.
Practice questions
These are original questions in the style of the Institute of Chartered Accountants of Nigeria exam. Try each one before you open the answer.
Question 1. Horizontal analysis compares:
- One year’s items with revenue
- Statements over a number of years
- Two industries
- Assets with liabilities
Show the answer
B. It is also called dynamic analysis.
Question 2. In common size statements, the base figure for the statement of financial position is:
- Revenue
- Total equity
- Total assets
- Net profit
Show the answer
C. Total assets are 100%. In the income statement the base is revenue.
Question 3. Revenue was ₦800 million in the base year and ₦1,250 million in year 3. The trend index for year 3 is closest to:
- 125
- 140
- 156
- 166
Show the answer
C. 1,250 divided by 800 is 1.5625, so the index is about 156.
Question 4. Which are the five groups of ratios?
- Profitability, liquidity, efficiency, gearing and shareholders’ return
- Tax, audit, law, ethics and strategy
- Cost, price, volume, mix and yield
- Assets, liabilities, income, expenses and equity
Show the answer
A. These groups cover performance, short-term position, use of assets, borrowing and returns to owners.
Question 5 (8 marks). Explain four techniques used in financial statements analysis.
Model answer
Show the model answer to Question 5
Comparative statements (2 marks). The statements of two or more periods are compared, and the absolute and percentage change in each item is found, to show the direction of performance and the effect of operations on assets and liabilities.
Common size statements (2 marks). Items are expressed as percentages: revenue is 100% in the income statement and total assets are 100% in the statement of financial position, so the structure and margins can be compared.
Trend analysis (2 marks). A base year is set at 100 and later years are indexed to it, which shows whether health and results are improving or deteriorating.
Ratio analysis (2 marks). Ratios show relationships between items in the statements and fall into profitability, liquidity, efficiency, gearing and shareholders’ return groups.
The next topic covers the ratio analysis toolkit for profitability, efficiency, liquidity, gearing and investors.
Pathfinder on Financial statements analysis: meaning, types and techniques
These are the ICAN Pathfinder questions that test this topic. ICAN owns the questions and the suggested solutions, so we point you to them and do not copy them. Open your Pathfinder, attempt each question under exam conditions, then check your answer against the notes above.
The marking keys reward analysis of changes in the financial statements in absolute and percentage terms. Build the same tables for each case.
Revise first: The four techniques
Both ask for performance over several years, five in 2017 and four in 2018, which is horizontal analysis. Plan the technique before you calculate.
Revise first: Types of financial statements analysis
Source: ICAN Pathfinder, Case Study. Diets covered: May 2015, November 2015, November 2017 and November 2018.
Spotted a mistake? Tell us and we will check it.