Waltair planning tools / 01
INVESTMENT STUDIO.
Build a portfolio. Challenge the assumptions. Explore the possibilities.
Choose your experiences
Mix concepts to see how the overall project changes.
Total project funding₹15.64 CrIncludes contingency & opening capital
Year 3 facility revenue₹37.95 CrOperating profile × your revenue assumption
Year 3 EBITDA₹14.11 Cr37.2% of facility revenue
Project cash payback2.4 yearsUnlevered · from start of operations
How the project performs
2 concepts · 11,556 sq ft · FOCO facility model
Facility revenueEquity cash flow after debt service
Project equity required₹15.64 Cr
Project debt₹0.00 Cr
Your modelled equity participation64.0%
Remaining equity to fund₹5.64 Cr
Your invested capital₹10.00 CrPro rata facility equity illustration
Your Year 3 cash flow₹7.00 CrAssumes 100% distributable cash paid out
Equity cash payback2.4 yearsAfter debt service · from operations
10-year equity IRR49.0%No exit proceeds or residual value
Pro rata ownership is an illustration, not an offered equity allocation. Retained cash, legal terms, pre-opening time, VAT/GST timing and final funding structure can change returns.
10-year cash-flow projection
₹ crore · tax and cash flow recalculated from operating inputs
| Operating year | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Facility revenue | 20.15 | 29.10 | 37.95 | 38.33 | 38.95 | 39.59 | 40.23 | 40.89 | 41.56 | 42.24 |
| EBITDA | 4.85 | 9.54 | 14.11 | 14.08 | 14.08 | 13.97 | 14.02 | 14.05 | 13.92 | 13.86 |
| Waltair operator fee | 3.02 | 4.36 | 5.69 | 5.75 | 5.84 | 5.94 | 6.03 | 6.13 | 6.23 | 6.34 |
| Debt interest | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Debt principal | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Tax | 0.71 | 1.89 | 3.03 | 3.02 | 3.02 | 3.00 | 3.01 | 3.51 | 3.48 | 3.47 |
| Replacement reserve | 0.14 | 0.14 | 0.14 | 0.14 | 0.14 | 0.14 | 0.14 | 0.14 | 0.14 | 0.14 |
| Equity cash flow | 3.99 | 7.51 | 10.94 | 10.92 | 10.92 | 10.84 | 10.88 | 10.40 | 10.30 | 10.26 |
| Cumulative equity cash flow¹ | -11.64 | -4.13 | 6.81 | 17.73 | 28.64 | 39.48 | 50.36 | 60.76 | 71.05 | 81.31 |
¹ Starts after deducting initial project equity. Payback interpolates the year in which cumulative cash flow becomes positive.
Saved comparisons
On this device · up to 3Save a scenario above, then change the mix or assumptions to compare.
Internal planning inputs, not audited forecasts. FOCO facility revenue belongs to the facility owner. Only Waltair’s operator fees accrue to the group; internal COCO operator fees are eliminated.