Description
The Comprehensive financial model for a 6,000-barrel-per-day refinery is an interactive, flexible, updated, and understandable model. The model is structured into Inputs, CAPEX, Debt & Equity Schedule, Working capital, Calculations, Monthly Financial Statement and Yearly Financial Statement Tabs. The model also has an interactive dashboard allowing users to see the key items for presentation purposes visually. On the dashboard, users can understand the model drivers. They also see the key output of the model in the form of charts, ratios, and return analysis
Given the capital-intensive nature of the crude oil refining business, the model has been logically built with the key assumption of funding from debt raise and equity to form the funding source for the project to be constructed and subsequently expanded. The model also assumes an initial refining capacity of 4,000bpd with an additional expansion of refining capacity by 2,000bpd in the second year of operation. Hence, bringing the total capacity to 6,000bpd. The model is flexible for users to work around other capacities as it relates to their real-life business
The model has a dedicated monthly financial statement ( Income statement, cash flow statement, and Balance sheet) tab that shows the business’s financial performance monthly over the model’s lifetime. In addition to this, the model also summarizes the financial statement outputs in a yearly format.
Lastly, we have incorporated a scenario analysis in the model showing the best-to-worst-case scenarios. The scenario analysis is driven by our sensitivities to various inputs, such as crude oil prices, prices of refined/white products, and capacity utilization.
Key Users
-Professionals in Corporate & Project Finance
-Entrepreneurs
-Corporate Institutions
-Other Financial Modelers/ Consultants
-Postgraduate and Undergraduate Students
File types: .xlsx and .pdf
Similar Products
Other customers were also interested in...
Hydrogen Gas Sales & Tolling Business Plan an...
Hydrogen Gas Sales & Tolling Fee business plan and valuation model is an excellent tool to asses... Read more
Oil and Gas Project Finance Model
Oil and Gas Project Finance Modeling Template. This is a project finance model for an oil and gas up... Read more
Upstream Oil & Gas Project Analysis
The Upstream Oil & Gas Project Financial Model Template in Excel empowers you to project and dissect... Read more
Private Equity Oil and Gas Financial Model
The Private Equity Oil and Gas Financial Model evaluates the financial feasibility and investor retu... Read more
Industry Based Financial Models (Variety Bundle)
There are currently 52 unique financial models included in this bundle. Nearly all of that include a... Read more
Oil & Gas Financial Model – Dynamic 10 Y...
Financial Model providing forecast and valuation analysis of an upstream Oil & Gas Project. T... Read more
Oil & Gas Financial Model – DCF and NAV Valu...
The Oil and Gas financial model with DCF (Discounted Cash Flow) and NAV (Net Asset Value) Valuation ... Read more
Green Hydrogen (Simple Electrolysis Financial Mode...
The Model Incorporates data provided by different available sources to Model an Electrolysis financi... Read more
Economic Model for Oil and Gas Extraction Feasibil...
This model runs for 20 years and makes it easy to create a financial plan and feasibility study for ... Read more
Solar Energy Power Plant Financial Model
In order to assess the financial viability of a Solar Park project, the Solar Energy Financial Model... Read more
Reviews
The model was quite useful and explanatory. I particularly like the structure of the model
383 of 773 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.