
Commercial Underwriting Risk Assessment & Decision Memo
Analyze commercial loans and generate risk assessment decision memos
What You Can Do
You can rapidly assess commercial loan applications by analyzing financial statements, credit history, industry dynamics, and collateral. Claude generates comprehensive risk memos with clear underwriting recommendations, enabling you to make faster, better-documented lending decisions with consistent risk evaluation criteria across your portfolio.
Features
Automatically calculate and interpret key metrics like debt service coverage ratio, loan-to-value, quick ratio, and interest coverage to benchmark borrower health against industry standards.
Apply a structured underwriting methodology that systematically evaluates credit risk, collateral risk, industry risk, and management risk on a consistent scale across all applications.
Generate professional, audit-ready decision memos that document your underwriting analysis, recommendation (approve/decline/conditional), conditions, and risk mitigants in a standardized format.
Analyze proposed collateral, evaluate liquidation value, identify secondary repayment sources, and assess concentration risk across your portfolio.
Propose loan covenants, guarantees, collateral requirements, and deal structures tailored to the specific risk profile of each borrower.
Incorporate industry trends, competitive positioning, economic headwinds, and market cycles into your risk evaluation for more forward-looking decisions.
Model loan performance under adverse scenarios (revenue decline, rate shock, economic downturn) to identify break-even points and tail risks.
Compare borrower metrics to peer company performance within their industry segment to contextualize relative financial strength.
Example Output
COMMERCIAL UNDERWRITING DECISION MEMO
Borrower: Apex Manufacturing LLC Requested Facility: $2.5M revolving credit line Recommended Action: APPROVE with conditions
Executive Summary Apex Manufacturing demonstrates solid financial performance with DSCR of 1.8x and improving margins. Strong owner equity (42%) and established customer relationships mitigate moderate industry cyclicality. Recommend approval contingent on personal guarantees and quarterly financial reporting.
Risk Assessment
- Credit Risk: MEDIUM — 7-year track record, clean payment history, but owner concentration and limited working capital depth
- Collateral Risk: MEDIUM-LOW — Current assets cover 1.4x facility size; inventory turns acceptable at 4.2x annually
- Industry Risk: MEDIUM — Manufacturing facing commodity price volatility; borrower hedges via long-term contracts (65% of revenue)
- Management Risk: LOW — Experienced owner (22 years); CFO upgrade recommended
Proposed Conditions
- Personal guarantee from owner
- Negative pledge on all business assets
- Quarterly unaudited financials within 30 days of quarter-end
- Minimum DSCR covenant of 1.25x
- Annual business plan review
What's Included
- Underwriting Analysis Template: Structured prompt template that guides you through credit analysis, financial benchmarking, risk classification, and recommendation logic.
- Decision Memo Format: Professional memo template with sections for executive summary, risk assessment by category, collateral analysis, covenants, and approval conditions.
- Financial Metric Library: Formulas and interpretation guidance for 20+ commercial lending ratios including leverage, liquidity, profitability, and efficiency metrics.
- Industry Risk Guidance: Context for key commercial sectors (manufacturing, healthcare, retail, technology, construction) including typical risks, cyclicality, and concentration concerns.
- Covenant & Structure Checklist: Decision framework for selecting appropriate financial covenants, collateral requirements, guarantees, and loan structure based on risk profile.
- Stress Testing Scenarios: Pre-built templates for modeling downside scenarios (10-30% revenue decline, rate shock, working capital stress) to test loan resilience.
Who It's For
- Commercial Lenders
- Credit Analysts
- Loan Officers
- Credit Committee Members
- Bank Risk Managers
Best For
- Evaluating commercial loan applications
- Generating audit-ready underwriting documentation
- Assessing credit risk and collateral adequacy
- Recommending loan structures and covenants
- Benchmarking borrower performance against peers







