Microfinance Institution Model
Credit Financial Model (Free Excel Download)
Forecast a microfinance institution’s loan book, branches, officers, funding, capital adequacy, and operating self-sufficiency across products and borrower groups.
professionals from Deloitte
Used by professionals from
About this model
A microfinance institution (MFI) model projects the financial profile of a lender to underbanked borrowers - small ticket, short tenor, with a portfolio split between group (solidarity / village-bank) and individual loans. The two products have different yields, different average loan sizes, and different credit profiles, but in this template they share a single roll-forward: opening loan book → grow at a target growth rate → write-offs (negative) → net new disbursements (the plug) → closing loan book. Average balance flows into interest income; net new disbursements drive upfront fee income. Blended yield is portfolio-mix-weighted.
Provisions are computed as average loan book × PAR > 30 days × LGD, so the income statement reflects expected credit losses rather than just realised write-offs. Branch operations scale separately: branches grow at a steady annual pace, loan officers scale with branches, and active loan count is derived from group and individual outstanding divided by average loan size. The officer-utilisation line surfaces the point where productivity becomes the binding constraint on book growth. Operating expense splits into branch cost, loan-officer compensation, and HQ overhead that grows with inflation.
Funding is sized from the loan book - deposits and debt as ratios of book - and equity is the balancing plug, accumulating retained earnings on top of opening equity. Risk-weighted assets equal the loan book times a density assumption (so a 75% density on a $100M book gives $75M of RWA), and the capital adequacy ratio (equity / RWA) is compared against a target minimum. The Returns sheet then reports the headline ratios institutional investors and regulators care about: ROA, ROE, net interest margin, cost-to-income, operating self-sufficiency (OSS - revenue divided by all costs), PAR ratio, provision coverage, and per-branch productivity. The Checks sheet verifies the balance equation, sign of the loan book and CAR, the bound on PAR, and that the product mix sums to one.
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 Microfinance Institution Model
- Portfolio mix between group and individual lending with separate yields and average loan sizes
- Loan book roll-forward: opening, growth-driven target close, write-offs, net new disbursements, average balance
- Branch and officer build-out with utilisation against active loan count
- Income statement with interest income, upfront fees, deposit and debt funding cost, loan-loss provisions, tax
- Funding mix sized from the loan book - deposits, debt, retained earnings - with capital adequacy versus a target
- Returns sheet: ROA, ROE, NIM, cost-to-income, OSS, PAR ratio, provision coverage, per-branch productivity
- Checks sheet - funding balance, loan-book sign, PAR bound, CAR sign, mix sum
Microfinance Institution Model: How the Template Works
This microfinance institution model projects a seven-year financial profile for an MFI, covering group and individual loan products, branch capacity, funding mix, capital adequacy and social performance. The underlying specification shows how portfolio dynamics, expected credit losses and balance-sheet mechanics link together.
This page explains the key operating drivers, calculation flow and outputs so you can evaluate whether the template fits your analysis.
What Drives the Model
The model is driven by a compact set of operating assumptions that feed every sheet. Loan growth, per-product yields and turnover-based disbursements determine the loan book.
- Branch capacity is driven by active loans, loans per officer and a utilisation target; required branches are calculated as the ceiling of active loans divided by officer capacity, with a minimum opening constraint. Funding assumptions include sight and term deposit rates, wholesale debt mix and scenario shocks.
- Equity injections and dividend payout round out the capital drivers. A scenario selector toggles between base, PAR shock, rate shock and growth shock, adjusting loss and funding parameters dynamically.
How Calculations Flow
The calculation flow begins with the loan book roll-forward: closing book equals opening plus net disbursements minus write-offs. Gross disbursements are turnover-based, using average tenor to determine how often the portfolio revolves.
- IFRS-9 provides a staged allowance: Stage 1 for performing loans, Stage 2 for 30–90 day past due, and Stage 3 for 91+ days, each with different loss assumptions. Provision expense reconciles the allowance roll with write-offs and recoveries.
- Interest income uses average loan balances, while wholesale debt interest uses opening balances to avoid circular references. This symmetry maintains consistency across the income statement and balance sheet.
What the Model Outputs
Outputs include a full balance sheet, income statement and indirect cash flow statement. The returns section reports ROA, ROE, net interest margin, risk-adjusted NIM, cost-to-income, operational self-sufficiency and financial self-sufficiency, alongside portfolio yield, effective borrower cost and yield gap.
- Branch economics and per-product net interest income contribution are also shown. The KPI sheet covers social performance such as active borrowers, percentage of women and rural clients, average loan to GNI and retention, plus Basel-style capital ratios (Tier 1, Tier 2, total CAR, headroom) and liquidity metrics.
- A checks sheet validates balance sheet balancing, cash tie, equity roll and allowance roll.
Practical Use and Scope
Practically, the template helps assess whether an MFI becomes operationally self-sufficient and how capital adequacy evolves under different credit and funding conditions. The scenario selector allows quick switching between base, PAR shock, rate shock and growth shock to observe the impact on profitability and capital.
- Sensitivity analysis provides static deltas to year-three net income for PAR doubling, a 200 basis point funding rate shock and a five percentage point growth reduction. The model is built for a single MFI over seven years, with quarterly or annual periods as assumed.
- Downloadable previews are values-only, so formulas do not recalculate; the description here covers the underlying logic. Users should adapt assumptions to their own context.
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 microfinance institution model?+
It is a lender model for an MFI - a financial institution that originates small, short-tenor loans to underbanked borrowers, usually split between group (solidarity / village-bank) and individual lending. The model projects the loan book, branch economics, funding mix and capital adequacy over a multi-year horizon.
Does it cover both group and individual lending?+
Yes. Portfolio mix percentages plus per-product yields and average loan sizes drive a blended yield. Set Group Loans to 100% to model a pure group MFI, or invert to model an upmarket individual-lender.
How are provisions calculated?+
Provisions = average loan book × PAR > 30 days × loss-given-default. PAR captures the at-risk balance, LGD converts it into expected loss. Write-offs are a separate, smaller flow on the loan book itself.
Why is the capital adequacy ratio so high in the default run?+
The model balances funding by deriving retained earnings as the plug, on top of opening equity. With deposits and debt sized off the loan book, equity ends up roughly 30% of assets - high by commercial-bank standards but realistic for an MFI building capital before scaling debt.
Can I extend the horizon beyond seven years?+
Yes - the builder is parameterised by NUM_PERIODS. Bump it and rerun and every sheet reflows.
Have more financial modelling questions? Contact us
Related templates
Direct Lending Fund Model
Financial model for direct lending fund with loan origination, yield, losses, and fund returns.
Bank Loan Analysis Model
Commercial bank loan origination and portfolio underwriting.
Loan Portfolio CDR Model
Credit default risk model for loan portfolios with cumulative default rates and loss severity analysis.
Auto Loan Portfolio Model
Automotive loan securitization and portfolio analysis.
