METHODOLOGY · FINANCIAL PROJECTIONS

    Financial projections and DSCR methodology.

    The analytical discipline that answers the project-level financial question — will this specific project carry debt service, satisfy lender thresholds, and produce equity returns appropriate to the capital structure. This page covers the practice's revenue projection methodology by asset class, operating expense benchmarking sources, NOI build and stabilization timeline modeling, DSCR thresholds across seven capital sources, debt yield methodology, three-tier sensitivity analysis, Monte Carlo simulation framework, and equity returns analysis for institutional capital.

    RMA Annual Statement Studies · IBISWorld industry data · IREM Income/Expense Analysis · 2026 lender threshold bands · Monte Carlo statistical methodology · 2,000 words

    THE DISCIPLINE

    What financial projections answer, and how rigor is measured.

    Financial projections answer the project-level question — will this specific project carry debt service, satisfy lender thresholds, and produce equity returns appropriate to the capital structure. The analytical work runs from revenue projection (asset-class-specific methodology), through operating expense benchmarking (industry data sources), to NOI build and stabilization, to debt service coverage testing against lender thresholds, to sensitivity analysis under multiple scenarios. Financial projections sit downstream of market analysis and upstream of the conclusion-of-feasibility statement.

    Financial modeling rigor is measured along three dimensions. First, revenue methodology — does the projection use asset-class-appropriate metrics (RevPAR for hotels, capture rate for car washes, GPD for fuel, occupancy and unit-mix-blended rent for multifamily) with documented data sources? Second, expense benchmarking — does the projection cite RMA Annual Statement Studies, IBISWorld, IREM Income/Expense Analysis, or asset-class-specific industry data sources, and does the benchmarking address operating ratios at the line-item level rather than aggregate? Third, sensitivity discipline — does the projection test downside, base, and upside scenarios with explicit assumption documentation, and does the methodology address rate sensitivity, occupancy sensitivity, and revenue sensitivity separately?

    The bankable framework's financial projections methodology benchmarks operating ratios to RMA Annual Statement Studies for the broad commercial real estate landscape, IBISWorld for industry-specific operating economics, IREM Income/Expense Analysis for multifamily and commercial property operations, and asset-class-specific specialty data (Smith Travel Research for hotels, Self-Storage Almanac for self-storage, NIC MAP for senior housing, others) to ensure NOI is defensible against lender scrutiny. The methodology output is a five-year forward pro forma at line-item level with sensitivity analysis at three tiers and DSCR/debt yield testing against the specific lender's threshold.

    REVENUE PROJECTION

    Revenue projection methodology by asset class.

    Each asset class has a primary revenue metric that drives the projection. Using asset-class-appropriate methodology rather than generic occupancy-times-rent calculation distinguishes lender-grade financial modeling from spreadsheet approximation.

    Hotel

    PRIMARY METRIC
    RevPAR (Revenue Per Available Room)

    ADR × occupancy = RevPAR. STR Global data anchors competitive set RevPAR. Demand source segmentation (commercial transient, group, leisure, government, SMERF) drives the room mix and rate position. Year-over-year RevPAR growth assumption documented explicitly.

    Multifamily

    PRIMARY METRIC
    Effective rent × occupancy

    Unit-mix-blended rent at the bedroom level, occupancy at the property level, vacancy and concession losses modeled separately. NCHMA-aligned methodology for affordable and LIHTC at the AMI band. Other income (parking, pet, storage) modeled at unit-mix multipliers.

    Self-storage

    PRIMARY METRIC
    Effective rent × occupancy by unit type

    Climate-controlled and drive-up rent bands, occupancy by unit type, tenant churn and rent roll repositioning during lease-up. Tenant insurance attachment, late fee revenue, and ancillary revenue modeled at industry standard multipliers.

    Senior housing

    PRIMARY METRIC
    Census × care-level rate

    Census (occupied units) × monthly rate by care level (independent, assisted, memory care, skilled). Care-level mix evolution over time as resident acuity progresses. Move-in fees, level-of-care upcharges, and ancillary revenue modeled separately.

    Gas station / C-store

    PRIMARY METRIC
    GPD × fuel margin + C-store sales

    Gallons per day × fuel margin = fuel gross profit. C-store sales × C-store margin = inside gross profit. Foodservice revenue modeled at industry-specific multipliers. Traffic count, demographic catchment, and competitor analysis drive GPD assumption.

    Car wash

    PRIMARY METRIC
    Vehicles × ticket × capture rate

    Catchment population × wash propensity × capture rate × ticket = revenue. Express tunnel volume modeling, membership program economics, and capture rate from competitive analysis. Industry data from ICA (International Carwash Association) and ISSA.

    The asset classes shown above represent typical revenue methodology — the practice handles 15+ asset classes with similar discipline. Industrial revenue methodology runs through tenant credit, lease structure, and effective gross income modeling. Medical office revenue runs through tenant rollover, hospital affiliation, and procedure mix for ASCs. Data center revenue runs through power-density-driven rent and tenant credit profile. Each asset class has a primary revenue metric that drives the projection; using the right metric is the discipline that distinguishes lender-grade modeling from generic occupancy-times-rent approximation.

    OPERATING EXPENSE BENCHMARKING

    Operating expense benchmarking sources.

    Operating expense benchmarking is the analytical discipline that ties projected expenses to industry data rather than to sponsor estimates. Lender-grade financial modeling cites operating ratio benchmarks at the line-item level — labor as percentage of revenue, utilities as percentage of revenue, repairs and maintenance per square foot, insurance per door, property taxes per assessed valuation. Each line item has industry data that establishes the typical range; projections that fall outside the typical range require explicit assumption documentation.

    RMA Annual Statement Studies provides the broadest industry benchmark coverage across commercial real estate operating economics. RMA data segments by asset class, deal size, and operating context with quartile distributions for each line item. The bankable framework's pro formas cite RMA quartile position for each major line item — top quartile expense ratio (efficient operator), median (typical), bottom quartile (high-cost operator). Lenders evaluate where the projection lands against the distribution and whether the assumption is defensible given the deal characteristics.

    IBISWorld industry data complements RMA with industry-specific operating economics for non-real-estate businesses that occupy commercial real estate (hotels, restaurants, gas stations, car washes, daycares, breweries, others). IBISWorld covers labor cost ratios, food cost ratios, supply cost ratios, and operating margins at the industry level. The bankable framework's special-purpose property pro formas cite IBISWorld for industry-specific operating ratios and RMA for property-level overhead ratios, integrated into a single pro forma structure.

    IREM Income/Expense Analysis covers multifamily and commercial property operations with detailed line-item benchmarking by submarket, age, and asset class. IREM data is particularly valuable for multifamily and office benchmarking because it reflects actual operator-reported data rather than industry estimates. Asset-class-specific specialty data (Smith Travel Research for hotels, Self-Storage Almanac for self-storage, NIC MAP for senior housing, IRR for medical office, others) supplements the broader industry sources for asset-class-specific operating economics. The bankable framework cites all four source categories explicitly in deliverable line-item benchmarking sections.

    View the data sources and subscriptions in the market analysis methodology →

    NOI BUILD AND STABILIZATION

    NOI build and stabilization timeline modeling.

    NOI build refers to the analytical work of constructing net operating income from revenue and expense components rather than projecting NOI directly as a percentage of revenue. The discipline matters because aggregate NOI assumptions hide line-item risk — a projection that NOI grows 4 percent annually doesn't reveal whether the growth comes from revenue expansion, expense compression, or both. Line-item NOI build surfaces the underlying assumptions and lets lenders evaluate them individually.

    Stabilization timeline modeling addresses lease-up, ramp-up, and trailing-twelve-month (TTM) operating performance for non-stabilized assets. Construction projects build through lease-up to stabilization (typically 12–36 months depending on asset class and submarket). Acquisition with reposition projects model the partial lease-up from acquisition occupancy to stabilized occupancy. Value-add projects model the rent roll repositioning from in-place rents to market rents. Stabilization timing affects DSCR throughout the lease-up period — pre-stabilization DSCR is often below 1.0x, requiring interest reserves, sponsor guarantees, or interest-only debt structure during lease-up.

    The bankable framework's stabilization methodology models month-by-month occupancy ramp during lease-up, with absorption tied explicitly to the market analysis methodology's absorption forecasting. NOI build during lease-up reflects pro-rata occupancy at each month; expense modeling reflects the ramp to stabilized operating expenses (which are often higher than ramp-up expenses because some expense categories scale with occupancy). The output is a month-by-month pro forma that clarifies when the deal achieves stabilized DSCR and what coverage looks like during the pre-stabilization period.

    For SBA 504 hotel construction projects, USDA B&I rural multifamily lease-up, HUD 221(d)(4) construction, and CMBS forward commitment structures, the stabilization methodology drives material analytical work beyond stabilized DSCR testing. The bankable framework's pro forma reflects pre-stabilization, stabilization, and post-stabilization performance separately to give lenders the analytical visibility they require.

    DSCR THRESHOLDS

    DSCR thresholds across seven capital sources.

    Each capital source applies a different minimum DSCR threshold. The methodology output tests the projection against the specific lender's threshold (or the most demanding lender if multiple are at the table). Below: the canonical threshold reference for 2026 underwriting.

    Capital sourceDSCR thresholdRegulatory or industry sourceNotes
    SBA 7(a) and 5041.15–1.25xSBA SOP 50 10 8 (June 1, 2025)Stabilized projection; debt yield not required
    USDA B&I and CF1.0–1.25x7 CFR Part 5001 (December 11, 2025)5-component framework prescribes financial feasibility
    Conventional bank (general)1.20–1.40xOCC/FDIC examiner postureBank discretion; specialty asset 1.30x+
    CMBS conduit1.25–1.40xKBRA Property Eval Methodology (Jan 9, 2026)Plus 8–10% debt yield as second filter
    CMBS SASB1.15–1.30xRating agency SASB methodologyPlus 7–9% debt yield; trophy asset accommodation
    Life-co (PGIM, MetLife, Northwestern, Principal)1.30–1.50xIndividual life-co credit committeePlus 8–10% debt yield; 25–30 year hold
    Fannie DUS (market-rate)1.25–1.30xDUS Form 4165 (August 2024)1.20x for affordable; debt yield not formal threshold
    Freddie Optigo1.25–1.30xOptigo Underwriting Manual1.20x for TAH; debt yield not formal threshold
    HUD 221(d)(4) Construction1.176x (fixed)HUD MAP Guide March 2021Fixed regulatory formula
    HUD 223(f) Refinance1.176x (fixed)HUD MAP Guide March 2021Fixed regulatory formula
    HUD 232 LEAN (skilled nursing)1.45xHUD Office of Healthcare ProgramsOperational volatility premium
    Debt fund / bridge1.10–1.25xIndividual debt fund credit committeePlus 7–10% debt yield; transitional credit

    DSCR threshold variation across capital sources reflects underlying credit risk pricing. Hold-period determines cushion — CMBS conduit at 1.20–1.35x prices for short-hold securitization with rated pool risk absorption; life-co at 1.30–1.50x prices for 25–30 year hold with individual deal risk on balance sheet. Asset class affects threshold — HUD 232 LEAN's 1.45x for skilled nursing reflects operational volatility versus HUD 223(f)'s 1.176x for stabilized multifamily. The bankable framework's methodology output tests the projection against the specific lender's threshold; cross-program scope tests against all relevant lenders simultaneously.

    Run the DSCR and Debt Yield Calculator →·Read the lender requirements matrix →

    DEBT YIELD METHODOLOGY

    Debt yield — the post-2008 second filter.

    Debt yield is the ratio of annual NOI to loan amount, expressed as a percentage. A debt yield of 10 percent means NOI equals 10 percent of loan principal — equivalently, if the property operated at break-even with no debt service, NOI would pay down 10 percent of principal annually. Debt yield is rate-and-amortization-independent, which is what makes it useful as a stress test against falling cap rates and rising rates.

    CMBS lenders added debt yield as a structural underwriting filter post-2008 because pre-crisis CMBS underwriting relied primarily on DSCR. Aggressive interest-only structures and compressed cap rates allowed deals to clear DSCR thresholds with NOI levels that turned out to be unsustainable when cap rates expanded. Debt yield doesn't move when rate or amortization changes — it isolates property cash flow contribution to loan principal. The post-2008 regulatory consensus elevated debt yield to a hard threshold alongside DSCR, particularly in CMBS conduit and life-co underwriting.

    Typical debt yield thresholds in 2026: CMBS conduit 8–10 percent, CMBS SASB 7–9 percent (lower because trophy assets carry institutional cap rate compression that supports tighter debt yield), life-co 8–10 percent, debt fund 7–10 percent on transitional product. SBA, USDA, conventional bank, and HUD do not formally apply debt yield as a threshold — their DSCR-only structure reflects either guarantee-backed risk transfer (SBA, USDA, HUD) or relationship-driven flexibility (conventional bank).

    For deals approaching CMBS conduit, CMBS SASB, or life-co financing, debt yield is often the binding constraint rather than DSCR. A deal with strong NOI and conservative loan amount may pass DSCR easily but fail debt yield because the loan amount is too high relative to NOI. The bankable framework's methodology tests both filters simultaneously — pass-on-both is required for these capital sources, and failed debt yield with passing DSCR triggers loan amount reduction or capital structure restructuring as the analytical recommendation.

    SENSITIVITY ANALYSIS

    Three-tier sensitivity framework.

    Sensitivity analysis tests the projection's resilience to assumption variance across three tiers — downside (adverse scenario), base (most likely outcome), upside (favorable scenario). The discipline matters because point projections hide assumption risk; a deal that passes DSCR at base case but fails at downside is fragile against operating volatility, while a deal that passes at downside is structurally robust. Lenders evaluate both base case and downside coverage explicitly.

    The bankable framework's downside scenario reflects asset-class-specific volatility patterns. Hospitality and senior housing carry high operating volatility — RevPAR variance of ±15 percent and census variance of ±10 percent are typical downside parameters. Industrial and credit-tenant net lease carry low volatility — NOI variance of ±5 percent reflects investment-grade tenant lease structure. Multifamily, retail, and office sit in the middle. The downside scenario tests DSCR, debt yield, and capital structure resilience under the asset-class-appropriate volatility.

    Specific stress dimensions covered in the bankable framework's sensitivity work: NOI variance (revenue and expense components separately), interest rate variance (for floating rate or rate-reset structures), cap rate expansion (for stabilized refinance and exit pricing), occupancy variance (for stabilizing or transitional assets), and tenant departure scenarios (for single-tenant or concentrated multi-tenant assets). Each dimension is tested individually rather than aggregated; lenders need to see which specific stress drives the binding constraint, not just whether the deal passes overall.

    MONTE CARLO

    Monte Carlo simulation when warranted.

    Monte Carlo simulation is the statistical methodology of running thousands of iterations with randomized assumption inputs to produce a distribution of outcomes rather than a point projection. The methodology is appropriate when individual assumptions have known probability distributions and when assumption interactions matter for the projection. A typical Monte Carlo run executes 10,000 iterations across the projection horizon with each iteration drawing assumption values from documented distributions; the output is a probability distribution of DSCR, debt yield, IRR, and equity multiple outcomes rather than a single value.

    The bankable framework deploys Monte Carlo for institutional capital deals where the sponsor's investment committee or lender's credit committee benefits from probability-distribution analysis rather than point estimates. Specific contexts: large CMBS SASB and life-co deals where loan amount sensitivity to cap rate matters substantially; HUD 232 LEAN deals where census volatility and reimbursement environment both affect coverage; data center development deals where power cost trajectory and hyperscaler tenant concentration both affect long-term economics; institutional multifamily portfolios where rent growth assumption interacts with operating expense inflation across multiple submarkets.

    Monte Carlo is not deployed for every deliverable. Most SBA, USDA, conventional bank, and standard CMBS conduit deals are well-served by three-tier sensitivity analysis without the additional analytical complexity. The bankable framework's methodology indicates Monte Carlo deployment only when the analytical value justifies the additional engagement scope and when the sponsor or lender specifically requests probability-distribution analysis. Most deliverables include Monte Carlo capability as an optional supplemental section rather than a required scope element.

    EQUITY RETURNS

    IRR, equity multiple, and cash-on-cash for institutional capital.

    Equity returns analysis quantifies the sponsor's and limited partners' return on equity capital over the investment hold period. The three primary metrics are internal rate of return (IRR — the discount rate that produces zero NPV across the cash flow stream), equity multiple (cumulative cash flow divided by initial equity), and cash-on-cash return (annual cash distribution divided by equity invested at each year). Each metric measures returns differently; institutional capital evaluates all three rather than relying on any single metric.

    For non-SBA capital sources where equity returns analysis is part of the engagement scope (CMBS, life-co, debt fund, agency multifamily, HUD with LIHTC overlay, mezzanine), the bankable framework's methodology produces hold-period IRR, equity multiple, and cash-on-cash projections at three sensitivity tiers (downside, base, upside). The output supports the sponsor's equity raise diligence, limited partner subscription decisions, and the lender's view of sponsor commitment depth on the deal.

    IRR analysis deserves particular attention for institutional capital because IRR sensitivity to exit assumption is structural. A 25 basis point change in exit cap rate can move IRR by 200–400 basis points depending on hold period and capital structure; the bankable framework's methodology tests exit cap rate variance explicitly rather than assuming a single exit cap rate. Equity multiple is less sensitive to exit timing assumption than IRR, which makes it complementary as a measure of cumulative returns. Cash-on-cash quantifies the year-by-year distribution profile, which matters for sponsors with operating-business equity needs and for limited partners with current-yield preferences.

    LIMITATIONS

    What this methodology can and cannot do.

    Financial projections methodology produces lender-grade analytical work, but it does not eliminate financial risk. The methodology surfaces revenue, expense, NOI, DSCR, and equity returns based on documented data and explicit assumptions; it does not predict the future or guarantee that operating performance will match projection. Lenders evaluate financial modeling quality based on analytical rigor, methodology transparency, and assumption documentation — not based on forecast accuracy.

    Forecast accuracy depends on factors outside the methodology's scope. Macroeconomic shifts (rate environment, employment, consumer spending), competitive dynamics (new supply, tenant movement, brand performance), regulatory changes (tax law, environmental compliance, healthcare reimbursement), and asset-specific events (capex surprises, system failures, tenant defaults) all affect actual outcomes versus projected outcomes. The methodology incorporates conservative scenarios to test resilience but cannot predict which factor will materialize.

    Pro forma horizon limits also affect methodology rigor. The bankable framework's pro formas extend 5 years for most asset classes (10 years for senior housing, hospitality, and other operating-intensive asset classes; 20–25 years for life-co permanent loan deals where amortization period extends substantially). Forecasting accuracy degrades over longer horizons; analyst representations document the forecast horizon explicitly and identify the scenarios where longer-horizon projections are most exposed to assumption error.

    See the methodology in actual deliverables, or test your own deal.

    Five redacted sample reports show the practice's financial projections methodology adapted for SBA, USDA, conventional bank, CMBS, and life-co lender review. The DSCR and Debt Yield Calculator lets you test your own deal against eleven capital source thresholds in real time.

    Or read the bankable framework methodology →·Market analysis methodology →·Methodology hub →·Lender requirements matrix →