Revenue and Calc
Edit shopper traffic, selling days, conversion, basket size, merchandise shares, prices, and monthly seasonality. The monthly calculation schedule allocates one pool of items sold across six categories.
Editable Thrift Store Financial Model in Excel
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Thrift Store Financial Model is an Excel template for planning a single, independent U.S. secondhand retail shop from 2026 through 2030. It converts shopper visits, purchase conversion, items per transaction, product mix, selling prices, and seasonality into monthly revenue and projected operating results.
The illustrative business is a roughly 3,000-square-foot, owner-managed neighborhood store that buys merchandise outright and sells in person. The case excludes donated stock, consignment, wholesale, and online sales; its forecasts are editable planning estimates, not historical performance or industry averages.
- Forecast
- 5annual forecast years
- Sales categories
- 6distinct merchandise types
- Trading days
- 26per modeled month
- Inventory days
- 41inventory planning input
WHAT IS INCLUDED
Which Worksheets and Reports Are Included?
The workbook connects store-level inputs to operating calculations, standard financial statements, and management decision reports.
COGS & OPEX and Payroll
Plan secondhand inventory purchases, merchandise handling, processing fees, occupancy costs, and staff compensation without counting wages twice. Role-level staffing and annual salary assumptions feed monthly operating expenses.
Dashboard and Funding
Review inputs and headline results, select Low, Base, or High scenario assumptions, and enter equity, capital spending, working capital, or debt facilities where applicable.
Financial Statements and Analysis
Income Statement, Cash Flow, Balance Sheet, Returns, Scenarios, Valuation, and Sources & Uses support broader financial decisions.
REVENUE FORECAST
How Does the Store Calculate Sales?
Revenue starts with shopper visits and conversion, then allocates sold items across six categories.
The 2026 case assumes 90 shopper visits per trading day, 26 trading days monthly, 40% purchase conversion, and 2.2 items per purchase. Visit assumptions rise to 135 per day by 2030, while conversion reaches 45% and items per purchase reach 2.3.
Clothing receives 50% of items, shoes and accessories 12%, furniture 5%, housewares and decor 18%, books and media 10%, and toys and small electronics 5%. Each item is assigned once, then multiplied by its category-specific realized selling price.
Revenue Forecast
The Revenue Forecast organizes store-traffic assumptions, six merchandise mixes, category selling prices, and annual revenue. Its inputs flow into Calc, where monthly seasonal factors adjust demand before sales are aggregated.
Reconciled 2026 annual sales illustration
2,059.2 items per baseline month × $11.31 weighted price per item × 12.0 total seasonal factors ≈ $279,475 annual revenue.
The 2026 product mix implies $11.31 per item. Seasonal factors reduce January and February demand to 90% of baseline and lift October to 115%; together, the factors total 12.0.
EXPENSES AND STAFFING
How Are Costs and Payroll Forecast?
The model separates merchandise-related direct costs, sales-linked variable costs, recurring fixed expenses, and base salaries.
Direct costs equal 33% of revenue: 30% for acquired secondhand merchandise, 1% for preparation supplies, and 2% for inbound pickup and freight. In-store processing fees start at 2.56% of sales in 2026, plus 1.2% for checkout bags and labels.
Fixed expenses include rent, utilities, insurance, marketing, bookkeeping, software, and cleaning. The modeled rent and occupancy expense increases from $4,500 per month in 2026 to $5,100 in 2030.
COGS and Operating Expenses
The COGS and Operating Expenses report separates purchased merchandise, sales-dependent fees, and recurring overhead. Adjusting these rates or fixed amounts changes gross margin, contribution margin, and EBITDA without duplicating payroll.
| Cost group | 2026 | 2030 |
|---|---|---|
| Direct costs (COGS) | $92,227 | $184,084 |
| Variable expenses | $10,515 | $20,571 |
| Fixed expenses | $88,800 | $95,520 |
| Base-pay payroll | $138,000 | $178,600 |
Display amounts are rounded; annual salary costs are separate from the other three groups.
Payroll Forecast by Staff Role
The Payroll Forecast builds staff expenses from annual-average full-time-equivalent staffing and salaries by role. The case includes a $50,000 store manager, sales associates at $36,000 per FTE, and merchandise processors at $34,000 per FTE.
Staffing increases from 3.5 FTE in 2026 to 4.65 in 2030. This operating illustration includes gross base pay only; employer taxes, benefits, and personal taxes are excluded.
STARTUP AND FUNDING
What Initial Investment Does the Model Track?
Startup assets, stock, deposits, and reserves are funding uses, not recurring EBITDA expenses.
The illustrative startup asset plan totals $35,000: $18,000 for leasehold improvements, $10,000 for display fixtures, $4,000 for checkout and security equipment, and $3,000 for sorting equipment. One-time formation cash and the refundable lease deposit are distinct items.
Inventory planning uses 41 inventory days, zero accounts receivable days, and zero accounts payable days. Customers pay immediately, while the store purchases stock with cash, making merchandise sourcing and opening working capital important liquidity inputs.
Capital Expenditure Plan
The Capital Expenditure Plan schedules shop improvements and equipment purchases separately from operating costs. The CAPEX sheet also tracks depreciation and asset balances for the broader financial statements.
Initial owner funding is estimated at $141,329, covering startup assets, launch cash, lease deposit, opening stock, and three months of recurring cash operating costs. No non-owner funding is confirmed.
Sources and Uses of Funds
The Sources and Uses of Funds report shows how equity, any modeled debt, operating receipts, expenses, and investments affect planned cash allocation. It is a funding reconciliation, not evidence that this illustrative balance guarantees cash sufficiency.
FIVE-YEAR PROJECTIONS
What Do the 2026–2030 Results Show?
The illustrative EBITDA forecast turns positive in 2028 after two loss-making years.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $279,475 | $329,541 | -$50,067 |
| 2027 | $353,375 | $366,235 | -$12,861 |
| 2028 | $418,233 | $405,546 | $12,687 |
| 2029 | $479,613 | $434,603 | $45,010 |
| 2030 | $557,831 | $478,776 | $79,056 |
All figures are forecasts, not observed results; whole-dollar rounding can create small differences in displayed subtotals.
Revenue rises as expected traffic, purchase conversion, basket size, and realized prices increase. The illustrative 2030 EBITDA of $79,056 follows $557,831 in sales and $478,776 in operating expenses; it does not establish net profit or free cash flow.
The Income Statement extends analysis below EBITDA; the Balance Sheet and Summary report financial position. This operating example establishes no particular net income, cash balance, or valuation.
Cash Flow Forecast
The Cash Flow Forecast tracks operating, investing, and financing cash movements, including stock purchases, capital spending, and funding transactions. Use it to investigate liquidity and cash timing separately from projected EBITDA.
DECISION SUPPORT
Can You Test Break-Even and Investment Returns?
The workbook separately analyzes sales break-even, cash break-even, payback, and ROIC.
Sales break-even tests the revenue required to cover modeled operating costs. Cash break-even examines cash timing, investment payback tracks recovery of invested funds through cumulative project cash flows, and annual ROIC relates operating returns to invested capital.
The Dashboard lets you adjust Low, Base, and High multipliers for revenue, direct costs, variable costs, fixed costs, and payroll. Scenarios compare their effect on revenue, margins, and EBITDA; actual financing terms can be entered in the Dashboard debt controls.
Break-Even, Payback and ROIC
The Returns analysis compares sales break-even, cash break-even, project payback, and annual ROIC as separate measures. Its calculations help test an investment decision, but the supplied operating forecast does not specify a payback date or ROIC result.
HOW TO USE IT
Who Can Use This Thrift Store Template?
The template suits owners and advisers assessing a storefront-only, purchased-inventory thrift store.
Replace example traffic, conversion, category mix, prices, wages, lease costs, inventory days, and funding with your own store assumptions. Compare cases to assess demand and cost sensitivity.
Donation intake, consignment, wholesale, and online sales would require different revenue and cost drivers from this purchased-inventory case.
FREQUENTLY ASKED QUESTIONS
Frequently Asked Questions About This Model
Answers to common questions about the inputs, forecasts, and financial reports.
Can I change the shopper traffic and conversion rate?
Yes. Edit visits per trading day, conversion, trading days, items per purchase, and monthly seasonality to recalculate demand and sales.
Does the template forecast sales by merchandise type?
Yes. Clothing, shoes and accessories, furniture, housewares and decor, books and media, and toys and small electronics each have a separate mix share and realized selling price.
Are donated and consigned goods included?
No. The illustrated operating plan purchases secondhand inventory outright and excludes donations, consignment, wholesale, and online channels.
Are employee wages already included in COGS?
No. Store manager, associate, and merchandise processor base pay is modeled separately in Payroll to avoid double counting.
Does the starting funding amount equal profit?
No. The $141,329 initial owner funding estimate represents planned capital for opening needs and reserves, not earned revenue or EBITDA.
Does positive EBITDA mean the store has positive cash flow?
No. EBITDA omits investment, financing, and working-capital cash movements; review the Cash Flow and Sources & Uses reports for those effects.
Will it calculate a break-even or payback date?
The Returns report supports break-even and payback calculations, but the illustrative operating assumptions do not establish a specific cash break-even or investment payback date.
What Does the Thrift Store Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Clear Model For New Users
I’m not great with advanced Excel, so this template was a relief. I got the thrift store model built and ready to review in under an hour instead of spending a full day trying to figure out formulas.
All Reports In One Place
I used to have P&L, cash flow, and charts spread across different files. This template pulled everything into one workbook, and it saved me about 6 hours of cleanup before my lender call.
Simple Assumptions Setup
My pricing, labor, and growth inputs were all over the place before. This model gave me a clean assumptions section, and I was able to finish planning with one clear version of the numbers.