Trusted by 25,000+ startup founders, investors and CPAs
Margin Clarity At Last
Megan Foster, NY
This template made margins and break-even easy to see, so I stopped guessing at profitability. I cut my review time by a few hours and could explain the numbers in one clean meeting.
Scenario Planning Without The Mess
Daniel Reed, TX
I used to build low, base, and high cases by hand, and it dragged on. With this model, I set up all three in under an hour and had a clearer plan for my next investor call.
Simple Enough To Use Quickly
Lauren Kim, CA
I’m not strong in Excel, so advanced modeling usually slows me down. This template kept the formulas out of the way and let me finish the forecast the same day without outside help.
Model review
What is the financial model of the store?
This editable five-year workbook models the revenue of perfume stores from visitor conversions, subsequent orders, product blends and prices, and then produces financial statements and management visions.
Use the workbook to plan how store movement turns into buyers, how repeat customers place monthly orders, and how mixing categories and prices shapes retail revenue.
The editable operational assumptions shall provide information on related calculations, cost schedules, financial statements, scenario comparisons and dashboard so that changes can be reviewed within forecast.
Built for driver-based planningChange the operating logs according to the store plan and see how the associated forecast reacts.
revenue engine of perfumery stores
How does this perfume storage model calculate revenue?
The model converts shoppers into new buyers, builds repeat customer cohorts, calculates orders and units, allocates a mixture of categories and applies category prices.
01
Change visitors
The weekly and monthly seasonal visitor stores feed the traffic, and then the conversion creates new buyers.
02
Build repeating cohorts
Recurring clients include cohorts that remain active for a specific lifetime.
03
Calculating orders
Monthly orders shall link first orders with active customers repeating the order frequency times.
04
allocation of units
Orders are converted into units and then a common pool of units follows according to the sales mix of the categories.
05
Calculation of revenue
The category units awarded are multiplied by the category prices and the revenue categories are summed monthly.
Basic formulaRevenue = units sold × mixed price
01 / Revenue
What can be changed in the revenue?
Worksheet revenue presents the assumptions regarding visitor, conversion, repeat customer, orders, product mix and prices that drive the model's retail sales calculation.
Revenue
Check visitor data, conversions, recurring customers, orders, product mix and prices in one sheet.
02 / COGS & OPEX
How are operating costs and expenses planned?
Worksheet COGS & OPEX separates product costs, variable costs and fixed operating expenses so that forecast can link cost assumptions to monthly results.
COGS & OPEX
Check assumptions about product costs, variable costs and fixed costs with related monthly calculations.
03 / Scenarios
How do you compare alternative cases?
The Worksheet scenarios place the Low, Base and High cases side by side with respect to revenue, gross margin, contribution margin and EBITDA throughout forecast.
Scenarios
Check the low, basic and high lines for revenue, margins and EBITDA over five years.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines configuration controls, scenario multipliers, key finances, a mix of revenue, profitability, cash flow and return on investment in one management view.
Dashboard
It's a case of checking scenarios, basic finances, a mix of revenue, profitability, cash flow and repayment combined.
Product adjustment
Is the financial model of the perfume store right for you?
This template is suitable for retail visitor conversion planning with recurring orders, mixed categories and related reports; substantially different revenue logics may require individual modelling.
Model ready
It fits perfectly
The Revenue of the store starts with the visitor traffic and the visitor-to-buyer conversion rate.
You need a cohort of customers with editable life and monthly order frequency.
Your merchandise can be arranged by unit, category sales mix, and category price.
You need a five-year forecast with scenarios, financial statements and management reports.
Order structure
Think about the model
Your basic revenue doesn't track visitor conversions, repeat orders, or commodity units.
Your company needs operational schedules that differ significantly from the structure of retail drivers.
The reporting requirements require results that go beyond the workbook views displayed here.
The planning process requires a different model architecture or an adapted computation flow.
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 may build or adapt a model where requirements require different revenue logic, operational timetable or reporting structures.
Once you've cashed in, you'll receive the editable financial model of the perfume store as an instant download to the five-year forecast and scenario analysis.
01
Book to be edited
Update the model entries in Excel or Google Sheets to reflect the store plan.
02
Forecast five years old
Review of the related five-year forecasts for operators and financial statements.
03
Analysis of scenarios
Compare the Low, Base and High cases in terms of revenue, margins and EBITDA.
04
Financial statements
Use the attached income statement, the cash flow, the balance sheet, the dashboard and the summary review.
Before purchase
Perfume Factory 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 Perfume Store calculate its revenue?
It converts shoppers into buyers, transfers cohort of repeat customers, calculates orders and units, allocates a mixture of categories and applies category prices.
02
Which of the stakes at the perfume store can I change?
You can edit the launch time, weekly visitors, conversion, repeat behavior, order units, category mix, category prices, and monthly seasonality.
03
What can I compare between low, basic and high 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.
04
What financial results are included in the model?
The product gallery confirms the income statement, the cash flow report, the balance sheet, the dashboard, the summary, the scenario analysis and several additional reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or customize the model when you need different revenue logic, operational timetable or reporting structures.
06
Is this workbook a prediction or a guarantee?
It's a planned forecast, not a guarantee of achievement. The outcome depends on the assumptions you put in place and how the company actually operates.
What Does the Perfume Store Financial Model Contain?
You get a comprehensive and user-friendly financial model template designed specifically for a perfume store, complete with pre-built financial statements, a dynamic dashboard, and detailed assumption sheets.
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
