Saved Me Hours
I used to spend days building the numbers by hand, and this template cut that down to a single afternoon. It let me move straight to planning instead of wrestling with formulas.
I used to spend days building the numbers by hand, and this template cut that down to a single afternoon. It let me move straight to planning instead of wrestling with formulas.
I could finally see margins and break-even in one place, which made the pricing assumptions much easier to sanity-check. It turned a messy spreadsheet into something I could explain in one meeting.
The cash-flow forecast made runway and shortfalls much easier to see, and that gave me a clearer view of when we’d need funding. One clean model replaced a lot of guessing.
This editable five-year Excel or Google Sheets workbook modeled monthly sales of aromatherapy from acquisition customers, recurring customer cohort, orders, product mix, prices and related financial statements.
Use workbook to translate marketing budgets, CAC channel, repeat customer behaviour, order volume, product mix and category prices into the five-year aromatherapy programme forecast.
The editable assumptions flow through revenue, COGS and operating expenses, scenarios and financial statements so that changes can be reviewed throughout the model.
Revenue starts with channel marketing and CAC spending and then adds further customer orders, units per order, product sales mix and category prices.
Divide each channel's marketing spending into its CAC, and then add online and offline new customers.
Transform some of the new customers into repeat buyers and keep each cohort active for a certain lifetime.
Add the first purchase order to the active repeat customers multiplied by the average monthly recurring orders.
Multiplied orders by units per order, followed by the allocation of a common set of units by product category sales mix.
Repeatedly differentiate the category units by matching the prices and sums of the revenue category in individual products and months.
Revenue sheet combines launch time, channel budget, seasonality of acquisition, CAC, recurring customer behaviour, frequency of order, unit per order, product mix and price of category with monthly sales.
REVENUE
The COGS & OPEX sheet separates the cost of procurement and implementation, the variable cost of sales and the recurring general cost as part of the monthly forecasts.
COGS & OPEX
In view of the scenarios, it compares the paths of low, basic and high revenues, gross margin, contribution margin and EBITDA over the five-year forecast.
SCENARIOS
The Dashboard combines configuration controls, scenario multipliers, main finance, a mix of revenue, profitability, cash flow and return on investment in one management view.
DASHBOARD
The ready-made workbook adapts to aromatherapy e-commerce operations using the delivered customer and product logic; different engine structures or revenue schedules may require individual modelling.
The indicator is the starting point for planning, not a guarantee of performance.
The Financial Models Lab may build or adapt the model where the revenue logic, operational schedules or required reporting differ from the finished structure.
ORDER A CUSTOM FINANCIAL MODELAt the end of cash, you will receive an edited Excel or Google Sheets financial model with five-year forecasts, a low/basic/high scenario analysis and related financial reports.
Updating the operational and financial assumptions in the entire pre-established calculation model.
Review of the five-year forecasts with detailed monthly and annual financial reporting.
Compare Low, Base, and High cases by controlling the scenarios and charts of the workbook.
See the income statement, cash flow, balance sheet, summary and dashboard results.
The basic answers are visible in their entirety, without the need to click on the accordion.
It counts new customers by channel, adds active orders with repeat customers, converts orders into units, allocates a sales mix and multiplies unit categories by price.
You can edit launch times, channel budgets and seasonality, CAC, repeat buyers rates and duration, repeat orders, unit per order, sales mix and category prices.
In view of the scenarios, it compares the low, basic and high paths for revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
The workbook report shall include the income statement, the cash flow, the sheet balance, the summary, the dashboard, the failure, the ROIC, the charts, the key indicators, the assessment, the ratio and other reporting views.
Yes. the Financial Models Lab can build or customize the model when you need a different revenue logic, operating schedule or reporting.
This is a financial forecast driven by editable assumptions and not a guarantee of business performance, profitability, financing or return.
This template includes everything you need to build a comprehensive financial plan for your aromatherapy business, from revenue modeling to detailed expense tracking.
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