Trusted by 25,000+ startup founders, investors and CPAs
Assumptions Organized At Last
Megan Carter, TX
This template brought pricing, costs, and growth into one place, so I could finally see the full picture without digging through scattered tabs. It saved me hours of cleanup before our planning meeting.
A Clear Starting Point
Daniel Brooks, NC
I was staring at a blank spreadsheet and not making progress. This model gave me a structure fast, and I had a usable first draft in under a day.
Fewer Formula Headaches
Priya Shah, CA
The built-in formulas kept my model stable, so one small change didn’t throw off the whole sheet. That saved me from rechecking every cell before I sent it to our advisor.
Model review
What is the financial model of oil production?
This editable five-year Excel or Google Sheets model combines product quantities, unit prices, costs, scenarios and financial statements for planning the production of essential oils.
Use the workbook to develop a five-year operational forecast based on product size, prices, production costs, employment, capital expenditure and financial commitments.
The editable assumptions flow through monthly and annual calculations in scenario comparisons, key statements and dashboard reports.
Built to plan line by lineThe unit wages for the product and prices shall keep the revenue related to the production plan.
revenue engine of the product line
How is the revenue calculated from the production of oil in this model?
Revenue are constructed by multiplying the recognised units of each product line by the corresponding sales price, applying the seasonality once a month and then adding the permissible additional revenue.
01
Definition of the line
Set the name of the manufactured products and the start date in which the model uses the start dates.
02
Plan units
Enter a product unit schedule using units sold when recognition is separate from production.
03
Set the price
An appropriate unit sales price should be assigned for each product line included.
04
Use seasonality
The annual revenue of the production line shall be allocated exactly once in the monthly seasonal schedule.
05
Total revenue
Sum of all revenue from the production line and any additional revenue given separately.
Basic formularevenue = units sold × sale price + additional revenue
01 / Revenue
How are the product-line revenues structured?
The revenue article organizes the introduction of products, the number of units, the price per unit, the seasonality and the calculated forecast revenue by product line.
Revenue
The revenue display shows the volume of the product line, prices, seasonality and forecast sections.
02 / OPEX
How are operating expenses planned?
The OPEX article separates the variable expenditure related to revenue from the fixed operating expenditure on the initial, final, expenditure and periodicity assumptions.
OPEX
The OPEX view shows variable costs based on revenue, fixed costs, time and monthly forecast.
03 / Scenarios
What can be compared with things low, low, and high?
The Scenarios report compares the low, basic and high paths in terms of revenue, gross margin, contribution margin and EBITDA over five years.
Scenarios
The scenario view compares the five-year paths of revenue, margin and EBITDA on a case-by-case basis.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines multiple scenarios, basic finance, a mixture of revenue, profitability, cash flow and return on investment in a single management view.
Dashboard
The Dashboard view combines configuration controls, the outcome of the scenarios, basic finances and management charts.
Product adjustment
Is the financial model of essential oil production right for you?
The ready-made model is compatible with the unit production and price economy; structural work on order is more appropriate where the revenue logic, timetable or reporting differ significantly.
Model ready
It fits perfectly
Your revenue is driven by product units multiplied by unit sales prices.
You're planning multiple product lines with editable launch dates, volumes and prices.
You want a monthly seasonality and a five-year financial forecast in one editable workbook.
You need comparisons of low, basic and high and boards and major financial statements.
Order structure
Think about the model
Your revenue depends on contracts, subscriptions, licenses or other sales engineers.
You need inventory recognition or sales logic that's substantially different from the structure of the workbook.
You need operational schedules that go beyond the revenue, costs, employment, capital and financing framework presented in the workbook.
You really need different reports, consolidated entities, or tailored models.
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?
The Financial Model Laboratory can build or adapt the model when you need different revenue logic, operational timetable or reporting requirements.
After you purchase, you will receive a fully editable five-year financial model for Excel or Google Sheets as an instant download.
01
Book to be edited
Open and edit the model in Excel or Google Sheets.
02
Forecast for five years
revenue plan, costs, profits and cash flow over the foreseeable five years.
03
Analysis of scenarios
Compare the Low, Base and High cases using the model scenario view.
04
Financial statements
An overview of income statement, cash flow, balance sheet, dashboard and supplementary reports.
Before purchase
Financial model of basic oil production 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 from the production of essential oils?
Revenue shall be calculated according to the product line of recognised units multiplied by the corresponding sales price and then combined with any additional revenue authorised. The monthly seasonality allocates annual revenue from the production line once.
02
Which assumptions can I change?
Product line names, start-up time where applicable, unit volume, unit prices, identification entries when displayed, monthly seasonality and additional revenues allowed may be changed.
03
What can I compare the Low, Base and High scenarios to?
They allow the comparison of alternative five-year revenue, gross margins, contribution margins and EBITDA paths within the model scenario settings.
04
What financial results are taken into account?
The workbook includes the dashboard, the income statement, the cash flow report, the balance sheet, the summary, the scenarios and the financial statements.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or adapt the model to different revenue logic, operational schedules or reporting requirements.
06
Is the book a prediction or a guarantee?
This is a planning forecast, not a guarantee of business performance, financing, profitability or return.
What Does the Essential Oil Manufacturing Financial Model Contain?
This is a comprehensive, five-year essential oil manufacturing feasibility study template designed to take you from idea to investor-ready pitch.
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
OPEX
Scenarios
Dashboard
