Free Excel templates

A free pawn shop financial model in Excel, with a full worked case

Loans, charges and forfeits by category, the loan book, merchandise, scrap and inventory, staffing from the schedule, a P&L with adjusted EBITDA and SDE, break-even and four stresses, the quarters and the line of credit, a third store and two offers for the business.

The file follows Kestrow Pawn & Jewelry, a fictional business with two licensed pawn stores. It writes 20,800 pawn loans a year for revenue of $2,915,004 and EBITDA of $482,808 (16.6%), and breaks even at 72.9% of its loan volume. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Pawn_Shop_Model_Kestrow.xlsx (60 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This file is the worked case of The Pawn Shop Owner. The book explains every assumption and every tab: why the lending value starts from the resale price, how the loan book earns its yield, when gold goes to the refiner, what the state and federal rules require at the counter, why the summer quarters consume cash, what a third store costs, and how two buyers would value the business.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Eleven tabs. Blue cells are inputs; every other cell is a formula.

Inputs
Loans written by store, category mix, average loan, lending value, redemption share and months of charges, the monthly charge, sale multiples, scrap shares, purchases, shrink, card fees, days on hand, the schedule and wages, fixed costs, the debt, the plan, the de novo budget and the two offers.
Loans
Amount lent, charges, forfeits and the average loan book by store and category ($1,126,601 of charges in the case).
Merchandise
Sales by category, the refiner’s lots, cost of goods, shrink, card fees, contribution and inventory.
Staffing
Hours worked from the schedule, full-time equivalents and hours paid (5.02 full-time equivalents at the main store).
P&L
Store EBITDA before company costs, the company P&L, the SBA loan, adjusted EBITDA and SDE ($624,605).
BreakEven
Fixed costs and the share of 2026 volume at which EBITDA is zero (72.9%).
Stress
The whole year rerun with lower redemption, a fall in gold, fewer loans and a lower monthly charge, the debt unchanged.
Cash
Four quarters: the book and inventory swing, debt payments, distributions, the line of credit and the cash floor.
Plan
2027 to 2029 with a third store: EBITDA, margin, coverage, the store’s budget and SBA loan, its first-year cash test, and the de novo first year of chapter 3.
Value
A chain’s offer on adjusted EBITDA plus book and inventory, an individual buyer’s offer on SDE with an SBA loan and a seller note, the cash the seller keeps, and the buyer’s coverage test.
Checks
Internal checks (mix, quarters, hours, SDE, line limit, reserves, offer layers) and a comparison with every figure printed in the book.

Three things to try

Lower the monthly charge. Enter a state cap below the case’s 18% a month: in the book’s stress, a charge of 15% takes EBITDA to $313,817.

Move the gold price. A 15% fall in gold cuts scrap proceeds at once and jewelry prices in part: EBITDA goes to $407,916 in the case.

Slow the third store. Lower its 2028 volume from 50% and read its first-year cash need against its loan capital and reserve on the Plan tab ($87,349 of margin in the case).

Questions

Does it model pawn charges and forfeits?

Yes. In the case, charges come to $1,126,601 on an average loan book of $632,898, and forfeited principal of $678,954 goes into inventory at cost, to be sold at each category’s realized multiple.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own pawn shop?

Yes: replace every blue input, starting with the loans you write, your redemption rates by category and the charges your state allows. Kestrow and every figure in it are fictional case assumptions, not market data.

Related reading