managing-commercial-loan-underwriting
Structures commercial loan underwriting with financial spreading, cash flow analysis, and risk rating. Use when underwriting commercial loans, analyzing borrower financials, or assigning risk ratings.
- License 许可
- Apache-2.0
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- managing-commercial-loan-underwriting
- tags
- [ "management", "commercial-banking", "risk" ]
- source
- https://github.com/CaseMark/skills
- license
- Apache-2.0
- language
- en
- metadata
- { "author": "casemark", "skill_modes": [ "Management", "Coordination" ], "document_types": [ "Management Report" ], "practice_areas": [ "Commercial Banking", "Trade Finance", "Lending" ] }
- description
- Structures commercial loan underwriting with financial spreading, cash flow analysis, and risk rating. Use when underwriting commercial loans, analyzing borrower financials, or assigning risk ratings.
- imported_at
- 2026-09-20
- source_path
- skills/finance/managing-commercial-loan-underwriting/SKILL.md
- source_repository
- CaseMark/skills
03 SKILL.md 正文
Managing Commercial Loan Underwriting
When To Use
- Underwriting a new commercial loan request (term loans, revolving lines, CRE loans, construction facilities)
- Performing annual or periodic credit reviews on existing borrowers
- Spreading borrower financials for credit analysis and trend identification
- Assigning or updating internal risk ratings
- Preparing a credit memo or underwriting package for credit committee approval
- Evaluating trade finance facilities, letters of credit, or working capital lines
Inputs To Gather
- Borrower financials: 3 years of audited/reviewed financial statements (balance sheet, income statement, cash flow statement); interim statements for YTD period
- Tax returns: Business and personal (guarantors) for 3 years
- Loan request details: Amount, purpose, term, proposed structure, collateral offered, pricing expectations
- Business information: Entity type, ownership structure, management bios, industry/NAICS code, years in operation
- Collateral documentation: Appraisals, environmental reports (Phase I/II), UCC search results, title reports for real estate
- Personal financial statements: For all guarantors with >20% ownership
- Existing debt schedule: All outstanding obligations with terms, balances, and lender names
- Industry benchmarks: RMA Annual Statement Studies or comparable data for the borrower's NAICS code
Workflow
-
Spread financials
- Normalize 3 years of financial statements into a standardized spreading template
- Adjust for non-recurring items, owner compensation above market, related-party transactions
- Calculate key ratios: current ratio, quick ratio, debt-to-worth, debt service coverage ratio (DSCR), leverage ratio, operating margin, return on assets
- Compare ratios against RMA industry medians and flag significant deviations
-
Analyze cash flow
- Prepare a Global Cash Flow analysis (UCA or traditional method) covering all related entities and guarantors
- Calculate DSCR using both EBITDA-based and cash-flow-based methods
- Minimum acceptable DSCR: typically 1.20x–1.25x for most commercial credits [VERIFY against institution's credit policy]
- Stress-test cash flow under adverse scenarios (revenue decline of 10–20%, interest rate increase of 200 bps)
-
Evaluate collateral
- Determine advance rates by collateral type: A/R (80–85% of eligible), inventory (50–65%), equipment (70–80% of NOLV), CRE (75–80% of appraised value) [VERIFY against institution's lending policy]
- Confirm collateral perfection requirements (UCC filings, mortgage recordings, title insurance)
- Identify environmental risk for real property collateral
- Calculate loan-to-value (LTV) ratios
-
Assign risk rating
- Apply the institution's internal risk rating scale (typically 1–10 or Pass/Watch/Substandard/Doubtful/Loss) [VERIFY against institution's rating system]
- Document the primary risk rating drivers: financial performance, industry conditions, management quality, collateral coverage, guarantor strength
- Dual risk rating: assign both a borrower risk rating (probability of default) and a facility risk rating (loss given default)
- Flag any rating that triggers enhanced monitoring, concentration reporting, or regulatory thresholds
-
Structure the credit facility
- Recommend loan structure: term, amortization schedule, rate type (fixed vs. floating), pricing spread
- Define financial covenants: minimum DSCR, maximum leverage ratio, minimum tangible net worth, capital expenditure limits
- Specify reporting requirements: frequency of financial statements, compliance certificates, borrowing base certificates (if applicable)
- Identify conditions precedent to closing and ongoing conditions
-
Prepare the credit memo
- Executive summary: borrower overview, request, recommendation
- Financial analysis section with spreading output and ratio trends
- Industry and market analysis
- Risk assessment with mitigants
- Collateral analysis with LTV calculations
- Proposed terms and conditions
- Exceptions to policy with justification (if any)
Output
A complete underwriting package containing:
- Standardized financial spreads with 3-year trend analysis and industry comparison
- Global cash flow analysis with DSCR calculations and stress test results
- Collateral analysis with advance rates, LTV calculations, and perfection checklist
- Risk rating assignment with documented rationale and dual rating (PD/LGD)
- Credit memo formatted for credit committee review with clear recommendation (approve, approve with conditions, decline)
- Covenant and structure summary with proposed terms, monitoring triggers, and reporting calendar
Quality Checks
- All financial spreads tie back to source documents — totals must reconcile with submitted statements
- DSCR calculated consistently (confirm whether using EBITDA, EBITDA–CapEx, or UCA cash flow) and method is disclosed
- Risk rating supported by quantitative metrics, not solely narrative judgment
- Collateral values based on current appraisals (within 12 months for CRE) [VERIFY appraisal age requirements per institution policy and regulatory guidance]
- Guarantor analysis completed for all individuals with >20% ownership
- Policy exceptions explicitly identified and justified — never buried in narrative
- Stress test assumptions are reasonable and documented
- All [VERIFY] items confirmed against the institution's current credit policy manual before submission
04 同仓库更多 Skills
dei-assessment
Assess diversity, equity, and inclusion with metrics. TRIGGERS - Use when user needs help with dei-assessment related tasks.
dei-action-plan
Create DEI action plans with goals and initiatives. TRIGGERS - Use when user needs help with dei-action-plan related tasks.
culture-fit-assessment
Design culture add assessment processes. TRIGGERS - Use when user needs help with culture-fit-assessment related tasks.
cowork-to-code-bridge
Use an already-installed, independently verified cowork-to-code bridge to run narrowly approved actions on the user's own macOS, Linux, or WSL2 machine through a local file queue.
counter-offer-response
Draft counter-offer responses for retention. TRIGGERS - Use when user needs help with counter-offer-response related tasks.
continuous-feedback-system
Design continuous feedback systems. TRIGGERS - Use when user needs help with continuous-feedback-system related tasks.