Oil & Gas Project Finance Model Excel Template

Description
Oil and Gas Project Finance Modeling Template.

This is a project finance model for an oil and gas upstream special project vehicle (SPV). This project finance model template has been built using the FAST standard.
This oil and gas project finance model template has incorporated the following:
a. well-structured input layout that can be updated using real project data.
b. construction period, operation period, and timing flexibility.
c. flexible scenarios and switches to test the viability of the project based on different input.
c. Nigeria petroleum income tax (PIA), also known as the fiscal policy. This includes royalties, tax holidays, hydrocarbon tax, company income tax, tertiary education tax, abandonment cost, CPR limit, investment tax allowance, HCDTF levy, NGGC levy, production allowance, and the maximum capital allowance absorbed.
d. funding sources, funding splits, and funding terms, including a moratorium period, capitalized interest during construction.
e.  oil and gas production profiles, price per barrel, gas mscf, variable cost per measure, fixed cost per measure, and operating working capital.
f. asset depreciation and capital allowances.
g. forecast output - income statement, balance sheet, and cashflow.
h. investment evaluation: free cashflow to firm, discounted cashflow, implied valuation, implied EV/2P reserves, internal rate of return (IRR), CFADS, DSCR, DSRA, ICR, ratios, margins, debt sizing, and debt service.