Residual land value calculator

Work backwards from what a scheme sells for to what the land beneath it can support. Enter saleable area, an achievable rate, the cost of building and selling, your finance assumption and the profit you require, and the calculator returns the residual land value, the value per square foot of land and per acre, plus a 5×5 sensitivity grid.

Scheme inputs

sq ft
₹/sq ft

Net of discounts, from your own comparables

Car park sales, commercial, amenity charges

Construction, fees, statutory, external, contingency

% of GDV
% of cost

Rolled-up interest over the programme

% on total cost
sq ft

Residual

Gross development value₹52.73 Cr
Less marketing and selling₹-2.11 Cr
Net realisation₹50.62 Cr
Finance cost₹2.08 Cr
Costs excluding land₹28.08 Cr
Residual land value₹14.10 Cr
Per sq ft of land₹3,237
Per acre₹14.10 Cr
Per sq ft of saleable area₹1,738

The formula

GDV                  = saleable area × rate + other revenue
net realisation      = GDV − marketing
finance              = development cost × finance %
costs excluding land = development cost + finance

profit is p% of (land + costs excluding land), so:

land = (net realisation − costs excluding land × (1 + p)) ÷ (1 + p)

The land is the balancing figure. Everything else in the scheme is either contracted (cost), market-determined (revenue) or a policy you set (profit); the land absorbs the difference. That is precisely why residual land value is volatile and why it should be presented as a range with the drivers named.

Sensitivity: sales rate against development cost

Residual land value at ±10% on the two drivers that move it most. Rows flex the sales rate; columns flex development cost.

Residual land value sensitivity to sales rate and development cost
Rate \ Cost-10%-5%0%+5%+10%
-10%₹12.69 Cr₹11.29 Cr₹9.88 Cr₹8.48 Cr₹7.08 Cr
-5%₹14.80 Cr₹13.40 Cr₹11.99 Cr₹10.59 Cr₹9.19 Cr
0%₹16.91 Cr₹15.51 Cr₹14.10 Cr₹12.70 Cr₹11.29 Cr
+5%₹19.02 Cr₹17.62 Cr₹16.21 Cr₹14.81 Cr₹13.40 Cr
+10%₹21.13 Cr₹19.72 Cr₹18.32 Cr₹16.92 Cr₹15.51 Cr

Worked example

A one-acre site supports 81,120 sq ft of saleable area. At ₹6,500 per sq ft the gross development value is roughly ₹52.7 crore. Marketing at 4% takes ₹2.1 crore, leaving ₹50.6 crore of net realisation. Development cost excluding land is ₹26 crore, and finance at 8% of that adds ₹2.1 crore, so costs excluding land are ₹28.1 crore. At a 20% profit on total cost, the land can absorb about ₹14.4 crore — roughly ₹33,000 per sq ft of land.

Now drop the sales rate by 10%. Net realisation falls by about ₹5 crore, but because the costs and required profit are unchanged, almost that entire fall lands on the residual. The land value falls by more than a third. Grid, not point estimate.

What to work out next

Frequently asked questions

What is residual land value?
It is what remains for the land once a scheme's net realisation has absorbed every cost of building and selling it and the profit the developer requires. It answers a different question from a comparable-sales valuation: not what similar land sold for, but what this scheme can afford to pay for this site.
Should profit be taken on cost or on value?
This calculator takes profit as a percentage of total cost including land, which is the more common Indian development convention and the more conservative of the two. Profit on GDV will produce a different — usually higher — residual for the same scheme, so never compare two appraisals without checking which basis each used.
Why is my residual land value negative?
Because at the rate, cost, finance and profit you entered, the scheme cannot pay anything for the land and still meet your profit requirement. A negative residual is a real answer, not an error: it usually means the sales rate assumption is optimistic, the cost is high for the product, or the profit requirement is above what the scheme supports.
How sensitive is the residual to the sales rate?
Extremely. Because land is the balancing figure, a small percentage change in revenue moves the residual by a much larger percentage. That gearing is why the sensitivity grid below matters more than the headline number, and why a single-point land value should never drive an acquisition decision.
Can I use this for a joint development instead of a purchase?
Use it first to establish what the site supports, then compare structures. The joint development calculator applies the same cost and revenue base to area-share and revenue-share terms so the implied land cost of each is directly comparable with this residual.

Take this from a calculator to a decision

A single-page calculator cannot phase a programme, model cash flow, compare structures on one base or freeze a report. DevPartner's deterministic engine does — with every assumption traced back to the value you entered.