Rangrez Paints (a hypothetical unlisted company) is considering a listing, and the banker wants a first view of value from four listed peers. Compute each peer's EV/EBITDA and P/E, take the median of each, and apply them to Rangrez.
All figures are ₹ crore except per-share values. A negative net debt means the company holds net cash.
| ebitda | company | net debt | market cap | profit after tax |
|---|---|---|---|---|
| 3,000 | Peer A | -2,000 | 60,000 | 2,000 |
| 1,250 | Peer B | 1,000 | 24,000 | 780 |
| 520 | Peer C | 600 | 9,000 | 300 |
| 900 | Peer D | -500 | 15,000 | 610 |
Fill every cell. Each is checked against a 2% band.
Enterprise value = market cap + net debt. The median of four numbers is the average of the middle two once sorted.
Apply the median EV/EBITDA to Rangrez's EBITDA to get enterprise value, then subtract net debt for equity. Apply the median P/E directly to Rangrez's profit for a second equity view.