# BNPL Model Build a BNPL financial model with dynamic origination volumes, unit economics, cohort-based default tracking, and cost of capital analysis. Designed for fintech operators and debt capital providers. - Canonical: https://finamodel.com/templates/bnpl-model - Excel download: https://finamodel.com/templates/bnpl.xlsx - Category: Credit - Model type: Underwriting - Difficulty: Intermediate - Audiences: Founders & operators, Investors & analysts, BNPL founders, Fintech investors, Growth strategists, Financial analysts - Tags: BNPL, fintech, unit economics, CAC, funding structure ## Overview A BNPL (buy-now-pay-later) fintech model projects the path to profitability by layering merchant take-rate revenue, customer default losses, funding costs, and unit economics (customer acquisition cost, lifetime value, churn) to show when the platform becomes cash-flow positive despite merchant subsidisation and credit losses. The model answers whether BNPL unit economics can achieve LTV/CAC > 2.0x (vs. the classic SaaS benchmark of 3.0x) and what percentage of merchants must be retained to hit EBITDA breakeven by year 3–4. Revenue is driven by merchant take-rate (percentage of transaction value captured), transaction volume growth by cohort, and customer cohort lifetimes. Default losses scale with the customer credit mix (subprime, near-prime, prime borrowers default at different rates) and are modelled as a percentage of gross transaction volume. Funding cost reflects the capital structure: warehouse lines (cheaper, high utilisation), securitisation (medium cost, slower), and equity (most expensive). Operating expenses include customer service (fraud handling, dispute resolution), fraud prevention technology, compliance and regulatory, and platform engineering. Working capital is negative because merchants hold money in escrow while consumers pay over time, creating a cash advantage. The model tracks monthly cohort payback (how quickly CAC is recouped from gross profit), blended LTV/CAC, and cash burn rate through to profitability. Venture investors and growth equity sponsors use BNPL models to confirm unit economics are approaching sustainable levels despite heavy customer acquisition, stress test the model for higher default rates and funding cost increases, and benchmark against Affirm, Klarna, and other public BNPL comparables. ## What's included - Dynamic GMV and origination volume build - Revenue schedules covering merchant discount rate and late fees - Cohort-based default vintage tracking and provisioning - Debt facility sizing, advance rates, and cost of capital - Unit economic tracking including contribution margin per loan - Merchant take-rate and transaction volume growth by cohort - Customer acquisition cost (CAC) and churn by vintage - Default rate and recovery by customer credit profile - Funding cost and capital structure: warehouse lines, securitization, equity - Operating expenses: customer service, fraud, compliance, and technology - Break-even analysis and path to positive unit economics ## What the BNPL Model Captures: Volumes, Receivables, Funding and Returns This BNPL model template links consumer growth and transaction volumes to merchant fees, interest income, credit losses, receivables and debt funding. It then carries those schedules into financial statements and equity returns over a five-year forecast. The explanation below focuses on documented operating drivers, calculation flow, outputs and practical use, so you can judge the template's structure and scope. ### Operating Drivers: Consumers, Transactions and Revenue Annual consumers begin from an opening base and grow at five input rates. Transactions equal consumers times annual frequency, and GMV equals transactions times blended average order value. - Merchant income is GMV multiplied by a weighted merchant discount rate, late fees are a GMV percentage, and long-term interest uses long-term GMV multiplied by duration divided by 365 and an APR. Two product types are covered: interest-free Pay-in-4 and interest-bearing longer-term credit, with a sample mix of 70% and 30% respectively. - Five merchant segments feed weighted AOV, MDR and loss rates. These assumptions are illustrative rather than market facts. ### Calculation Flow: Receivables, Losses and Funding Weighted product duration sizes closing receivables as annual GMV times days divided by 365. Losses apply a weighted current and prior-year GMV base, set at 70% and 30% by default, combined with a product-blended charge-off rate. - Repayments are the balancing movement to the target closing book. Senior and mezzanine drawn debt are set by receivables multiplied by an advance rate, and capacity applies a further multiplier. - Interest uses average drawn balances, while commitment fees use average undrawn amounts. Completed schedules then feed the statements, returns and KPIs. ### Outputs: Statements, KPIs and Equity Returns Operating costs use headcount and loaded costs, support density, variable acquisition cost and fixed brand spend. Software capex is a revenue percentage with straight-line amortisation. - Equity cash flows combine operating and investing cash flows with net borrowing, and terminal equity value uses a terminal revenue multiple and exit net debt. IRR and NPV use Day 0 equity and annual cash flows. - The Dashboard shows final-year GMV, take rate, receivables, consumers and margins, while KPIs include CAC, LTV and a net interest margin definition. Checks test balances, cash and coverage. ### Practical Use and Documented Boundaries The template is designed for fintech operators and debt capital providers evaluating BNPL unit economics and funding needs. Inputs are directly adjustable, but there is no dedicated case selector or sensitivity grid. - Receivables are an annual duration proxy and repayments are back-solved, so there is no individual instalment schedule, delinquency transition matrix or expected-loss allowance rollforward. Consumer churn is used for LTV, not subtracted from the active-user growth formula. - LTV is annual net transaction margin per consumer divided by churn. Net transaction margin excludes disputes and commitment fees. Facility capacity grows with receivables rather than imposing a fixed external borrowing limit. The public download is a values-only preview, not a live calculator. ## Built for BNPL unit economics Use this model when merchant take rates, default curves, and cost of funds drive the profitability equation. ## Designed around lending cohort logic A useful BNPL model tracks origination vintages and repayment curves so credit quality and capital needs are visible over time. ## Better for capital planning and debt raising This gives you the granularity lenders and investors need to evaluate advance rates, portfolio yield, and funding requirements. ## Built for BNPL unit economics Use this model when merchant take rates, default curves, and cost of funds drive the profitability equation. ## Designed around lending cohort logic A useful BNPL model tracks origination vintages and repayment curves so credit quality and capital needs are visible over time. ## Better for capital planning and debt raising This gives you the granularity lenders and investors need to evaluate advance rates, portfolio yield, and funding requirements. ## Features - **Cohort-based unit economics:** Track each customer cohort from acquisition through churn, with default and repayment timing, to calculate true LTV and payback. - **Funding structure flexibility:** Model warehouse line, securitization, and equity funding separately with their respective costs and pricing power. - **Default and loss modeling:** Use cohort-specific default rates and recovery timing to forecast loan loss reserves and funding requirements. ## Use cases - **Series A/B fundraising:** Show investors path to unit economics profitability and outline capital efficiency metrics. - **Merchant pricing and incentive strategy:** Determine optimal take-rate and cashback/discount programs to acquire merchants and volumes. - **Funding and capital planning:** Forecast funding needs by quarter and evaluate warehouse vs. securitization costs. ## Frequently asked questions ### What is a BNPL financial model? It is a model that forecasts origination volume, revenue from merchant fees and late charges, credit losses, and cost of capital for a Buy Now, Pay Later platform. ### Who uses BNPL models? Fintech founders, debt facility providers, venture capital investors, and credit risk teams use them for planning and capital raising. ### What should a BNPL model include? It should include GMV, merchant discount rates, repayment curves, default vintage tracking, debt facility mechanics, and unit economics. ### Does it track defaults by cohort? Yes. The model uses cohort-based vintage curves to track non-performing loans and charge-offs as origination volume scales. ### Can I model different repayment schedules? Yes. The model supports configurable repayment curves for standard pay-in-four schedules as well as longer-term instalment loans. ## Related templates - [Fintech Payments Platform Model](https://finamodel.com/templates/fintech-payments-model) - [Credit Card Portfolio Model](https://finamodel.com/templates/credit-card-model) - [Auto Loan Portfolio Model](https://finamodel.com/templates/auto-loan-model)