Chapter 35Advanced~13 min

Investigate a fictional company

Work through a fictional company's numbers.

Meet ABC Manufacturing Ltd — a fictional Indian company that makes industrial components and sells them to other businesses. Its financial year runs from April to March, like most Indian companies, and all figures below are in ₹ crore unless stated otherwise.

The numbers

The table gives ABC's figures for three financial years: FY22, FY23 and FY24. Read across each row and notice the direction of travel, not just a single year.

Item (₹ crore unless stated)FY22FY23FY24
Revenue1,0001,2501,500
Total expenses (before interest and tax)9001,1321,362
Operating profit (EBIT)100118138
Net profit8095110
Net profit margin8.0%7.6%7.3%
Operating cash flow9040−20
Capital expenditure60120150
Free cash flow30−80−170
Trade receivables150250420
Total debt300550900
Cash and equivalents1208030
Total assets9001,1501,550
Shareholders' equity500560610
Shares outstanding (crore)101011
Earnings per share (₹)8.09.510.0

ABC Manufacturing — three years of figures. The share price in FY24 is ₹150.

Two measures deserve a quick explanation. Return on equity (ROE) shows the profit earned on the money shareholders have put into the business. The price-to-earnings ratio (P/E) compares the share price with the earnings per share, and is one way people describe how a price relates to profit.

Free cash flow = Operating cash flow − Capital expenditure

The cash left after money spent on long-term assets such as plant and machinery.

Return on equity = Net profit ÷ Shareholders' equity

Profit measured against the shareholders' money in the business.

Case study: ABC Manufacturing

A fictional company with three years of numbers. Investigate it yourself before revealing each answer.

₹ croreFY22FY23FY24
Revenue1,0001,2001,350
Net profit90110120
Total debt300420600
Cash807060
Receivables150210300
Operating cash flow1109560
Shareholders' equity500560610

Shares outstanding

12 crore

Share price

₹150

Market capitalisation

₹1,800 Cr

EPS ≈ ₹10

What happened to revenue?

Is profit growing?

What happened to debt?

What happened to cash flow?

What is the company's ROE?

What is the P/E?

What risks should be investigated?

There is deliberately no buy/sell conclusion. The goal is to practise asking the right questions and doing the arithmetic, not to be told what to do.
Load ABC Manufacturing and explore how the figures move together.

What to investigate

  • What happened to revenue over the three years? Did it grow, and by how much?
  • Is profit growing at a similar pace? Are the margins holding steady?
  • What happened to total debt, and how does it compare with shareholders' equity?
  • What happened to operating cash flow and free cash flow? Are they rising or falling?
  • What is the return on equity for FY24?
  • What is the price-to-earnings ratio at a share price of ₹150?
  • How did the number of shares change, and what might that suggest?
  • Which of the red flags from the earlier chapter appear in these numbers?
ABC Manufacturing is fictional and the numbers are rounded for practice. Nothing here is a recommendation to buy or sell anything.
Work through the questions yourself before moving on. In the next lesson we organise those observations into a careful, independent view.

Key takeaways

  • ABC's revenue grew from ₹1,000 crore to ₹1,500 crore over three years.
  • Net profit rose, but operating cash flow fell and turned negative.
  • Total debt grew faster than equity, lifting the debt-to-equity ratio.
  • Free cash flow was persistently negative and worsening.
  • Several red flags appear together, which is what makes the numbers worth studying.

Check your understanding

Every answer comes with an explanation — the goal is understanding, not a score.

Question 1 / 40%

By how much did ABC's revenue grow from FY22 to FY24?

How was this lesson?

Ratings are tied to your account so we can tell which lessons land well. Sign in to leave one — it takes a second.

Sign in to rate