From a blank spreadsheet to an editable thrift store forecast in one afternoon. Fully formatted, investor-ready, and built for Excel and Google Sheets.
Trusted by 25,000+ startup founders, investors and CPAs
Clear Model For New Users
Megan Clark, OR
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
Derek Johnson, OH
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
Lauren Mitchell, NC
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.
Model review
What does the financial model of a product called Thrift Store include?
Thrift Store Financial Model is an editable Excel workbook that provides five years of shopping traffic, conversion, recurring purchases, product mixes, prices and costs into financial results.
Use the workbook to check how traffic, conversion, repeat behavior, order volume, mix of products, prices, seasonality, employment and operating costs shape the store plan.
The editorial assumptions are the source of monthly calculations, financial statements, comparisons of scenarios and reports from the navigation desktop, making operational changes flow through the model.
Built for retail driversThe use of revenues follows the conversion of visitors, repeating cohorts, frequency of orders, units on request, mixing categories and price categories.
revenue engine for grocery stores
How is the revenue calculated in the savings shop?
The model transforms visitors to shop in buyers, adds active orders to customers, calculates units, allocates these units according to mix of products and applies category prices.
01
Change visitors
A new buyer is equal to a visitor to a store multiplied by a visitor's conversion rate to the buyer.
02
Build repeating cohorts
Some new buyers become repeat customers for a certain lifetime.
03
Calculating orders
Monthly orders combine first orders with active repeating customers multiplied by the frequency of repeating orders.
04
allocation of units
Orders become units through units on order, then the common pool of units follows mixing the sales category.
05
Calculation of revenue
Category units are assigned by category and added to total retail income.
Basic formulaRevenue = units sold × price weighted by sales mix
01 / Revenue
What leads to the revenue of savings stores spreadsheet?
The revenue view organizes the movement of visitors, conversion of buyers, repeated behaviour, volume of orders, mix of products and the price of categories that feed the calculation of retail revenues.
Revenue
The Revenue view displays assumptions about the visitor, the customer, the orders, the product mix and the prices.
02 / COGS & OPEX
How are the costs set in the model?
The view of COGS and OPEX separates direct, variable and fixed operating costs, so that the expenditure assumptions can flow to the monthly financial forecast.
COGS & OPEX
The COGS & OPEX view shows cost categories, time, percentage of revenue, fixed expenditure and periodicity.
03 / Scenarios
How do you compare Low, Base, and High cases?
In view of the scenarios, Low, Base, and High trajectories in the range of revenue, gross margin, contribution margin and EBITDA within the five-year range of forecast are compared.
Scenarios
The Scenarios report compares the Low, Base, and High revenue, margin and EBITDA paths.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use the navigation desktop to review configuration control, selection of scenarios, key finance, mix of revenue, profitability, cash flow and reports on the period of return of the investment in one place.
Dashboard
You can use the navigation desktop to review the configuration of models, scenarios, basic finance and management charts.
Product adjustment
Is this financial model suitable for you?
The ready model fits the planning of the retail conversion of visitors, while different revenue logic, operating schedules or reporting may require individual modelling.
Model ready
It fits perfectly
Selling starts with shoppers turning into first-time buyers.
You need multiple customer cohorts modeled for a certain period of activity.
You sell goods through a mix of sales categories, units and price categories.
You need edited retail assumptions that provide scenarios, financial statements and reports from your navigation desktop.
Order structure
Think about the model
Your main income does not depend on visitors to the store and convert the buyer.
Your repeated behavior requires different cohorts, behaviors or transaction logic.
Your products require a much different allocation, price or revenue recognition mechanics.
Your operating schedule or management reports require a different workbook structure.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
Financial Models Lab can build or customize the model when you need a different revenue logic, operational schedule or reporting based on your requirements.
After purchase you receive an immediate, editable Excel financial model with five-year projections, scenario analysis and related financial reporting.
01
Editable workbook
Change the model assumptions and input in the downloaded Excel version of the workbook.
02
Five-year forecast
Overview of five-year forecasts with detailed monthly and annual management visions.
03
Analysis of scenarios
Compare Low, Base, and High cases in key financial results.
04
Financial statements
Review of the related profit and loss account, cash flow, balance sheet and management reports.
Before purchase
Financial model Shoppinghop FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model of the revenue savings store calculate?
The revenue starts with visitors to the shops and converting buyers, and then add further orders from customers, units to order, a mix of categories and price categories.
02
Which assumptions can I change?
You can change the start time, visitors during the week, conversion, share and use of multiple customers, multiple order, custom units, sales mix, category prices and seasonality.
03
What can I compare between Low, Base, and High scenarios?
In view of the scenarios, the Low, Base, and High paths for revenue, gross margin, contribution margin and EBITDA are compared throughout forecast.
04
What financial results are taken into account?
The current review of the workbook includes profit and loss account, cash flow, balance sheet, navigation desk, summary and additional analytical reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or customize the model where different revenue logics, operating schedules or reporting are required.
06
Is this workbook a prediction or a guarantee?
This is a planned forecast, not a guarantee of the results of business. The results change with assumptions.
What Does the Thrift Store Financial Model Contain?
This downloadable financial model for a small resale shop includes everything you need to plan, manage, and grow your business.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue
COGS & OPEX
Scenarios
Dashboard
