Acquire customers
Divide each channel’s marketing spend by its CAC, then combine online and offline new customers.

The Diabetes Insulin Pump Supply Store Financial Model is an editable five-year workbook linking customer acquisition, repeat purchasing, product mix, pricing, scenarios, and financial reports.
Use the workbook to plan how marketing-driven customer acquisition and repeat purchasing translate into orders, units sold, category revenue, costs, cash flow, and profitability.
Channel marketing budgets and CAC create new customers; repeat behavior, orders, units, sales mix, and prices then flow into linked financial outputs.
The model acquires new customers by channel, keeps eligible repeat-buyer cohorts active, converts orders into units, allocates units by sales mix, and applies category prices.
Divide each channel’s marketing spend by its CAC, then combine online and offline new customers.
Convert the repeat-customer percentage into buyer cohorts that remain active for the stated lifetime.
Add first-purchase orders from new customers to active repeat customers × average repeat orders per month.
Multiply orders by average units per order, then allocate the shared unit pool across categories by sales mix.
Multiply each category’s allocated units by its price, then sum category revenue across months.
The Revenue Assumptions sheet links channel budgets, CAC, repeat customer behavior, order frequency, units per order, sales mix, and product pricing.
The COGS & Operational Expenses sheet separates product-related COGS, variable expenses, and fixed operating costs across the forecast.
The Scenario Analysis view compares Low, Base, and High trajectories for revenue, gross margin, contribution margin, and EBITDA across five years.
The Dashboard combines model setup, scenario controls, revenue mix, profitability, cash flow, and investment payback in one management view.
The ready-made model fits ecommerce stores using customer acquisition, repeat cohorts, order volume, product mix, and pricing; materially different operating logic may warrant 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 financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable financial model workbook for a five-year forecast with scenario analysis and linked financial reporting.
Update marketing, CAC, repeat-customer, order, sales-mix, pricing, cost, staffing, capital, and funding assumptions.
Plan monthly and annual financial results across the five-year projection horizon.
Compare Low, Base, and High cases through the workbook’s scenario framework.
Review income statement, cash flow, balance sheet, dashboard, and supporting reports.
The essential answers are visible in full, with no accordion clicks required.
It acquires new customers by channel, adds active repeat-buyer orders, converts orders to units, allocates units by sales mix, and applies category prices.
You can edit launch date, channel budgets and seasonality, CAC, repeat-customer percentage and lifetime, repeat ordering, units per order, sales mix, and yearly prices.
You can compare alternative trajectories for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The workbook preview confirms the Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Summary, Break-Even, ROIC, Charts, KPIs, and additional reports.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast based on the assumptions entered in the workbook, not a guarantee of business performance.
This powerful template includes everything you need to build a comprehensive financial plan for your Diabetes Insulin Pump Supply Store, from initial startup costs to a full 5-year forecast and investor-ready reports.
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
Building the store model by hand would have eaten up days, but this template gave me a clean starting point fast. I had projections ready in a few hours instead of a week.
One broken formula can wreck a model, so having the checks built in was a relief. I caught issues early and shared cleaner numbers with my lender.
I’m not an Excel expert, and that used to slow everything down. The layout made it easy to plug in assumptions and finish the forecast without outside help.