Trusted by 25,000+ startup founders, investors and CPAs
Margins Finally Stood Out
Megan Carter, TX
The template made margin and break-even numbers easy to see, which saved me hours of digging through tabs. I could spot the weak points fast and adjust pricing before the next planning meeting.
Investor Format Made Clear
Daniel Brooks, NY
I finally had a model that showed the right outputs in the right order, so I wasn’t guessing what investors expected. It cut my prep time by a full day and helped me book a cleaner follow-up call.
Scenario Planning Got Easy
Alyssa Grant, FL
Switching between low, base, and high cases used to take forever, but this template made it simple. I built all three versions in under an hour and had cleaner numbers for our planning review.
MODEL OVERVIEW
What Is the Financial Model of Oil Refinery?
It is a five-year workbook for oil refineries, which combines volumes and prices of petroleum products with monthly and annual financial statements, scenarios and management reports.
Use of the model to plan the production of refineries and the sale of products and then follow operational assumptions through costs, cash flow, profitability and financial situation.
The names of the petroleum products to be edited, the time of production, the production units, the sales prices, the monthly seasonality and the additional income are the basis for the forecasts and related reports.
Built around the economy of refinery productsThis model maintains the revenues of refineries related to the production units and the corresponding sales prices, not the single contribution of the highest quality growth.
ENGINE OF THE REVENUE FROM THE OIL REFINER
How Does the Model Calculate Petroleum Refinery Revenues?
The model calculates each line of petroleum product from the units produced and its adjusted selling price, is applied once a month seasonality and then adds possible additional income.
01
Set Product Lines
The name of each line of petroleum product shall be indicated and the time of production shall be indicated, if applicable.
02
Enter Production
The annual units produced for each line of petroleum products included shall be reported.
03
Set Sales Prices
Enter the corresponding selling price per piece for each line of product.
04
Calculate and Clear
Multiplication of units at price and allocation of annual income through monthly seasonality once.
05
Total Revenue
Total of receipts from petroleum products and any separately entered additional income.
FORM OF CORRECTIONRevenue = units produced × selling price + ancillary revenue
01 / REVENUE
How Does the Revenues of Oil Refinery Drive Prognose?
The income working sheet combines oil product lines, start date, annual units produced, sales prices, monthly seasonality and calculated revenue in the entire forecast.
REVENUE
The revenue outlook shows the oil product units, prices, seasonality and annual revenues calculated.
02 / COGS
How Are the Refinery Cost Drivers Modelled?
The COGS worksheet combines product-specific direct costs with profit-per-per-month forecasting bases.
COGS
View COGS shows direct cost categories, calculation bases, assumptions and monthly results.
03 / SCENARIOS
How Can You Compare Low, Core and High?
The Scenarios compared low, base and high revenue paths, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The scenario view compares low, base and high financial paths for five years.
04 / DASHBOARD
What Does the Dashboard Show?
The board includes a set of models, scenarios results, basic finances, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
The navigation desk combines configuration control, scenario results, financial trends, cash flow and cost recovery.
FIT OF PRODUCTS
Is the Oil Refinery Finance Model Suitable for You?
It fits with refineries using the logic of production revenue and prices; different types of recognition mechanisms, operational schedules or reporting structures may require non-standard modelling.
MODEL BY MADA READY
Good Example
The revenue comes from units of petroleum products produced multiplied by matching sales prices.
You plan many refinery products with start time and monthly seasonality.
You need the possibility to edit production, prices, direct costs, personnel and capital assumptions.
You want five-year and annual reports from Low, Base and High Cases.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your recognition of income depends on the separate sale, stock, contract or mechanics of acquisition outside the manufactured units.
Your refinery requires performance, mix, raw materials or productivity schedules beyond the current template structure.
You need different operational schedules, reporting systems or management results.
Your model requires financing or accounting logic for specific companies outside of this structure.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The financial models of Lab can build or adapt the financial model when you need different revenue logic, operating schedules or reporting from the ready-made template.
After booking, you will receive a five-year model of the oil refinery with a monthly and annual forecast, an analysis of scenarios and related financial reports.
01
Editable workbook
Change the assumptions regarding the production of refineries, prices, costs, personnel, capital and financing for the plan.
02
year forecast 5
Review five years of forecasts with detailed opinions each month and each year.
03
Analysis of scenarios
Compare low, base and high cases using scenario structure model.
04
Financial statements
Review of related balance sheet, balance sheet, summary and management results.
BEFORE BUYING IMPORTANT INFORMATION
Oil Refinery Model Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the oil refinery's income?
It calculates each line of petroleum product from units produced multiplied by its matching selling price, then sums up the revenue from the products and allows auxiliary income.
02
What assumptions can I change for oil refineries?
You can edit product line names, run time, units produced, sales prices, monthly seasonality, additional revenue and other operating assumptions presented in the workbook.
03
What can I compare in Low, Base and High scenarios?
The alternative paths for revenues, gross margin, premium premium and EBITDA in the five-year forecast can be compared.
04
What financial results are taken into account?
The Gallery presents the Income Statement, cash flow report, balance sheet, dashboard, summary and additional financial analysis reports.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The Financial Models Laboratory can build or adjust a model when the revenue logic, work schedules or reporting needs differ from the final structure.
06
Is this a forecast or a guarantee?
This is a planning forecast based on assumptions contained in the workbook, not a guarantee of business results.
What Does the Oil Refinery Financial Model Contain?
This powerful template includes everything you need to develop a financial model for an oil refinery project, from detailed revenue forecasts to a complete set of financial statements.
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
SCENARIOS
DASHBOARD
