It is an editable five-year oil refinery workbook that connects petroleum product volumes and prices to monthly and annual financial statements, scenarios, and management reports.
Use the model to plan refinery production and product sales, then trace those operating assumptions through costs, cash flow, profitability, and financial position.
Editable petroleum product names, launch timing, units produced, sales prices, monthly seasonality, and ancillary revenue feed the forecast and its linked reports.
Built around refinery product economicsThe model keeps refinery revenue tied to product units produced and matching sales prices rather than a single top-line growth input.
OIL REFINERY REVENUE ENGINE
How Does the Model Calculate Oil Refinery Revenue?
The model calculates each petroleum product line from units produced and its matching sales price, applies monthly seasonality once, then adds enabled ancillary revenue.
01
Set Product Lines
Name each petroleum product line and enter launch timing when applicable.
02
Enter Production
Enter annual units produced for each enabled petroleum product line.
03
Set Sales Prices
Enter the matching sales price per unit for each product line.
04
Calculate and Allocate
Multiply units by price and allocate annual revenue through monthly seasonality once.
05
Total Revenue
Sum enabled petroleum product revenue and any separately entered ancillary revenue.
CORE FORMULARevenue = Units produced × Sales price + Ancillary revenue
01 / REVENUE
How Do Oil Refinery Revenue Inputs Drive the Forecast?
The Revenue worksheet connects petroleum product lines, launch dates, annual units produced, sales prices, monthly seasonality, and calculated revenue across the forecast.
REVENUE
The Revenue view shows petroleum product units, prices, seasonality, and calculated annual revenue.
02 / COGS
How Are Refinery Cost Drivers Modeled?
The COGS worksheet links product-specific direct costs to percentage-of-revenue and per-unit calculation bases for monthly refinery cost forecasting.
COGS
The COGS view shows direct cost categories, calculation bases, assumptions, and monthly results.
03 / SCENARIOS
How Can You Compare Low, Base, and High Cases?
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIOS
The Scenarios view compares Low, Base, and High financial paths over five years.
04 / DASHBOARD
What Does the Dashboard Show?
The Dashboard combines model setup, scenario outputs, core financials, revenue mix, profitability, cash flow, and investment payback into one management view.
DASHBOARD
The Dashboard combines setup controls, scenario outputs, financial trends, cash flow, and payback.
PRODUCT FIT
Is the Oil Refinery Financial Model Right for You?
It fits refineries using product units-produced-and-price revenue logic; materially different recognition mechanics, operating schedules, or reporting structures may call for custom modeling.
READY-MADE MODEL
A Good Fit
Revenue comes from petroleum product units produced multiplied by matching sales prices.
You plan multiple refinery product lines with launch timing and monthly seasonality.
You need editable production, pricing, direct cost, staffing, and capital assumptions.
You want five-year monthly and annual statements with Low, Base, and High cases.
CUSTOM STRUCTURE
Consider Custom Modeling
Your revenue recognition depends on separate sales, inventory, contract, or offtake mechanics beyond produced units.
Your refinery requires yield, blend, feedstock, or capacity schedules beyond the current template structure.
You need different operating schedules, reporting layouts, or management outputs.
Your model requires business-specific financing or accounting logic outside this structure.
The template is a planning starting point, not a guarantee of performance.
CUSTOM FINANCIAL MODELING SERVICE
Need a Model Built Around Your Requirements?
Financial Models Lab can build or adapt a financial model when you need different revenue logic, operating schedules, or reporting from the ready-made template.
After checkout, you receive an editable five-year oil refinery financial model with monthly and annual forecasting, scenario analysis, and linked financial reports.
01
Editable workbook
Change refinery production, pricing, cost, staffing, capital, and financing assumptions for your plan.
02
5-year forecast
Review five years of projections with detailed monthly and annual views.
03
Scenario analysis
Compare Low, Base, and High cases using the model scenario structure.
04
Financial reports
Review linked income statement, cash flow, balance sheet, summary, and management outputs.
BEFORE YOU BUY
Oil Refinery Financial Model FAQ
The essential answers are visible in full, with no accordion clicks required.
01
How does the model calculate oil refinery revenue?
It calculates each petroleum product line from units produced multiplied by its matching sales price, then sums product revenue and enabled ancillary revenue.
02
Which oil refinery assumptions can I change?
You can edit product-line names, launch timing, units produced, sales prices, monthly seasonality, ancillary revenue, and the other operating assumptions shown in the workbook.
03
What can I compare in the Low, Base, and High scenarios?
You can compare alternative paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
04
Which financial outputs are included?
The gallery shows the Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Summary, and additional financial analysis reports.
05
Can Financial Models Lab adapt the model to custom requirements?
Yes. Financial Models Lab can build or adapt a model when your revenue logic, operating schedules, or reporting needs differ from the ready-made structure.
06
Is this workbook a forecast or a guarantee?
It is a planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
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
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.
Choosing a selection results in a full page refresh.
REVENUE
COGS
SCENARIOS
DASHBOARD
