What Is NPV in Housing Development?
Net present value (NPV) is one of the main measures housing associations use to appraise a development scheme. In a housing association appraisal it compares the present value of a scheme's future net rent with the finance the scheme needs, to show whether the rent can repay the borrowing (National Housing Federation, Understanding Development Appraisal, 2015).
This guide explains how NPV is calculated, how the discount rate and appraisal period affect it, and how housing associations use it, drawing on that guide unless another source is given.
How NPV is calculated
Present value
Present value (PV) is compound interest in reverse. The NHF guide's example: £200 received at the end of Year 10, discounted at 6%, has a present value of £111.68, because £200 ÷ 1.06¹⁰ = £111.68. In general, PV = C ÷ (1 + i)ⁿ, where C is the future amount, i the discount rate and n the number of periods (NHF, 2015).
Present value of the net rent
A scheme receives net rent every year rather than a single sum, so the PV of each year's net rent is calculated and the results are added together. The total represents the amount of borrowing the scheme could pay back from net rent over the discount period (NHF, 2015).
NPV
NPV = PV of net rent − finance required
In a standard development appraisal the finance required is not discounted, because the date it is calculated is treated as the present, Year 0. It includes development interest (NHF, 2015).
The NHF guide gives three outcomes:
|
PV of net rent |
Finance required |
NPV |
Meaning |
|---|---|---|---|
|
£1,000,000 |
£800,000 |
£200,000 surplus |
The scheme could absorb cost overruns or generate surplus income to support other schemes' borrowing |
|
£500,000 |
£800,000 |
−£300,000 deficit |
The scheme needs further subsidy, or income from other sources, to service the loan |
|
£800,000 |
£800,000 |
£0 |
The scheme neither needs nor gives subsidy |
An NPV of zero is also the starting point for calculating residual land value for rented homes. The guide stresses that an NPV surplus is not cash or profit: it is a calculation of the loan repayment capability of projected cash flows built on many assumptions (NHF, 2015).
The discount rate and the discount period
The discount rate
The NHF guide explains discounting in terms of opportunity: money available today could be deposited at a known rate of interest, so alternative uses of cash are compared against known returns. Inflation is not automatically part of a PV calculation. A housing association would never use a discount rate as low as the rate of inflation, even for a scheme funded entirely from cash reserves, because discount rates always include a degree of risk premium (NHF, 2015).
The discount period
There is no single correct appraisal period. The guide's benchmarking data shows wide variation, with a median of 40 years. The effect of a higher or lower discount rate grows with the length of the period, and lengthening the period while keeping other assumptions unchanged makes every appraisal look better (NHF, 2015).
The guide illustrates how the combination of period, discount rate and NPV hurdle affects an organisation's competitiveness for land and its risk:
|
Discount period |
100 years |
100 years |
100 years |
30 years |
30 years |
30 years |
|---|---|---|---|---|---|---|
|
Discount rate |
6% |
8% |
10% |
4% |
5% |
6% |
|
NPV surplus hurdle |
£10k a home |
£20k a home |
£100k a home |
£0 |
£2k a home |
£10k a home |
|
Competitive land bidding |
High |
Medium |
Low |
High |
Medium |
Low |
|
Risk to organisation |
High |
Medium |
Low |
High |
Medium |
Low |
Using NPV in decisions
Hurdles
Many organisations require every scheme to show an NPV surplus, whatever its tenure. No organisation appraises schemes aiming for an NPV deficit, unless it is appraising another landlord's stock with a view to acquiring it, but many accept that some schemes need subsidy (NHF, 2015).
NPV per unit
NPV per unit is the NPV surplus divided by the number of homes, and is likely to be used by organisations that do not compare schemes on IRR. Where NPV is negative, the negative NPV per unit shows the subsidy each home needs, which forms a common appraisal hurdle for rented schemes (NHF, 2015).
NPV and IRR
The internal rate of return (IRR) is the discount rate at which the NPV surplus is zero. A scheme with an NPV surplus at the organisation's discount rate has an IRR above that rate, and IRR is commonly used to show how much buffer a scheme has against uncertain projections and to compare schemes (NHF, 2015).
Mixed-tenure schemes
Where different tenures are appraised at different discount rates, the NHF guide suggests organisations consider requiring each tenure to pass its own IRR hurdle (NHF, 2015). Homes England also assesses each tenure in a mixed-tenure development separately, with no cross-subsidy assumed, when deciding grant (Capital Funding Guide, chapter 6).
Calculating NPV in ProVal
ProVal Vantage, SDS's development appraisal software, reports NPV, IRR and payback, with sensitivity analysis, and appraises multiple tenures in a single appraisal (G-Cloud 14 listing). It projects cashflow up to 100 years ahead and produces consistent, board-ready outputs for governance sign-off (SDS).