Finance & Funding 08 min read

Calculating Scheme-Level IRR in Social Housing

Internal rate of return (IRR) is one of several measures housing associations use to judge a development scheme. The National Housing Federation's guide to development appraisal lists the common measures as cost/value per cent, net yield, interest cover, first-year subsidy, break-even year, peak debt, payback, net present value (NPV) and IRR. NPV and IRR are "discounted" measures: they translate the net rent over the forecast period back to values at completion (National Housing Federation, Understanding Development Appraisal, 2015).

 

This guide explains what IRR measures, how it relates to NPV and the discount rate, and how housing associations use it, drawing on that guide unless another source is given.

NPV, the discount rate and IRR

NPV

In a housing association appraisal, the NPV compares the present value of a scheme's net rent over the discount period with the finance the scheme requires. Where the present value of net rent exceeds the finance required, the result is an NPV surplus; where it is lower, an NPV deficit, which indicates the scheme needs further subsidy or income from elsewhere to service its loan. Many organisations require every project to show an NPV surplus, whatever its tenure (NHF, 2015).

The discount rate

The discount rate is the rate used to calculate present value and NPV. The NHF guide notes that a housing association would never use a discount rate as low as the rate of inflation, because discount rates always include a degree of risk premium (NHF, 2015).

IRR

The IRR is the discount rate at which the NPV surplus is zero: at that rate, the amount the scheme can afford to repay exactly equals the amount it needs to borrow. If a scheme shows an NPV surplus at the organisation's discount rate, its IRR will be higher than that discount rate (NHF, 2015).

 

The NHF guide's worked example shows a scheme needing £1,400 of finance with rising net rent over 10 years. The NPV surplus falls as the discount rate rises, from £328 at 3% to £74 at 6%, and reaches zero at about 7.01%, which is the scheme's IRR.

 

A 2025 report on Social Rent viability makes the same point from the other direction: housing association appraisals use a discounted cash flow to calculate NPV, and because they tend to require an NPV of £1 or zero, the test is very close to the definition of IRR (Making Social Rent Homes Viable, 2025).

How housing associations use IRR

As a risk buffer and for comparison

An organisation could appraise schemes at a discount rate close to its average cost of borrowing and then require a minimum IRR, which amounts to the same test. The NHF guide says that is unusual: IRR is more commonly used to show how much of a buffer a scheme has against uncertain projections, and to compare schemes (NHF, 2015).

 

The guide's example compares three schemes that all show an NPV surplus at a 6% discount rate:

Scheme

NPV surplus

IRR

A

£100,000

8%

B

£500,000

7%

C

£1,000,000

6.1%

Scheme C has the largest surplus, but a small rise in the discount rate would remove it. With limited funding, the guide concludes that A and B would be the better choices (NHF, 2015).

Alongside NPV per unit

Organisations that do not compare schemes on IRR are likely to use NPV per unit, the NPV surplus divided by the number of homes. 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).

Appraisal period

Housing association NPV and IRR are calculated from net rent across a long-term forecast. The NHF guide finds no single answer on how long the period should be: its benchmarking data shows wide variation, with a median of 40 years. Lengthening the period while leaving the discount rate unchanged makes every appraisal look better (NHF, 2015).

Mixed-tenure schemes

Where different tenures are appraised at different discount rates, the 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).

Sensitivity

NPV and IRR depend on their assumptions. The NHF guide shows that the effect of a higher or lower discount rate is greater the longer the appraisal period, and its three-scheme example shows how a scheme with a large NPV surplus but an IRR only just above the discount rate has little margin for error (NHF, 2015).

 

At organisation level, the Regulator of Social Housing's Governance and Financial Viability Standard requires private registered providers to carry out detailed and robust stress testing against identified risks and combinations of risks across a range of scenarios (Governance and Financial Viability Standard).

Calculating IRR 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 (SDS).