When you're valuing an E&P (Exploration & Production) company, the Net Asset Value (NAV) Model is the key methodology.
By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers"
UNLIKE in a DCF, where cash flow growth is assumed into infinity, in a NAV model you assume the company's cash flows go to $0 eventually as it completely produces all of its reserves and has nothing left.
A granular NAV model is complex, but it comes down to a 2-step process:
Step 1: Model the company's existing production from wells it already has... and assume a decline rate for the annual production each year, also assuming commodity prices to determine revenue, and linking operating expenses to production and calculating cash flow like that.
Step 2: Assume the company drills new wells in its PUD (Proved Undeveloped), PROB (Probable), and POSS (Possible) reserves.
The second step involves dozens of sub-steps and assumptions, but here we're just going to focus on ONE small part of this process: estimating the decline rate of a new well the company drills.
It starts off at a very high production rate, but then declines quickly within even the first year of its useful life - and we need to estimate the decline rates each year to build the rest of the model.
You COULD do lots of complicated math, try fitting hyperbolic or exponential functions, run a regression analysis, etc., but we suggest a much simpler approach here: if the company doesn't disclose data on its decline rates for individual wells, find data from another company operating in the same region and fit it to your company's "average" wells.
How to Do That:
Step 1: Find the company's key data, such as the EUR per well and IP rate per well in the region you're looking at.
Step 2: Now, see if the company discloses data on its own decline rates... if so, you're set!
If not, or if it's not enough, find another company operating in the region that discloses more data (EQT here), and go to that company's investor presentations to get the numbers.
Step 3: In the first year, assume that production is some % of 365 * IP Rate per Well... because there is a huge drop-off in daily production from Month 1 to Month 12 in that first year.
EQT's data shows 45%; we assume 60% here since UPL has a slightly flatter decline curve.
Step 4: Copy and paste the other company's decline rates into each year of your decline curve.
Step 5: Enter the correct formula for calculating annual production each year AFTER the initial year... here:
Want to take either Last Year Production * (1 + Decline Rate) (the first part), or the total remaining reserves in this well (the second part).
Step 6: Set up Subtotal / Remainder / Total math and ensure that everything is produced.
Step 7: "Fit the data" using Goal Seek and the Factor - multiply each decline rate by a certain factor and use Goal Seek (Alt + A + W + G) to solve for the factor that makes the Subtotal equal to the EUR.
Step 8: Build in support for a different EUR by scaling the production up or down in the "Total" column.
Step 9: Allocate the production to oil vs. gas. vs. NGLs.
Step 10: Complete the Subtotal / Remainder / Total math at the bottom.
Next, we'd complete this process for all the wells the company drills in every region, estimate revenue, expenses, and cash flow for each one, and then aggregate the discounted cash flow values in every region across all reserve types...
Which brings us closer to the implied NAV per share, which is what the NAV model is really all about.
Stay tuned for more!