formualizer

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.

Request SummaryA5:F25

Saved workbook valuesInputOutput

RowABCDEF
5Requested Number of Years of Assistance (1-15)
6
7Section: Bedroom Type: Number of Units30% Rent Limit for this bedroom size50% Rent Limit for this bedroom size60% Rent Limit for this bedroom size
8A. Units with Coordinated Entry System Referral: 0 Bedroom Units with CES referral
91 Bedroom Units with CES referral
161 Bedroom Units
23Total Number of Units Requested0
24Total 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 / descriptionType / constraints / default
    ces_units

    Count 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_30

    USD 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_60

    USD 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_units

    Count of one-bedroom units without CES referrals, nonnegative integer. Other bedroom sizes remain publisher blank.

    Type: integer

    Constraints: min: 0

    Default: 0

    nonces_rent_30

    USD 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_50

    USD 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 / descriptionType / constraints / default
    total_units

    Count of requested one-bedroom units; all other bedroom rows remain blank.

    Type: number

    deficit_year1

    USD first-year rent deficit, positive when higher AMI rents exceed 30% rents.

    Type: number

    deficit_5_years

    USD cumulative nominal rent deficit over 5 years, 3% annual escalation after year 1, no discounting.

    Type: number

    deficit_15_years

    USD 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/mcp

    Slug: 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.