Upstream Oil & Gas Project

This is a Excel financial model template for an upstream oil & gas project and it contains a forecast horizon up to 30 years.

, ,
, , , , , , , , , , , , , , , , , , , , , , , , ,

This is an Excel financial model template for an upstream oil & gas project. The model contains a forecast horizon of up to 30 years, and allows to project an investment case based on your own forecast of oil prices, oil production, costs (variable and fixed) and the required investment. The model provides a framework to determine the project’s feasibility by calculating the IRRs of the project and also by taking into account a promote (carry) payable from investors to the promoter of the project. The Excel model comes with an Executive Summary and graphs to better understand the investment case.

 

A video with a walk-through of this model is available here:

 

The highlights of this financial model template in Excel are the following:

  • 30 year forecast horizon for revenues, costs, investments, financial debt, profit share, balance sheet and all cash flows
  • Executive Summary Sheet with a variety of graphs, key financial information and the main assumptions
  • Break-even analysis to determine the required oil price to make this project work
  • Assumptions include: years of the expected project life, oil price, oil volume, fixed costs, variable costs, general assumptions
  • Calculation of the required funding required
  • Calculation of the lifetime profits of this project
  • Calculation of the project’s payback period
  • Uses and Sources of Funds Table
  • Three Statement Model with Income Statement, Balance Sheet and Cash Flow Statement Forecast (also for 30 years)
  • IRR calculations: Project IRR based on the Free Cash Flow to the Firm (FCFE) and Equity IRR based on the Levered Free Cash Flow to Equity Investors
  • Comparison of profits and returns (Internal Rate of Return IRR, average cash on cash yield CoC) for each investor
  • Debt schedule
  • Fixed Asset Schedule
  • Simple Waterfall Model to calculate a promote (or carry) payable from investors (Limited Partners) to the project’s promoter (General Partner). This profit split simply assumes a certain percentage given from the yearly cash flows from investors to the promoter. The percentage split in this model depends if the initial investment has been paid back or not yet

 

The full Excel model is available in two versions, including or excluding the sensitivity tables. For both Excel models, a Free PDF demo version is available for download.

 

Upstream Oil & Gas Executive Summary
Upstream Oil & Gas Executive Summary

 

Upstream Oil & Gas Financing Structure
Upstream Oil & Gas Financing Structure

 

Upstream Oil & Gas IRR Calculation
Upstream Oil & Gas IRR Calculation

 

Upstream Oil & Gas Simple Waterfall & Carry Calculation
Upstream Oil & Gas Simple Waterfall & Carry Calculation

 

Upstream Oil & Gas Debt Schedule
Upstream Oil & Gas Debt Schedule
Upstream Oil & Gas Detailed 30 years Income Statement Forecast
Upstream Oil & Gas Detailed 30 years Income Statement Forecast
Upstream Oil & Gas Financial Ratios
Upstream Oil & Gas Financial Ratios
Upstream Oil & Gas Revenue_Estimation
Upstream Oil & Gas Revenue Estimation

 

Upstream Oil & Gas Three Statement Model - Condensed
Upstream Oil & Gas Three Statement Model – Condensed

 

Users who purchased Upstream Oil & Gas Project, also purchased:
E-Commerce 3 Statement Financial Projection Model with Valuation
Add to wish list
Purchase Excluding 0% tax
Investment Return Monte Carlo Simulation Excel Model Template
Add to wish list
Purchase Excluding 0% tax
Start Up Hydro Dam Excel Model and Valuation
Add to wish list
Purchase Excluding 0% tax

Write a Review

Get these templates too for a discount!

Price: $112.00

This is a collection of financial model templates for projects or ventures in the Renewable Energy Industry and its related…

Add to wish list
Add to cart Excluding 0% tax

Price: $149.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 0% tax

Starting at: $99.00

I have added all the industry specific financial models all into one bundled package. Included Models: 1. Mining Operation 2.…

Add to wish list
Add to cart Excluding 0% tax