For antique store owners pitching investors, applying for SBA loans, or planning opening year - a 5-year financial model with every statement and every ratio they'll ask for.
Trusted by 25,000+ startup founders, investors and CPAs
Clear Scenarios Fast
Megan Carter, NY
I stopped spending hours juggling low, base, and high cases by hand. The template made side-by-side scenario planning simple, and I had my financing discussion ready the same day.
Cleaner Assumptions, Less Guessing
Derek Hall, TX
Pricing, costs, and growth were all over the place before this. Now the assumptions sit in one model, so I could tighten the numbers in under an hour and finally explain them without losing the thread.
Reporting In One Place
Lauren Mitchell, IL
Our statements and charts used to live in separate files, which made every update a mess. This pulled everything into one place and saved me a full day before our lender meeting.
Model review
What's the financial model of the antique shop?
This is an editable five-year Excel workbook that models monthly visiting retail sales and creates low/basic/high value cases with related financial statements.
Use the workbook to see how store traffic, conversions, repeat purchases, order volume, sales mix, prices and seasonality shape antique store forecasts.
The editable assumptions feed the revenue, costs, employment, capital and reporting schedules so that changes flow through the financial statements model and management views.
Built for driver-based planningChanges to operational assumptions and a review of the resulting revenue, cash flow, balance sheet and outcome scenarios.
revenue engine of antique shops
How does the financial model of the antique shop revenue calculate?
The model converts shoppers into new buyers, moves repeat customer cohorts, builds orders and units, and then prices category allocations into monthly revenue.
01
Visiting buyers
Daily visitors, weekly patterns, seasonal patterns, and conversions decide on new buyers every month.
02
Repeat the cohorts
The recurring share of new buyers remains active for a given customer lifetime.
03
Monthly orders
First orders are linked to active customers repeating their monthly order frequency times.
04
Units and mixture
Orders times units per order form units and then the sales mix allocates categories.
05
Revenue from retail sales
Category units multiplied by category price are summed up in individual categories and months.
Basic formulaRevenue = units sold × price of the weighted sales category of the mixture
01 / Revenue
What revenue influence the forecast of the antique shop?
The revenue article describes visitor traffic, conversion, recurring customer behaviour, volume of orders, product mix and price of categories that drive sales calculations.
Revenue
Article revenue containing guesses of the visitor, customer, orders, sales mix and prices.
02 / COGS & OPEX
How are commodity costs and operating costs determined?
The COGS & OPEX article organizes direct costs of goods, variable costs and fixed operating expenses with start dates, time and monthly calculations.
COGS & OPEX
Article COGS & OPEX with assumptions for direct, variable and fixed expenditure.
03 / Scenarios
What changes on a case-by-case basis?
The Scenarios report compares the low, basic and high results for revenue, gross margin, contribution margin and EBITDA under the five-year forecast.
Scenarios
The scenarios show a comparison of the paths of revenue, margin and EBITDA in three cases.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines model configuration, scenario control, underlying finances, a mix of revenue, profitability, cash flow and earnings prospects in a single management report.
Dashboard
configuration controls Dashboard, scenarios, financial tables and management charts.
Product adjustment
Is the financial model of the antique shop appropriate to your plan?
It is adapted to the retail sale of goods carried out by visitors with repeat purchases and category prices; different structural revenue logics or reporting may require individual modelling.
Model ready
It fits perfectly
You predict store visitors, conversions, recurring customers, orders and units sold.
You sell goods in different categories with an editable mix of sales and category prices.
You need a five-year forecast with monthly details and related financial statements.
You need Low, Base and High cases plus team reports on common assumptions.
Order structure
Think about the model
Your revenue is subject to auctions, consignments, memberships, rentals or commissions instead of selling goods.
You need multiple locations, channels, or modeled entities with separate operating structures.
Your logic of cost, inventory, or customer lifecycle differs significantly from the trading mechanisms provided.
You need specialist reports or schedules outside of a validated 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?
The Financial Model Laboratory may build or adapt the model where the revenue logic, operational schedules or reporting requirements differ from that model.
Once you have cashed, you will receive a fully editable financial model of Excel with five-year forecasts, monthly details, scenarios and related financial statements.
01
Book to be edited
Update operating models, prices, costs, employment and capital requirements in Excel.
02
forecast 5-year
Review of the five forecast years with monthly forecasts subject to annual financial review.
03
Analysis of scenarios
Compare low, primary and high cases by reporting model scenarios.
04
Financial statements
Use the related income, cash flow, balance sheet, spreadsheet and supplementary reports.
Before purchase
Antique shops Financial models 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 antique shop revenue calculate?
It converts shoppers into buyers, runs repeat cohorts, calculates orders and units, allocates a mix of sales and prices for each category.
02
Which bets at the antique store can I change?
You can change launch times, weekly visitors, conversions, recurring customer behavior, order frequency, unit per order, sales mix, category prices and seasonality.
03
What can I compare between low, basic and high scenarios?
A comparison can be made of how the alternative cases change revenue, gross margins, contribution margins and EBITDA over the five-year period of forecast.
04
What financial results are taken into account?
The product confirms the income statement, the cash flow report, the balance sheet, the dashboard, the scenarios, the summary and the additional financial statements.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers personalised financial modelling for different revenue logics, operational schedules or reporting requirements.
06
Is the book a prediction or a guarantee?
This is a planning forecast based on edited assumptions, not a guarantee of business or financial results.
What Does the Antique Store Financial Model Contain?
This antique store expense tracking template excel provides everything you need to build a robust financial plan, from initial startup costs to a full five-year forecast.
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
