CRE Loan Underwriting Analyzer
Extract CRE loan data into structured underwriting memos with financial and risk analysis
What You Can Do
You can upload loan packages—financial statements, appraisals, market data, and sponsor documentation—and Claude organizes this information into structured underwriting memos. The skill calculates key CRE metrics (DSCR, LTV, debt yield), evaluates sponsor capacity and property fundamentals, identifies risk factors across market, property, and structural dimensions, and delivers defensible credit recommendations with scenario analysis.
Features
Automatically computes DSCR, LTV, debt yield, NOI, and other CRE credit metrics from application materials
Evaluates balance sheets, cash flow, guarantor strength, and track record against loan size and risk profile
Synthesizes appraisals, comps, market trends, and submarket dynamics to assess property fundamentals and cyclical exposure
Organizes findings into executive summary, loan structure, financial analysis, risk assessment, and recommendation sections for consistency and review efficiency
Tests debt service coverage under rate increases, occupancy declines, and exit scenarios to assess borrower resilience
Flags inconsistencies, weak sponsors, market softness, or structural concerns that warrant enhanced due diligence or mitigants
Analyzes multiple scenarios or refinance structures side-by-side to support approval strategy and pricing decisions
Produces institutional-grade underwriting documentation that supports credit committee review and audit trails
Example Output
Executive Summary Output:
- Loan Request: $25M, 5-yr fixed, 65% LTV on 150-unit multifamily in Denver submarket
- Sponsor: Grade B+ (strong balance sheet, 20-year track record, 3 other stabilized assets)
- Stabilized DSCR: 1.32x (Year 1), 1.18x stressed (95% occupancy, +200 bps rates)
- Risk Rating: Medium (Submarket supply headwinds offset by sponsor strength and cash reserves)
- Recommendation: APPROVE with standard covenants; monitor quarterly NOI variance vs. budget
Financial Analysis Sample:
- Net Operating Income (Year 1): $3.2M (4.2% cap rate vs. 4.6% market average)
- Debt Service: $2.4M annually; DSCR 1.32x (comfort level above 1.25x threshold)
- LTV: 65%; Loan-to-Cost: 62% (within policy)
- Exit IRR (5-yr hold): 18.2% at 4.8% cap rate exit
Risk Assessment Snapshot:
- Property Risk: Medium (Class B asset, 92% occupancy, competitive supply pipeline +8% over 3 years)
- Sponsor Risk: Low (Experienced operator, $150M portfolio, 3:1 liquid reserves to loan amount)
- Market Risk: Medium (Denver multifamily fundamentals soft but not distressed; rent growth moderating)
- Structural Risk: Low (Fixed-rate term, interest-only first 2 years, standard DSC/LTV covenants)
- Overall Credit Grade: B+ (Approve with monitoring)
What's Included
- SKILL.md instruction file: Prompts Claude to systematize CRE loan analysis with defined analytical steps
- Underwriting memo template: Structured format for executive summary, financial analysis, risk assessment, and recommendations
- CRE financial metrics checklist: DSCR, LTV, debt yield, DCF, stress scenarios, and calculation guidance
- Risk assessment framework: Taxonomy for evaluating property, sponsor, market, and structural risk dimensions
- Scenario analysis workbook: Templates for testing rate shocks, occupancy stress, and exit assumptions to support approval decisions
Who It's For
- CRE credit analysts — Evaluating loan applications and documenting credit decisions for approval committees
- Senior lenders & underwriters — Reviewing large loan packages and supporting loan approval recommendations
- Portfolio managers — Analyzing existing CRE loans for refinance opportunities or risk monitoring
- Relationship managers — Preparing credit packages and loan proposals for internal review and sponsor discussions
- Internal audit & compliance teams — Validating underwriting rigor and consistency against institutional credit policies
Best For
- Stabilized multifamily, office, retail, and industrial loan underwriting and approval documentation
- Sponsor financial capacity and track record evaluation against leverage and loan structure
- Debt service coverage and loan-to-value stress testing under economic and rate scenarios
- Market and submarket risk assessment based on appraisals, comps, and supply/demand data
- Comparative analysis of multiple loan structures, refinance scenarios, or competing proposals
You might also like
You can submit loan application materials—financial statements, credit reports, business plans, and collateral documentation—and receive a structured underwriting memorandum that assesses creditworthiness across institutional standards. Claude extracts key financial metrics, calculates debt service coverage ratios, identifies material risk factors, and documents lending recommendations with rationale suitable for credit committee review and regulatory examination.
by eternaljust
Conduct thorough, documented customer risk assessments using structured compliance decision trees aligned with FinCEN, OFAC, and BSA standards. You'll evaluate customer information, identify regulatory red flags, determine appropriate risk classifications, and generate audit-ready documentation that demonstrates defensible decision-making during regulatory examinations. This skill accelerates due diligence while reducing compliance gaps and creating the paper trail regulators expect.
by eternaljust
You can analyze transaction patterns across 90-180 day windows, calculate risk scores based on regulatory frameworks (FinCEN, OCC, Fed guidance), and detect behavioral anomalies that suggest structuring, layering, or placement activity. Claude generates defensible suspicious activity documentation and supports your SAR filing decisions with evidence-based contextual analysis rather than rule-matching alone.
by eternaljust
This skill guides you through SAR preparation with structured compliance validation, ensuring your filings meet FinCEN requirements and withstand regulatory examination. You'll validate mandatory fields, risk-score transactions against BSA/AML thresholds, document investigation procedures for audit defensibility, and cross-check against common rejection reasons that delay filing. The skill helps you align documentation across Operations, Risk, Compliance, and Legal teams to ensure timely, accurate SAR submission within the 30/60-day timeline.
by eternaljust
You can conduct multi-source sanctions screening on customers, counterparties, and beneficial owners; assess regulatory risk for complex transaction scenarios; determine Enhanced Due Diligence (EDD) necessity; and document compliance findings with reasoning that withstands OFAC enforcement scrutiny. The skill integrates customer due diligence protocols, sanctions jurisdiction analysis, and transaction authorization logic to streamline BSA/AML decision-making.
by eternaljust
Systematically identify chart patterns and validate them using technical confluence scoring. You get actionable trade setups with entry/exit levels and risk/reward analysis based on multiple indicator confirmation. Filter false signals and improve your trade quality by combining technical indicators in a disciplined framework.
by eternaljust
You can systematically evaluate customer risk profiles using a consistent methodology that integrates beneficial ownership verification, customer intelligence gathering, and risk scoring. The framework guides you through determining whether baseline CDD or enhanced due diligence is required, documents your decision rationale in audit-trail format, and generates compliance-ready files that satisfy regulatory examination standards.
by eternaljust
You can apply a structured risk assessment framework to transaction alerts, consistently scoring suspicious activity against regulatory expectations and internal thresholds. Claude helps you triage alerts efficiently, document decision rationale for examination readiness, and classify activity by risk level to prioritize investigations and determine SAR filing obligations while minimizing time spent on false positives.
by eternaljust