This Excel spreadsheet template models the financial projections for a portfolio of up to 10 upstream Oil & Gas Drilling wells from a Private Equity investor point of view. Investors can either invest at the project level or the consolidated level.
This spreadsheet model was created to provide a more advanced model version than the Upstream Oil & Gas model, which includes not only one well but an investment in a portfolio of different drilling well projects. The Private Equity Oil and Gas Financial Model contains detailed financial projections, including Income Statement, Balance Sheet, Cash Flow Statement, Financial Ratios and Free Cash Flow Forecast for each drilling well project as well as for their aggregated financial projections at a consolidated level. The forecast horizon covers a period of 30 years for each of the 10 drilling well projects. The model is driven by a set of assumptions that help to forecast the production of oil, gas, or natural gas liquid (NGL) and the corresponding revenues, costs, and capital expenditures for each well.
The Private Equity Oil and Gas Financial Model calculates a range of financial feasibility metrics such as the amount of funding required, Internal Rate of Return (IRR), Payback Period, Cash on Cash Yield, and Net Present Value (NPV). Summary sheets also provide breakdowns and comparisons of the relevant financial metrics by the project. Uses and sources of funds are stated on a project-by-project basis as well as on an aggregated level. For each drilling project, a debt financing schedule is included as well. The model also calculates and compares the break-even points for volumes and prices for each project. A sensitivity analysis is available for the IRR calculations.
Private Equity Investors can invest by using a standard General Partner/Limited Partner profit distribution model where the general partner’s compensation can be modeled depending on the achieved financial performance. A two-tier profit distribution waterfall model is included, allowing investor participation either at the project or the consolidated level.
There is also one worksheet included, which allows to break down the yearly budgets of the first two years to a monthly schedule.
A video with a walk-through of the Private Equity Oil and Gas Financial Model model template is available here:
The model includes the following worksheets:
• Title sheet
• General Assumptions
• Project Assumptions
• Uses and Sources of Funds
• Model Checks
• Project Comparison
• Project Summary
• Project Summary
• Monthly Budget
• Consolidated Financials
• Investor Financials
• Project Sheets 1 – 10
The summary and the project summary sheets contain a series of tables and charts which allow deep insights, project comparisons, and financial analysis into such a portfolio. Furthermore, there are toggles to include/exclude each drilling project from the consolidated forecast. In addition, the start year for each project can be changed flexibly in the Excel spreadsheet template. This model structure allows running a series of different scenarios to understand better how their impact on the overall financial feasibility metrics and funding required.
Why this is a great model to purchase?
• Suitable for oil and gas drilling projects
• Analyze each drilling project separately
• Compare the key financial metrics of the different drilling projects and identify priorities
• Simulate investor participation at holding or at project levels together with a profit-sharing structure
• Tons of charts and tables which allow obtaining a solid understanding and insights into such projects
• Run a variety of consolidation and timing scenarios
The Excel model is available in two versions: a free PDF Demo Version and a fully editable MS Excel version.
Important Tip: Download the free PDF Demo Version to obtain a precise understanding of the model structure.
File Types: .xlsx .pdf