06 · Sensitivity
Sensitivity Analysis
Revenue growth vs EBITDA margin, re-running the full forecast engine for each cell.
The source workbook does not contain a sensitivity table. This grid is a derived calculation: it applies uniform shifts to the active scenario's FY26–FY28 revenue growth and EBITDA margin inputs and recomputes using the model's own formulas. No new assumptions are introduced.
FY28 EPS — Growth shift (rows) × EBITDA margin shift (columns)
Centre = active case: growth 8.0% / 8.5% / 9.0%, margin 28.0% / 28.2% / 28.5%
| Growth ↓ / Margin → | -2.0pp | -1.0pp | Active | +1.0pp | +2.0pp |
|---|---|---|---|---|---|
| -2.0pp | ₹154.87 -12.6% | ₹161.22 -9.0% | ₹167.56 -5.4% | ₹173.91 -1.8% | ₹180.26 +1.7% |
| -1.0pp | ₹159.27 -10.1% | ₹165.80 -6.4% | ₹172.33 -2.7% | ₹178.86 +0.9% | ₹185.38 +4.6% |
| Active | ₹163.76 -7.6% | ₹170.47 -3.8% | ₹177.18 base | ₹183.89 +3.8% | ₹190.61 +7.6% |
| +1.0pp | ₹168.33 -5.0% | ₹175.23 -1.1% | ₹182.13 +2.8% | ₹189.03 +6.7% | ₹195.93 +10.6% |
| +2.0pp | ₹172.98 -2.4% | ₹180.07 +1.6% | ₹187.16 +5.6% | ₹194.25 +9.6% | ₹201.34 +13.6% |
Upside vs activeDownside vs activeActive case