Excel workbook · Catalog edition 2026
RIHousing ELI One-Bedroom Subsidy Projection
Rhode Island Housing (RIHousing)
Project the first-year, five-year and fifteen-year subsidy deficits for one-bedroom units with and without CES referrals using entered rent limits.
- Inputs
- 6
- Outputs
- 4
- File size
- 43 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 5 | Requested Number of Years of Assistance (1-15) | |||||
| 6 | ||||||
| 7 | Section: | Bedroom Type: | Number of Units | 30% Rent Limit for this bedroom size | 50% Rent Limit for this bedroom size | 60% Rent Limit for this bedroom size |
| 8 | A. Units with Coordinated Entry System Referral: | 0 Bedroom Units with CES referral | ||||
| 9 | 1 Bedroom Units with CES referral | |||||
| 16 | 1 Bedroom Units | |||||
| 23 | Total Number of Units Requested | 0 | ||||
| 24 | Total Projected 15 Year Deficit: | $0 |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
Publication date unknown. URL upload path 2026/01 and source filename explicitly for 2025 RFP; no publisher edition date inferred.
Fixed first-year, 5-year and 15-year horizons; requested-years selector is outside this flow. One-bedroom units only, with and without CES referrals; all other bedrooms retain blank source defaults. Supply current location-appropriate rent limits; no rent-limit lookup or eligibility certification. Source uploaded under 2026/01, filename says 2025 RFP; edition 2026 identifies that handbook artifact, not an asserted publisher edition or publication date. No RIHousing endorsement.
What it computes
Ports for the compact flow: quick_one_bedroom_projection. The full port contract includes all 10 ports.
Inputs (6)
| Port / description | Type / constraints / default |
|---|---|
ces_unitsCount of one-bedroom units with Coordinated Entry System referrals, nonnegative integer. Other bedroom sizes remain publisher blank. | Type: integer Constraints: min: 0 Default: 0 |
ces_rent_30USD per unit per month: current local 30% AMI rent limit for CES one-bedroom units, nonnegative. Supply with ces_units and ces_rent_60. | Type: number Constraints: min: 0 Default: 0 |
ces_rent_60USD per unit per month: current local 60% AMI rent limit for CES one-bedroom units, nonnegative. Supply with ces_units and ces_rent_30. | Type: number Constraints: min: 0 Default: 0 |
nonces_unitsCount of one-bedroom units without CES referrals, nonnegative integer. Other bedroom sizes remain publisher blank. | Type: integer Constraints: min: 0 Default: 0 |
nonces_rent_30USD per unit per month: current local 30% AMI rent limit for non-CES one-bedroom units, nonnegative. Supply with nonces_units and nonces_rent_50. | Type: number Constraints: min: 0 Default: 0 |
nonces_rent_50USD per unit per month: current local 50% AMI rent limit for non-CES one-bedroom units, nonnegative. Supply with nonces_units and nonces_rent_30. | Type: number Constraints: min: 0 Default: 0 |
Outputs (4)
| Port / description | Type / constraints / default |
|---|---|
total_unitsCount of requested one-bedroom units; all other bedroom rows remain blank. | Type: number |
deficit_year1USD first-year rent deficit, positive when higher AMI rents exceed 30% rents. | Type: number |
deficit_5_yearsUSD cumulative nominal rent deficit over 5 years, 3% annual escalation after year 1, no discounting. | Type: number |
deficit_15_yearsUSD cumulative nominal rent deficit over 15 years, 3% annual escalation after year 1, no discounting. | Type: number |
Questions this workbook answers
- How much ELI subsidy covers my one-bedroom rent deficit in Rhode Island?
- Compare CES and non-CES ELI rent gaps over fixed assistance horizons
- Project cumulative RIHousing ELI one-bedroom rent deficits
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: ri-eli-subsidy-projection · Edition: 2026
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "ri-eli-subsidy-projection",
"edition": "2026",
"flow": "quick_one_bedroom_projection",
"inputs": {
"ces_units": 8,
"ces_rent_30": 600,
"ces_rent_60": 1200,
"nonces_units": 4,
"nonces_rent_30": 600,
"nonces_rent_50": 1000
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_one_bedroom_projection
One-bedroom ELI subsidy projection
All inputs contribute to the projected deficit in populated scenarios. Higher AMI limits should be at least the corresponding 30% limits; reversed rents yield signed negative gaps, not a funding recommendation.
6 input ports · 4 output ports. Full membership in the port contract.
REST example
Bundle scenario: mixed_12_units · Flow: quick_one_bedroom_projection
curl 'https://catalog.formualizer.com/v1/models/ri-eli-subsidy-projection/2026/evaluate?flow=quick_one_bedroom_projection' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"ces_units":8,"ces_rent_30":600,"ces_rent_60":1200,"nonces_units":4,"nonces_rent_30":600,"nonces_rent_50":1000}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"total_units": 12,
"deficit_year1": 76800,
"deficit_5_years": 407741.63020799996,
"deficit_15_years": 1428396.5864979574
}
}Looking for another spreadsheet? Request a workbook.