Case 007Credit analysis and ratingsHard
You are given Pellora Pharma's financials: EBITDA Rs 420 crore, debt Rs 700 crore, receivable days up from 95 to 130. Find the business drivers and credit issues, write your management meeting questions, and work out how much more debt it can take at a 3.0x leverage ceiling.
1The situation
Pellora Pharma makes branded medicines sold through stockists at home and generic medicines exported through distributors abroad. Sales rose from Rs 1,800 crore to Rs 2,000 crore this year and EBITDA is Rs 420 crore, a 21% margin. Debt is Rs 700 crore and tax paid was about Rs 70 crore.
Receivable days rose from 95 to 130. Pellora wants to borrow more for a new plant, and the lender's ceiling is total debt of 3.0x EBITDA. Assume that half of any sale booked on stretched credit is profit at the EBITDA line.
2Your task
Name the business drivers and the credit issues, write the questions you would put to management, and size the extra debt.
Quick check
What is the most important number in this set of financials?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
On reported EBITDA Pellora has Rs 560 crore of headroom under a 3.0x ceiling, but I would lend about Rs 272 crore until the receivables stretch is explained. Receivables rose Rs 244 crore, and only Rs 52 crore of that is growth; Rs 192 crore is customers paying later. Stripping half of it out of profit cuts EBITDA to Rs 324 crore and the headroom to Rs 272 crore.
Step 1What drives this business, and where does credit risk sit?
Start with how the money is made before touching ratios. A branded and generic drug maker earns on three drivers: volumes through its sales channel, prices that regulators and buyers can push down, and the approvals that let its plants supply regulated export markets. The credit issues follow from those: price controls on its biggest brands at home, one failed plant inspection shutting off an export market, customer concentration among a few large distributors, and working capital that swells whenever the company pushes stock to hit a number.
Step 2Why is the receivables line the one to worry about?
Picture a shopkeeper whose sales rise 11% while his credit book grows 52%. He is either extending more generous terms to win business, or recording sales his customers have not really bought. Receivables rose from Rs 468 crore to Rs 712 crore; at the old 95 days, growth alone would explain only Rs 52 crore of the rise, so Rs 192 crore is customers paying later. That is the classic sign of channel stuffingPushing extra stock onto distributors or stockists near a reporting date, often on longer credit, so that sales and profit look higher than end demand., of a large customer in difficulty, or of looser terms to defend share. Any of the three makes EBITDA worth less as cash.
Check it against cash. EBITDA of Rs 420 crore, less about Rs 70 crore of tax, less the Rs 244 crore absorbed by receivables, leaves about Rs 106 crore of operating cash before any capex. A company reporting Rs 420 crore of EBITDA that turns only about a quarter of it into operating cash is telling you its earnings quality needs checking.
Step 3How much more debt can Pellora take?
Do the reported sum first, because the interviewer expects it. A 3.0x ceiling on Rs 420 crore allows Rs 1,260 crore of debt; less Rs 700 crore outstanding leaves Rs 560 crore. Now adjust: if half of the Rs 192 crore of stretched sales is profit that may never turn into cash, EBITDA is nearer Rs 324 crore, capacity Rs 972 crore and headroom Rs 272 crore. Leverage moves from 1.67x to 2.16x before a rupee of new debt.
Step 4What would you ask management?
Each question should test one reading of the receivables line. Which customers account for the increase in receivables, and how much is overdue beyond agreed terms? Did credit terms change this year, and why? How much of the fourth quarter's sales went to stockists and distributors in the last month? What are stock levels in the channel in weeks of sales? Have any export customers asked for longer terms or disputed invoices? Add two on the other drivers: the status of the latest plant inspections, and the share of domestic sales under price control.
Then give the view. Pellora is not stretched on leverage, but its earnings are less proven than they look. Lend about Rs 272 crore now, with a covenant on receivable days and the rest available once collections show the stretch was temporary.
Where candidates lose it
The fast answer multiplies Rs 420 crore by 3.0, subtracts Rs 700 crore and announces Rs 560 crore. It is arithmetically correct and misses the only interesting line on the page. The case was built around receivable days.
The second miss is spotting the stretch but never quantifying it. Splitting the increase into growth and stretch turns a vague concern into a number the panel can argue with.
What the interviewer asks next
- Management says a large export distributor asked for 150-day terms. Does that change your number?
- How would you write a covenant that catches this earlier next year?
- What would you expect the inventory line to show if this were channel stuffing?
- Would a rating analyst treat the stretch differently from a lender?
Asked at Moody's, Debt Capital Markets, Hong Kong, 2018 (Wall Street Oasis): Was given financials of company, main task was finding business drivers and credit issues. Writing management meeting questions in mandarin. Calculate amount of debt.
Company names and figures are illustrative.
