All of the Sweet 16 forecast/valuation models are macro driven Excel spreadsheets. If you change oil, gas and NGL price assumptions for the forecast periods the spreadsheets will automatically update revenues, net income and stock price valuation.
Remember that companies with a lot of production hedged are not impacted much by the ups and downs of oil and gas prices.
Sweet 16 valuations
Sweet 16 valuations
Dan Steffens
Energy Prospectus Group
Energy Prospectus Group