Trusted by 25,000+ startup founders, investors and CPAs
Simple Enough To Use
Megan Carter, TX
I’m not an Excel person, and this made the modeling side feel manageable instead of technical. I saved a full afternoon by using the built-in structure instead of trying to build formulas myself.
Clear Cash-Flow View
Daniel Brooks, FL
The cash-flow tab made it much easier to see when the business might get tight and where the shortfalls could show up. That helped me finish my planning sooner and walk into my lender call with clearer numbers.
No More Blank Sheet
Hannah Wilson, NY
Starting from zero always slows me down, so this template was a relief. I had a working fragrance store model in under an hour instead of staring at an empty spreadsheet all morning.
MODEL OVERVIEW
What Is the Financial Model of the Fragrance Shop?
This editable five-year workbook for the production of models of fragrances from conversion, multiple purchase, product range and prices, then prepares financial statements and management reports.
Plan how warehouse traffic, customer conversion, repeat purchases, basket size, basket size, baskets and prices translate into revenue, costs, cash flow and profitability.
The change in operational assumptions and related calculations shall update the forecast, statements, scenarios and reporting opinions for the selected case.
Built for Planning EditingUse your own start time, traffic, conversion, repeat customer, order, mix, prices, seasonality, costs, staff and capital assumptions.
SPECIAL COOPERATION OF REVENUE
How Does the Financial Model of the Fragrance Shop Calculate Revenue?
Revenue starts by converting shop visitors to buyers, adding active orders to a recurring client, converting orders into units, assigning units according to the sales cart and applying the price category.
01
Convert Visitors
Every month, new people purchasing a daily shop, seasonality and conversion decide to visit the shop.
02
Building Repeated Cohorts
The participation of new buyers is repeated for the declared active life of the customer.
03
Calculate Order
Monthly orders combine the first orders of a new buyer with the active frequency of ordering a repeat client.
04
Association Units
Orders convert to units and then the common pool of units follows the sales category mix.
05
Calculate Income
The assigned units of the category shall receive periodic prices and the revenue of the category shall be aggregated monthly.
FORM OF CORRECTIONRevenue = Sold Units × Price Weighted Mixed Sales
01 / REVENUE
Which Entrances do You Get from the Scent Shop?
The revenue sheet brings guests on weekdays, conversion, repetition of behaviour, order size, product range, category prices, start time and seasonality in one operational schedule.
REVENUE
The revenue view shows visitors, a recurring customer, order, product-mix and price inputs.
02 / COGS & OPEX
How to Structure Operational Costs?
The COGS & OPEX worksheet separates the cost of the product, variable operating costs and fixed expenditure, so that the forecast can combine sales activities with operating expenditure.
COGS & OPEX
View COGS & OPEX separates direct, variable and fixed assumptions of operating costs.
03 / SCENARIOS
How Can You Compare Things?
The Scenarios compared low, base and high cases with regard to revenues, gross margin, premium margins and EBITDA to show how alternative assumptions change results.
SCENARIOS
The Scenarios report compared low, basic and high paths for basic funds.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The table contains general settings, scenario checks, basic finances, income set, profitability, cash flow and return on investment in one management reporting view.
DASHBOARD
The table contains configuration checks, scenario results, financial summaries and management charts.
FIT OF PRODUCTS
Is the Financial Model of the Fragrance Shop Suitable for You?
The ready model fits retail planning with repeat customers and the sales portfolio of the category, while structural income differences or reporting logic may require non-standard modelling.
MODEL BY MADA READY
Good Example
The sale starts with physical movement of the shop and conversion of the buyer.
You expect some buyers to return for more shopping.
You sell many categories of goods from a common pool of units.
You want to edit the prices, mix, order size and seasonality of the assumptions.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your logic does not start with guest storage and conversion.
You need important different cohorts of customers, billing mechanics, or time of income.
You require operational schedules outside the structure of retail template planning.
You need a substantially different architecture for reporting in decision-making.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
Lab financial models can build or customize a model when you need a different revenue logic, operating schedules or reporting from a ready-made template.
After payment, you will receive an immediate, editable financial model with five-year forecasts, monthly details for two years, scenarios and financial reports.
01
Editable workbook
Update of operational assumptions, costs, personnel, capital and configuration models.
02
5-Year Forecast
Plan for five years with monthly details during the first two years.
03
Analysis of scenarios
Compare low, base and high cases through a special view of the script.
04
Financial statements
Overview of Income Account, Cash Flow, Balance Sheet, Dashboard and Other Model Reports.
BEFORE BUYING IMPORTANT INFORMATION
Fragrance Shop Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate revenue from the scent store?
It transforms shop visitors into buyers, transfers the cohorts of repeat customers, calculates orders and units, allocates units according to the product range and then applies the price category.
02
What are the assumptions on income that I can change?
You can edit start time, guests on the day of the week, conversion, repeat actions and vitality, repeat orders, custom units, mix categories, prices and seasonality.
03
What can I compare in Low, Base and High scenarios?
The Scenarios compared alternative income, gross margin, premium margin and EBITDA over the forecast period.
04
What financial results are taken into account?
The product presents a statement of income, a statement of cash flow, a balance sheet, a balance sheet, a summary, an analysis of scenarios and additional financial statements.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. Financial Models Lab offers custom financial modelling when you need different revenue logic, operating schedules, or reporting.
06
Is the workbook a forecast or a guarantee?
This is a editing forecast based on the assumptions made. It does not guarantee business results or financial results.
What Does the Fragrance Store Financial Model Contain?
This downloadable excel template for perfume store financials includes everything you need to build a comprehensive financial plan from the ground up.
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
