# Neobank Operating Model

See how customer growth, lending, deposits, and operating costs shape a digital bank's path to profitability.

- Canonical: https://finamodel.com/templates/neobank
- Excel download: https://finamodel.com/templates/neobank.xlsx
- Category: Banking
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: CFOs & FP&A, Founders & operators, Neobank founders, Fintech investors, Bank CFOs, Regulatory teams
- Tags: neobank, challenger bank, fintech, nim, cet1

## Overview

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's included

- 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
- Equity raise schedule with per-year input row (default Y3 and Y5 raises to defend CET1)
- Scenario selector (Base 1.00x, Bull 1.25x, Bear 0.75x) on customer acquisition via CHOOSE
- Six validation checks: BS balances Y1 and Y5, CET1 above minimum, NIM in range, customers monotonic, equity injection in CFF
- Customers sheet: opening, new, churned, closing, average, cumulative acquired
- Balance sheet: Loans, Cash (Central Bank), Customer Deposits, Equity rollforward, Total Assets and L+E
- Income statement: NII, Fee Income, Revenue, CAC, Opex (fixed and variable), Loan Loss Provision, PBT, Tax, Net Income
- Returns: Net Interest Margin, Cost-to-Income, ROA, ROE, CAC payback, customer LTV, LTV/CAC
- Six validation checks tying the balance sheet, CET1, NIM, and equity injection

## 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.

## Built for the founder-to-Series-D arc

When the question is "at what scale does the unit economic flip from CAC-heavy loss to NII-funded operating leverage, and what equity raise keeps the bank above the regulator capital floor?", a clean cohort build plus a Basel-IV CET1 view is the answer. This template hands a founder, board, or fintech investor a one-page bridge from customer acquisition to capital adequacy.

## Designed for one-edit responsiveness

Every input - new customers per year, churn, deposit / loan / fee per customer, CAC, fixed opex, raise schedule - is a named-range cell or a per-year input row. Edit one and the customer cohort, balance sheet, income, capital, and returns all recompute. No formula rewrites needed to test a different growth trajectory or fee structure.

## Honest about cash interest circularity

Cash yield uses opening (prior-period closing) cash, not average - breaking the classic 3-statement circular dependency between cash interest, net income, and equity. Year 1 uses Initial Equity as opening cash because the founding raise sits as cash before deposits or loans arrive. No iterative calculation toggle needed.

## Built for the founder-to-Series-D arc

When the question is "at what scale does the unit economic flip from CAC-heavy loss to NII-funded operating leverage, and what equity raise keeps the bank above the regulator capital floor?", a clean cohort build plus a Basel-IV CET1 view is the answer. This template hands a founder, board, or fintech investor a one-page bridge from customer acquisition to capital adequacy.

## Designed for one-edit responsiveness

Every input - new customers per year, churn, deposit / loan / fee per customer, CAC, fixed opex, raise schedule - is a named-range cell or a per-year input row. Edit one and the customer cohort, balance sheet, income, capital, and returns all recompute. No formula rewrites needed to test a different growth trajectory or fee structure.

## Honest about cash interest circularity

Cash yield uses opening (prior-period closing) cash, not average - breaking the classic 3-statement circular dependency between cash interest, net income, and equity. Year 1 uses Initial Equity as opening cash because the founding raise sits as cash before deposits or loans arrive. No iterative calculation toggle needed.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: scenario selector, macro and capital, customer cohort panel, rates, costs, raise schedule.

- Scenario_Sel (1=Base, 2=Bull, 3=Bear)
- Start year, initial equity, CET1 minimum, retail risk weight, tax rate, LTV discount rate
- Cohort: new customers, churn, deposit / loan / fee per customer (Y1-Y5)
- Rates: loan rate, deposit rate, policy rate, cost of risk
- Costs: CAC, variable opex per customer, fixed opex Y1, opex growth
- Per-year equity raise schedule (Y1-Y5)
- Scenario scalars and active scalar derived via CHOOSE

### Customers

Cohort acquisition with churn arithmetic and cumulative acquired.

- New customers (scaled by Active_Scalar)
- Annual churn rate
- Opening, churned, closing customers per year
- Average customers (opening / closing mean)
- Cumulative acquired across all years

### Balance_Sheet

Stylised bank balance sheet with deposit-funded cash residual.

- Cash (Central Bank) = Equity + Deposits − Loans (residual that makes BS balance by construction)
- Loans = closing customers × loan per customer
- Customer Deposits = closing customers × deposit per customer
- Equity rollforward: Opening + Net Income + Equity Raise
- Risk-weighted assets = Loans × 75% retail risk weight

### Income_Statement

NII plus fees through to tax-adjusted net income.

- Interest Income = avg loans × loan rate
- Cash Yield = opening cash × policy rate (no circular dependency)
- Interest Expense = avg deposits × deposit rate
- Fee Income = avg customers × fee per customer
- Costs: CAC (new × CAC), Fixed Opex (compounding), Variable Opex (closing × per-cust), Loan Loss Provision (avg loans × cost of risk)
- Pre-Tax Profit, Tax (positive PBT only), Net Income

### Cash_Flow

CFO, CFI, CFF, closing cash with bank-specific deposit-funding treatment.

- CFO = Net Income
- CFI = −Change in Loans + Change in Deposits (deposit funding lumped here so cash residualises cleanly)
- CFF = Equity Raise from the schedule
- Net Change in Cash and closing cash roll forward from opening (Initial Equity at Y1)

### Capital

Regulatory capital adequacy against the Basel IV minimum.

- Risk-Weighted Assets per year
- CET1 Required = RWA × 10.5%
- CET1 Actual = Equity / RWA
- CET1 Minimum (10.5%) for reference
- CET1 Buffer in basis points (positive = passing)

### Returns

Year-5 NIM, Cost-to-Income, ROE, payback and LTV/CAC plus Y5 composition.

- Net Interest Margin (Y5) = NII / earning assets
- Cost-to-Income (Y5) = total cost / revenue
- Return on Assets and Return on Equity (Y5)
- CAC Payback in months at Y5 unit economics
- Customer LTV = discounted lifetime contribution at Y5 mix
- LTV / CAC ratio
- Composition: closing customers, deposits, loans, equity, cumulative NI, total raised

### Checks

Six cross-sheet validation checks.

- Balance sheet balances at Y5 (Assets = L+E)
- Balance sheet balances at Y1
- CET1 above minimum at Y5
- NIM in plausible 0-10% range
- Cumulative customers monotonic non-decreasing
- Equity injection in CFF matches raise schedule total

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: scenario selector, macro and capital, customer cohort panel, rates, costs, raise schedule.

- Scenario_Sel (1=Base, 2=Bull, 3=Bear)
- Start year, initial equity, CET1 minimum, retail risk weight, tax rate, LTV discount rate
- Cohort: new customers, churn, deposit / loan / fee per customer (Y1-Y5)
- Rates: loan rate, deposit rate, policy rate, cost of risk
- Costs: CAC, variable opex per customer, fixed opex Y1, opex growth
- Per-year equity raise schedule (Y1-Y5)
- Scenario scalars and active scalar derived via CHOOSE

### Customers

Cohort acquisition with churn arithmetic and cumulative acquired.

- New customers (scaled by Active_Scalar)
- Annual churn rate
- Opening, churned, closing customers per year
- Average customers (opening / closing mean)
- Cumulative acquired across all years

### Balance_Sheet

Stylised bank balance sheet with deposit-funded cash residual.

- Cash (Central Bank) = Equity + Deposits − Loans (residual that makes BS balance by construction)
- Loans = closing customers × loan per customer
- Customer Deposits = closing customers × deposit per customer
- Equity rollforward: Opening + Net Income + Equity Raise
- Risk-weighted assets = Loans × 75% retail risk weight

### Income_Statement

NII plus fees through to tax-adjusted net income.

- Interest Income = avg loans × loan rate
- Cash Yield = opening cash × policy rate (no circular dependency)
- Interest Expense = avg deposits × deposit rate
- Fee Income = avg customers × fee per customer
- Costs: CAC (new × CAC), Fixed Opex (compounding), Variable Opex (closing × per-cust), Loan Loss Provision (avg loans × cost of risk)
- Pre-Tax Profit, Tax (positive PBT only), Net Income

### Cash_Flow

CFO, CFI, CFF, closing cash with bank-specific deposit-funding treatment.

- CFO = Net Income
- CFI = −Change in Loans + Change in Deposits (deposit funding lumped here so cash residualises cleanly)
- CFF = Equity Raise from the schedule
- Net Change in Cash and closing cash roll forward from opening (Initial Equity at Y1)

### Capital

Regulatory capital adequacy against the Basel IV minimum.

- Risk-Weighted Assets per year
- CET1 Required = RWA × 10.5%
- CET1 Actual = Equity / RWA
- CET1 Minimum (10.5%) for reference
- CET1 Buffer in basis points (positive = passing)

### Returns

Year-5 NIM, Cost-to-Income, ROE, payback and LTV/CAC plus Y5 composition.

- Net Interest Margin (Y5) = NII / earning assets
- Cost-to-Income (Y5) = total cost / revenue
- Return on Assets and Return on Equity (Y5)
- CAC Payback in months at Y5 unit economics
- Customer LTV = discounted lifetime contribution at Y5 mix
- LTV / CAC ratio
- Composition: closing customers, deposits, loans, equity, cumulative NI, total raised

### Checks

Six cross-sheet validation checks.

- Balance sheet balances at Y5 (Assets = L+E)
- Balance sheet balances at Y1
- CET1 above minimum at Y5
- NIM in plausible 0-10% range
- Cumulative customers monotonic non-decreasing
- Equity injection in CFF matches raise schedule total

## Features

- **Customer cohort, not headline assumption:** New customers, churn, and per-customer balances are year-vector inputs - not a single annual growth rate. The model honestly reflects that a neobank's deposit-to-loan ratio narrows from 3.0x to 1.3x as the lending product layers on, the canonical neobank arc.
- **Basel IV CET1 against the regulatory minimum:** RWA uses the 75% standardised retail risk weight on the loan book. CET1 actual = Equity / RWA, plotted year-by-year against the 10.5% minimum, with the buffer in basis points. The default raise schedule defends CET1 at the Y3 and Y5 inflection points.
- **No circular cash interest:** Cash yield uses opening (prior-period closing) cash, not average - breaking the classic 3-statement circular dependency between cash interest, net income, and equity. Year 1 uses Initial Equity as opening cash because the founding raise sits as cash before deposits or loans arrive.

## Use cases

- **Founder pressure-test before Series A:** At what scale does the unit economic flip from CAC-heavy loss to NII-funded operating leverage? Flex the customer cohort and the CAC and watch the Y3 NIM and Cost-to-Income land on the institutional benchmark - Cost-to-Income under 50% by Y4.
- **Regulatory capital stress test:** Drop the Year-3 raise to zero and see CET1 crash through the 10.5% minimum by Y4. The model surfaces exactly when the capital floor binds and how much primary equity defends it through the projection terminal.
- **Investor diligence on the loan-product launch:** A deposit-only neobank earns the policy-rate spread on customer deposits. The loan-product launch lifts NIM from 0.5% to 4%+ but adds RWA and cost of risk. Edit Loan/Customer up or down and watch the NIM, the loan-loss provision, and the CET1 buffer all move together.

## Frequently asked questions

### 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.

## Related templates

- [Bank Capital Adequacy Model](https://finamodel.com/templates/bank-capital-adequacy-model)
- [Fintech Payments Platform Model](https://finamodel.com/templates/fintech-payments-model)
- [Bank Loan Analysis Model](https://finamodel.com/templates/bank-loan-model)