Credit Card Model
Banking Financial Model (Free Excel Download)
Model card balances, purchase volume, revolving interest, interchange, charge-offs, funding costs, and customer acquisition to forecast portfolio yield and returns.
professionals from Deloitte
Used by professionals from
About this model
This credit card issuer model projects a credit card portfolio's growth, revenue generation, credit losses, and profitability. It forecasts active cardholder accounts by tier (prime, near-prime, subprime), average credit limits, utilisation rates, and revolving balances; then calculates interest income (average revolving balance × APR), interchange (purchase volume × interchange rate, a separate metric from interest), annual member fees, and late fees. Credit losses are modelled using CECL (Collective Expected Credit Loss) methodology: gross charge-off rates (4–6% through-cycle), loss severity (70% unsecured), recovery lag (12 months), and an allowance for credit losses that grows with the loan book.
The model includes a cardholder portfolio builder tracking accounts by cohort, spend per account, payment rate (fraction of balance repaid monthly), and revolving balance; a revenue schedule separating interest, interchange, fees, and late charges; a credit loss schedule with CECL allowance roll-forward (opening + provision − net charge-offs = closing = target rate × closing loans); an operating expense section covering customer acquisition cost, servicing cost per account, technology, and G&A; and a warehouse debt schedule showing debt drawn as advances of 80% of gross loans. A three-statement output includes income statement, balance sheet (with net loans = gross loans − allowance), and cash flow statement (using single net receivables line, no separate provision add-back).
This model is used by credit card issuer finance teams managing portfolio performance, lenders sizing warehouse facilities, private equity investors evaluating issuer acquisitions, and regulators assessing capital adequacy. It is critical for fintech lending platforms and non-bank issuers building financial infrastructure for the first time.
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 Credit Card Model
- Revenue segmentation across interchange, interest income, and fees
- Transactor vs revolver behavioural modelling
- Vintage-based loss forecasting and credit provisioning
- Warehouse facility and cost of funds mechanics
- Unit economics and portfolio yield outputs
- Loan originations by credit tier and vintage
- Monthly default and loss severity assumptions by FICO band
- Interest revenue and finance charges by product
Inside the Credit Card Model: How a Card Issuer's Economics Fit Together
This credit card model shows how a card issuer's accounts, spend, and balances drive revenue, losses, funding, and cash over a five-year horizon. It links portfolio behaviour to a three-statement structure with credit-loss provisioning and capital checks, so you can see how the business relationships move together rather than reading a single static forecast.
What Drives the Issuer's Economics
The model starts from account behaviour rather than a single revenue growth rate. Accounts in force, average credit limit, utilisation, and the share of balances that revolve determine gross loans, while annual spend per account runs separately because interchange accrues on purchase volume regardless of whether balances are repaid.
- Risk-tier segmentation lets each tier carry its own mix, pricing, loss, utilisation, and spend assumptions, so the portfolio figures are weighted aggregates. Annual fees and late fees follow smaller, distinct drivers.
- That separation matters because treating spend and repayment as one behaviour misstates both interest and interchange.
How Revenue and Losses Are Calculated
Interest income is built as average gross loans times the APR, with average balances taken across opening and closing positions.
- Interchange applies a likely rate range to annual card spend; annual fees apply to the fee-bearing share of accounts; late fees apply to the share of accounts incurring them.
- On the loss side, net charge-offs run off average gross loans, while the CECL allowance is rolled forward so closing allowance equals a coverage rate applied to closing gross loans, with the income-statement provision absorbing new originations and any change in expected loss.
Funding, Capital, and Cash Flow Outputs
Funding is split across warehouse and ABS tranches, with total funded debt set by gross loans times an advance rate. Interest expense applies only to that debt-funded portion, which avoids overstating cost by charging the equity-funded haircut.
- Because debt tracks the loan book, financing cash flow is the period-on-period change rather than a scheduled repayment. Equity must cover the unfunded share of loans, so retained earnings and any injections are checked against that requirement.
- The cash flow statement uses a single change-in-net-receivables line for loan movements.
Where the Model Is Most Useful
This model is useful for evaluating growth versus capital intensity: faster balance growth consumes cash and requires more equity to fund the haircut, even when reported revenue rises.
- It also helps test how pricing, tier mix, and credit performance interact with funding cost and net interest margin.
- The outputs include PPNR, capital ratios, and coverage measures, backed by automated checks on balance-sheet integrity, allowance targeting, and debt tracking.
- Note that the public download is a values-only preview, not a live formula workbook, so use it to understand structure and relationships before building.
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 credit card financial model?+
It is a model that forecasts portfolio performance including interchange revenue, interest income, credit losses, and net interest margin for a credit card programme.
Who uses credit card models?+
Fintechs, neobanks, traditional lenders, and credit risk teams use them for programme planning, capital raising, and yield optimisation.
What should a credit card model include?+
It should include revenue by type, cardholder behaviour assumptions, vintage-based loss curves, provisioning, and cost of funds mechanics.
Does it handle transactors and revolvers separately?+
Yes. The model applies behavioural logic to distinguish between users who pay in full and those who carry a balance, driving different revenue profiles.
Can it support warehouse lending analysis?+
Yes. The model includes debt funding logic with advance rates and benchmark rate spreads to calculate true net interest margin.
Have more financial modelling questions? Contact us
Related templates
Auto Loan Portfolio Model
Automotive loan securitization and portfolio analysis.
Bank Loan Analysis Model
Commercial bank loan origination and portfolio underwriting.
Mortgage Portfolio Model
Mortgage loan portfolio analysis with prepayment speeds, default rates, and cash flow projections.
Bank Capital Adequacy Model
Regulatory capital calculations and stress testing for banks.
