Comprehensive 3 - Statement Financial Model for a Midstream Oil and Gas (Refinery with 7- Years Forecast)

Description
The Comprehensive financial model for a 6,000-barrel-per-day refinery is an interactive, flexible, easy to update 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 at a glance for presentation purposes. 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 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 showing the financial performance of the business monthly over the lifetime of the model. In addition to this, the model also summarizes output 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 made to various inputs such as crude oil prices, prices of refined/white products, and capacity utilization. 

Model Output
7-Year Annual Financial Statement
Monthly Financial Statement
General Dashboard
IRRPayback 

Key Users
-Professionals in Corporate & Project Finance
-Entrepreneurs
-Corporate Institutions
-Other Financial Modelers/ Consultants
-Postgraduate and  Undergraduate Students