Pawn Shop Model
Consumer Financial Model (Free Excel Download)
Model pawn-shop performance from loan originations, collateral value, redemption rates, merchandise sales, inventory turns, loss rates, staffing, and store cash flow.
professionals from Deloitte
Used by professionals from
About this model
This model helps you understand a pawn shop that earns from both short-term loans and the sale of unredeemed collateral. It connects loan volume, ticket size, redemption behaviour, and retail sales to the cash tied up in the pledge book and inventory.
Use it to test pricing, store growth, customer demand, and funding needs. The summary shows how those choices affect margin, cash flow, and business value.
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 Pawn Shop Model
- Store network inputs: Year-1 stores, new stores per year, pledge loans per store, average ticket, ticket growth
- Pawn service charge tiers: tier 1 monthly rate, tier 1 principal cap, tier 2 monthly rate, weighted months on loan
- Redemption & forfeiture: redemption rate, scrap share of forfeits, retail markup, melt recovery, ancillary fee per loan, fee escalation
- Cost structure: associates per store, associate wage, store manager comp, corporate FTE and comp, benefits and wage growth
- Overhead: occupancy & rent, security & compliance, utilities, marketing and G&A as % of gross profit; inventory shrink; depreciation (% of revenue)
- Tax: blended corporate rate on EBIT
- Capital and working capital: maintenance capex %, new-store buildout cost, pledge book life, inventory months on hand, base-year working capital
- Valuation: WACC, terminal growth, net debt, shares outstanding
How the Pawn Shop Financial Model Works: Lending Yield, Forfeiture Inventory and Valuation
This pawn shop financial model template projects a small pawnbroking chain over seven years. It connects store openings to pledge loans, applies a statutory tiered rate schedule to set blended monthly yield, splits loans between redemption and forfeiture, routes forfeited collateral to retail or melt, and values the unlevered cash flows.
The public download is a values-only preview; the underlying model captures the full relationships.
Stores, Pledge Volume and Average Ticket
The model builds the store estate by rolling opening stores plus new openings to get closing stores.
- Each store writes a fixed number of pledge loans per year, so total loans written scale directly with the estate.
- The average ticket, or principal advanced per loan, grows as collateral values rise, because a broker lending a consistent loan-to-value against a more valuable pledge writes a larger loan.
- One mechanic ties these drivers together: the ticket interacts with the statutory rate tiers that price the loan book, so ticket growth is a first-class input rather than an assumed uplift.
Statutory Tiered Rates and Blended Monthly Yield
Pawn service charges are set by state statutes that apply a high monthly rate to the first slice of principal and a lower rate to everything above it. The model computes principal in each tier and takes a principal-weighted blend to get the blended monthly rate applied to the redeemed book.
- When the average ticket sits entirely inside the tier-1 cap, the blend equals the tier-1 rate. As the ticket grows beyond that cap, a larger share of each loan earns only the lower tier-2 rate, so blended monthly yield compresses over time without any change in posted pricing.
- This yield is tracked as a headline KPI and a dashboard trend, reflecting how collateral appreciation can erode lending economics.
Redemption, Forfeiture and Two Revenue Engines
Each originated loan is split between redemption and forfeiture. Pawn service charges are earned only on redeemed principal, calculated as redeemed principal times the blended monthly rate times months on loan.
- The forfeited principal becomes the cost basis of the merchandise business: part goes to a refiner for melt recovery and part to the retail floor at a markup. Because higher forfeiture shrinks the interest-earning book while growing the retail book, the two engines offset each other, which helps explain why pawnbrokers tend to be relatively indifferent to redemption rates within a normal band.
- Cost of goods sold is derived directly as forfeited principal, not as a margin assumption.
Cash Flow, Working Capital and Valuation
The model produces an unlevered free cash flow bridge: NOPAT plus depreciation, less capex and the change in working capital. Working capital is the pledge loan book plus merchandise inventory, so growth in loans or inventory consumes cash.
- That means a fast-growing chain can report net income while free cash flow is negative, because cash is tied up in the pledge book and on the retail shelf. Capex includes maintenance and new-store buildout.
- Free cash flows are discounted at a WACC with a terminal growth rate to estimate enterprise value, then net debt is subtracted to arrive at equity value and value per share. A dashboard summarises stores, loans, average ticket, blended yield, revenue, EBITDA, margins, enterprise value and value per share.
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 pawn shop financial model?+
A pawn shop financial model captures the seven-year operating economics and intrinsic value of a pawnbroking chain. It rolls a store estate forward, converts store count into pledge loans written, inflates an average ticket at the rate its collateral appreciates, and prices the book against a statutory tiered rate schedule. Every loan then splits: redeemed pledges earn a pawn service charge, while forfeited pledges become merchandise at exactly the principal advanced, which is sold on a retail floor at a markup or melted at a refiner recovery. It charges labour, a gross-profit-geared overhead stack and an inventory shrink provision to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.
Why is the pawn service charge modelled as a tiered rate?+
Because that is how pawn statutes actually work. Rather than a single capped rate, states typically set a high monthly rate on the first slice of principal and a lower rate on everything above it. Modelling a single blended rate misses the economics entirely: as collateral values inflate the average ticket past the statutory break, a growing share of every loan earns only the cheaper tier, so the blended monthly yield compresses even though the shop never changes its pricing. The model computes both tier bases as visible rows, takes the principal-weighted blend, and surfaces the resulting yield as a headline KPI and a dashboard trend line.
Why is cost of goods sold the forfeited principal?+
Because that is what the merchandise actually cost. When a customer does not redeem a pledge, the shop keeps the collateral, and the cash it handed over at the counter is the cost basis of the goods now on its shelf. Deriving cost of goods sold as the forfeited principal rather than asserting a retail margin means merchandise gross margin falls out of loan-to-value and disposition mix instead of being an input. Service charges and ancillary fees carry no cost of goods at all, which is why blended gross margin sits near seventy-six percent.
Why is Year-1 free cash flow negative when the business is profitable?+
Because a pawn shop funds its own growth out of cash. Working capital in this model is the pledge loan book plus merchandise inventory, not a percentage of revenue growth, so every incremental loan on the book and every forfeit on the shelf is cash out the door. In the base case working capital grows from $2.24M to $5.90M across the horizon, which is enough to make Year-1 unlevered free cash flow negative despite $628k of net income. It turns positive from Year 2 as the book growth decelerates relative to earnings.
Have more financial modelling questions? Contact us
Related templates
Retail Store Model
Plan and value a retail-store chain using new stores, customer traffic, sales, inventory, and operating costs.
Microfinance Institution Model
MFI model with loan book roll-forward by product, branch ops, funding mix, capital adequacy, and return ratios.
Credit Card Portfolio Model
Model credit card loan losses, interest revenue, and regulatory capital requirements.
E-Commerce Unit Economics
P&L model for e-commerce business with CAC, LTV, gross margin, and unit economics.
