NISM RA study kit
Chapter 8 of 15

Company analysis: financial analysis

Worth 12 marks of 100Book pages 145 to 186About 90 minutes

Read the balance sheet, the profit and loss account and the cash flow, then turn them into ratios that tell a story.

Chapter mapA long, numbers-heavy chapter. 8.11 (ratios) and 8.12 (DuPont) are the core for numericals. Tap to jump.
Intro

Why financial analysis?

Chapters 5 to 7 looked at the economy, the industry and the company's business. Financial analysis turns all that into the company's likely profits, cash flows and, finally, the fair value of its shares. Financial statements also supply the numbers for market sizing (6.4), industry KPIs (6.7) and strengths and weaknesses (7.5).

You do not need to be an accountantThe book says an analyst need not be a great accountant, but must be able to read and interpret financial statements. Accounting knowledge helps.
8.1

The financial statements

In India, the statements and their format are governed by Schedule III of the Companies Act, 2013 and Ind AS 1. A complete set under Ind AS 1:

A complete set of financial statementsInd AS 1
1

Balance sheet

Statement of financial position: assets, liabilities and equity at the end of the period. A snapshot.

2

Statement of profit and loss

Income, expenses and profit for the period. Must include other comprehensive income (OCI).

3

Statement of changes in equity

How shareholders' funds changed: profit, dividends, new shares, buybacks, OCI.

4

Cash flow statement

Sources and uses of cash.

5

Notes

Accounting policies and break-ups of the figures.

Each statement must show figures for at least one prior period for comparison. Companies may show more.

8.2 Standalone versus consolidated

Every company is a separate legal entity and prepares its own standalone statements. But for groups these can mislead: Toyota Motor Corporation's standalone accounts show only sales of that entity in Japan, not sales through subsidiaries in China, India or North America.

Consolidated statements treat all companies controlled by the parent as one group and combine their results.

Control
Owning more than 50% of voting rights, or the right to appoint a majority of the board. Even without 50%, a company that can direct a subsidiary's strategy and operations to change its returns is in de facto control, and must consolidate under Ind AS 110.
Holding (parent)
The company that controls.
Subsidiary
The company that is controlled. Book examples: Jio Platforms (controlled by Reliance Industries); Toyota Kirloskar Motor (majority owned by Toyota Motor Corporation, Japan).

Usually prefer consolidated

It gives a more holistic picture of the group.

Also check standalone when...

Subsidiaries cannot pass dividends to the parent: strict capital controls in their country, or a debt covenant banning dividends. Then ask: can the parent stand on its own in a crisis?

As per the book, SEBI requires listed companies to publish consolidated statements annually and standalone results quarterly. Quarterly consolidated results are voluntary, which leaves analysts with dated group numbers between annual reports.
8.3

The balance sheet

Format: Schedule III of the Companies Act, 2013. Banks, insurers and utilities follow formats set by their own regulators. The book uses Bharti Airtel's consolidated balance sheet for 31 March 2019 as its example.

Assets are items expected to give future benefits. A company can show only assets that can be measured in money and have been paid for. So a company generally cannot show its own self-generated brand.

Current asset
Gives benefit within one operating cycle, usually taken as one year. If the cycle is longer than a year, one year is the convention.
Non-current asset
Gives benefit over the long term, usually more than one year. Everything that is not current.
Asset line itemsWhat each one means, and how it is valued
Line itemWhat it isHow it is shown
Property, plant and equipment (PPE)Land, buildings, machines, furniture, computersHistorical cost less accumulated depreciation. Ind AS 16 allows a revaluation model, applied to a whole class of assets
Capital work in progressPPE still under constructionMoved to PPE when ready to operate
GoodwillPrice paid for a business above the fair value of net assets taken overTested for impairment; any shortfall written off
Intangible assetsLegal rights: acquired copyrights, patents, brands. Internally developed software can be shown; other self-generated assets cannotCost less accumulated amortisation
Intangibles under developmentIntangibles not yet readyMoved to intangibles when ready
Investment in joint ventures and associatesStrategic stakes the company does not controlEquity method: adjusted for its share of profit and OCI, reduced by dividends received
Non-current financial assetsLong-term investments, loans, advancesDebt held to collect interest and principal: amortised cost. Others: fair value
InventoryRaw material, work in progress, unsold finished goodsLower of cost or market value
Current financial assetsCash and cash equivalents, bank balances, receivables, short-term investmentsReceivables net of provision for doubtful debts. Investments at fair value
Other current assetsPrepaid expenses; benefits received in kind within a year 
The book's goodwill exampleIn FY 2018, Bharti Airtel bought 100% of Tigo Rwanda for Rs 3,200 crore. Tigo's net assets were worth Rs 2,838 crore. The extra Rs 362 crore was recorded as goodwill. If a company pays less than fair value, the difference goes to capital reserve under equity.

Equity: the owners' residual share

Equity = assets minus liabilities. Its parts:

Share capital
Face value of paid-up shares.
Share premium
Amount received above face value when shares were issued (IPO or FPO).
Retained earnings
Profit and OCI not paid out as dividend or set aside.
General reserve
Retained earnings set aside for future use.
Capital and revaluation reserve
Surplus from showing assets above purchase price. Usually not available for dividends.
Non-controlling (minority) interest
Outside shareholders' share of a subsidiary's equity. Appears only in consolidated statements.

Liabilities

Liability line items
Non-current (beyond one year)
  • Long-term debt: loans, bonds, debentures due after a year. The part due within a year is shown as current portion of long-term debt.
  • Lease liability: right to use an asset for more than a year. Analysts often treat it as debt.
  • Derivative instruments: mark-to-market losses on contracts settled after a year.
  • Other long-term financial liabilities.
  • Deferred revenue: advance received for service still to be given.
  • Provisions: for a specific obligation not yet fully quantified: retirement benefits, warranties, pending legal cases.
Current (within one year)
  • Payables: owed to suppliers.
  • Short-term debt: borrowed for under a year, but often rolled over.
  • Short-term provisions
  • Current portion of long-term liability
  • Deferred revenue (due within a year)
  • Advances from customers
  • Unpaid and accrued expenses
Deferred revenue, the book's example: a customer buys a 6-month prepaid pack for Rs 1,200. After one month, the company counts Rs 200 as revenue. The other Rs 1,000 (1,200 × 5/6) is deferred revenue: a promise still owed.
A provision is for a specific obligation (like retirement benefits). A reserve is set aside without a specific obligation. Do not mix them up.

8.3.2 Balance sheet metrics analysts add

Balance sheets often miss fair value because of the historical cost and money measurement concepts. So analysts compute extra metrics.

Total debt and working capital
Total debt

Long-term debt + current portion of long-term debt + short-term debt + finance lease obligations + accrued interest.

Debt is settled in cash and carries interest, unlike other liabilities.

Net working capital

Current assets − current liabilities. The accountant's measure.

Bharti Airtel FY 2019: 329.06 − 930.55 = minus Rs 601.49 billion.

Core working capital

Inventory + trade receivables − trade payables.

Only items from core operations. Helps judge the need for bank working capital finance. The book suggests also including a reasonable cash balance.

Why working capital is neededThe book says the "day-to-day needs" idea is a misnomer. A company needs working capital because it spends first (raw materials, production) and waits to be paid by customers who buy on credit.
8.4

The profit and loss account

Shows performance for a period. Format: Schedule III; Ind AS 1 adds OCI, shown below net profit. Banks, insurers and utilities use their regulators' formats.

P&L line items
Line itemMeaning
RevenueSales of goods and services from core and incidental operations. Some show incidental income as "other operating income"
Other incomeNon-operating income: investment income, profit on sale of assets
Cost of raw materialsPurchases + opening stock − closing stock of raw materials
Purchase of stock-in-tradeGoods bought and resold without processing. Most retail purchases
Change in inventory of WIP and finished goodsOpening minus closing balance of WIP and finished goods
Employee costSalaries, benefits, stock-based compensation, staff welfare, annual retirement provision
DepreciationAllocates the cost of tangible assets over their useful life. Ind AS 16: method should reflect how the asset is used (a cab fleet by distance)
AmortisationGradual write-off of intangible assets
Finance costInterest, processing fees, amortised cost of issuing securities
Income from equity-accounted entitiesShare of profit of joint ventures and associates
Exceptional itemsNot from the normal course of business: natural calamity losses, one-time regulatory charges
TaxCurrent tax, MAT, deferred tax. Deferred tax has no cash impact
Non-controlling interestSubsidiary profit belonging to outside shareholders

EPS: basic and diluted

Basic EPS = net profit to equity shareholders ÷ weighted average shares outstanding

Diluted EPS assumes all instruments that could become shares without full payment are converted: in-the-money warrants, ESOPs, convertibles. Profit is adjusted for the effect too. For a loss-making company, basic and diluted EPS are the same.

Other comprehensive income (OCI)

Income or expense that bypasses the P&L, mostly changes in value from non-operating factors: revaluation surplus changes; remeasurement of defined benefit plans; translation of foreign operations; fair value changes of certain financial assets or liabilities; gains or losses on derivatives that hedge risk.

8.4.2 Profit metrics

Most companies present a single-step P&L (all income minus all expenses = profit before tax). Some, like Bharti Airtel, present a multi-step P&L showing EBITDA. Analysts often redraw single-step statements into multi-step ones.

From revenue to profitThe profit "waterfall"

Revenue

 

Gross profit

Revenue − cost of goods sold. Not computable for most Indian companies

EBITDA

Before interest, tax, depreciation, amortisation

EBIT

"Operating profit"

PAT

Net profit for shareholders

  • Gross profit suits manufacturers, but Indian companies disclose only raw material costs among direct costs, so it usually cannot be calculated.
  • EBITDA is not affected by capital structure (interest) or infrastructure and accounting choices (depreciation), so it is the right metric to compare firms, even across sectors. "Adjusted EBITDA" also strips out investment and other non-operating income. EBITDA is a proxy for cash profit, but use it that way only as a last resort.
  • EBIT is called operating profit. It shows the ability to meet interest, and feeds the interest coverage ratio and free cash flow to the firm.
  • PAT (net profit, EAT) is what is left for shareholders after interest and tax.
  • Adjusted PAT removes exceptional items, with their tax impact, so years can be compared. It may need judgement: Bharti Airtel's FY 2019 effective tax rate was "not meaningful" because it paid huge taxes despite reporting losses.

8.5 Statement of changes in equity

Required by Ind AS 1. Shows how each type of transaction changed each part of shareholders' equity.

8.6

Cash flow

Accounts use the accrual basis: income counts when earned, not when received; expenses when incurred, not when paid. So profit and cash can differ a lot.

The book's example: buy goods for Rs 80,000 in cash, sell them for Rs 1,00,000. If the sale is in cash, you have a Rs 20,000 profit and the cash. If the sale is on credit, the P&L still shows Rs 20,000 profit, but there is no money. If the customer never pays, even the Rs 80,000 is lost. Profit without cash is "paper profit".
Three kinds of cash flowSigns, as the book describes them
Operating

From the business (P&L items)

Net profit + non-cash expenses (depreciation, amortisation) ± changes in receivables and payables.

Investing

From assets (B/S items)

Buying assets: negative. Selling assets: positive.

Financing

From liabilities and equity (B/S items)

Borrowing or issuing equity: positive. Repaying debt or buying back equity: negative.

A warning from Kingfisher Airlines

A business with negative operating cash flow for years needs constant doses of borrowing or new equity. In the end it either turns cash-positive or dies when lenders and investors stop. The book's example (Rs crore, source moneycontrol.com):

Kingfisher Airlines, years ending March
Rs crore20132012201120102009
Net profit before tax−4,301.12−3,446.09−1,520.78−2,417.92−2,155.21
Net cash from operating activities−1,390.86−885.55−2.23−1,665.09−645.78

EBIT stayed far below interest for years, so it borrowed to pay interest, until lenders refused.

Expansion (negative investing cash flow) is funded by operating cash, past cash balances, or financing. Be cautious with firms that rely heavily on borrowing to expand: assets may realise less than book value, but liabilities must be paid in full.

Four rules from the book: net cash flow can deceive; analyse operating, investing and financing separately; focus on sustainable, recurring cash flows; adjust for non-recurring items.
8.7

Notes to accounts

8.7.1 Significant accounting policies

There are several ways to account for an item, for example straight-line or written-down value depreciation. The policies show which way the company chose. Companies must state any change from last year. Frequent changes in policy are a reason for suspicion of manipulation.

8.7.2 Contingent liabilities

Liabilities that arise only if an uncertain future event goes against the company. They are not recorded in the accounts, only in the notes. Examples: outstanding lawsuits, tax disputes, bank guarantees given, product warranty claims, pending investigations, changes in FX or government policy.

Management will usually say it does not expect to lose. Look at the size of contingent liabilities compared with the P&L and balance sheet. If large, be cautious.

Off-balance sheet items

Any asset or liability that does not appear on the balance sheet. The book's examples: operating leases, contingent liabilities, and derivative contracts (shown only in notes). Derivatives have threatened many businesses worldwide, so analyse these in detail, especially negative surprises.

8.8 Points to keep in mind

  • Numbers can be dressed up by assumptions or creative accounting. Auditors' qualifications in the notes (the fine print) are very useful.
  • A change in accounting period can confuse comparisons with past years.
  • One-off items can raise or lower profit; miss them and the whole analysis changes.
  • The best company for investors shows consistent growth in sales, profit and net worth, lower debt, better margins and a rising return on net worth (RoNW).

8.9 The audit report

Management prepares the accounts; auditors check that they give a true and fair view. Auditors work on the information given to them and cannot vouch for every transaction. So they check, in order: are adequate control systems in place; were they properly implemented; were accounting standards followed in measuring and disclosing items?

Three kinds of audit reportAs listed in the book
Clean

No issues

Standard format, looks much the same across companies.

Disclaimer

Could not verify

Auditors could not verify part of the financials because information was not available.

Qualified

Not true and fair

Auditors believe all or part of the statements do not give a true and fair view: they disagree with a policy, or see serious discrepancies.

For a disclaimer or a qualified report, auditors explain their reasons. Always read the audit report for reservations.

8.10

Why ratios?

A number alone means little. Bharti Airtel's FY 2019 EBIT of Rs 47.62 billion sounds large, until you compare it with revenue of Rs 807.8 billion (only 5.8%), or with interest expense of over Rs 110 billion (not enough to pay it). Ratio analysis expresses one line item as a percentage or multiple of a related one. Only compare numbers that are related.

Three uses of ratio analysisThe book's Bharti Airtel FY 2019 example
Descriptive

Adds a sense of proportion: operating profit was 5.8% of revenue.

Diagnostic

Finds what went wrong: revenue fell 2.19% but EBITDA fell 13.9%. Network operating expense rose from 23.8% to 27.6% of revenue.

Predictive

Shows how costs behave: most costs stayed a steady % of sales (they move with sales); network costs rose as sales fell, so they are largely fixed. Two years of data is too little; more data gives more confidence.

8.11 Commonly used ratios

Margins are thin in a competitive industry with pricing pressure. They are high when a business is unique with big entry barriers, or an early entrant in a sunrise industry. But very high profitability rarely lasts: new entrants and competition pull it back to moderate levels. Ratios that compare a period figure (sales, profit) with a balance sheet figure (equity, assets) should use the average balance, usually the average of opening and closing.

Ratio formula sheetFormulas exactly as the book defines them, with the book's Bharti Airtel FY 2019 figures
RatioFormulaReading it
Profitability
EBITDA marginEBITDA ÷ Net salesOperating efficiency; not affected by depreciation policy, funding or tax. Bharti: 32.2% (FY18: 36.6%)
PAT marginPAT ÷ Net salesShare of sales left for shareholders. Bharti: 2.1%
NOPATEBIT × (1 − tax rate)Used in valuation (later chapters)
Return
ROE (RoNW)PAT ÷ Net worth"Single most important parameter" for equity investors. Net worth = share capital + reserves and surplus. Bharti: 2.1%
ROCEEBIT ÷ Capital employedCapital employed = total assets − non-interest-bearing current liabilities, or equity + debt (book values). Pre-tax. Bharti: 2.38%
Leverage
Debt / EquityTotal adjusted debt ÷ Net worthMost conservative benchmark: 1 or less. Bharti: 1.52x
Interest coverageEBIT ÷ Interest expenseBelow 1 or negative: earnings do not cover interest
Liquidity
Current ratioCurrent assets ÷ Current liabilitiesAlso called working capital ratio. Bharti: 0.35
Quick ratio(Current assets − Inventories) ÷ Current liabilitiesStricter: inventory cannot become cash immediately
Efficiency
Receivable turnoverRevenue ÷ Average receivablesHigher is better: faster collection. Low may mean credit is too easy, or money is hard to recover
Payable turnoverPurchases ÷ Accounts payableLow means long supplier credit: strength, or lack of cash
Asset turnoverNet sales ÷ Total assetsHigher is better: assets put to work. Used in DuPont
Inventory turnoverSales ÷ InventoryHigher is better. Slow stock locks up money, and perishables can spoil. High for FMCG, low for capital goods

Reading the liquidity ratios

  • High finished goods stock may mean slowing sales; high raw material stock may mean poor planning.
  • High receivables: selling on credit and struggling to collect. High payables: may show strength in getting good credit terms.
  • A current ratio below 1 is not always a red flag. A company that collects cash on sales and pays suppliers on credit has its working capital funded by customers. Firms with strong bargaining power often prefer negative working capital: it is an interest-free obligation.
  • A very high current ratio may point to poor management of inventory, receivables and cash.
ROE uses PAT; ROCE uses EBIT. ROE's denominator is net worth only; ROCE's is equity plus debt. Interest coverage uses EBIT, not PAT. Quick ratio removes inventories.

The book notes several versions of ROCE and D/E are used in the industry (for example, net debt = total debt minus cash). For the exam, use the formulas in the sheet above.

8.12

DuPont analysis

Reading ratios together gives more insight. For example, sales rising while the collection period lengthens suggests lenient credit to push sales. DuPont analysis breaks ROE into three parts:

ROE = (Net profit ÷ Sales) × (Sales ÷ Assets) × (Assets ÷ Equity)
1

Net profit margin

Profitability

2

Asset turnover

Efficiency

3

Equity multiplier

Leverage

Why split it?ROE that rises from better margins or efficiency is good news. ROE that rises from more leverage need not be, because leverage also adds risk.
DuPont calculatorStarts with the book's HighLevCo. Press LowLevCo to compare.
net profit margin
asset turnover
equity multiplier
ROE

The book's comparison. HighLevCo: ROE 92.3% = 20% margin × 2.3x turnover × 2.0x leverage. LowLevCo: ROE 52.4% = 22% margin × 2.4x turnover × 1.0x leverage (no debt). LowLevCo is the better operator, with higher margin and slightly higher turnover. Its ROE is lower only because it uses no debt, which also means less risk.

8.13 Forecasting with ratios

Analysts use how items behaved in the past to forecast. But that assumes the past represents the future, which need not hold. Apply judgement and adjust for changes.

The book's example: Suzlon was the only wind turbine maker, with great pricing power, until it faced tremendous domestic and offshore competition starting from the middle of 2000 (as the book puts it). Projecting its financials purely from history would have been a blunder.

Quotes from the book: Warren Buffett has "no use whatsoever for projections or forecasts" and looks deeply at track records. Charlie Munger says projections "do more harm than good". Graham and Dodd: a past trend is a fact, a future trend only an assumption, and the past is only a "rough index" to the future.

8.14 Peer comparison

Comparing a company's ratios with those of peers in the same sector shows its competitive position. The book calls peer comparison critical for any research report. Databases give quick peer snapshots.

8.15

Other things to track

History of equity expansion

Raising money costs the business; if raised expensively, existing shareholders bear it. Debt costs are clear from the contract; the cost of issuing equity is harder to see. Ways to issue shares:

  • Rights issue (to existing shareholders in proportion to holdings)
  • Public issue (IPO or FPO)
  • Private placement: preferential issue, qualified institutional placement (QIP)
  • Exercise of warrants
  • ESOPs or sweat equity
Which issues dilute existing shareholders?As the book explains
Rights issue

No major dilution: offered to all in proportion. Dilutes only those who do not take up their rights.

Preferential allotment

Raises the chosen investor's stake, cuts everyone else's. Two views: dilution risk, or a sign that someone may bail the company out in a crisis. Check the situation and price: a premium price is value-accretive for minorities.

QIP

Dilutes, but likely shows institutional confidence in fundamentals.

Internal accruals

Growth funded from the company's own profits: very little dilution concern.

Dividend and earnings history

  • Dividends plus capital gains make up an investor's total return.
  • Growth phase: companies pay little or no dividend; shareholders do not mind if the company earns more on the money than they could.
  • Mature phase: shareholders expect timely dividends. Predictability matters; high-yield stocks attract long-term income seekers.
  • Mature companies in defensive industries offer the most predictable dividends, often with interim dividends. Book examples: Colgate Palmolive, Britannia.
  • Some companies smooth dividends: build reserves in good years, use them in bad years.
  • Buybacks (other than for stock-based compensation) are also a way to distribute profit; companies may prefer them for tax reasons, and they let investors choose to sell or raise their stake.
Reading the signalsA strong company retaining more profit than usual may plan a big investment, or may expect hard times. A high-growth company raising its dividend may see fewer growth opportunities. When a dividend breaks sharply from the past, ask management why.

History of corporate actions

Dividends, bonuses, splits and rights affect the share price. Chapter 9 covers them.

Insider buying and selling

Owners know the business best, and trade within SEBI's guidelines. Their trades can give insight. Peter Lynch, quoted in the book: insiders sell for many reasons, which need not ring alarm bells, "but if insiders are buying, then there can be only one reason that the company is likely to make huge profits in future".

The book's text gives Bharti Airtel's total debt as "Rs.12.87 billion" and core working capital as "negative Rs.2.36 billion", but its own tables (in Rs million) show 12,87,036 and minus 2,36,141. The quiz does not use these two figures.

All exam traps in this chapter

  1. Statement format: Schedule III of the Companies Act, 2013 and Ind AS 1. Banks, insurers, utilities use their regulators' formats.
  2. Ind AS 1 requires OCI in the P&L statement, below net profit.
  3. Control: more than 50% votes, or right to appoint the board majority, or de facto control (Ind AS 110).
  4. SEBI (as per the book): consolidated annually, standalone quarterly.
  5. Self-generated brands cannot be shown as assets; internally developed software can.
  6. Goodwill = price paid minus fair value of net assets. Paying less goes to capital reserve.
  7. Inventory: lower of cost or market value. Receivables: net of doubtful debt provision.
  8. Investments in JVs and associates use the equity method.
  9. Minority interest appears only in consolidated statements.
  10. Provision: specific obligation. Reserve: no specific obligation.
  11. Total debt includes current portion of long-term debt, finance leases and accrued interest.
  12. Core working capital = inventory + receivables − payables.
  13. Raw material cost = purchases + opening stock − closing stock.
  14. Loss-making company: basic EPS = diluted EPS.
  15. Gross profit usually cannot be computed for Indian companies.
  16. EBITDA is best for comparing firms; EBIT is "operating profit".
  17. Deferred tax has no cash impact.
  18. Buying assets: negative investing cash flow. Borrowing: positive financing cash flow.
  19. Contingent liabilities are not recorded in the accounts, only in notes.
  20. Audit reports: clean, disclaimer, qualified.
  21. ROE = PAT ÷ net worth. ROCE = EBIT ÷ capital employed. Use average balances.
  22. D/E benchmark: 1 or less on the most conservative basis.
  23. Current ratio below 1 is not always bad: customers may be funding working capital.
  24. Inventory turnover is high for FMCG, low for capital goods.
  25. DuPont: margin × asset turnover × equity multiplier. ROE from leverage adds risk.
  26. Rights issues dilute only those who do not subscribe.
  27. Insider buying is a stronger signal than insider selling (Peter Lynch).

For the group discussion

  1. Pick a listed company. Do its standalone and consolidated revenues differ much? Why?
  2. Why might a profitable company still run out of cash? Use the book's Rs 80,000 example.
  3. Bharti Airtel's current ratio was 0.35. Is that a problem? Argue both sides.
  4. Two companies have the same ROE. How would DuPont help you choose between them?
  5. A company has made three preferential allotments in four years. What would you check?