Models
MAHINDRA HOLIDAYS LTDMHRILLeisure Services
₹-157per share · Base Model Note
Revenue growth, the horizon and scenarios are yours to change. Every other input is part of the Trader plan; saving, sharing a saved link and the live-formula workbook are part of the Institutional plan.
Scenario
Value per share, your model₹(157)implied FY26 P/E (59.5)× · EV/EBITDA (3.2)×
Against CMP ₹196.70−179.6%close of 2026-09-10
Growth the CMP implies45.0%revenue, a year for 5 years, on your other inputs
Value after FY31—share of enterprise value in the terminal
This figure is the arithmetic of your inputs and nothing else. MarketPing publishes no fair value, target or rating; the model is yours.
Where the methods land · ₹ per share · the dashed line is the CMP
DCF, rate ±1 · growth ±1your model across the sensitivity grid
₹(204)₹(133)
52-week rangetraded range, a fact not a value
₹193₹369
From enterprise to equity · ₹ crore
| PV of FY27–FY31 free cash flow | (346) |
| PV of terminal value | (1,615) |
| Enterprise value | (1,961) |
| less net debt | (1,198) |
| less non-controlling interest | 0 |
| add non-operating investments | 0 |
| Equity value | (3,159) |
| ÷ 20.17 crore shares | ₹(157) |
Free cash flow, filed and modelled · ₹ '000 crore
Filed, cash from operations − capexModelled free cash flow to firm
Sensitivity · ₹ per share
Down Across| WACC ↓terminal growth → | 4.0% | 4.5% | 5.0% | 5.5% | 6.0% |
|---|---|---|---|---|---|
| 10.00% | (160) | (168) | (178) | (189) | (204) |
| 10.50% | (152) | (158) | (166) | (176) | (187) |
| 11.00% | (145) | (150) | (157) | (164) | (174) |
| 11.50% | (138) | (143) | (149) | (155) | (163) |
| 12.00% | (133) | (137) | (142) | (147) | (153) |
The outlined cell is your model. Green figures sit above the CMP of ₹196.70; n/a marks a terminal growth at or above the discount rate. Steps: WACC and terminal growth ±0.5 point, growth ±2, margin ±1.
Distribution of outcomes · 4,000 draws · growth, margin and the discount rate vary together
| 10th · 50th · 90th percentile, ₹ per share | (209) · (156) · (113) |
| Draws below the CMP | 100% |
| Rank correlation with revenue growth | −0.75 |
| Rank correlation with ebitda margin | +0.60 |
| Rank correlation with discount rate | +0.27 |
Each driver is drawn from a PERT distribution between the lowest and highest value across your scenarios (or ±50% growth, ±20% margin when there is one scenario), with the discount rate ±1.5 points. Seeded, so the same inputs give the same picture.
Projected cash flow to the firm · ₹ crore
History Forward| ₹ crore | FY23 | FY24 | FY25 | FY26 | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|---|---|---|---|
| Revenue | 2,517 | 2,705 | 2,781 | 2,992 | 3,216 | 3,457 | 3,717 | 3,995 | 4,295 |
| growth % | 25.0 | 7.5 | 2.8 | 7.6 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |
| EBITDA | 472 | 514 | 579 | 606 | 650 | 698 | 751 | 807 | 868 |
| margin % | 18.7 | 19.0 | 20.8 | 20.2 | 20.2 | 20.2 | 20.2 | 20.2 | 20.2 |
| less depreciation | (290) | (337) | (366) | (409) | (441) | (474) | (509) | (547) | (588) |
| EBIT | 182 | 177 | 213 | 196 | 209 | 225 | 242 | 260 | 279 |
| less tax on EBIT | (101) | (107) | (116) | (124) | (133) | (143) | |||
| NOPAT | 95 | 102 | 109 | 117 | 126 | 136 | |||
| add depreciation | 290 | 337 | 366 | 409 | 441 | 474 | 509 | 547 | 588 |
| less capex | (261) | (338) | (326) | (421) | (453) | (508) | (568) | (633) | (706) |
| less working-capital build | — | (130) | (140) | (150) | (161) | (173) | |||
| Free cash flow to firm | 420 | 287 | 295 | — | (41) | (64) | (91) | (121) | (156) |
| Discount factor | 0.949 | 0.855 | 0.770 | 0.694 | 0.625 | ||||
| Present value | (39) | (55) | (70) | (84) | (97) |
History columns are the filed years (free cash flow there is cash from operations − capex, as filed); the base year and everything to its right come from the engine. Forward is the explicit horizon of the model itself: 3, 5 or 10 years, then flat.
The three statements, projected · ₹ crore · debt held at 1,234, dividends at 0% of profit
| ₹ crore | FY26 | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|---|
| Income statement | ||||||
| EBIT | 196 | 209 | 225 | 242 | 260 | 279 |
| Interest at 16.3% on debt | (201) | (201) | (201) | (201) | (201) | |
| Profit before tax | 8 | 24 | 40 | 59 | 78 | |
| Profit after tax | 70 | 4 | 11 | 20 | 28 | 38 |
| Dividends | (0) | 0 | 0 | 0 | 0 | 0 |
| Balance sheet, year end | ||||||
| Cash | 36 | (103) | (265) | (454) | (673) | (926) |
| Working capital | 1,731 | 1,861 | 2,001 | 2,151 | 2,312 | 2,486 |
| Net block and other assets | 9,618 | 9,630 | 9,664 | 9,723 | 9,809 | 9,927 |
| Debt | 1,234 | 1,234 | 1,234 | 1,234 | 1,234 | 1,234 |
| Equity | 784 | 787 | 799 | 819 | 847 | 885 |
| Balance check | 0 | 0 | 0 | 0 | 0 | 0 |
| Cash flow | ||||||
| From operations | 315 | 345 | 379 | 414 | 453 | |
| Investing (capex) | (453) | (508) | (568) | (633) | (706) | |
| Financing (dividends) | 0 | 0 | 0 | 0 | 0 | |
| Net change in cash | (139) | (162) | (189) | (219) | (253) | |
| Free cash flow to equity | (139) | (162) | (189) | (219) | (253) | |
Other liabilities are held at their FY26 level, so the check tests only what the model moves: cash, working capital, net block and other assets, debt and equity. A non-zero check would mean the three statements no longer tie.
Scenarios side by side · ₹ per share
| Scenario | Template | Growth | Margin | Rate | Terminal | ₹ / share | vs CMP |
|---|---|---|---|---|---|---|---|
| Base · editing | DCF | 7.5% | 20.2% | 11.00% | 5% | ₹(157) | (179.6)% |
A scenario is a full set of inputs under a name. Keep Base as the filed history carried forward; add Bull and Bear by saving the current inputs under those names and moving the two or three assumptions you actually hold a view on. The distribution above draws each driver between the lowest and highest value across your scenarios, so three scenarios give it a real range; with one scenario it falls back to fixed bands.