Finance & Funding 07 min read

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).