ROI Calculator

Run the numbers.

The same model WTF uses internally. Every input is live — every output recalculates in real time. Built from the Excel term sheet.

Investment

Total Capex

Rs 150 Llakh

Rs 1.50 Cr · Rs 2,500 / sq ft

Floor Area

6,000 sq ftsq ft

Membership

Mature Members (M12)

1,200members

Net ARPU

Rs 1700Rs / mo

ARPU Escalation

5.0%/ year

Member Growth (Y2+)

6.0%/ year

PT Attach Rate

8.3%of members

Operating Costs (Mature)

Rent / sq ft / mo

Rs 100Rs

Rs 6.0 L / month

Payroll

Rs 5.5 Llakh / mo

Utilities

Rs 2.8 Llakh / mo

Marketing

Rs 1.2 Llakh / mo

Power Fee

Rs 1.0 LL / mo

Fixed monthly WTF operating fee (~₹1,00,000/mo)

Cost Escalation

5.0%/ year

Rs 441 L

5-Yr Net Cash

After Rs 1.50 Cr deployed

294%

5-Yr ROI

Cash-on-cash

2.2 yr

Payback

19 mo at mature EBITDA

61%

IRR / yr

Annualized

8.0

Mature EBITDA / mo

Rs lakh, at Month 12

3.9x

5-Yr MOIC

Multiple on capital

5-Year P&L Outlook

Revenue, EBITDA, cumulative cash — all Rs lakh

Monthly Cash Flow & Cumulative Position

Includes ramp losses in Year 1. Capex deployed at Month 0.

Annual P&L Summary

Rs Lakh	Y1	Y2	Y3	Y4	Y5	5Y
Members (year-end)	1,200	1,272	1,348	1,400	1,400	—
Revenue	240	355	391	421	438	1,844
EBITDA	12.9	117	140	159	162	591
EBITDA Margin	5.4%	32.9%	36.0%	37.7%	37.0%	32.0%
Total OPEX	227	238	250	263	276	1,253
Tax	0.0	0.0	0.0	0.0	0.0	0.0
Net Cash (after tax)	12.9	117	140	159	162	591
Cumulative Cash	-137	-20.1	120	279	441	441
Cumulative net of Capex	-137	-20.1	120	279	441	441

Sensitivity · Mature Monthly EBITDA

Members (rows) × ARPU (cols) — Rs lakh / month at Month 12

Members ↓ · ARPU →	Rs 1400	Rs 1500	Rs 1600	Rs 1700	Rs 1800	Rs 1900	Rs 2000
900	-1.4	-0.5	0.4	1.3	2.2	3.1	4.0
1000	0.5	1.5	2.5	3.5	4.5	5.5	6.5
1100	2.4	3.5	4.6	5.7	6.8	7.9	9.0
1200	4.4	5.6	6.8	8.0	9.2	10.4	11.6
1300	6.3	7.6	8.9	10.2	11.5	12.8	14.1
1400	8.2	9.6	11.0	12.4	13.8	15.2	16.6
1500	10.2	11.7	13.2	14.7	16.2	17.7	19.2

Sensitivity · Simple Payback (months)

Months from cash deployment to recover capex at mature EBITDA. n.m. = EBITDA not positive.

Members ↓ · ARPU →	Rs 1400	Rs 1500	Rs 1600	Rs 1700	Rs 1800	Rs 1900	Rs 2000
900	n.m.	n.m.	400	118	69	49	38
1000	303	100	60	43	33	27	23
1100	62	43	33	26	22	19	17
1200	34	27	22	19	16	14	13
1300	24	20	17	15	13	12	11
1400	18	16	14	12	11	10	9
1500	15	13	11	10	9	8	8