Model Every Dollar.
From NOI to
Owner Cash Flow.
The CRELYTIC Waterfall Calculator maps every tier of cash allocation — from gross potential rent through debt service, reserves, and equity splits — with lockbox, cash trap, and LP/GP promote scenarios built in.
What Sets the Waterfall Calculator Apart
Five capabilities working together to replace your manual waterfall modeling workflow.
Standard Waterfall Mode
Map the full cash flow cascade from gross potential rent through effective gross income, operating expenses, debt service, reserves, and owner cash flow. Every tier is itemized and adjustable, giving you a transparent view of how each dollar flows from the top line to the bottom line — with real-time NOI and cash-on-cash calculations updating as you adjust assumptions.
Income, vacancy, OpEx, debt service, reserves, and owner distributions — each tier is a discrete, editable layer. Change one input and watch the entire waterfall recalculate instantly.
Lockbox & Cash Trap
Model DSCR-triggered cash retention scenarios where lender-controlled lockbox accounts intercept cash flow when coverage ratios fall below configurable thresholds. Set your DSCR trigger level, define trap release conditions, and see exactly how much cash gets diverted versus distributed under different operating scenarios.
Configure DSCR trigger thresholds (e.g., 1.25x) and trap release conditions. The calculator shows exactly when the trap activates and how much cash is retained versus distributed to the borrower under each scenario.
Equity Waterfall & Promotes
Structure LP/GP waterfalls with preferred returns, catch-up provisions, and multi-tier promote splits. Visualize how distributions flow through each tier — from LP preferred return through GP catch-up to promoted interest — with clear breakpoints showing exactly when each tier activates and how much each party receives.
Tier-by-tier visualization shows LP preferred returns, GP catch-up, and promote splits at each IRR hurdle. Adjust preferred return rates, promote percentages, and hurdle thresholds to model any partnership structure.
Reserve Tier Modeling
Model CapEx reserves, TI/LC allowances, tax escrow, and insurance deposits as distinct tiers within the waterfall. Each reserve category has its own funding schedule, balance tracking, and draw-down assumptions — so you can see how reserve requirements impact distributable cash flow and whether your budget allocations are sufficient for the hold period.
CapEx, TI/LC, tax escrow, and insurance reserves each get their own tier with configurable funding rates. See the cumulative impact of reserve deposits on owner distributions across your entire hold period.
Interactive Scenario Analysis
Toggle between interest-only and amortizing debt structures, adjust vacancy and rent growth assumptions, and compare multiple scenarios side by side. Every change propagates through the entire waterfall in real time, so you can stress-test a deal under different market conditions and immediately see the impact on cash flow, coverage ratios, and equity returns.
Switch between IO and amortizing with one click, slide vacancy from 3% to 15%, and watch DSCR, cash-on-cash, and owner distributions update instantly. Compare up to three scenarios simultaneously to bracket your deal economics.
See It In Action
Interactive preview with sample property data
Net Operating Income
$1.86M
EGI less OpEx
▲ 4.2% vs prior year
DSCR
1.42x
NOI / Debt Service
▲ 3.1% vs prior year
OpEx Ratio
38.2%
OpEx / EGI
▼ 1.5% vs prior year
Owner Cash Flow
$412K
After all obligations
▲ 6.8% vs prior year
Gross Potential Rent
Total scheduled rental income at full occupancy
$3,200,000
Less Vacancy
8% vacancy & credit loss allowance
-$256,000
Less Operating Expenses
Property taxes, insurance, management, maintenance, utilities
-$1,120,000
Less Debt Service
Annual mortgage payments (P&I) at 5.25% amortizing
-$824,000
Less CapEx Reserve
Capital expenditure reserve for major repairs & improvements
-$96,000
Less TI/LC Reserve
Tenant improvement & leasing commission escrow
-$72,000
Less Tax Escrow
Real estate tax escrow deposits
-$48,000
= Owner Cash Flow
Remaining cash available for distribution to equity holders
$412,000
Cash Flow Allocation
Percentage of Gross Potential Rent by category
Built for Every Seat at the Table
From acquisitions to lending — the Waterfall Calculator adapts to your role.
For Acquisitions Teams
You're evaluating a 200-unit multifamily deal and need to understand the cash flow waterfall before making an offer. The Waterfall Calculator lets you model gross potential rent, vacancy assumptions, operating expenses, debt service with IO toggle, and reserve deposits — all in one view. Within minutes, you have a clear picture of projected owner cash flow under conservative, base, and aggressive scenarios, so you can underwrite with confidence and set your bid accordingly.
For Fund Managers
Your fund has a two-tier promote structure with an 8% LP preferred return, GP catch-up, and a 20/80 split above a 12% IRR hurdle. Instead of building a custom Excel model for each deal, the Equity Waterfall mode lets you configure preferred returns, catch-up provisions, and promote tiers in seconds. Visualize exactly how distributions split between LPs and GPs at each hurdle — and present clean, investor-ready waterfall breakdowns to your capital partners.
For Lenders
You need to stress-test a borrower's DSCR under lockbox and cash trap conditions before approving a loan. The Lockbox mode lets you set DSCR trigger thresholds, model different vacancy and expense scenarios, and see exactly when the cash trap activates and how much cash is retained. Run three scenarios — base case, moderate stress, and severe downside — and export the results for your credit committee package.
For Asset Managers
You're managing a stabilized office asset and need to project owner distributions under different operating assumptions for the next 5 years. Adjust rent growth, vacancy, expense escalations, and reserve contributions to see how distributable cash flow changes year over year. Compare interest-only versus amortizing debt structures and identify the operating thresholds where coverage ratios start to tighten — before they become a problem.
Platform Capabilities
Frequently Asked Questions
Common questions about the CRELYTIC Waterfall Calculator and cash flow waterfall modeling.
What Is a Real Estate Waterfall Calculator?
A real estate waterfall calculator models the distribution of cash flows between partners in a commercial real estate investment. The term "waterfall" refers to how money flows downward through tiers of distribution — from senior debt obligations through preferred returns to promote splits between limited partners (LPs) and general partners (GPs).
In a typical CRE equity waterfall, cash distributions follow a priority structure: first, return of capital to LPs; second, a preferred return (commonly 8-10% IRR); third, a GP catch-up provision; and fourth, a promote split where the GP receives a disproportionate share of profits above certain return hurdles. Multi-tier waterfalls may include 3-4 hurdle rates with escalating promote percentages.
The CRELYTIC Waterfall Calculator supports three distinct modeling modes. Standard Waterfall maps the full flow from gross potential rent through vacancy, operating expenses, debt service, reserves, and owner distributions. Lockbox / Cash Trap mode models lender-controlled cash sweeps triggered by DSCR or LTV covenant breaches. Equity Waterfall mode focuses on LP/GP distribution mechanics with configurable preferred returns, catch-up provisions, and multi-tier promote structures.
Unlike downloadable Excel waterfall templates that require manual formula construction and are prone to circular reference errors, the CRELYTIC Waterfall Calculator runs entirely in your browser with real-time recalculation as you adjust assumptions. It is free to use with no signup required — try it above or visit crelytic.ai/waterfall-calculator.
Related Tools & Resources
- Real Estate Waterfall Model Guide — Understand equity distribution structures
- IRR Calculator — Model investment returns
- Cap Rate Calculator — Analyze property values
- NOI Calculator — Calculate Net Operating Income
Stop Building Waterfalls in Excel
Your deal team is spending hours building custom waterfall models for every acquisition, refi, and investor presentation. Every manual formula is a risk — one broken cell reference and your entire distribution analysis is wrong. CRELYTIC Waterfall Calculator gives you institutional-grade waterfall modeling with real-time scenario analysis built in.