# Trade Finance Model Build a trade finance model for LC fee structures, factoring discounting, and supply chain finance programmes. Includes granular risk-adjusted margin analysis and working capital cycle integration. - Canonical: https://finamodel.com/templates/trade-finance-model - Excel download: https://finamodel.com/templates/trade-finance.xlsx - Category: Capital Markets - Model type: Underwriting - Difficulty: Advanced - Audiences: Bankers & advisors, Credit & risk, Trade finance lenders, Supply chain finance advisors, Credit risk managers, Export credit agencies - Tags: L/C, collateral, invoice, supply-chain, default ## Overview Model a trade finance credit facility with collateral coverage ratios, payment term mechanics, and default loss scenarios. The facility finances short-term trade transactions: importers obtain letters of credit (L/C) or supply-chain financing against invoices or inventory collateral. Each transaction is underwritten with a coverage ratio: advance amount divided by collateral value (invoices, inventory, receivables) determines margin over the advance. The model tracks counterparty concentration, payment term risk (30–90 days typical), and loss scenarios under good/expected/stressed conditions. Collateral haircuts reflect receivable quality (80–95% of invoice face value, lower for buyer concentration risk), inventory haircuts (50–70% depending on product type), and duration risk (longer payment terms = higher risk). Expected loss is calculated as probability of default × loss severity; reserve requirements are modeled as a percentage of drawn balances. Key metrics: utilization rate (% of facility drawn), concentration metrics (largest counterparty as % of portfolio), average tenor (weighted payment term), and reserve adequacy. Trade finance is a working-capital solution for high-volume, short-duration transactions; margins are tight (100–300 bps) but throughput is high. This model applies to banks, specialty finance firms, and supply-chain finance platforms. ## What's included - Letter of credit issuance, amendment, and confirmation fee schedules - Factoring and invoice discounting with advance rate and dilution reserve logic - Supply chain finance and reverse factoring mechanics - Risk-adjusted net interest margin and ROI reporting - Transaction-level turnover, tenor, and volume forecasting - Trade finance facility structure (L/C, supply chain, inventory financing) - Transaction-level detail with invoice amount, payment terms, and due date - Collateral values (invoices, inventory, receivables) and margin over advances - Buyer creditworthiness and concentration risk by customer - Default probability and loss severity scenarios - Reserve requirements and expected loss calculations ## Trade Finance Model: How the Lending Book Projection Works This trade finance model projects a receivables-finance lending book over five years, linking origination, discount yield, two-tier funding, and credit losses. It helps readers evaluate whether a lender generates positive net interest margin, reaches profitability, and stays within funding covenants. The public download is a values-only preview; the underlying model captures the full calculation flow. ### Operating drivers: origination, tenor, pricing, and funding mix The model is driven by monthly origination that compounds at an annual growth rate, with Base, Good, and Stressed scenarios selecting different growth, probability of default, loss given default, and advance rate values. A 30/60/90-day tenor mix produces a weighted-average tenor that governs how quickly the book turns over. - Pricing combines an effective discount APR on the funded balance with per-invoice transaction fees and an arrangement fee on the warehouse limit. Funding uses a senior warehouse facility sized to a borrowing base and a subordinated mezzanine facility covering the slice the warehouse does not reach, with margins over SOFR and a non-utilisation fee on undrawn capacity. - Operating costs scale semi-variably with invoice throughput. ### Calculation flow: roll-forward, funded-balance income, and credit losses The receivables roll-forward sets closing book equal to opening plus originations minus repayments and defaults, where repayments reflect the share of the book maturing within the year based on tenor. - Discount income is charged on the funded balance, defined as gross receivables times the advance rate, and the warehouse funding cost is scaled to the same base so net interest margin is consistent. - Credit losses follow a PD times exposure times LGD relationship, with an allowance on the balance sheet that reconciles to the income statement provision and write-offs. - The two-tier debt structure ensures total debt equals the closing book, so debt growth funds book growth. ### Outputs: financial statements, portfolio metrics, and checks The model produces an income statement, balance sheet, and indirect-method cash flow statement, along with a ratios sheet covering profitability, portfolio risk, and covenant metrics. - These outputs show net interest margin, return on equity, collateral coverage, facility utilisation, and concentration measures. - A checks sheet validates balance-sheet balancing, warehouse debt within the borrowing base and facility limit, debt-to-equity and NPL covenants, the minimum cash buffer, and the receivables roll-forward. - Under the Stressed scenario, the model reports losses and a covenant breach while the balance sheet still balances, helping distinguish genuine economic stress from construction errors. ### Practical use: evaluating the lending book under different scenarios For a reader assessing whether a trade-finance lender can generate positive net interest margin and reach profitability, the model provides a structured view. The scenario toggle lets you compare Base, Good, and Stressed outcomes for origination growth, credit risk, and advance rates. - The funding stack shows how the warehouse and mezzanine facilities interact with the borrowing base and limits. The covenant checks highlight when debt or credit conditions could breach agreed thresholds. - The public download is a values-only preview of a debt-funded, five-year lending-book projection, useful for understanding the documented mechanics without live formulas. ## Built for trade finance operations Use this model when LC fee structures, factoring economics, or supply chain finance programme design are central to the business case. ## Tracks margin after all costs A proper trade finance model calculates net interest margin after cost of funds, credit insurance, collateral haircuts, and operating expenses across risk tiers. ## Useful for banks and commodity traders This gives you institutional-grade analytics for underwriting trade facilities, managing factoring portfolios, or evaluating supply chain finance programmes. ## Built for trade finance operations Use this model when LC fee structures, factoring economics, or supply chain finance programme design are central to the business case. ## Tracks margin after all costs A proper trade finance model calculates net interest margin after cost of funds, credit insurance, collateral haircuts, and operating expenses across risk tiers. ## Useful for banks and commodity traders This gives you institutional-grade analytics for underwriting trade facilities, managing factoring portfolios, or evaluating supply chain finance programmes. ## Features - **Collateral coverage tracking:** Model loan-to-value (LTV) ratios by transaction and aggregate portfolio to ensure adequate collateral coverage and early warning signs of deterioration. - **Payment term mechanics:** Track open invoice aging by customer and payment term (net 30, 60, 90 days) to identify payment delays and refinancing needs. - **Counterparty concentration:** Identify concentration risk by buyer and supplier, and stress-test portfolio under single counterparty default scenarios. ## Use cases - **Supply chain finance structuring:** Optimize facility size, advance rates, and concentration limits to meet client needs while managing credit risk. - **Portfolio stress testing:** Model loss scenarios under buyer defaults, supplier failures, or commodity price shocks that affect collateral value. - **Pricing and reserve adequacy:** Calculate expected loss by counterparty and facility segment to set appropriate pricing and reserve levels. ## Frequently asked questions ### What is a trade finance financial model? It is a model that forecasts fee income, funding costs, and risk-adjusted returns for trade finance operations including letters of credit, factoring, and supply chain finance. ### Who uses trade finance models? Trade finance banks, specialty factoring companies, commodity traders, and export-import managers use them for facility underwriting and portfolio management. ### What should a trade finance model include? It should include LC fee schedules, factoring advance rates, cost of funds analysis, credit insurance, and net interest margin outputs. ### Does it support different LC tenors? Yes. The model handles sight, usance, and deferred payment LCs with automatic fee and interest accrual calculations based on specific payment terms. ### Can I model recourse and non-recourse factoring? Yes. The model includes toggles for different risk-sharing structures, incorporating credit insurance premiums and bad debt provisioning logic. ## Related templates - [Factoring Program Model](https://finamodel.com/templates/factoring-model) - [Bank Loan Analysis Model](https://finamodel.com/templates/bank-loan-model) - [Credit Portfolio CDO Model](https://finamodel.com/templates/credit-portfolio-cdo-model)