Case 033Forensic accountingHard
Over five years Mardanta Infra reported cumulative profit of Rs 2,000 crore but operating cash flow of only Rs 600 crore, with unbilled revenue rising every year. What is happening, and what would you ask management?
1The situation
Mardanta Infra builds roads and water pipelines for state governments on fixed-price contracts and books revenue by percentage of completion: as costs are incurred, it recognises the matching share of the contract's revenue and profit, whether or not it has billed the client. Over five years revenue grew from Rs 3,000 crore to Rs 5,000 crore and profit after tax added up to Rs 2,000 crore, a steady 10% margin.
Operating cash flow over the same five years was Rs 30, 85, 90, 195, 200 crore, Rs 600 crore in total. Unbilled revenue, work done but not yet invoiced, rose from Rs 500 crore to Rs 1,600 crore. Trade receivables rose by Rs 450 crore. Net debt rose from Rs 400 crore to Rs 700 crore while Mardanta paid Rs 350 crore of dividends.
2Your task
Where did the profit go, how worried should you be, and which five questions would you put to management?
Quick check
Which line explains most of the Rs 1,400 crore gap between profit and operating cash flow?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
Mardanta is booking profit it has not billed: only 30% of five years' profit arrived as cash, and Rs 1,100 crore of the gap sits in unbilled revenue. Unbilled revenue rose from about 70 to 117 days of revenue, so the problem is growing faster than the business. Either billing milestones are slipping, claims are being booked before clients accept them, or cost estimates are too optimistic. Until the ageing is explained, treat the earnings as unproven.
Step 1What does a five-year gap between profit and cash usually mean?
A tuition teacher who writes every month's fees into her register as earned, though half the parents have not paid, will show a healthy profit and an empty purse. One slow month is normal; five years of it means some of those fees are never coming. Timing differences between profit and cash reverse within a year or two, so a gap that widens for five years running is not timing: it is the loudest warning an income statement can give. Mardanta turned Rs 2,000 crore of profit into Rs 600 crore of operating cash and borrowed to pay its dividends.
Step 2Where exactly is the missing cash?
Rebuild operating cash flow from profit: add back depreciation, then subtract every rupee that went into working capital. Of the Rs 1,400 crore shortfall, Rs 1,100 crore is the rise in unbilled revenueRevenue recognised for work done under a contract that has not yet been invoiced to the client; shown as a contract asset on the balance sheet., Rs 450 crore is receivables and Rs 150 crore other working capital. Receivables are at least invoices the client has seen. Unbilled revenue is Mardanta's own estimate of what it has earned, which is why it deserves the harder look.
| PAT | profit after tax over five years, Rs crore |
| D&A | depreciation and amortisation, a non-cash cost |
| Delta Unbilled | rise in work done but not invoiced |
| Delta Receivables | rise in invoices not yet paid |
| Year | Revenue | Profit | Operating cash | Unbilled at year end | Unbilled days |
|---|---|---|---|---|---|
| 1 | 3,000 | 300 | 30 | 700 | 85 |
| 2 | 3,500 | 350 | 85 | 900 | 94 |
| 3 | 4,000 | 400 | 90 | 1,150 | 105 |
| 4 | 4,500 | 450 | 195 | 1,350 | 110 |
| 5 | 5,000 | 500 | 200 | 1,600 | 117 |
Step 3What would you ask management?
Ask questions whose answers are numbers, not reassurance. First, the ageing of unbilled revenue: how much is more than a year old, and on which contracts. Second, which billing milestones have slipped and why. Third, how much of the unbilled balance is claims for extra work or cost overruns that the client has not yet accepted, and how many are in arbitration. Fourth, how often estimates of total contract cost have been revised upwards, because a rising cost estimate on a fixed-price contract should cut profit already booked. Fifth, whether any receivables have been sold or discounted, which would flatter reported cash.
Then put a number on the downside. If 30% of the Rs 1,600 crore of unbilled revenue is never billed, the write-off is Rs 480 crore before tax, nearly a quarter of five years' reported profit. For valuation, lean on cash: five years of operating cash flow average Rs 120 crore a year against reported profit of Rs 400 crore, and any earnings multiple should be applied only to profit the business has shown it can collect.
Where candidates lose it
The usual loss is accepting that infrastructure is working capital heavy and moving on. It is, but that explains a stable gap, not unbilled days rising from 85 to 117 for five straight years.
The second is focusing on receivables because they are the familiar line. Unbilled revenue has not even been invoiced; it is the company's own estimate of what it is owed, which makes it the weaker asset of the two.
What the interviewer asks next
- What would you look for in the auditor's report for Mardanta?
- How do customer advances change the picture for a contractor?
- Mardanta proposes a large new order win. Why might that make the cash problem worse before it gets better?
Company names and figures are illustrative.
