How to Build a Multi-Year Cashflow Model for a Rented Flat
A single-year yield number hides how a rented flat actually behaves over a hold — rent escalates, EMI eventually ends, CAM rises, and vacancy hits unevenly. A proper cashflow model lays out every year explicitly.
Line items per year
5–7
Typical annual rent escalation
5–8%
Vacancy assumption to build in
7–9%
Model that replaces guesswork
1
What the data says
Core line items each year: gross rent (escalated), less vacancy loss, less CAM, less property tax, less EMI, equals net pre-tax cash flow.
Worked example, Year 1: gross rent ₹6L, vacancy loss (8%) ₹48,000, CAM ₹60,000, property tax ₹15,000, EMI ₹4.2L — net cash flow = 6,00,000 − 48,000 − 60,000 − 15,000 − 4,20,000 = ₹57,000.
By Year 5, with 6% annual rent escalation and unchanged EMI, gross rent rises to roughly ₹7.57L while EMI stays fixed, expanding net cash flow to well over ₹1.3L for that year — the model should show this trajectory explicitly, not just a single static year.
Build the full multi-year projection at /knowledge/calculators/cashflow instead of a static spreadsheet.
How EstateVeda executes this
List every recurring inflow (rent) and outflow (EMI, CAM, tax, insurance, repairs) on a year-by-year basis.
Apply realistic escalation to rent and CAM independently, since they rarely move in lockstep.
Build in a vacancy assumption for at least one month per year in most micromarkets.
Sum the multi-year net cash flows and combine with exit proceeds to derive total and IRR-based returns.
Risks we underwrite against
Assuming zero vacancy or zero CAM escalation across a multi-year hold materially overstates cash flow.
Ignoring EMI reset risk on floating-rate loans can leave the model badly wrong from Year 3 onward.
EstateVeda verdict
Never rely on a single-year cash flow snapshot — model the full hold period, since rent escalation, EMI and CAM all evolve at different rates.
Frequently asked questions
Why build a multi-year cashflow model instead of just checking Year 1 yield?
Rent, CAM and EMI change at different rates over time, so a Year 1 snapshot can understate or overstate the true return profile of a multi-year hold significantly.
What escalation rate should I assume for rent?
5–8% annually is a reasonable assumption for most NCR residential micromarkets, though corporate-catchment properties can sustain the higher end more reliably.
How does the cashflow model feed into IRR?
Each year's net cash flow from the model becomes one input in the IRR calculation (see /knowledge/calculators/irr), together with the initial outlay and exit proceeds.