Trusted by 25,000+ startup founders, investors and CPAs
Clear Margin Picture
Megan Carter, TX
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.
Cash Flow Became Trackable
Dylan Brooks, FL
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.
Investor Format Was Clear
Rachel Nguyen, NY
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.
Model review
What's the financial model of the candle shop?
This editable financial model Candle Store transforms visitor conversions, repeat purchases, order volume, sales mix and prices into a five-year forecast from financial statements and scenario analysis.
Plan how store movements become buyers by repeating orders, units sold, revenue categories, operating expenses, cash flow and profit over time.
The editable assumptions flow into monthly forecast, which flow into annual reviews, low/basic/high comparisons, linked statements and management reports.
Built around retail conversionThe revenue logic starts with visitors and follows the buyer's conversion through recurring activity, order volume, product mix and category price.
revenue engine of the candle shop
How is the candle shop dealing with revenue?
The model converts shoppers into buyers, transports cohortes of repeat customers throughout their active lives, builds monthly orders and units, and then prices the mix of category sales.
01
Change visitors
Store visitors become new buyers using the visitor to buyer conversion factor.
02
Build repeating cohorts
The participation of new buyers is repeated and remains active for a given lifetime.
03
Calculating orders
Monthly orders combine first orders with active repeat customers × repeat orders per customer.
04
allocation of units
Units sold equal to total orders × average units per order followed by a mix of category sales.
05
Calculation of revenue
Revenue categories are equal to units allocated × period prices and then aggregated in individual categories and months.
Basic formulaRevenue = allocated units × category price
01 / Revenue
Where do I set up the revenue assumptions candle shop?
The revenue view organizes visitors within a week, conversion, repetition behaviour, order size, product mix, category start-up time and period pricing in a single operating schedule.
The COGS and OPEX approach separates direct product costs, variable costs and recurring constant operating expenses so that cost assumptions flow into margin and cash planning.
COGS & OPEX
Worksheet COGS & OPEX sets out the assumptions for direct, variable and fixed operating expenses.
03 / Scenarios
What can be compared in different scenarios?
The scenario compares the low, basic and high levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Scenarios
The Scenarios report shall present the operational outcomes of the four financial instruments: low, basic and high.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines configuration controls, scenario multipliers, basic finance, key metrics, a mixture of revenue, profitability, cash flow and return on investment in one management view.
Dashboard
The Dashboard combines model controls, scenario outcomes, core finances and management charts.
Product adjustment
Is the financial model Candle Store right for you?
The ready-made model is compatible with retail sales by visitors with repeat customers, a common blend of unit sales and category prices; substantially different operational logic may justify the order structure.
Model ready
It fits perfectly
Selling starts with shoppers turning into first-time buyers.
You want repeat client cohorts to be tracked for a certain amount of time.
You sell units in different product categories using an edited sales mix.
You need related costs, scenarios, financial statements and management reports.
Order structure
Think about the model
Your main revenue comes from subscriptions, contracts, rentals or capabilities instead of transforming the store.
You need several locations modeled as separate operational units with separate economies.
You need a completely different logic to keep customers, orders, or prices.
You need reporting schedules that are vastly different from the existing workbook results.
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 different revenue logic, operational schedule or ready-made template reporting is required.
Once you've cashed in, you'll receive an editable Candle Store Excel workbook with five-year monthly and annual forecasts, scenario analysis and related financial statements.
01
Book to be edited
Change of revenue, costs, staff, capital, financing and other planning requirements in Excel.
02
Forecast five years old
Review of monthly and annual projections within the five-year model planning horizon.
03
Analysis of scenarios
Compare low, basic and high cases using the workbook scenario framework.
04
Financial statements
Use the linked income, cash flow, balance sheet, summaries and management views.
Before purchase
Candle Store Financial model FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the model calculate the revenue of the candle shop?
It converts visitors into new buyers, tracks recurring cohorts, calculates orders and units, allocates a mix of sales and prices for each category before the revenue merger.
02
Which assumptions can I change?
You can edit the launch date, visitors per week, conversion, repeat behavior, orders, units per order, category sales mix, period prices and monthly seasonality.
03
What can I compare between low, basic and high scenarios?
A comparison of revenue, gross margin, contribution margin and EBITDA paths can be made in three scenarios.
04
What financial results are taken into account?
In workbook you will find income statement, a report from cash flow, a balance sheet, a dashboard, scenarios, summary, assessment, equivalence, ROIC, charts, indicators and KPIs. Additional views include the highest revenue, the highest spending, sources and uses, and DuPont.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. Financial Models Lab offers personalised financial modelling where revenue logic, operational schedules or reporting requirements require a different structure.
06
Is this workbook a prediction or a guarantee?
This is a planning forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Candle Store Financial Model Contain?
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.
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
