“Our revenue depends on a housing market we can’t control. We’re grateful to CCA and its partners for giving us a clear forecast and real options, so we can plan ahead and keep investing in affordable housing for the Chicagoans who need it most.”
Summary
Clients: Chicago Low-Income Housing Trust Fund (CLIHTF) and the Chicago Department of Housing (DOH)
Partners: JLL, Mesirow, and SNtial
Project: A revenue-modeling engagement to help the Chicago Low-Income Housing Trust Fund forecast its two main revenue streams and identify new funding options amid a volatile housing market.
Outcome: Three-year revenue forecasts for the Trust Fund’s recording-fee and in-lieu-fee income, a reusable model and development pipeline database, and an assessment of new revenue options. Grounded in years of audited financials, City development data, peer research, and developer interviews, it gives the Trust Fund a realistic view of the revenue to expect and how to plan for volatility.
Opportunity
The Chicago Low-Income Housing Trust Fund, is a critical part of the affordable housing ecosystem. As the nation's largest city- and state-funded rental subsidy program, the Trust Fund pays landlords to cover the gap between market rent and what Chicago's lowest-income households can afford. Subsidies are tied to specific units rather than individual tenants, keeping those apartments affordable over time for households earning 30% or less of the area median income (AMI). As of its latest 2026 report, the Trust Fund subsidizes 2,428 units, more than half of which serve households earning 15% of AMI or less.
The program’s funding comes from two increasingly volatile sources: recording fees collected through the state's Rental Housing Support Program (RHSP) whenever a real estate document, such as a deed or mortgage, is filed with the county; and in-lieu fees paid by developers under the City’s Affordable Requirements Ordinance (ARO) to avoid including affordable units in their projects.
When 30-year mortgage rates jumped from 2.7% in 2021 to 7.8% in 2023, home sales and refinancing slowed, fewer documents were recorded, and the Trust Fund’s share of RHSP revenue fell from $15.6 million to $4.6 million in a single year. ARO in-lieu fees, which consistently topped $10 million a year from 2015 to 2020, have dropped as multifamily construction slowed. With expenses rising steadily, the Trust Fund needed a clear forecast and new options to stabilize its funding.
Action
CCA built a revenue model and explored new funding sources with support from a Mesirow fellow embedded on the team and targeted expertise from JLL and SNtial.
Analyze: The team reviewed the Trust Fund’s audited financials, state RHSP data, and mortgage and construction trends, and interviewed developers and real estate specialists, with JLL's market experts helping the team understand what drives each revenue stream.
Model: Drawing on the Mesirow fellow's financial expertise and JLL's market-based assumptions, the team built three-year forecasts for both revenue streams under growth, steady, and decline scenarios, compiling a pipeline database from DOH, Committee on Zoning, and Chicago Plan Commission records to estimate when developments would pay in-lieu fees.
Explore: The team assessed new revenue options, including a nominee recording fee modeled on Connecticut’s, with SNtial scoping the software needed to put it in place, and various other revenue options, including interest on real estate escrow accounts, tax revenue from former city property, and proceeds from the sale of city-owned property.
“A stable, affordable home is the foundation for so much else in a person’s life. We’re honored to work with CCA to assist those that help put affordable housing within reach for every Chicagoan.”
“For 25 years, SNtial has been committed to applying technology, data, and innovation to challenges that matter. Supporting this project was a natural fit with our mission to use our technical expertise in ways that create lasting community impact. We are proud to have contributed to an effort that helps protect and expand access to affordable housing for Chicago families.”
Impact
A more stable Trust Fund helps protect affordable homes for the Chicagoans who rely on them. The Trust Fund now has a clear-eyed view of its finances: recording-fee revenue should hold steady at $7 million to $8 million a year, in-lieu fees will likely swing between $1 million and $8 million and depend on a handful of large developments, and without new revenue, net assets could fall to post-pandemic lows by 2028.
The model and pipeline database give the Trust Fund and DOH a single source of truth they can update as projects move forward, and the revenue analysis gives leaders the evidence to pursue reforms, like a nominee recording fee that could add at least $10 million in annual revenue.
“CCA’s well-researched, deeply meticulous revenue model and consideration of alternative revenue strategies provided actionable insights for me – a new Executive Director – to hit the ground running his year when I joined CLIHTF. The CCA team answered questions I brought with me as a new leader, saving us time and money at a time when we are watching every penny. What’s more, CCA’s work laid the groundwork for productive conversations with our funders and stakeholders, helping us move toward sustainability. Many, many thanks to CCA!”