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
| Input | Value |
|---|---|
| Affordable units | 20 |
| Cost per affordable unit | 150,000 |
| Net proceeds per affordable unit | 110,000 |
| Dedicated grant total | 200,000 |
| Market-rate units | 60 |
| Result | Value |
|---|---|
| Required cross-subsidy per market unit | 10,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Affordable units | 20 | 22 | Required cross-subsidy per market unit | 10,000 | 11,333.333333 |
| Cost per affordable unit | 150,000 | 165,000 | Required cross-subsidy per market unit | 10,000 | 15,000 |
| Net proceeds per affordable unit | 110,000 | 121,000 | Required cross-subsidy per market unit | 10,000 | 6,333.333333 |
| Dedicated grant total | 200,000 | 220,000 | Required cross-subsidy per market unit | 10,000 | 9,666.666667 |
| Market-rate units | 60 | 66 | Required cross-subsidy per market unit | 10,000 | 9,090.909091 |
