Trusted by 25,000+ startup founders, investors and CPAs
Kept Our Cash Flow Clear
Megan Foster, TX
This template made runway and shortfall planning much easier to follow. I could see the cash gap months ahead and shaved about 3 hours off each forecast update.
Margins Were Easy To See
Daniel Reed, NC
I finally had a clean view of profit, break-even, and where the spread was disappearing. It helped me prepare a lender conversation a week faster than I expected.
Simple Enough To Use
Alyssa Grant, FL
I’m not an Excel power user, so the guided layout was a relief. I had the reseller model filled in the same afternoon and booked a meeting with my partner the next day.
MODEL OVERVIEW
What's the financial model of a salesman's business?
This editable five-year workbook model of the acquisition channel, repeat purchases, sales categories, costs, scenarios and related financial statements for the sales firm.
Use the model to match online and offline marketing budgets and CAC with customer size, recurring orders, category unit sales, prices, costs and financial results.
Changes to operational requirements in the workbook and related calculations update the monthly forecast, scenario views, statements and management reports.
Built for driver-based planningThe sales engine starts with the acquisition channels and tracks customer cohorts through orders, units, category mix and revenue.
RESELLER BUSINESS REVENUE ENGINE
How does the model calculate the activity of the Revenue seller?
Revenue starts with expenditure on channel marketing and CAC, adds active repeat buyers, converts orders into units, allocates a mix of categories and applies category prices.
01
Get customers
The cost of online and offline marketing divided by CAC channels is calculated by new customers per channel.
02
Build repeating cohorts
Some new customers become repeat buyers who remain active for a certain lifetime.
03
Calculating orders
Monthly orders combine first purchases with active repeat customers multiplied by repeat order frequency.
04
allocation of units
Orders become units using units per order and then the category sales mix allocates a pool of units.
05
Calculate the Revenue
Category units awarded shall be multiplied by category prices and summed by category and month.
CORE FORMULARevenue = unit of category × price of category
01 / REVENUE
Where to set the Revenue assumptions?
The Revenue view combines the acquisition channel, repeat customer behaviour, order volume, product mix and category prices that drive forecast sales.
REVENUE
Revenue worksheet displays the acquisition entries, multiple client settings, unit mix, price and calculated sales drivers.
02 / COGS & OPEX
How are costs and Operating expenses structured?
The COGS & OPEX view organizes direct costs, variable operating expenses and fixed expenses with assumptions based on time and percentage.
COGS & OPEX
COGS and OPEX worksheet shall allocate direct, variable and fixed expenditure under forecast.
03 / SCENARIOS
What do you compare to in Low, Base, and High cases?
In view of the scenarios, alternative cases for revenue, gross margin, contribution margin and EBITDA under the five-year forecast are compared.
SCENARIOS
worksheet scenarios present low, basic and high results for key profitability measures.
04 / DASHBOARD
What does a Dashboard have to do with one look?
The Dashboard combines model setting, scenario management, revenue and expenditure, cash flow, profitability, key metrics and return charts.
DASHBOARD
Dashboard consolidates the configuration controls, the outcome of the scenarios, the financial trends, the cash flow and the investment metrics.
PRODUCT FIT
Is the seller's financial model right for you?
The ready-made model fits the seller's e-commerce structure through channels; substantially different revenue logics or operating schedules may require custom modelling.
READY-MADE MODEL
It fits perfectly
You get customers through online and offline marketing channels with CAC edited.
You expect some of the new customers to come back for more shopping.
You're selling multiple product categories using an edited mix and category prices.
You want related scenarios, statements, and management reports from common assumptions.
CUSTOM STRUCTURE
Think about the model
Your revenue depends on subscriptions, markets, commissions or a substantially different sales logic.
You need an operational schedule that goes beyond the customer, order, unit and model categories.
You need additional reporting structures or calculations specific to your organization.
You need a workbook tailored to different business rules or workflow planning.
The indicator is the starting point for planning, not a guarantee of performance.
CUSTOM FINANCIAL MODELING SERVICE
Do you need a pattern that meets your requirements?
Financial Models Lab can build or customize the model when you need a different revenue logic, operational schedule or ready-made reporting structure.
When you're done with the money, you'll get an edited five-year reseller business financial model for Excel and Google Sheets as an instant download.
01
Editing the workbook
Open and edit the financial model in Excel or Google Sheets.
02
five-year forecast
Plan for five years forecast with detailed monthly and annual cash flows.
03
Analysis of scenarios
Compare Low, Base, and High cases in the model scenario view.
04
Financial statements
An overview of related P&L, cash flow, sheet balance sheet and management reporting results.
BEFORE YOU BUY
Financial model of retail business FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the Reseller Business revenue model calculate?
It calculates new customers from marketing and CAC expenditure, adds recurring cohorts, converts orders into units, allocates a mix of categories and applies category prices.
02
Which assumptions can I change?
You can edit the launch date, channel budget and seasonality, CAC, repeat order frequency, unit per order, sales mix and annual category prices.
03
What can I compare between low, basic and high scenarios?
Alternative paths for revenue, gross margin, contribution margin and EBITDA over the five years of forecast can be compared.
04
What financial results are taken into account?
The product page shows P&L, cash flow, sheet balance, dashboard, scenarios, summary, failure, ROIC, charts, key indicators, rating and other reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers personalised financial modelling for different revenue logics, operational schedules or reporting requirements.
06
Is this a forecast workbook or a warranty?
This is forecast planning based on the assumptions you put in place, not a guarantee of business results or financial results.
What Does the Reseller Business Financial Model Contain?
This downloadable financial model for wholesale distribution includes everything you need to build a comprehensive financial plan for your reseller business.
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
