Convert Visitors
Store visitors become new buyers using the visitor-to-buyer conversion rate.
This editable Candle Store Financial Model turns visitor conversion, repeat buying, order size, sales mix, and prices into a five-year forecast with financial statements and scenario analysis.
Plan how store traffic becomes buyers, repeat orders, units sold, category revenue, operating costs, cash flow, and profit over time.
Editable assumptions flow into monthly projections, which roll into annual views, Low/Base/High comparisons, linked statements, and management reporting.
The model converts store visitors into buyers, carries repeat-customer cohorts across their active lifetimes, builds monthly orders and units, then prices the category sales mix.
Store visitors become new buyers using the visitor-to-buyer conversion rate.
A share of new buyers repeats and stays active for its stated lifetime.
Monthly orders combine first orders with active repeat customers × repeat orders per customer.
Units sold equal total orders × average units per order, then follow category sales mix.
Category revenue equals allocated units × period price, then totals are summed across categories and months.
The Revenue view organizes weekday visitors, conversion, repeat behavior, order size, product mix, category launch timing, and period prices in one operating schedule.
REVENUE
The COGS & OPEX view separates direct product costs, variable expenses, and recurring fixed operating expenses so cost assumptions flow into margins and cash planning.
COGS & OPEX
The Scenarios view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIOS
The Dashboard combines setup controls, scenario multipliers, core financials, key metrics, revenue mix, profitability, cash flow, and investment payback in one management view.
DASHBOARD
The ready-made model fits visitor-driven retail with repeat customers, shared unit sales mix, and category pricing; materially different operating logic may justify a custom structure.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting from the ready-made template.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Candle Store Excel workbook with five-year monthly and annual forecasts, scenario analysis, and linked financial reports.
Change revenue, cost, staffing, capital, financing, and other planning assumptions in Excel.
Review monthly and annual projections across the model’s five-year planning horizon.
Compare Low, Base, and High cases using the workbook’s scenario framework.
Use linked Income Statement, Cash Flow, Balance Sheet, summary, and management views.
The essential answers are visible in full, with no accordion clicks required.
It converts visitors into new buyers, tracks repeat cohorts, calculates orders and units, allocates sales mix, and prices each category before summing revenue.
You can edit launch date, weekday visitors, conversion, repeat behavior, orders, units per order, category sales mix, period prices, and monthly seasonality.
You can compare revenue, gross margin, contribution margin, and EBITDA paths across the three scenario cases.
The workbook includes Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Scenarios, Summary, Valuation, Break-Even, ROIC, Charts, Ratios, and KPIs. Additional views include Top Revenue, Top Expenses, Sources & Uses, and DuPont.
Yes. Financial Models Lab offers custom financial modeling when your revenue logic, operating schedules, or reporting requirements need a different structure.
It is a planning forecast based on editable assumptions, not a guarantee of business performance or financial results.
You get a comprehensive and user-friendly candle store financial model template designed to help you plan, fund, and launch your retail business with confidence.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
This template made margins and break-even easy to see, so I stopped guessing at pricing. I saved about 6 hours building the first version and could explain the profit story to my partner much faster.
It gave me a clear view of runway and likely shortfalls, which took the stress out of monthly planning. I booked a lender call with cleaner numbers and saved a full afternoon of spreadsheet work.
I finally had a model with the right structure and outputs for investors, so I wasn’t piecing it together from scratch. It cut my prep time by a day and made the deck easier to review.