Revenue & Calc
Edit showroom visits, basket conversion, category allocation, realized prices, and launch timing; review the resulting monthly and annual sales forecast.
Antique Store Financial Model
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
This Antique Store Financial Model is an Excel planning template for an independent, owned-inventory antique and vintage retailer. It converts showroom traffic, purchase conversion, five merchandise allocations, selling prices, and operating expenses into monthly financial projections and management reports.
The included example represents one leased, 1,500-square-foot showroom in Columbus, Ohio, launching January 31, 2026. Its 2026–2030 figures are hypothetical planning assumptions, not actual store results, market averages, or a forecast for every buyer.
- Forecast length
- 5annual forecast years
- Merchandise groups
- 5allocated basket groups
- Showroom
- 1500square feet in example
MODEL CONTENTS
What Is Included in the Workbook
The workbook connects store-specific assumptions to operating calculations, financing schedules, financial statements, and decision reports.
COGS & OPEX
Separate merchandise purchase and handling costs from payment processing, shrinkage, supported delivery, and recurring showroom overhead.
Payroll & CAPEX
Plan the owner-manager and sales assistant by full-time-equivalent staffing, while tracking fitout, display, point-of-sale, and equipment investments.
Dashboard & Scenarios
Set the reporting case, working-capital days, Low/Base/High multipliers, and optional debt facility assumptions in one management area.
Statements & Decisions
Review Income Statement, Cash Flow, Balance Sheet, Summary, Returns, Valuation, benchmarks, ratios, and reconciliation checks without assuming any unprovided example values.
REVENUE FORECAST
How Antique Store Sales Are Calculated
Monthly sales are driven by qualified visits multiplied by the purchase conversion rate, with each paid basket assigned to exactly one merchandise group.
The illustrative plan uses 650 showroom visits per month in 2026, increasing to 1,150 by 2030, and a constant 28% purchase conversion. This creates one shared pool of purchases rather than five independent customer counts.
The five allocated groups are antique furniture, vintage jewelry, art and framed works, ceramics and glass, and collectibles and smalls. The model applies a realized selling price to the basket share in each group; the last allocation is residual.
Revenue Forecast
The Revenue Forecast links showroom visits, purchase conversion, category shares, and average sale prices to annual merchandise revenue. The Calc worksheet distributes those inputs across forecast months and applies the store launch date.
| Merchandise category | Basket share | Price per sale |
|---|---|---|
| Antique furniture | 18% | $650 |
| Vintage jewelry | 20% | $180 |
| Art and framed works | 15% | $260 |
| Ceramics and glass | 27% | $80 |
| Collectibles and smalls | 20% | $55 |
The shares total 100% of one paid-basket demand pool; they are not separate visitor populations.
Illustrative 2026 monthly sales build
650 visits × 28% = 182 paid baskets; 182 × $224.60 weighted realized price ≈ $40,877 in monthly revenue.
The monthly example annualizes to approximately $490,526 in 2026 revenue. The chosen assumptions contain no material seasonality profile, and the forecast activates streams in the full launch month rather than using prelaunch sales.
OPERATING COSTS
How Inventory, Overhead, and Payroll Affect EBITDA
Direct merchandise costs, sales-linked expenses, fixed monthly overhead, and role-based salaries each enter operating expenses once.
Estimated direct costs total 59.5% of revenue: acquisition 55%, inbound transport 2%, outside restoration 2%, and protective packing 0.5%. Variable expenses add payment processing 2.4%, damage and shrinkage 1%, and supported delivery 1%.
Fixed overhead includes rent, utilities, insurance, security, marketing, accounting, cleaning, and upkeep. The example budgets $64,800 annually in fixed expenses, including $3,000 monthly showroom rent and occupancy.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates acquisition and handling costs, sales-linked variable items, and scheduled fixed charges. It helps show how inventory economics and recurring showroom costs change contribution and EBITDA as sales vary.
| Expense category | 2026 | 2030 |
|---|---|---|
| Direct costs (COGS) | $291,863 | $516,373 |
| Variable expenses | $21,583 | $38,186 |
| Fixed overhead | $64,800 | $64,800 |
| Payroll | $79,000 | $88,000 |
These are illustrative forecast costs, rounded to whole dollars. Payroll is not counted inside COGS or variable expenses.
Payroll includes one full-time owner-buyer and manager at $52,000 annual base pay, plus a sales and catalog assistant at $36,000 per full-time equivalent. Assistant staffing is 0.75 FTE in 2026–2027 and 1.0 FTE from 2028.
The documented case excludes employer payroll taxes, benefits, and personal taxes. Operating EBITDA therefore reflects the stated scope rather than a claim about fully burdened wages or net income.
Payroll Forecast by Staff Role
The Payroll Forecast schedules each position, compensation basis, and full-time-equivalent staffing level into monthly personnel costs. This makes the assistant staffing change visible without treating the owner’s salary or staff salaries as merchandise acquisition costs.
OPENING CAPITAL
How the Opening Investment Is Organized
Store setup assets, preopening cash expenses, initial merchandise stock, and a planning reserve are distinct from recurring annual operations.
The hypothetical store includes $24,500 in startup assets for fitout, secure displays, point-of-sale and security equipment, and stock-handling tools. Another $17,000 covers separate prelaunch cash items such as deposits, registration, opening promotion, and preparation.
Working-capital controls use zero accounts-receivable days, zero accounts-payable days, and 168 inventory days. They reflect immediate customer payment, payment for stock before pickup, and a sizeable inventory holding assumption.
Capital Expenditure Plan
The Capital Expenditure Plan records fixture and equipment purchases, their spending dates, and applicable depreciation schedules. These capital investments are tracked separately from the revenue-based merchandise acquisition expenses and other operating charges.
| Funding use | Planned amount |
|---|---|
| Startup assets | $24,500 |
| Other preopening cash | $17,000 |
| Opening merchandise stock | $134,256 |
| Three-month recurring reserve | $114,312 |
Total estimated initial owner funding is $290,068 after rounding. Committed external funding in this example is zero.
The reserve equals a default three months of recurring expenses; it has not been proven sufficient for peak cash needs. The CapTable records equity contributions, while Dashboard debt inputs and the Debt sheet allow separate analysis of any financing assumptions a buyer enters.
Sources and Uses of Funds
The Sources and Uses of Funds report organizes equity, potential borrowing, and business receipts against operating payments, capital spending, and retained cash. It supports a funding review without treating the illustrated opening reserve as a verified cash runway.
FIVE-YEAR PROJECTIONS
Illustrative Annual Revenue and EBITDA Forecast
The documented base planning case projects growing showroom sales while showing all direct costs, variable expenses, fixed overhead, and Payroll through EBITDA.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $490,526 | $457,246 | $33,280 |
| 2027 | $603,725 | $529,580 | $74,145 |
| 2028 | $716,923 | $610,914 | $106,009 |
| 2029 | $792,389 | $659,136 | $133,252 |
| 2030 | $867,854 | $707,359 | $160,495 |
Hypothetical 2026–2030 forecast; original calculations use more precision than these whole-dollar display values.
In this example, EBITDA rises from $33,280 in 2026 to $160,495 in 2030 as monthly showroom visits increase and the sales mix and selling prices remain at their selected levels. The result is an operating forecast, not historical performance.
The workbook also includes an Income Statement, Balance Sheet, Cash Flow, Summary, charts, and consistency checks. Their functions are available for planning, but the example brief does not establish net profit, account balances, or a particular cash balance.
Cash Flow Forecast
The Cash Flow Forecast separates operating, investing, and financing cash movements and reconciles opening to closing cash. It can expose funding needs from inventory, capital purchases, and repayment schedules that EBITDA alone does not show.
RETURNS & SENSITIVITY
How to Examine Break-Even and Investment Returns
Returns and scenarios help test different business questions beyond the provided operating EBITDA forecast.
The Returns worksheet distinguishes sales break-even from cash break-even, tracks project cash flow toward investment payback, and evaluates annual return on invested capital. None of those measures can be read directly from the supplied EBITDA figures.
Break-Even, Payback and ROIC
The Returns analysis displays break-even calculations, cash recovery and investment payback, and return on invested capital based on the relevant workbook schedules. It is designed for testing a store investment without asserting an unsupported payback date or ROIC.
The Dashboard provides Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed costs, and Payroll. Comparing those cases is useful when visits, selling prices, stock purchase economics, or occupancy costs depart from the example.
Valuation and benchmarks are separate workbook analyses. A DCF value depends on entered discount and terminal assumptions, while benchmark comparisons depend on user-selected references; neither establishes a verified market value or industry average.
Financial Scenario Analysis
The Financial Scenario Analysis compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA. It lets a store owner review sensitivity to changing assumptions without presenting any scenario as a guaranteed business result.
BEST USE CASES
Who This Financial Model Is Built For
This workbook suits an owned-stock antique retail concept where one showroom sells merchandise directly to customers.
Use it to draft a new-store business plan, compare traffic and category pricing assumptions, plan opening inventory and fixtures, or discuss potential financing with an adviser. Replace the sample estimates with your actual lease, supplier terms, marketing plan, staffing, and sales assumptions.
The reference case does not model consignment commissions, dealer booth rental, or staff-constrained appointment capacity. Businesses with those mechanics should revise the revenue engine rather than reuse this example unchanged.
FREQUENTLY ASKED QUESTIONS
Questions About the Antique Store Excel Model
These answers clarify editable inputs, the example assumptions, and the distinction between operating projections and investment decisions.
Can I change customer visits and purchase conversion?
Yes. Edit qualified showroom visits and conversion assumptions in Revenue; the model recalculates the paid-basket pool and merchandise sales.
Does the forecast count a customer in multiple categories?
No. Each modeled paid basket is allocated once across the five principal merchandise groups using shares totaling 100%.
Can I update merchandise prices and acquisition costs?
Yes. Edit category realized prices and the relevant COGS assumptions to test different revenue and gross margin outcomes.
Does the sample cover consignment or dealer booths?
No. The sample represents store-owned inventory bought outright, not consignment sales or rented dealer booths.
Are the example 2026–2030 amounts actual store results?
No. They are hypothetical U.S.-dollar projections based on estimated inputs for a single Columbus showroom.
Are fixed salaries included in merchandise costs?
No. Owner and assistant base salaries flow through Payroll separately from COGS, variable expenses, and fixed overhead.
Does the $290,068 funding estimate guarantee enough cash?
No. It includes a default three-month reserve, not a tested maximum cash requirement; use Cash Flow to evaluate liquidity.
Can the workbook evaluate payback and alternative cases?
Yes. Returns supports break-even, payback, and ROIC analysis, while Dashboard scenario controls compare Low, Base, and High assumptions.
What Does the Antique 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 Scenarios Fast
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
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
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.