Banking & Credit Underwriting Desk
Regulatory bank capital adequacy under Basel III, commercial debt service coverage ratio (DSCR) underwriting, Small Business Administration (SBA 7a vs 504) loan comparison, and commercial rate cap hedging. Built for chief credit officers, commercial lenders, and business borrowers.
Bank Balance Sheet, Capital & Basel III ALM Underwriter
Deterministic bank asset-liability management (ALM) and regulatory capital stress-tester. Quantify duration gaps, Net Interest Margin (NIM) sensitivity, Common Equity Tier 1 (CET1), Supplementary Leverage Ratio (SLR), Liquidity Coverage Ratio (LCR), and deposit run liquidity cushions.
• Basel III Regulatory Capital Ratios: CET1, Tier 1, Total Capital & SLR
• Liquidity Coverage Ratio (LCR) & 30-Day Net Cash Outflow Solver
• 4-Tier Deposit Run Contagion Stress-Test (5% to 25% Outflow)
• Regional Bank (SVB-style) vs. G-SIB Balance Sheet Presets
Commercial Debt Service Coverage Ratio (DSCR) Underwriter
Dual-mode credit committee underwriter. Solve for debt coverage and test against revenue & interest rate shocks, or solve backwards to calculate maximum borrowing capacity.
• Mode B: Max Allowable Debt Capacity Solver
• Bank Approval Verdict (Approved / Conditional / Stressed)
• Dual Revenue & Rate Sensitivity Stress Matrix
SBA 7(a) vs. SBA 504 vs. Conventional Underwriter
Direct side-by-side cost and debt service comparison across the three primary commercial debt instruments. Calculates tiered SBA guaranty fees, blended rates, and total interest.
• SBA 504 Two-Tier Debenture (25Y Fixed Rate)
• Conventional Commercial Bank Loan with Balloon
• Statutory SBA SOP Tiered Guaranty Fee Schedule
Commercial Loan Amortization & Prime Rate Stress-Tester
Deterministic commercial loan amortization and floating rate stress-tester. Model monthly debt service, principal retirement waterfalls, balloon refinancing payoffs, and Prime/SOFR rate shocks (+/- 50 to 300 bps) against commercial bank DSCR covenants.
• Floating Spread vs. Conventional Fixed Rate Modes
• Mismatched Balloon Maturity Balances (5Y, 7Y, 10Y Balloon)
• 8-Tier Interest Rate Shock Sensitivity Matrix (-100 to +300 bps)
• Year-by-Year Debt Service Amortization Schedule Table
Commercial Floating Rate Cap & Interest Rate Swap Underwriter
Underwrite commercial debt hedging structures. Compare upfront cash rate caps against zero-cost floating-to-fixed interest rate swaps (SOFR and WSJ Prime). Model lender escrow requirements, monthly counterparty recoveries, 6-scenario rate shock sensitivity, and Mark-to-Market (MtM) early loan prepayment breakage penalties.
• Zero-Cost Floating-to-Fixed SOFR Swap Lock Structuring
• 6-Scenario Macro Interest Rate Shock Matrix (-200 to +300 bps)
• Breakeven Benchmark Rate & Cap Premium Amortization Solver
• Early Prepayment Mark-to-Market (MtM) Breakage Fee Estimator
Banking & Credit Underwriting Desk Quantitative Architecture & Methodology
The Banking & Credit Underwriting Desk reflects the institutional underwriting standards enforced by commercial banks and regulatory authorities (OCC, FDIC, Federal Reserve). Models enforce Basel III risk-weighted asset (RWA) limits and commercial loan covenants.
Core Mathematical Formulations
The primary regulatory measure of a bank's financial strength and capacity to absorb unexpected loan losses without insolvency.
The standard cash flow coverage test verifying whether commercial operating income is sufficient to service mandatory principal and interest payments.
Quantifies the exact time in days required for a company to convert operating investments into cash inflows, driving working capital loan sizing.
Structures interest rate cap corridors protecting commercial borrowers against sharp SOFR spikes on floating-rate debt.
Target Institutional Audience & Applications
Senior underwriters verifying commercial DSCR coverage, collateral advance rates, and regulatory Basel III capital allocation.
Entrepreneurs and CFOs comparing SBA 7(a) vs. CDC/504 vs. conventional bank debt to minimize down payments and financing costs.
Financial intermediaries packaging multi-million dollar credit requests for bank and non-bank direct lending approval.
Cross-Asset Concept Guides & Recommended Reading
Regulatory capital buffers, risk-weighted asset classifications, and CAMELS ratings.
Global cash flow analysis, debt service constant tables, and minimum lender coverage rules.
Comparison of fee structures, prepayment penalties, and real estate financing mechanics.