lev-os Managing Real Estate Debt Funds
Structures real estate debt fund analysis covering loan origination pipelines, portfolio credit quality, leverage management, and investor reporting for CRE and residential debt strategies.
When To Use
- Evaluating a debt fund's loan portfolio composition, credit metrics, and risk concentrations
- Analyzing origination pipelines and underwriting standards for new loan production
- Preparing quarterly or annual fund performance reports for LPs
- Stress-testing portfolio exposure to interest rate shifts, property value declines, or borrower defaults
- Comparing debt fund performance against benchmarks (e.g., Giliberto-Levy, ODCE debt equivalents)
- Assessing compliance with fund-level covenants, leverage limits, and concentration guidelines
Inputs To Gather
- Fund Documents: LPA/PPM terms including target returns, leverage caps, reinvestment period, investment restrictions, and fee structure (management fee, incentive allocation, catch-up, clawback)
- Loan Tape: Full loan-level data — outstanding balance, origination date, maturity, coupon (fixed/floating + spread), LTV at origination and current, DSCR, property type, geography, borrower info, loan status
- Portfolio Financials: NAV statements, capital account summaries, cash flow waterfalls, distribution history
- Origination Pipeline: Loans under review, term sheets issued, expected close dates, pipeline conversion rates
- Facility/Leverage Data: Warehouse lines, repo facilities, CLO issuances — advance rates, mark-to-market triggers, margin call thresholds, facility maturity dates
- Market Data: Current benchmark rates (SOFR, Treasury curve), CRE cap rates and transaction volumes by property type, delinquency and default rate trends
Workflow
Map Fund Strategy and Constraints
- Classify fund strategy: senior whole loans, mezzanine, bridge/transitional, construction, preferred equity, or multi-strategy
- Document target return profile (current yield vs. total return), leverage policy, and permitted investment types
- Note reinvestment period status — whether fund is deploying, fully invested, or in harvest/wind-down
Analyze Portfolio Composition
- Break down by property type (multifamily, office, industrial, retail, hospitality, mixed-use), geography, loan position (senior, subordinate, mezz), and floating vs. fixed rate
- Calculate weighted-average LTV, DSCR, coupon/spread, remaining term, and loan size
- Identify concentration risks: any single borrower, property type, or MSA exceeding fund guidelines [VERIFY concentration limits in LPA]
- Flag loans on watch list, in special servicing, or with modified terms
Evaluate Credit Quality and Risk
- Review internal risk ratings and any migration trends (upgrades/downgrades over trailing quarters)
- Assess interest rate exposure: portion floating vs. fixed, rate caps in place, cap expiration dates
- Run stress scenarios: +200/+300 bps rate shock impact on borrower DSCRs, LTV revaluation under 10-20% property value decline
- Calculate portfolio-level expected loss using PD × LGD framework or historical loss rates by loan type
- Review loan covenant compliance (debt yield minimums, DSCR triggers, cash management/lockbox triggers)
Assess Leverage and Liquidity
- Document fund-level leverage: total facility commitments, drawn amounts, advance rates by collateral type
- Evaluate mark-to-market risk on repo lines — what price decline triggers margin calls
- Map facility maturity dates against loan maturity profile to identify term mismatches
- Calculate undrawn capacity and cash reserves relative to unfunded commitments and potential capital calls
Review Origination and Deployment
- Summarize pipeline by loan type, size, geography, and expected timing
- Compare recent origination spreads and LTVs to fund targets and historical averages
- Track deployment pace against the reinvestment period timeline and unfunded LP commitments
- Note any drift in underwriting standards (rising LTVs, thinner DSCRs, loosened covenants)
Compile Performance Metrics
- Calculate and present: gross/net yield, total return (income + realized/unrealized gains), current cash-on-cash, IRR since inception
- Compare performance to stated target returns and relevant benchmarks
- Prepare waterfall analysis showing management fees, preferred return, catch-up, and carried interest allocation [VERIFY waterfall mechanics against LPA]
- Summarize distribution history and reinvestment activity
Output
Produce a management report structured as:
- Executive Summary: Fund strategy recap, current AUM/NAV, key portfolio stats (WA LTV, WA DSCR, WA spread), deployment status, and headline credit observations
- Portfolio Overview Table: Loan-level detail with columns for borrower, property type, location, balance, LTV, DSCR, coupon/spread, maturity, risk rating, status
- Concentration Analysis: Charts or tables showing allocation by property type, geography, loan type, and borrower; flag any guideline breaches
- Credit and Risk Dashboard: Watch list summary, risk rating migration, stress test results, interest rate sensitivity
- Leverage Summary: Facility utilization, advance rates, MTM cushion, maturity schedule, liquidity position
- Origination Update: Pipeline summary, recent closings, spread/LTV trends, deployment pace
- Performance Summary: Yield, return, and distribution metrics; waterfall breakdown; benchmark comparison
- Action Items: Loans requiring attention, upcoming maturities, covenant monitoring, LP communication needs
Quality Checks
- Loan tape totals reconcile to NAV statement and facility borrowing base reports
- Weighted-average metrics are balance-weighted, not simple averages
- LTV calculations use consistent valuation dates — flag stale appraisals (>12 months) with [VERIFY current value]
- Stress scenarios use internally consistent assumptions (rate shock should flow through to both DSCR and refi risk)
- Waterfall calculations match LPA terms exactly — verify hurdle rates, catch-up splits, and GP co-invest treatment
- Concentration percentages sum correctly and reference the correct denominator (committed capital vs. invested capital vs. NAV)
- All return figures clearly state whether gross or net of fees, and whether levered or unlevered
- Interest rate exposure distinguishes between naturally floating, swapped-to-fixed, and capped exposures