Five-year projections, dashboard, P&L, cash flow, balance sheet, and three scenarios - pre-built in Excel and Google Sheets. Built for herbal remedies businesses. Delivered as an instant download.
Trusted by 25,000+ startup founders, investors and CPAs
Hours Saved Fast
Megan Carter, CO
I stopped building the projections by hand and got the model done in a fraction of the time. It saved me about two days of work, and I could move straight into planning instead of wrestling with spreadsheets.
Everything In One Place
Daniel Brooks, NC
The statements and charts were finally organized in one file, so I wasn't hunting through tabs and folders anymore. That cleaned up my reporting and made it much easier to share with my team.
Clear Investor Structure
Priya Shah, NJ
I wasn't sure what investors expected, but this template gave me a clear structure to work from. It helped me put together the right outputs and get a meeting booked without second-guessing the format.
MODEL OVERVIEW
What's the financial model of herbal medicine?
This editable five-year Excel and Google Sheets model provides for e-commerce sales of herbal medicines from acquisition, repeat purchases, product mix, prices, costs and financial results.
Use the model to translate the customers of acquisition, recurring purchases, volume of orders, product mix, prices and costs in the five-year funding of herbal funds forecast.
The editable assumptions are the source of monthly and annual calculations, low/ basic/ high cases, financial statements and management reporting views across the model.
Built-in for e-commerce of herbsRevenue follows the acquisition channel, repeating cohorts, orders, units sold, category mix and category price.
HERBAL REMEDIES REVENUE ENGINE
How does the herbal medicine model calculate Revenue?
The model converts online and offline marketing spending into customers, repeating cohorts, orders, units, category allocations, and product sales in price every month.
01
Get customers
Divide each channel's marketing budget into its CAC, using seasonality, and then connect online and offline customers.
02
Build a repeating base
The percentage of repeat buyers and customer life shall be applied to the cohort and the active repeat customers and frequency of the order shall be calculated.
03
Calculating orders
Add the first purchase order from new customers to the active repeat customers multiplied by the average monthly recurring orders.
04
allocation of units
Multiplying the total number of units ordered per order and then allocating the total unit collection by sales category mixture.
05
Calculate the Revenue
Multiply the category units by matching the price of the category and the amount of revenue by product category and month.
CORE FORMULARevenue = Units sold × Average weighted product price
01 / REVENUE
Which shipments are powered by Revenue herbal medicines?
The view of Revenue links the channel budget, CAC, recurring behaviour, volume of orders, product mix and the prices of the category for the sale of herbal products.
REVENUE
Revenue worksheet shows the acquisition channel, recurring behaviour, unit volume, mix of category sales and product price entry.
02 / COGS & OPEX
How are the costs of herbal medicines and Operating expenses determined?
COGS & OPEX worksheet organises direct product costs, variable costs and fixed operating expenses that feed forecast and the declarations.
COGS & OPEX
The COGS & OPEX view separates direct product costs, variable costs and recurring constant operating expenses.
03 / SCENARIOS
How do you compare Low, Base, and High cases?
The scenario view compares the low, basic and high results for revenue, margins and EBITDA so that the changes in assumptions can be reviewed side by side.
SCENARIOS
worksheet scenarios compare the trajectories of low, basic and high revenues, gross margin, contribution margin and EBITDA.
04 / DASHBOARD
What can you analyze about Dashboard?
The Dashboard combines model configuration charts, scenario controls, financial results, a mixture of revenue, profitability, cash flow and investment payback in one display.
DASHBOARD
The Dashboard summarizes the configuration controls, the outcome of the scenarios, the underlying finances, the mix of revenue, profitability, cash flow and repayment.
PRODUCT FIT
Is the financial model for herbal medicine right for you?
This ready-made structure is suitable for e-herbal planning using acquisition customers, repeating cohort, product mix and category prices; different operational logic may require on-demand work.
READY-MADE MODEL
It fits perfectly
You sell herbal products through e-commerce to new and repeat customers.
The acquisition plan uses online and offline marketing budgets, seasonality and CAC channels.
The sale of forecast uses orders, units per order, mix of categories and price of categories.
You need editable five-year monthly and annual reports, scenarios and vision management reports.
CUSTOM STRUCTURE
Think about the model
Your revenue depends on subscriptions, wholesale contracts, services, commissions, markets or other various mechanisms.
You need operational schedules that go far beyond the structure of the customer, the product, and the cost of the model.
You need specialist reports or calculations outside the reporting structure listed in the workbook.
You need a workbook tailored to basically different business rules or planning requirements.
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 different revenue logic, operating schedules or financial reporting.
You get an instant download, fully editable Excel and Google Sheets model with five-year monthly and annual projections, scenarios, statements and reports.
01
Editing the workbook
Update revenue, costs, employment, capital and global planning assumptions across the edited model.
02
five-year forecast
A review of the detailed monthly and annual forecasts for the five-year planning horizon.
03
Analysis of scenarios
Compare Low, Base, and High cases using the model scenario frame.
04
Financial statements
Please see the income statement, cash flow, sheet balance, dashboard and supplementary reports.
BEFORE YOU BUY
Financial model of herbal remedies FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the model calculate herbal products revenue?
It converts channel marketing and CAC spending into customers, models repeat cohorts and orders, allocates units by category mix and applies category prices.
02
Which revenue assumptions can I change?
You can edit the launch time, channel budgets and seasonality, CAC, repeat behavior, unit per order, category mix and category price per year.
03
What can I compare between low, basic and high scenarios?
The model revenue, gross margin, contribution margin and EBITDA can be compared in three cases.
04
What financial results are taken into account?
The workbook shall include the income statement, the cash flow income statement, the sheet balance, the Dashboard, the summary, the scenarios and the supporting analysis reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or adapt the model where different revenue logics, operational schedules or financial results are required.
06
Is the workbook a forecast or a guarantee?
This is forecast planning based on edited assumptions, not a guarantee of business results or financial results.
What Does the Herbal Remedies Financial Model Contain?
This pre-written excel financial model for natural wellness business includes a comprehensive suite of tools, including 5-year financial statements, a dynamic dashboard, detailed assumption sheets, and automated break-even analysis.
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
