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]