Published: August 2026 | White Warp | whitewarp.in
IRR (Internal Rate of Return) on a small residential project is the discount rate at which the net present value of all project cash flows, outflows for land and construction and inflows from unit sales, equals zero. It is calculated by laying out every cash flow by period (typically month or quarter) across the project timeline and solving for the rate, which is usually done with a financial calculator or spreadsheet function rather than by hand. IRR matters more than a simple ROI percentage because it accounts for when money goes out and comes back, not just how much.
Quick Answer
- IRR requires a full cash flow timeline: every outflow (land payment, construction draws) and every inflow (unit sale proceeds) placed in the specific period it occurs, not lumped into a single start and end date.
- IRR differs from ROI because it accounts for timing. Two projects with identical total profit can have very different IRRs if one returns cash sooner than the other.
- Spreadsheet software has a built-in IRR function that takes a series of periodic cash flows and returns the rate; this is the practical way to calculate it, not manual trial and error.
- A common approach for a small residential project is monthly or quarterly periods across an 18 to 36 month timeline, with land cost as a large early outflow, construction cost spread across the build period, and sale proceeds arriving in the final months as units close.
- IRR should be compared against the project's cost of capital or a hurdle rate the investor considers acceptable given the risk, not treated as good or bad in isolation.
- A single-point IRR hides risk. Running the same cash flow model with a range of assumptions on sale timing and rate (a sensitivity or scenario analysis) gives a more honest picture than one number.
Step 1: Lay Out the Full Project Timeline in Periods
Break the project into monthly or quarterly periods from land acquisition to final unit handover and sale closure. A typical small residential project might run 18 to 30 months from land purchase to last unit sold, though this varies by project size and market.
Step 2: Place Every Outflow in Its Actual Period
Land cost (plus stamp duty and registration) is usually a large outflow at or near period zero. Construction cost is not a single lump sum; it is drawn progressively across the build period, following typical construction drawdown patterns (foundation, structure, finishing) rather than evenly across all months. Approval and professional fees occur early, mostly before and during the initial construction phase.
Step 3: Place Every Inflow in Its Actual Period
Sale proceeds do not all arrive at project completion. Some projects sell units progressively during construction (subject to RERA rules on collections against construction milestones where applicable); others sell only after completion. Place each expected sale inflow in the period it is realistically expected to land, based on the sales strategy for the specific project.
Step 4: Net Each Period's Cash Flow
For each period, subtract outflows from inflows to get a single net cash flow figure for that period. Most early periods will be negative (outflows dominate); later periods, once sales start closing, turn positive.
Step 5: Apply the IRR Function to the Full Series
Using a spreadsheet's IRR function (or an equivalent financial calculator function) on the complete series of periodic net cash flows returns the periodic IRR. If cash flows are monthly, this returns a monthly rate, which is then annualized to compare against an annual hurdle rate.
Step 6: Compare IRR Against the Hurdle Rate
The calculated IRR only means something in context. Compare it against the investor's cost of capital, an alternative investment's return, or a personally acceptable hurdle rate given the project's risk level, to judge whether the project clears the bar.
Worked Example: 4-Unit Independent Floor Project, 24-Month Timeline
Assumptions (illustrative only, not representative of any specific real plot):
- Month 0: Land purchase + stamp duty = -₹1.9 crore
- Months 1-4: Approvals and professional fees = -₹8 lakh total, spread across these months
- Months 3-16: Construction cost = -₹1.0 crore total, drawn progressively (heavier in the structural phase, lighter at the finishing stage)
- Months 18-22: Unit sales close progressively as each of the 4 units finds a buyer and completes registration, assumed at approximately ₹75 lakh per unit net of selling costs = +₹3.0 crore total, spread across these 5 months as units close one at a time
Net cash flow by period (simplified to a few key points for illustration):
| Period | Net Cash Flow |
|---|---|
| Month 0 | -₹1.9 crore |
| Months 1-4 | -₹8 lakh (total) |
| Months 3-16 | -₹1.0 crore (total) |
| Months 18-22 | +₹3.0 crore (total, spread as units close) |
Applying the IRR function to the full monthly series of these cash flows (not the summarized totals shown above, which are for readability) returns a monthly IRR, annualized to an approximate project IRR. The specific annualized figure depends entirely on the exact monthly distribution of each outflow and inflow, which is why this worked example deliberately does not state a single final IRR percentage: the number is sensitive enough to timing that presenting one figure from a simplified table would be misleading. The correct way to get the real number for a specific project is to build the full monthly cash flow series and run it through a spreadsheet IRR function, not to estimate it from a summary table.
Common Mistakes
Using ROI instead of IRR to compare projects with different timelines. A project that returns the same total profit in 18 months rather than 36 months has a meaningfully higher IRR, and ROI alone does not capture this.
Lumping all outflows and inflows into two dates. Treating the entire construction cost as a single outflow at the start, or all sale revenue as a single inflow at the end, distorts the IRR compared to the actual progressive cash flow pattern.
Ignoring sales timing risk. Assuming all units sell immediately upon completion, rather than progressively over several months as is typical, overstates IRR by pulling inflows earlier than realistic.
Not running a sensitivity range. A single-point IRR based on one set of assumptions about sale rate and timing hides how sensitive the result is to those assumptions. A range built from optimistic, base, and conservative scenarios is more honest.
Confusing periodic IRR with annualized IRR. A monthly IRR figure needs to be correctly annualized before it can be compared against an annual hurdle rate; comparing a raw monthly figure to an annual benchmark produces a wrong conclusion.
FAQ
What is a reasonable IRR target for a small residential project in India? There is no single universal benchmark; it depends on the investor's cost of capital, the project's risk profile, and prevailing alternative investment returns. A project should be evaluated against the specific investor's hurdle rate, not a generic industry figure.
Does IRR account for taxes? A pre-tax IRR calculation, which is what the standard IRR function produces from pre-tax cash flows, does not reflect the investor's actual after-tax return. For a complete picture, a separate after-tax cash flow series, accounting for capital gains tax and GST where applicable, should be modeled.
How is IRR different from a simple annualized return? A simple annualized return typically assumes a single lump-sum investment and a single lump-sum return at a fixed end date. IRR handles multiple cash flows occurring at different times throughout the project, which is the realistic pattern for a construction project with progressive costs and progressive sales.
Can IRR be negative? Yes, if the total cash outflows exceed total inflows across the project's life, the IRR calculation will return a negative rate, indicating the project destroyed value rather than created it.
Should financing cost be included in the IRR cash flows? This depends on whether the IRR is being calculated on an unlevered (project-only) or levered (equity investor) basis. An unlevered IRR excludes loan interest and principal flows; a levered IRR, which reflects the actual return to an equity investor using debt financing, includes them. Be clear about which one is being calculated and compared.
White Warp models the full periodic cash flow timeline, including IRR, for every project it runs a feasibility check on. Run your project's numbers →