Acquire Customers
Channel budgets follow monthly seasonality, then spend is divided by CAC and online and offline new customers are added.
This editable five-year workbook models customer acquisition, repeat purchasing, product-category sales, costs, scenarios, and linked financial statements for a wholesale ecommerce business.
Use the model to connect marketing budgets and CAC to customer volumes, repeat orders, category unit sales, pricing, costs, and financial performance.
Change the operating assumptions in the workbook, and the linked calculations update monthly projections, scenario views, statements, and management reports.
Revenue starts with channel marketing spend and CAC, adds active repeat buyers, converts orders into units, allocates category mix, and applies category prices.
Channel budgets follow monthly seasonality, then spend is divided by CAC and online and offline new customers are added.
A percentage of new customers becomes repeat buyers, and each cohort remains active for its stated lifetime.
Monthly orders combine first-purchase orders with active repeat customers multiplied by average repeat orders per month.
Total orders become units using average units per order, then category sales mix allocates the shared unit pool.
Allocated category units are multiplied by matching category prices, then revenue is summed across categories and months.
The Revenue view brings together channel acquisition, repeat-customer behavior, order volumes, product mix, and category pricing that drive projected ecommerce sales.
REVENUE
The COGS & OPEX view organizes direct product costs, variable operating expenses, and fixed expenses with timing and percentage-based assumptions.
COGS & OPEX
The Scenarios view compares alternative cases for revenue, gross margin, contribution margin, and EBITDA across the five-year projection.
SCENARIOS
The Dashboard combines model setup, scenario controls, revenue and expense outputs, cash flow, profitability, key metrics, and payback charts.
DASHBOARD
The ready-made model fits a channel-driven wholesale ecommerce structure; materially different sales logic or operating schedules may call for custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting from the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable five-year Wholesale Business Financial Model for Excel and Google Sheets as an instant download.
Open and edit the financial model in Excel or Google Sheets.
Plan five years of projections with monthly and annual forecast detail.
Compare Low, Base, and High cases through the model's scenario view.
Review linked P&L, cash flow, balance sheet, and management reporting outputs.
The essential answers are visible in full, with no accordion clicks required.
It calculates channel customers from marketing spend and CAC, builds repeat cohorts, converts orders to units, allocates sales mix, and applies category prices.
You can edit launch date, channel budgets and seasonality, CAC, repeat share and lifetime, repeat order frequency, units per order, sales mix, and yearly category prices.
You can compare alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
The product page shows P&L, cash flow, balance sheet, Dashboard, Scenarios, Summary, Break-Even, ROIC, Charts, KPIs, Valuation, and other reports.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
It is a planning forecast driven by the assumptions you enter, not a guarantee of business performance or financial results.
You receive a downloadable financial planning spreadsheet for wholesale companies, complete with a dynamic dashboard, 5-year projections, detailed cost analysis, and a dedicated assumptions tab.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
This template made runway and shortfalls much easier to see, so I could spot a funding gap before it became a problem. I saved a few hours of guesswork and had a cleaner plan for the next board call.
I used to spend way too long juggling low, base, and high cases by hand. Now I can switch scenarios fast and share a cleaner plan with the team in minutes.
It pulled pricing, costs, and growth into one place, so the whole model finally made sense. I cut a full afternoon of cleanup and could explain the numbers without flipping through scattered tabs.