A practitioner tool for 4% LIHTC affordable-housing deals. Budget with basis tracking, sources, sizing, 20-year projections, and the full LP/GP waterfall — all balanced live. Plus access to the full HousingLabs360 resource library.
We just sent a confirmation email. Click the link inside, and the tool link is yours.
From project setup through LP/GP waterfall, every piece of a 4% LIHTC feasibility analysis — connected, balanced, and recalculating live. Load the housing example to see the whole flow in one click.
Per-bedroom AMI tables, utility allowances, unit-level Section 8 PBV contracts. Line-item development budget with basis-eligibility flags feeding the 4% credit calc.
Pricing, QCT/DDA boost, applicable fraction, federal grant basis reduction. Built for the post-OBBBA 25% threshold. Equity pay-in schedule by milestone.
Two stacks, soft loans with custom waterfall treatment, sponsor-priority loans, and dev fee tranches by milestone — milestone triggers feed construction draws.
Two closed-form estimates plus a full cash-flow scenario simulating monthly draws against an editable S-curve. Peak balance becomes the construction loan; total interest auto-populates the budget.
EGI auto-calculated from rent roll (with manual override). Operating expenses with required above-the-line items. Perm loan sized by target DSCR — flows back to Sources.
Line-by-line escalators (overridable). DSCR trajectory with 1.00 floor flags. Waterfall with DDF priority modes, sponsor-priority loans, and per-loan public lender splits.
Pass/warn/fail verdict with detail. Red flag panel surfacing deal-killers (gap, DSCR < 1.0, unpaid DDF). Visual capital stack, ratio benchmarks, AMI tier breakdown.
Everything auto-saves to your browser. Export the whole deal as JSON for backup or sharing. Load the housing example in one click to see a worked deal before building your own.
It's a working screening model, not a substitute for your deal-specific underwriting. The math is built on decades of practitioner experience and current LIHTC rules — but every output should be validated against your own pro forma before you rely on it for an LOI, an investment decision, or a lender submission.
If you find a bug or have feedback, email me directly. This tool gets better when practitioners push back on it.
Confirm your email. Get instant access to the tool and the full HousingLabs360 resource library. Load the housing example to see the whole flow, then build your own.
We just sent a confirmation email. Click the link inside, and the tool link is yours.