Affordable housing cross-subsidy per market unit · Calculation guide

Allocate the affordable units’ net funding shortfall after dedicated grants equally across market-rate units.

Calculation guide

Use costs and net proceeds per affordable unit.

Required cross-subsidy per market unit = (max(0, ((Affordable units × (Cost per affordable unit − Net proceeds per affordable unit)) − Dedicated grant total)) ÷ Market-rate units)

Inputs

Affordable units

Example entry 20. Allowed range 0 to 10000. Use whole numbers.

Cost per affordable unit

Example entry 150000 (in the selected currency).

Net proceeds per affordable unit

Example entry 110000 (in the selected currency).

Dedicated grant total

Example entry 200000 (in the selected currency).

Market-rate units

Example entry 60. Allowed range 1.0 to 10000000.0. Use whole numbers.

Worked example

InputValue
Affordable units20
Cost per affordable unit150,000
Net proceeds per affordable unit110,000
Dedicated grant total200,000
Market-rate units60
ResultValue
Required cross-subsidy per market unit10,000

Calculation steps

Required cross-subsidy per market unit = (max(0, ((Affordable units × (Cost per affordable unit − Net proceeds per affordable unit)) − Dedicated grant total)) ÷ Market-rate units)

(max(0, ((20 × (150,000 − 110,000)) − 200,000)) ÷ 60) = 10,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Affordable units2022Required cross-subsidy per market unit10,00011,333.333333
Cost per affordable unit150,000165,000Required cross-subsidy per market unit10,00015,000
Net proceeds per affordable unit110,000121,000Required cross-subsidy per market unit10,0006,333.333333
Dedicated grant total200,000220,000Required cross-subsidy per market unit10,0009,666.666667
Market-rate units6066Required cross-subsidy per market unit10,0009,090.909091
Affordable housing cross-subsidy per market unit →

Sources