Trusted by 25,000+ startup founders, investors and CPAs
Scenario Clarity At Last
Megan Carter, TX
I kept getting tangled in low, base, and high cases, and this template finally put them side by side in a way I could follow. It saved me about 4 hours of reworking assumptions before our planning call.
Assumptions In One Place
Daniel Brooks, IL
Pricing, costs, and growth used to live in separate tabs and it was a mess. This model organized everything cleanly, and I booked a review with my team the same day.
Easy To Use For Founders
Laura Mitchell, NC
I’m not an Excel power user, so the advanced modeling pieces usually slow me down. This template made the setup understandable, and I finished a full draft without asking for outside help.
Model review
What is the financial model of the retail assortment optimisation service?
This editable five-year workbook models customer acquisitions, service-level groups, billable hours and hourly rates with financial statements, scenarios and management reports.
Use the model to plan how your marketing expenses turn into active customers, service billing, revenue, operating expenses, and financial results.
The editable assumptions are the source of monthly calculations and consist of annual reviews, financial statements, scenario comparisons and dashboard reports.
Built around the service economyCustomer cohort, billable hours and hourly rates remain the main drivers of revenue.
revenue engine of the customer cohort
How does the retail assortment optimisation service model calculate revenue?
The model attracts customers from marketing spending, retains cohorts by service level, converts active customers into billable hours, and applies hourly rates.
01
Get customers
New customers equals marketing expenses divided by customer acquisition costs.
02
Separate the cohorts
Divide new customers into different service levels and maintain each cohort throughout the customer's life.
03
Active clients
Add new clients to any cohort of new clients that are still active.
04
Calculated hours
Multiplication of active customers by average billable hours per active customer each month.
05
Calculation of revenue
Multiplication of billable hours with respect to the hourly rate and total revenue in individual levels and months.
Article revenue assumptions links to forecast revenue marketing-based customer acquisition, service level cohorts, billable hours and hourly rates.
Revenue assumptions
Check customer purchases, cohort, hourly payments and hourly rate on the revenue assumptions form.
02 / COGS & operating expenses
How are operating expenses organised?
The COGS and operational expenditure item divides the cost assumptions into COGS, variable costs and fixed costs for the monthly forecast.
COGS and operating expenses
Check the COGS, variable expenditure and assumptions for fixed expenditure together with their monthly estimates.
03 / Analysis of the scenario
What's the equivalent of a scenario analysis?
In terms of scenario analysis, it compares the low, underlying and high positions with respect to revenue, gross margin, contribution margin and EBITDA with respect to forecast.
Analysis of scenarios
Examine the low, basic and high trajectories for revenue, margins and EBITDA over five years.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard contains scenario control, key metrics, core finance, a mix of revenue, profitability, cash flow and payback period charts in one view.
Dashboard
Control of scenarios, tables KPI, income mix, profitability, cash flows and return period charts.
Product adjustment
Is the financial model of the retail assortment optimisation service suitable for you?
The ready-made model is compatible with the hourly service economy, whereas substantially different revenue logics, operational schedules or reporting may require custom modelling.
Model ready
It fits perfectly
Your service revenue is driven by active customers, billing hours and hourly rates.
You'll get customers by betting on marketing expenses and customer acquisition costs.
You need service-level cohorts with editable customer lifetimes and interest rates.
You want five-year reports, scenario comparisons and management reports in one workbook.
Order structure
Think about the model
Your main revenue is not based on the customer group, billing times and hourly rates.
You need operational schedules that are vastly different from the structure of workbook.
You need a specialist report beyond the financial and managerial results presented here.
You need a workbook tailored to the additional business-specific computational logic.
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 can build or customize a model when you need a different revenue logic, operational schedule or reporting.
You will receive an editable five-year financial model for Excel or Google Sheets with monthly and annual projections, scenarios and financial reports.
01
Book to be edited
Updating model assumptions, service levels, costs, employment and operational data.
02
Forecast five years old
Review forecast for monthly and annual financial reviews.
03
Analysis of scenarios
Compare the Low, Base and High cases in the most important financial results.
04
Financial statements
P&L, cash flow, Balance Sheet, dashboard and Supplementary Reports are reviewed.
Before purchase
Optimization service for the retail range 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 revenue from the retail assortment optimisation service?
Revenue come from active customers with a service level multiplied by invoiced hours per customer and the hourly rate applied, with acquisitions resulting from marketing and CAC expenditure.
02
Which assumptions can I change?
You can edit runtime, startup clients, marketing budget and seasonality, CAC, level allocation, customer usage time, billable hours and hourly rates.
03
What can I compare between low, basic and high scenarios?
It is possible to compare the low, basic and high trends for revenue, gross margin, contribution margin and EBITDA across forecast.
04
What financial results are taken into account?
The product side shows P&L, cash flow, balance sheet, dashboard, summary, settlement, ROIC, charts, KPIs, indicators, ratings and additional reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual financial modeling when you need a different revenue logic, operational schedule or reporting.
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 Retail Assortment Optimization Service Financial Model Contain?
This comprehensive assortment planning template provides everything you need to build a detailed financial forecast, analyze your business, and prepare for investor conversations.
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 assumptions
COGS and operating expenses
Analysis of scenarios
Dashboard
