Neobank Operating Model

Banking Financial Model (Free Excel Download)

Forecast neobank growth from customers, deposits, card spend, interchange, lending balances, net interest margin, credit losses, operating costs, and funding needs.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model helps you plan a digital bank from customer acquisition through deposits, lending, revenue, costs, and capital. It shows how changes in growth, retention, lending activity, and product mix affect profitability over time.

Use it to test the trade-offs between investing for growth and maintaining a healthy capital position. It is built for founders, finance teams, investors, and anyone evaluating a digital banking business.

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 Neobank Operating Model

  • Customer cohort panel: new customers, annual churn, deposit / loan / fee per customer for Y1-Y5
  • Rate block: loan rate, deposit rate, central-bank policy rate, cost of risk basis-points charge
  • Customers sheet with opening, new, churned, closing, average, cumulative acquired
  • Balance sheet: Loans, Cash (Central Bank residual), Customer Deposits, Equity rollforward, Total Assets and L+E
  • Income statement: NII (loan interest + cash yield − deposit interest), Fee Income, CAC, Opex, Loan Loss, Tax, Net Income
  • Cash flow statement: CFO from Net Income, CFI on loan and deposit growth, CFF from equity raise, closing cash
  • Capital sheet: RWA at 75% retail risk weight, CET1 actual %, CET1 minimum, CET1 buffer in pp
  • Returns: Net Interest Margin, Cost-to-Income, ROA, ROE, CAC payback months, customer LTV, LTV/CAC

Neobank Operating Model: Customer Cohorts, Net Interest Margin and Capital

This neobank model projects a digital challenger bank from launch to Year 5, linking customer acquisition and churn to deposit and loan balances, revenue, costs and regulatory capital. It is built for founders, finance teams and investors who need to test how growth, lending mix and equity raises interact before committing to a plan.

How Customer Growth and Balances Drive the Business

The operating engine begins with customer cohorts: each year adds a count of new customers, an annual churn rate is applied, and a closing customer count is derived. Cumulative acquired customers are tracked alongside closing customers.

  • Per-customer deposit and loan balances then scale with that closing count, so balance sheet size follows acquisition and retention rather than being set independently. Fee income per customer is also applied to the average customer base.
  • The specification shows the deposit-to-loan ratio narrowing over time, from a deposit-heavy starting point toward a more balanced relationship as lending layers on. That progression matters because it shifts the earnings mix from fee and cash yield toward interest income, while also increasing risk-weighted assets and the capital needed to support them.

From Balances to Profit: Revenue, Costs and Provisions

Revenue is assembled from net interest income plus fee income. Interest income is calculated on average loans at a loan rate, interest expense on average deposits at a deposit rate, and cash held at the central bank earns a policy rate.

  • Fee income is average customers multiplied by fee per customer. Costs are split into customer acquisition spend, fixed operating costs that grow at a declining rate, variable operating cost per customer, and a loan-loss provision charged as a percentage of average loans.
  • Pre-tax profit subtracts all of these from revenue, and tax is applied only when pre-tax profit is positive, so losses do not generate a tax shield in the model.

Balance Sheet and Capital Adequacy

The balance sheet derives deposits and loans from closing customers and per-customer balances. Risk-weighted assets apply a uniform retail risk weight to loans, while cash is the residual funding after loans and earns the policy rate without a credit risk weight.

  • Equity rolls forward from an initial founding raise, adding net income and any scheduled equity raise. The capital section calculates CET1 required as risk-weighted assets multiplied by a minimum ratio, CET1 actual as equity divided by risk-weighted assets, and the buffer as the difference.
  • The model assumes equity is the only CET1 capital source, so a growing loan book can erode the buffer and require a raise to stay above the minimum.

Returns, Scenarios and Validation

The returns view summarises net interest margin, cost-to-income, return on assets, return on equity, customer acquisition cost payback and lifetime value to acquisition cost, using the model's own revenue and cost relationships.

  • A scenario selector applies a scalar to new-customer counts for base, bull and bear cases, which changes cumulative customers and the pace of capital consumption.
  • Validation checks confirm that the balance sheet balances, customer counts reconcile with cohort arithmetic, terminal CET1 is above the minimum, net interest margin sits in a plausible range, cumulative customers never decrease, and scheduled equity injections appear when equity grows.
  • Together these give a structured way to test growth and capital trade-offs.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

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.

Alex Tapio, ex-Deloitte financial modelling expert

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 neobank operating model?+

A neobank operating model is a 3-statement plus capital-adequacy forecast for a digital-only bank (Revolut, Monzo, Starling, N26, Bunq, Chime). It translates customer cohort acquisition into the bank balance sheet, then runs the income statement on Net Interest Margin and Cost-to-Income, and verifies the CET1 capital ratio stays above the Basel IV minimum across the projection.

Why does cash yield use opening (not average) cash?+

Average cash creates a circular dependency: BS Cash depends on Equity Close, which depends on Net Income, which depends on Cash Yield, which would depend on average BS Cash. Using opening cash (Initial Equity in Year 1, prior closing thereafter) breaks the loop cleanly without an iterative calculation toggle. This is the institutional convention for bank operating models.

How is RWA computed?+

Risk-weighted assets equal loan balance times a 75% retail risk weight (Basel IV standardised approach). Cash held at the central bank carries a zero risk weight in this stylised model - earning the policy rate but consuming no capital. A more granular model would split RWA by product (mortgages 35%, SME 75%, unsecured 100%).

What does the scenario selector do?+

Scenario_Sel (1=Base, 2=Bull, 3=Bear) runs a CHOOSE() over three customer-acquisition scalars (1.00x, 1.25x, 0.75x). The selected scalar multiplies every year new customer count. Flipping the cell on Assumptions recomputes the entire model in one keystroke.

Can I extend it to multi-currency or banking-as-a-service?+

Not directly. The template is single-currency USD with one blended loan product, one blended fee per customer, and equity as the only CET1 source (no AT1 / Tier 2 issuance). To layer banking-as-a-service, add a non-customer revenue line (API call volume × take rate) on the income statement and a deferred-revenue working-capital item if invoicing on contracted MRR.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview