Trusted by 25,000+ startup founders, investors and CPAs
Saved Me Hours
Mia Thompson, CA
I stopped building the revenue model by hand, and the template cut my planning time from a full day to about an hour. It let me move straight to pricing and growth decisions.
Safer Model Checks
Ethan Walker, TX
One broken formula used to send me in circles; this model kept the tabs organized and easier to trust. I caught an input issue in minutes instead of rebuilding the whole sheet.
Simple Scenario Planning
Olivia Bennett, NY
Switching between low, base, and high cases was tedious before, but now the assumptions are already set up in a clean way. I could compare scenarios fast and get the numbers ready for a meeting the same day.
MODEL OVERVIEW
What Is the Financial Model in the Sales Box?
This is a five-year Excel or Google Sheets workbook that modeles customer acquisition, repeat orders, product range, category valuation, scenarios and basic financial statements.
Use the model to plan how channel marketing budgets, CAC, recurring customer behavior, custom units, sales mix, prices, costs and financing shape the forecast of e-commerce.
Editable operational assumptions flow through monthly calculations to annual forecasts, financial statements, scenario comparisons and navigational desk reports.
Built for e-commerce productThe revenue logic follows new and repeated orders of customers, and then allocates units in different categories of price products.
COMMERCIAL CLIENT INCOME ENGINE
How Does Recording Display Sales Frame Generate Revenue in Model?
Marketing releases of channels and CAC create new customers, recurring cohorts add recurring orders, and mixing units plus price categories convert orders to ecommerce revenues.
01
Buy Clients
Online and offline marketing divided by the channel CAC calculates new customers.
02
Building Repeated Cohorts
The participation of new customers becomes a recurring buyer for the specified life span.
03
Calculate Order
First-sale orders are combined with active repeat buyers of repeated orders per month.
04
Association Units
Orders shall be converted into sold units and then the sale of the blend shall allocate units in different product categories.
05
Calculate Income
The units of the category multiply by matching prices and the revenues of the category are added up for a month.
FORM OF CORRECTIONRevenue = Sold units × Weighted category price
01 / REVENUE RESULTS
What Can i Edit in Taxes?
View Revenues The assumptions combine channel marketing, CAC, repeated behaviour, order size, sales basket of categories and prices of products with e-commerce revenues.
GROUNDS FOR THE REVENUE
Preview of the entry of the acquisition, the assumptions of the repeat client, the order drivers, the product range and the price of the category.
02 / COGS & OPEX
How Are the Structured Costs in COGS & OPEX?
The COGS & OPEX worksheet separates product costs, variable sales costs and fixed overhead costs, including schedule and monthly detail forecasts.
COGS & OPEX
Preview direct product costs, variable costs, fixed overheads, schedule and monthly forecasts.
03 / SCENARIO ANALYSIS
What Can Be Compared in Scenario Analysis?
The analysis of the scenarios compares low, base and high revenue trajectory, gross margin, premium margin and EBITDA in the five-year forecast.
ANALYSIS SCENARIO
Compare low, base and high revenues, margins, input and trajectory EBITDA.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The board includes a set of models, scenario control, key metrics, basic finance, revenue mix, profitability, cash flow and return on investment in one view.
DASHBOARD
Control of review configuration, scenario results, key metrics, basic finances, cash flow and return charts.
FIT OF PRODUCTS
Is the Financial Model Sales in the Record Box Suitable for You?
The ready model fits the sales of e-commerce driven by purchase, repeat orders, product range and price categories; structural custom work corresponds to essentially different operating logic.
MODEL BY MADA READY
Good Example
You are recruiting customers through online marketing budgets and offline with channels from CAC.
You expect some new customers to generate orders repeated over a certain period of life.
You sell many product categories from a common unit pool using a editable mix and prices.
You need five-year reports, a year-long analysis of scenarios and reports from your navigational desks.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your income depends primarily on subscription, project settlement, markets or other important mechanics.
The customer life cycle requires different retention, upgrade, quality reduction or reactivation of logic.
Your operating schedules require different stocks, capacities, personnel, or cost ratios.
Reporting requirements go beyond the scope of the workbook of the statements and management views.
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?
The financial models of Lab can build or adjust the model when you need different revenue logic, operating schedules or reporting from the ready structure.
You will receive an immediate, fully edited financial model Excel or Google Sheets with five-year monthly and annual forecasts, scenarios and financial reporting.
01
Editable workbook
Open and edit your financial model in Excel or Google Sheets.
02
year forecast 5
Planning of monthly and annual forecasts within the five-year horizon.
03
Analysis of scenarios
Compare low, basic and high cases in key financial resources.
04
Financial statements
Overview of the income account, cash flow, balance sheet, Dashboard and Summary.
BEFORE BUYING IMPORTANT INFORMATION
Record Display Sales Frame Model Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate sales revenue under the Record?
Calculates new customers by channels from marketing expenses and CAC, adds first and repeats orders, converts orders into units, allocates a mixture of units and applies category prices. Revenues from the category are aggregated in months.
02
What are the assumptions I can change?
You can change the launch date, online and offline marketing budgets, channel seasonality and CAC, repetitive percentage and lifetime, repeatability of order frequency, order units, product range and category prices.
03
What can I compare in Low, Base and High scenarios?
The alternative revenues, gross margin, premium margin and the trajectory of EBITDA in the five-year model can be compared.
04
What financial results are taken into account?
The workbook contains a statement of revenue, a statement of cash flows, a balance sheet, a navigational desk, an analysis of scenarios and a summary.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The financial models Lab offers custom financial modelling for various revenue logic, operational schedules, or reporting requirements.
06
Is this a forecast or a guarantee?
This is a planned forecast based on the assumptions for the edition, not a guarantee of the results of business activity or financial results.
What Does the Record Display Frame Sales Financial Model Contain?
This excel financial model for record display frame sales provides everything you need to plan, launch, and grow your retail business with financial clarity.
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.
GROUNDS FOR THE REVENUE
COGS & OPEX
ANALYSIS SCENARIO
DASHBOARD
