Trusted by 25,000+ startup founders, investors and CPAs
Saved Me Hours
Megan Carter, TX
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.
No More Formula Stress
Brian Wallace, OH
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.
Easy Enough To Follow
Laura Mitchell, AZ
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.
Model review
What is the financial model of an insulin-powered diabetes store?
The Financial model of the insulin-powered diabetes store is an editable five-year workbook combining customer acquisition, repeat purchases, product mix, price, scenarios and financial statements.
Use the workbook to plan how customer acquisition through marketing and repeat purchases translates into orders, units sold, revenue categories, costs, cash flow and profitability.
The marketing budgets of the channel and CAC create new customers; they repeat the behaviour, orders, units, sales mix and prices, and then flow to the related financial results.
Cohorts-based e-commerce planningNew customers are acquired through the channel, while repeat purchaser cohorts remain active for a certain lifetime.
Revenue of the e-commerce client cohorts
How does the store calculate revenue in this model?
The model acquires new customers by channel, maintains active qualifying recurring buyers, converts orders into units, allocates units by sales mix and applies category prices.
01
Customer acquisition
Divide each channel's marketing spending into its CAC, and then connect online and offline new customers.
02
Build repeating cohorts
Convert the percentage of repeat customers to buyers' cohorts that remain active for a given lifetime.
03
Calculation of orders
Addition of first purchase orders from new customers to active repeat customers × average monthly repeat orders.
04
Unit Division
Multiplication of orders by average units per order, followed by allocation of a common set of units in individual categories according to the sales mix.
05
Calculated Revenue
Multiply the units allocated to each category by its price and then combine the revenue categories within months.
Basic formulaRevenue = Units sold × Average price of category
01 / Revenue assumptions
Which revenue drives the e-commerce forecast?
The revenue assumptions article combines channel budgets, CAC, repeated customer behaviour, order frequency, units per order, mix of sales and product price.
Revenue assumptions
The Revenue assumptions view shows purchases, repeat purchases, product mix and price contributions.
02 / COGS & operating expenses
How are production and operating costs structured?
The COGS item and operating expenses are separated from the COGS product-related, variable costs and operating expenses fixed as a whole by forecast.
COGS and operating expenses
In terms of costs, COGS, variable costs and fixed expenditure schedules are organised.
03 / Analysis of the scenario
How do you compare low, low and high cases?
In view of the analysis of the scenario, the low, basic and high trajectories for revenue, gross margin, contribution margin and EBITDA over five years are compared.
Analysis of scenarios
The scenario analysis compares the low, basic and high trajectories for the four key financial results.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines model setting, scenario management, a mix of revenue, profitability, cash flow and return on investment in one management view.
Dashboard
Dashboard is consolidating configuration controls, scenario results, revenue mix, profitability, cash flow and repayment.
Product adjustment
Is the financial model of an insulin-powered store for diabetics suitable for you?
The ready-made model is suitable for e-commerce stores using customer acquisition, repeating cohorts, order volumes, product mix and price; substantially different operational logic may require individual modelling.
Model ready
It fits perfectly
Your store acquires customers through online and offline marketing channels with measurable CAC.
You expect a certain number of new customers to become repeat buyers.
You're selling multiple product categories using order units, a mix of sales and category prices.
You want the client, the cost, the scenario, and the financial results to be linked together by a single forecast.
Order structure
Think about the model
Your revenue depends primarily on insurance compensation, settlement of claims or payment agreements.
Your basic model requires subscribing, renting or renting equipment instead of product ordering revenue.
You need inventory schedules, replenishment or refunds outside the e-commerce structure in the workbook.
You need very different reports or calculations based on internal operational requirements.
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 financial reporting.
Upon purchase, you will receive an editable workbook of the financial model for the five-year forecast with scenario analysis and related financial reports.
01
Book to be edited
Current assumptions regarding marketing, CAC, multiple customer, orders, sales mix, prices, costs, staff, capital and financing.
02
Forecast five years old
Planning of monthly and annual financial results over a five-year projection horizon.
03
Analysis of scenarios
Compare the Low, Base and High cases in the workbook scenario.
04
Financial statements
Review of the reports on income, cash flow, balance sheet, table and supplementary reports.
Before purchase
Diabetes Insulin Pump Supply Store 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 the revenue of an insulin-powered diabetes store?
It accepts new customers by channel, adds active recurring orders, converts orders into units, allocates units by sales mix and applies category prices.
02
Which assumptions can I change?
You can edit the launch date, channel budget and seasonality, CAC, recurring customer percentage and usage period, recurring orders, units per order, sales mix and annual prices.
03
What can I compare between low, basic and high scenarios?
Alternative trajectories of revenue, gross margin, contribution margin and EBITDA for the five-year forecast can be compared.
04
What financial results are taken into account?
The workbook review shall confirm the income statement, the cash flow statement, the balance sheet, the dashboard, the summary, the settlement, the ROIC, the charts, the KPIs and the additional reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or customize the model when you need a different revenue logic, operating schedule or reporting.
06
Is the book a prediction or a guarantee?
This is a planning forecast based on the assumptions contained in the workbook and not a guarantee of economic performance.
What Does the Diabetes Insulin Pump Supply Store Financial Model Contain?
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.
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
