# Pawn Shop Model See how loan demand, redemptions, merchandise sales, and funding needs affect a pawn shop. - Canonical: https://finamodel.com/templates/pawn-shop - Excel download: https://finamodel.com/templates/pawn-shop.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Pawn shop owners and operators, Specialty finance investors, Consumer credit analysts, Lenders and acquirers - Tags: pawn-shop, pawnbroking, collateral-lending, tiered-rate, dcf ## Overview 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's included - 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 - Operations sheet: store roll-forward, pledge volume and ticket, the statutory tier split and blended rate, the redemption/forfeiture fork, the two disposition channels, pledge book and inventory, staff headcount, loans per FTE - Revenue sheet: pawn service charges, retail merchandise sales, scrap & melt sales, a merchandise subtotal, ancillary fees, total revenue - P&L sheet: revenue to net income with forfeited-cost COGS, the opex stack, margins, blended monthly yield, service-charge share, identity check - FCF sheet: NOPAT, depreciation add-back, maintenance and new-store capex, the working capital balance and its change, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, equity value, value per share, implied EV/EBITDA - Dashboard with stores, loans written, average ticket, blended monthly yield, revenue, EBITDA margin, service-charge share, EV, per share, revenue mix and an earnings waterfall ## 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. ## The pawn service charge is a statutory tiered rate State pawn statutes do not cap the charge with a single number. They set a high monthly rate on the first slice of principal and a lower rate on everything above it, so the model computes both tier bases as visible helper rows and takes the principal-weighted blend. The economic point is the compression: at the Year-1 ticket of $148 the whole loan sits inside the $150 tier-one cap, so the blended rate is exactly the 20.0% tier-one rate; from Year 2 the ticket crosses the break and a growing share of every loan earns only the 12% tier-two rate, dragging the blend to 17.72% by Year 7 without the shop ever changing its pricing. A pawnbroker's yield decays as its collateral appreciates, and the only defences are ticket mix or a statute change. ## Forfeiture is inventory, not a loss A pledge that is not redeemed does not write off. The shop keeps the collateral, whose cost basis is exactly the principal it advanced, so the model derives cost of goods sold as the forfeited principal itself rather than as revenue times one minus a margin. The disposition then splits between a retail floor at a 2.10x markup and a jewellery melt at a 1.35x refiner recovery, which makes merchandise gross margin a function of loan-to-value and mix rather than an assumption: lend less against the pledge and the retail spread widens mechanically. Service charges and ancillary fees carry no cost of goods at all, so blended gross margin sits near 76% and eases as the merchandise engine outgrows the lending one. ## Designed for one-edit responsiveness Every input, the store pipeline and loans per store, the average ticket and its growth, both statutory rates and the tier threshold, months on loan, the redemption rate, the scrap share, the retail markup and melt recovery, the full cost stack, book life and inventory months, capex, and the WACC, is a named-range cell. Edit one and the operations build, revenue, P&L, free-cash-flow bridge, valuation, and dashboard all recompute. No formula rewrites are needed to test a store opening, a statute change, a gold-price move, or a shift in redemption behaviour. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Dashboard Headline KPIs, a seven-year summary, trend charts, and an earnings waterfall. - KPI cards for stores, pledge loans written, average ticket and blended monthly yield - Revenue, EBITDA, EBITDA margin, the service-charge share, enterprise value and value per share - Seven-year operating summary that feeds every chart - Trend grid including the blended-yield compression line, plus a Revenue-to-Net-Income waterfall ### Assumptions Every driver in one sheet: stores, rate tiers, forfeiture, costs, tax, valuation. - Year-1 stores, new stores per year, pledge loans per store, average ticket and ticket growth - Tier 1 and tier 2 monthly rates, the tier 1 principal cap, and weighted months on loan - Redemption rate, scrap share, retail markup, melt recovery, ancillary fee and fee escalation - Associates per store, wages with benefits and growth, the percent-of-gross-profit overhead lines, shrink and depreciation - Corporate tax rate, maintenance capex, new-store buildout, book life, inventory months, base-year working capital - WACC, terminal growth, net debt, shares ### Operations Store roll-forward, the rate tiers, the redemption fork, and the loan book. - Opening plus new equals closing stores; closing stores times loans per store gives loans written - The average ticket inflates at collateral-value growth - Principal in tier 1 is the minimum of ticket and threshold; tier 2 is the excess above it - The blended monthly rate is the principal-weighted average of the two statutory rates - Originations split into redeemed and forfeited principal at the redemption rate - Forfeits route to the retail floor and to melt at the scrap share - Pledge loan book plus merchandise inventory equals working capital - Associate, store-manager and corporate headcount, with loans per FTE as a productivity metric ### Revenue Four revenue lines across lending, retail, scrap, and fees. - Pawn service charges equal redeemed principal times the blended monthly rate times months on loan - Retail merchandise sales equal forfeits routed to the floor times the retail markup - Scrap & melt sales equal forfeits routed to melt times the refiner recovery - A merchandise subtotal combines retail and scrap - Ancillary fees equal loans written times a per-loan fee, escalated annually ### P&L Revenue to net income with cost of goods derived from forfeited principal. - Cost of goods sold is the forfeited principal itself, not a margin assumption - Service charges and ancillary fees carry no cost of goods - Associate, store-manager and corporate labour loaded for benefits and escalated at wage growth - Occupancy, security & compliance, utilities, marketing and G&A geared to gross profit, plus inventory shrink - EBITDA, depreciation, EBIT, corporate tax, net income - Margins, the blended monthly yield, the service-charge share, and an identity check that resolves to zero ### FCF Unlevered free cash flow from EBIT to a discounted present value. - EBIT less unlevered tax equals NOPAT - Add back depreciation - Less maintenance capex and new-store buildout capex - Less the change in working capital, measured off the pledge book plus inventory balance - Unlevered FCF, discount factor and PV ### Valuation An unlevered DCF to enterprise value, equity value, and value per share. - Sum of explicit PV plus the PV of a Gordon-growth terminal value - Enterprise value less net debt equals equity value - Value per share and an implied EV/EBITDA multiple ## Features - **The pawn service charge is a statutory tiered rate:** State pawn statutes do not cap the charge with a single number. They set a high monthly rate on the first slice of principal and a lower rate on everything above it, so the model computes both tier bases as visible helper rows and takes the principal-weighted blend. The economic point is the compression: at the Year-1 ticket of $148 the whole loan sits inside the $150 tier-one cap, so the blended rate is exactly the 20.0% tier-one rate; from Year 2 the ticket crosses the break and a growing share of every loan earns only the 12% tier-two rate, dragging the blend to 17.72% by Year 7 without the shop ever changing its pricing. A pawnbroker's yield decays as its collateral appreciates, and the only defences are ticket mix or a statute change. - **Forfeiture is inventory, not a loss:** A pledge that is not redeemed does not write off. The shop keeps the collateral, whose cost basis is exactly the principal it advanced, so the model derives cost of goods sold as the forfeited principal itself rather than as revenue times one minus a margin. The disposition then splits between a retail floor at a 2.10x markup and a jewellery melt at a 1.35x refiner recovery, which makes merchandise gross margin a function of loan-to-value and mix rather than an assumption: lend less against the pledge and the retail spread widens mechanically. Service charges and ancillary fees carry no cost of goods at all, so blended gross margin sits near 76% and eases as the merchandise engine outgrows the lending one. - **Two engines that offset each other, and a loan book that eats cash:** Pawn service charges are earned only on redeemed principal, because a customer who walks away pays no interest, they pay in goods. That makes the two engines mechanically linked and offsetting: a higher forfeiture rate shrinks the interest book and grows the retail book at the same time, which is why pawnbrokers are relatively indifferent to redemption rates within a normal band. Working capital is modelled as the pledge loan book plus merchandise inventory rather than a percentage of revenue growth, so growth is a genuine cash call: Year-1 unlevered free cash flow is negative despite $628k of net income, and only turns positive from Year 2. ## Use cases - **Intrinsic valuation:** Set the store pipeline, loans per store, the ticket and its growth, the statutory rate tiers, the redemption split, the cost stack and a WACC, and read enterprise value, equity value, value per share and implied EV/EBITDA. The base case resolves near 6.9x on Year-1 EBITDA, in the range where independent pawn chains actually change hands. - **Regulatory and rate-tier stress testing:** Flex the tier threshold and either statutory rate to see what a statute change does to the blended monthly yield, EBITDA and value. Because the ticket walks through the tier break on its own, the model also shows how much yield the business loses to collateral inflation alone if the statute never moves. - **Store expansion and cash planning:** Flex new stores per year, buildout cost, book life and inventory months to see how fast the pledge book and the shelf consume cash. This is the model's sharpest use: a pawn chain growing quickly is a cash consumer even while it is profitable, and the working-capital build makes the funding gap explicit rather than smoothing it away. ## Frequently asked questions ### 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. ## Related templates - [Retail Store Model](https://finamodel.com/templates/retail-store) - [Microfinance Institution Model](https://finamodel.com/templates/microfinance) - [Credit Card Portfolio Model](https://finamodel.com/templates/credit-card-model)