managing-loan-underwriting-real-estate

# Managing Loan Underwriting Real Estate

Structures commercial real estate loan underwriting with DSCR, LTV, and debt yield analysis for commercial property debt transactions.

## When To Use

- Underwriting a new CRE loan (acquisition, refinance, or construction-to-perm)
- Evaluating loan sizing across multiple coverage metrics (DSCR, LTV, debt yield)
- Comparing term sheet proposals from multiple lenders
- Stress-testing loan structures under varying NOI, cap rate, or interest rate scenarios
- Preparing credit committee or investment committee loan packages
- Assessing REIT-level portfolio leverage and covenant compliance

## Inputs To Gather

- **Property financials**: Trailing-12-month (T-12) operating statements, rent roll with lease expiration schedule, historical occupancy data
- **Appraisal or valuation**: Recent appraisal, broker opinion of value, or internal underwritten value with cap rate basis
- **Loan terms**: Proposed loan amount, interest rate (fixed/floating + spread), amortization period, maturity, IO period if any, prepayment provisions
- **Borrower information**: Sponsor track record, net worth and liquidity, guaranty structure (recourse vs. non-recourse with carve-outs)
- **Market data**: Submarket vacancy, comparable rental rates, recent sales comps for cap rate benchmarking
- **Third-party reports**: Environmental (Phase I/II), property condition report, seismic (if applicable), survey, title [VERIFY: lender-specific report requirements vary]

## Workflow

1. **Build the NOI waterfall**
   - Start from gross potential rent, subtract vacancy/credit loss, add other income
   - Deduct operating expenses line-by-line (management fee, R&M, insurance, taxes, utilities, common area)
   - Arrive at in-place NOI, then build an underwritten NOI adjusting for lease-up, rent bumps, and normalized expenses
   - Clearly label in-place vs. stabilized vs. stressed NOI figures

2. **Calculate core coverage metrics**
   - **DSCR** = Underwritten NOI ÷ Annual Debt Service. Minimum thresholds: 1.20x–1.25x typical for stabilized; 1.30x+ for transitional or single-tenant [VERIFY: lender-specific DSCR floors]
   - **LTV** = Loan Amount ÷ Appraised Value. Senior loans typically capped at 65%–75% [VERIFY: product-specific LTV limits]
   - **Debt Yield** = Underwritten NOI ÷ Loan Amount. Minimum 8%–10% for most CRE lenders; acts as a rate-independent sizing check

3. **Size the loan using the binding constraint**
   - Calculate maximum loan proceeds under each metric independently
   - The binding constraint (lowest proceeds) governs final loan sizing
   - Document which metric is the binding constraint and the gap to the next constraint

4. **Stress test the structure**
   - Interest rate stress: model +100bps and +200bps rate increases on floating-rate loans
   - NOI stress: model 10%–20% NOI decline and recalculate DSCR
   - Cap rate stress: model 50–100bps cap rate expansion and recalculate LTV
   - Identify breakeven occupancy and breakeven rental rate for debt service coverage

5. **Evaluate loan structure and terms**
   - Compare IO period impact on amortizing vs. IO DSCR
   - Assess prepayment provisions (yield maintenance, defeasance, step-down) against hold period
   - Review recourse carve-outs (bad boy guarantees) and their scope
   - Flag any cash management triggers (hard vs. soft lockbox, cash sweep thresholds)

6. **Compile the underwriting package**
   - Loan sizing summary table showing proceeds under each metric
   - Sources and uses of funds
   - Sensitivity tables (rate, NOI, cap rate scenarios)
   - Borrower/sponsor summary and guarantor financial capacity
   - Risk factors and mitigants narrative

## Output

A structured loan underwriting report containing:

- **Loan sizing summary**: Maximum proceeds by DSCR, LTV, and debt yield with the binding constraint identified
- **NOI waterfall**: Gross-to-net income build with clear in-place vs. underwritten adjustments
- **Coverage metrics table**: DSCR (IO and amortizing), LTV, debt yield at base case and stress scenarios
- **Sensitivity matrix**: NOI decline × interest rate increase grid showing resulting DSCR
- **Sources & uses**: Total project cost, equity requirement, and loan-to-cost
- **Risk summary**: Key risks (lease rollover concentration, market softness, sponsor experience) with mitigants
- **Term comparison** (if multiple proposals): Side-by-side lender term sheets with net proceeds, all-in cost, and flexibility ranked

## Quality Checks

- NOI underwriting ties back to the rent roll and T-12 with all adjustments documented
- Debt service calculation matches the stated rate, amortization, and IO period precisely
- All three coverage metrics (DSCR, LTV, debt yield) are computed and the binding constraint is correctly identified
- Stress scenarios use clearly stated assumptions and show metric movement directionally
- Vacancy assumption is justified relative to submarket data, not assumed at a flat percentage without support
- Management fee is underwritten consistently (market standard or actual, whichever is higher) [VERIFY: lender underwriting convention]
- Reserves (TI/LC, capex, ground rent if applicable) are included in the cash flow before debt service where required by the lender
- No circular references between stabilized value assumptions and loan sizing
- Sponsor financial capacity (net worth ≥ loan amount, liquidity ≥ 10% of loan) is verified against lender requirements [VERIFY: specific lender thresholds]