CRE Underwriting Analysis & Credit Memo Generation
Analyze CRE loans and generate institutional credit memoranda with financial modeling
What You Can Do
You can transform raw CRE loan packages into defensible credit decisions by leveraging Claude to normalize financial statements, calculate debt service coverage ratios (DSCR), stress-test scenarios, and synthesize borrower creditworthiness assessments. The skill organizes complex property performance data, market conditions, and loan structures into comprehensive credit memoranda that institutional investors and regulators expect, eliminating manual data wrangling and ensuring consistent metric calculation across underwriting workflows.
Features
adjust historical operating statements for one-time items, normalize expenses, and identify sustainable cash flow
compute normalized operating income, calculate debt service coverage ratios, and stress-test multiple interest rate and occupancy scenarios
organize comparable sales data, income capitalization approaches, and cost approaches into valuation summaries
synthesize personal financial statements, tax returns, guarantor strength, and borrower track record into risk profiles
identify portfolio concentration risks, evaluate tenant quality, and flag occupancy/expiration cliffs
recommend sizing based on DSCR thresholds, loan-to-value constraints, and risk-adjusted equity returns
flag structural risks (market cycles, capital needs, refinance risk) and recommend protective covenants
produce formatted institutional memoranda with executive summaries, financial exhibits, risk assessments, and recommendation sections
Example Output
Example 1: DSCR Stress-Test Summary
| Scenario | NOI | Debt Service | DSCR | Status |
|---|---|---|---|---|
| Base Case (92% occupancy, 3.5% rates) | $2,145,000 | $1,680,000 | 1.28x | ✓ Acceptable |
| Conservative (85% occupancy, 4.5% rates) | $1,980,000 | $1,840,000 | 1.08x | ⚠ Below threshold |
| Recession (75% occupancy, 5.5% rates) | $1,815,000 | $2,010,000 | 0.90x | ✗ Covenant breach |
Example 2: Executive Summary Extract
Property: 250,000 SF Class A office, Denver CBD | Loan Amount: $28.5M | Term: 5-year fixed
Credit Strengths: Strong sponsor with $500M AUM; 94% leased to investment-grade tenants; 2.1x DSCR at stabilization; seasoned asset with 15-year operating history.
Key Risks: Market softness in Denver office; 38% lease expiration 2026-2027; $800K annual capital reserve needed; refinance risk if rates remain elevated.
Recommendation: Approve with rate adjustment to 4.75%, DSCR floor covenant of 1.15x, and annual capital reserve requirement of $800K.
Example 3: Tenant Concentration Risk
Largest tenant (TechCorp Inc.) represents 28% of NOI; lease expires Q3 2026. Recommended protective measures: lease renewal priority, tenant improvement allowance pre-negotiation, expanded lease-up contingency in DSCR calculation.
What's Included
- SKILL.md: comprehensive underwriting framework with financial normalization guidance and risk assessment methodology
- CRE Financial Model Template: spreadsheet structure for NOI calculation, DSCR stress-testing, and scenario analysis
- Credit Memo Template: institutional format with executive summary, property overview, financial analysis, borrower assessment, and recommendation sections
- Underwriting Checklist: verification items for financial statements, lease roll accuracy, environmental reports, and structural inspections
- Risk Assessment Framework: structured approach to identifying market, property, borrower, and transaction risks with mitigation recommendations
Who It's For
- Credit analysts and commercial real estate lenders evaluating acquisition and refinance deals
- Loan officers preparing underwriting recommendations for internal approval committees
- Portfolio managers and institutional investors reviewing CRE investment memoranda
- Risk management professionals conducting covenant compliance and stress-testing analysis
- Underwriting teams in banks, life insurance companies, and commercial mortgage-backed securities (CMBS) platforms
Best For
- Analyzing commercial office, retail, industrial, and multifamily loan applications
- Synthesizing complex financial packages into standardized credit memoranda
- Calculating DSCR and stress-testing scenarios across interest rate and occupancy assumptions
- Normalizing operating statements and identifying sustainable cash flows
- Identifying and quantifying property-specific and borrower-specific credit risks
- Structuring loan terms and covenants based on underwriting findings and risk profile
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