Methodology

Building KPI Trees for Indian Companies

A KPI tree connects a company's operating drivers to its financial statements as a hierarchy. Here is how to structure one, top-down, with an Indian-company shaped example.

A KPI tree is a hierarchical map that starts from a number in the financial statements, such as revenue or profit, and breaks it down, level by level, into the operating drivers that combine to produce it. You build it top-down, from the outcome you care about to the smallest quantities you can actually track, so that every operating metric has a defined place and a defined arithmetic path up to the accounts. The value is not in the list of metrics. It is in the structure that connects them.

Most people collect KPIs as a flat list: subscribers, market share, utilisation, receivable days, store count, and so on down the page. A flat list has two problems. Everything on it looks equally important, and nothing on it tells you how the pieces fit together. A tree fixes both. It ranks the drivers by where they sit in the hierarchy, and it makes the relationship between them explicit, so you can see that a change in one leaf flows up through a branch and lands on a specific line in the statements.

Start from the number, not the metrics

The mistake that ruins most driver maps is building from the bottom up. You start listing every operating metric you can find and hope they add up to something. They rarely do, because you have no organising principle telling you which metrics belong and which are noise.

A KPI tree is built the other way round. You pick the root first: the single financial outcome the whole tree is going to explain. For a topline analysis that root is revenue. For a profitability analysis it might be EBITDA or net profit. For a lender it is often net profit or return on equity. Whatever you choose, the root is a real line in the accounts, stated in rupees, because that anchors everything below it.

Then you ask one question and only one question: what two or three quantities combine to produce this number. That gives you the first level of branches. You ask the same question of each branch, and you keep asking it, one level at a time, until you reach quantities you can observe on their own. Deciding the root is not a formality. It fixes what the tree is for. A tree rooted at revenue and a tree rooted at return on equity for the same company look completely different, because they are answering different questions. This is the same discipline as revenue mapping explained: you take the topline apart into segments and then into drivers, but a tree extends that idea to any financial outcome, not just revenue, and it insists on the hierarchy.

The rule at every branch: real arithmetic, no gaps, no overlaps

A tree is only useful if the branches under any node are honest. Two rules make them honest.

First, the children of a node must combine into the parent by a real arithmetic relation, not a vague association. Revenue equals price times volume. Net interest income equals average assets times net interest margin. Profit equals revenue minus costs. If you cannot write down the operation that takes the children back up to the parent, they are not children, they are just related ideas, and the tree has broken.

Second, at each level the children must be mutually exclusive and collectively exhaustive. Mutually exclusive means no two branches count the same rupee, so you are not double-counting. Collectively exhaustive means the branches leave nothing out, so the children genuinely reconstruct the parent with no unexplained residual. A common failure is a tree where the branches almost add up, leaving a mysterious gap that gets quietly plugged. That gap is usually a driver you have not named yet, and naming it is exactly the work.

Together these two rules separate a KPI tree from a mind map. A mind map connects ideas. A tree conserves arithmetic at every level, so a number entered at any leaf can be pushed to the top and land on the correct figure in the statements.

A worked example: a lender’s profit tree

An Indian lender, a bank or a non-banking finance company, is one of the cleanest businesses to draw as a tree, because almost every node is a clean multiplication or subtraction. Take net profit as the root.

At the first level, profit splits into a few exhaustive pieces: net interest income, plus other income, minus operating expenses, minus credit costs, minus tax. Those five combine by simple addition and subtraction into profit, with no overlap and no gap. That is a valid first level.

Now expand the branches that carry the business.

  • Net interest income splits into average interest-earning assets times net interest margin. Average assets is itself a branch: opening loan book, plus disbursements, minus repayments and run-off, which is how the book you have described as assets under management actually builds through the year. Net interest margin is the spread between what the lender earns on assets and what it pays for funds.
  • Operating expenses split into a cost-to-income relationship, or into headcount, branches, and technology spend if you want more detail and can observe those pieces.
  • Credit costs split into the loan book times a credit cost rate, where the rate is the leaf you actually debate: how many rupees of provisions per hundred rupees lent.

Notice what the tree has done. It has taken a single profit number and expressed it as a small set of leaves you can each reason about separately: how fast the book grows, what spread it earns, how efficiently the lender runs, and how much it loses to bad loans. Those four questions are the business. A flat KPI list would have buried them among twenty metrics of equal apparent weight. The tree surfaces them because of where they sit.

The same shape works for any Indian business, only the branches change. A telecom roots at revenue and splits into subscribers times average revenue per user, with subscribers branching into gross additions minus churn. A retailer splits into store count times sales per store. A commodity processor splits into volume times realisation per tonne. The method is identical. Only the arithmetic under each node reflects the specific business.

Attach a statement line to every node

The tree earns its keep at the moment you tie it back to the accounts, because that is what makes it a model rather than a diagram. Every node should name the financial-statement line it rolls up into. The root is a line by definition. The branches, expressed in rupees, roll into that line. The leaves, often expressed in units or ratios, feed the branches.

This is where a KPI tree meets the discipline of mapping every KPI to the financial statements. That mapping asks, for a single metric, which line it moves. The tree asks the structural version: how all the metrics fit together on the way to the line. When both are done, you can trace a change in any leaf, say a move in net interest margin or a slowdown in disbursements, straight up the branches to the effect on profit. A number that cannot be traced up to a line does not belong on the tree.

Knowing when to stop

The final structural decision is where to stop splitting. The answer is simple to state: you stop at leaves you can observe and forecast independently. If a branch splits into two children that you can only ever estimate together, splitting them adds no information, only the appearance of rigour. False precision is a real cost, because it invites you to argue about a number you cannot actually see.

This is also where a tree connects to judgement about which drivers matter, the subject of KPI tracking that actually matters. A full tree can have dozens of leaves, but only a few of them decide the outcome. Once the tree is built, you can test each leaf by asking how much the root moves when that leaf moves within a plausible range. The leaves with the most leverage are the ones you monitor closely. The rest you carry, but lightly. The tree gives you the structure; that sensitivity test tells you where to spend your attention.

What to take away

Building a KPI tree is a structural exercise, and the structure is the insight.

  • Pick the root first. Choose the one financial line the tree exists to explain, and state it in rupees.
  • Split top-down, one level at a time. Ask what two or three quantities combine to make each node, and make them children.
  • Keep every branch honest. Children must combine into the parent by real arithmetic, with no double-counting and no unexplained gap.
  • Name the line at every node. If a metric cannot be traced up to a statement line, it does not belong on the tree.
  • Stop at leaves you can see. Split only as far as you can observe and forecast each child on its own.

A well-built tree turns a company from a page of disconnected metrics into a single connected structure you can reason about, and it is the scaffold everything downstream sits on, including a full three-statement model. The point is never to have more KPIs. It is to know how the ones that matter fit together, and where each one lands in the accounts. A tool like Altys keeps those drivers source-linked and calculated rather than guessed, but the discipline of structuring the tree is yours to build first.

This article is educational. Altys Labs is not a registered research analyst or investment adviser, and nothing here is investment advice or a recommendation to buy, sell, or hold any security.

Frequently asked questions

What is a KPI tree?

A KPI tree is a hierarchical map that starts from a financial outcome, such as revenue or profit, and breaks it down, level by level, into the operating drivers that combine to produce it. Each node splits into children that recombine by a known arithmetic relation, until you reach the smallest quantities you can actually observe and forecast on their own.

How is a KPI tree different from a list of KPIs?

A list is flat and unranked, so every metric looks equally important and nothing tells you how they fit together. A tree is structured. It shows which driver sits under which, how they multiply or add into the number you care about, and therefore which leaf actually moves the result. Structure is the whole point.

Where does a KPI tree connect to the financial statements?

At every node. The root of the tree is a financial-statement line, such as revenue, EBITDA, or net profit. Each level down is still expressed in the units of that line, so a change in any leaf can be traced arithmetically up the tree to a specific number in the accounts.

How detailed should a KPI tree be?

Only as detailed as your ability to observe and forecast the leaves independently. You stop splitting a branch when the children can no longer be estimated separately from public disclosure or reasonable judgement. A tree that keeps branching past that point adds false precision, not insight.