Acquire Customers
Divide each channel marketing budget by its CAC, applying seasonality, then combine online and offline customers.
This editable five-year Excel and Google Sheets model forecasts herbal remedies ecommerce sales from acquisition, repeat buying, product mix, pricing, costs, and financial outputs.
Use the model to translate customer acquisition, repeat purchasing, order volume, product mix, prices, and costs into a five-year herbal remedies financial forecast.
Editable assumptions feed monthly and annual calculations, Low/Base/High cases, financial statements, and management reporting views throughout the model.
The model converts online and offline marketing spend into customers, repeat cohorts, orders, units, category allocation, and priced product sales each month.
Divide each channel marketing budget by its CAC, applying seasonality, then combine online and offline customers.
Apply repeat-buyer percentage and customer lifetime to cohorts, then calculate active repeat customers and ordering frequency.
Add first-purchase orders from new customers to active repeat customers multiplied by average repeat orders per month.
Multiply total orders by units per order, then allocate the shared unit pool by category sales mix.
Multiply category units by matching category prices and sum revenue across product categories and months.
The Revenue view links channel budgets, CAC, repeat behavior, order volume, product mix, and category prices to herbal remedies sales.
REVENUE
The COGS & OPEX worksheet organizes direct product costs, variable expenses, and fixed operating expenses that feed the forecast and statements.
COGS & OPEX
The Scenarios view compares Low, Base, and High outcomes for revenue, margins, and EBITDA so assumption changes can be reviewed side by side.
SCENARIOS
The Dashboard combines model setup, scenario controls, financial outputs, revenue mix, profitability, cash flow, and investment payback charts in one view.
DASHBOARD
This ready-made structure fits herbal remedies ecommerce planning using customer acquisition, repeat cohorts, product mix, and category pricing; different operating logic may require custom work.
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 MODELYou receive an instant-download, fully editable Excel and Google Sheets model with five-year monthly and annual projections, scenarios, statements, and reporting views.
Update revenue, cost, staffing, capital, and global planning assumptions throughout the editable model.
Review detailed monthly and annual projections across the five-year planning horizon.
Compare Low, Base, and High cases using the model's scenario framework.
Review the income statement, cash flow, balance sheet, dashboard, and supporting reports.
The essential answers are visible in full, with no accordion clicks required.
It converts channel marketing spend and CAC into customers, models repeat cohorts and orders, allocates units by category mix, and applies category prices.
You can edit launch timing, channel budgets and seasonality, CAC, repeat behavior, units per order, category mix, and category prices by year.
You can compare modeled revenue, gross margin, contribution margin, and EBITDA trajectories across the three cases.
The workbook includes the income statement, cash flow statement, balance sheet, Dashboard, Summary, Scenarios, and supporting analysis reports.
Yes. Financial Models Lab can build or adapt a model when different revenue logic, operating schedules, or financial outputs are required.
It is a planning forecast based on editable assumptions, not a guarantee of business performance or financial results.
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.
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
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.
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.
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.