BNPL Model
Credit Financial Model (Free Excel Download)
Forecast buy-now-pay-later originations, merchant fees, repayment curves, credit losses, funding costs, and cohort profitability across customer and product scenarios.
professionals from Deloitte
Used by professionals from
About this model
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 every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the BNPL Model
- 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
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.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
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.
Have more financial modelling questions? Contact us
Related templates
Fintech Payments Platform Model
Unit economics model for payments fintech with transaction volume, take rate, and customer cohorts.
Credit Card Portfolio Model
Model credit card loan losses, interest revenue, and regulatory capital requirements.
Auto Loan Portfolio Model
Automotive loan securitization and portfolio analysis.
Student Loan Portfolio
Model a portfolio of student loans with origination, repayment schedules, and default assumptions.
