Scenario Comparison Analysis

Side-by-side KPI comparison with variance analysis · Select any two scenarios to compare

Scenario A

TPH:

Scenario B

TPH:

Full KPI Comparison

Delta shows Scenario B relative to Scenario A

KPI	Downside Case	Upside Case	Variance (B vs A)
Returns
Project IRR	51.0%	164.1%	221.7%
Equity IRR	89.8%	373.3%	315.9%
NPV @ 14%	₹14.8 Cr	₹60.5 Cr	307.3%
Payback Period	Yr 2.3	Yr 0.7	70.4%
Revenue
Year 1 Revenue	₹11.6 Cr	₹22.9 Cr	98.7%
Year 2 Revenue	₹17.3 Cr	₹27.8 Cr	60.7%
Year 5 Revenue	₹18.9 Cr	₹30.4 Cr	60.7%
Profitability
Yr2 EBITDA	₹4.11 Cr	₹15.1 Cr	267.5%
Yr2 EBITDA Margin	23.7%	54.3%	128.7%
Yr2 PAT	₹2.44 Cr	₹10.7 Cr	337.6%
Yr2 PAT Margin	14.1%	38.4%	172.3%
Debt Service
DSCR (Year 2)	3.96x	14.55x	267.5%
DSCR (Year 3)	4.75x	16.41x	245.8%
Capital
Total Project Cost	₹6.25 Cr	₹6.25 Cr	0.0%
Yr2 Gross Margin	27.9%	56.9%	103.9%