With a recent improvement in sentiment for natural gas production stocks, we wanted to see which companies' cash flow would be most sensitive to an increase in natural gas prices in 2020 and 2021.
Canalyst’s database of models with common sector specific row names enables us to quickly pull data across any number of names. Here we pulled the liquids production proportion across our exploration and production universe and sorted from gassiest to most liquid to narrow down the names we were going to look at. Starting with 98 stocks with liquids weightings, we removed names <$250mm market cap, narrowing it down to 58, and then took the top 15 names on gas weighting.
 
Then, it’s quick enough to link the sheets into a master compsheet in order to run different pricing scenarios across the narrowed universe. We tested these stocks cash flow per share sensitivity at 50c increments in benchmark natural gas prices and got the following output: 
 
Clients may access this sheet on our portal which is conveniently linked to support any case of their choosing. If you’d like to start running Canalyst Scenarios, request free access to our custom screens here.

You May Also Like

Ratios Tab Expedites Comparing Names Across a Sector

Canalyst’s newest drop-in sheet calculates all of a company’s ratios, making it easier to comp...

Read More
September 11, 2020

Drivers Worksheets Speed Up Scenario Analysis

Adjust the forecast values for the model drivers all in one place, and see the effect of their for...

Read More
June 3, 2020

New Solvency Screen

Who has enough cash to survive (the longest) without revenue? Our Solvency Output highlights days ...

Read More
April 21, 2020