Practical stock researchModule 2, lesson 4 of 23
Analysing financial statements in practice
Building a multi-year table from annual reports, common-size statements, explaining each major change, and reconciling profit with cash from filings.
In this lesson
- Build a multi-year table of key figures from a company's own filings.
- Use common-size statements to compare years and companies.
- Explain each major change in the figures with evidence.
- Reconcile reported profit with operating cash flow over several years.
Builds on
- Products, customers and revenue driversThe revenue drivers explained there help explain changes in the statements.
- Quality of earningsReconciling profit with cash applies the earnings quality checks from that lesson.
- Free cash flow and cash conversionThe table includes free cash flow, explained there.
On this page
In simple terms
A single year's results can mislead. Several years, laid side by side and explained line by line, show how a business really behaves: whether growth is steady, whether margins hold, whether profit turns into cash, and how much capital the business needs.
This lesson is a method for doing that with a company's own filings.
Step 1: build your own table
From the annual reports, collect the same figures for five to ten years. A useful core set:
- Revenue, operating profit, net profit, earnings per share
- Operating cash flow, capital expenditure, free cash flow
- Receivables, inventory, payables
- Debt, cash, shareholders' equity
- Number of shares
Use consolidated figures, which include subsidiaries, and keep definitions consistent. Note restatements: companies sometimes revise earlier years after accounting changes, and the latest annual report's comparative figures may differ from the original.
Step 2: common-size the statements
Express income statement lines as a percentage of revenue, and balance sheet lines as a percentage of total assets. This shows trends that raw numbers hide, and lets you compare companies of different sizes, as the comparing companies lesson explains.
Worked example: A made-up company over five years
| Year | Revenue (₹ crore) | Operating profit | Operating margin | Net profit | Operating cash flow | Receivable days |
|---|---|---|---|---|---|---|
| 1 | 1,000 | 150 | 15.0% | 90 | 95 | 44 |
| 2 | 1,150 | 175 | 15.2% | 105 | 60 | 54 |
| 3 | 1,300 | 190 | 14.6% | 115 | 70 | 65 |
| 4 | 1,420 | 200 | 14.1% | 120 | 55 | 75 |
| 5 | 1,600 | 210 | 13.1% | 130 | 50 | 84 |
| Revenue growth, yearly over four years: (1,600 ÷ 1,000)^(1/4) − 1 | about 12.5% |
|---|---|
| Net profit growth, yearly: (130 ÷ 90)^(1/4) − 1 | about 9.6% |
| Total net profit, five years | ₹560 crore |
| Total operating cash flow, five years | ₹330 crore |
| Cash conversion: 330 ÷ 560 | about 59% |
Three things need explaining: margins are slipping, profit is growing more slowly than revenue, and only about three-fifths of profit is turning into operating cash, as receivable days nearly double.
Step 3: explain every major change
For each big movement, find the explanation:
- Revenue: volumes, prices, mix, acquisitions, as the products and customers lesson explains.
- Margins: input costs, pricing, operating leverage, one-off items.
- Working capital: why receivables or inventory are rising faster than sales.
- Debt and equity: new borrowing, share issues, buybacks, acquisitions.
Look in the management discussion, the notes to the accounts and the segment data, as the notes lesson explains. Write the explanation and its source next to each change. If you cannot explain something, write it down as a question.
Step 4: reconcile profit with cash
Over a single year, profit and operating cash flow can differ for good reasons. Over five or more years, they should broadly match, as the profit and cash flow lesson explains. A persistent gap usually comes from:
- Receivables rising faster than sales: customers paying slowly, looser credit terms, or revenue recognised too early.
- Inventory building up: slowing sales or stock that may not sell.
- Costs being capitalised rather than expensed.
Then subtract capital expenditure to get free cash flow, as the free cash flow lesson explains. A company that needs all its cash, and more, to keep growing may need to borrow or issue shares.
Data websites and filings
Data websites save hours, but their numbers can differ from the filings because of:
- Standalone and consolidated figures mixed up.
- Different definitions, for example of operating profit or debt.
- Restatements not carried back.
- Exceptional items treated inconsistently.
- Simple errors.
Use them to start, and check every important figure against the annual report.
Why it matters
A careful multi-year analysis turns a pile of documents into a story you can test. It reveals whether reported growth is backed by cash and capital discipline, and it produces the questions that matter for the rest of your research.
Limitations
Past figures describe the past. Accounting changes, acquisitions and disposals can break comparisons. A company in rapid, healthy growth can legitimately have cash flow below profit for a time. The analysis tells you what to ask, not always what the answer is.
Common mistakes
- Relying on one year or on a data website alone.
- Mixing standalone and consolidated figures.
- Noting changes without explaining them.
- Ignoring the gap between profit and cash.
Try it yourself
- For a company you are researching, build the table above for at least five years from its annual reports.
- Calculate operating margin, receivable days and cash conversion for each year.
- Write a one-line explanation, with a source, for each large change.
- List the changes you could not explain as questions.
Key takeaways
- Build your own table of five to ten years of key figures from the annual reports, using consolidated figures and the same definitions each year.
- Common-size statements express each line as a share of revenue or total assets, making trends and comparisons easier to see.
- For every large change, find the explanation in the management discussion, notes or segment data. A change you cannot explain is a question to follow up.
- Over several years, operating cash flow should broadly keep up with profit. A persistent gap, often from rising receivables or inventory, needs explaining.
- Data websites are useful shortcuts, but they can differ from filings because of restatements, definitions and errors. The company's filings are the source of record.
Check your understanding
Finished reading?
Your progress is saved only in this browser.
Terms used in this lesson
- Common-size statement
- A financial statement with each line shown as a percentage of a base, such as revenue for the income statement or total assets for the balance sheet.
- Free cash flow
- Cash from operating activities minus capital expenditure. The cash left for lenders and owners after keeping the business running.
- Receivables
- Money owed to a business by customers who have bought on credit and not yet paid.
Spotted a mistake or something unclear? Report it by email. Here is how corrections work.
This lesson is general education, not investment advice. Examples use made-up or clearly dated figures to explain ideas; they are not recommendations. Read the disclaimer.