Compute corporate level cash flows based on roll-up of single well economics data
Usage
After configuring the package, run the workflows by triggering the included schedule for the workflow A&D Corporate Cash Flow Reset Signals.
Details
The workflows in this package will run single-well economics for all combinations of 3 hub price scenarios and 3 sets of production, OpEx, and CapEx multipliers, and then perform corporate-level cash flow calculations on the rolled-up results of those single well economics runs.
The results of these calculations can be reviewed in the
Follow the below steps in order to configure the package before executing the workflows.
Note
Because the workflows in this package automatically execute the scripts from the Economics package, running these workflows also requires configuring the Economics package.
Configuration
- Create a hierarchy containing the wells to be analyzed.
This hierarchy can have any name, but we recommend calling it A&D Economics Hierarchy. Once the hierarchy is made, specify the name of the hierarchy and the parent entity types in the workspace values A&DEconomicsHierarchyName and A&DEconomicsParentyEntityType. Doing this will automatically populate the necessary entity sets used in the package workflows. - Configure all inputs for the Economics package as per the instructions for that package.
- Choose desired execution options on the workflow activity CorporateCashFlows in the workflow A&D Corporate Cash Flow.
The following options are available:
- Acquisition Type: determines how many calculations are carried out, including how equity is calculated.
- Run Expected Case Only: if set to 'true', will only run economics for the Expected price Scenario with the Expected set of multipliers. If set to 'false', will run full set of all scenarios and multipliers.
Tip
When the "Expected Case Only" option is chosen, outputs will be saved directly to the workspace rather than to a scenario. This is a useful option when first setting up and configuring the inputs, as it will allow you to quickly make multiple runs and see the results before running the entire set of scenarios.
-
- G&A Option: determines how G&A will be determined. See below if choosing the Quarterly Schedule option.
- Debt Limits Option: determines how debt limits will be determined. See below if choosing the Quarterly Schedule option.
- Profits option: determines whether profits will be paid out as dividends
- Tandem Div & Debt Increase: whether dividends will be paid out if it means an increase in debt.
- Basis for infrastructure CapEx: determines how infrastructure capital expenses will be calculated. See below if choosing the Quarterly Schedule option.
- Dictionary inputs: the remaining inputs specify the workspace dictionaries that will be accessed by the activity. These should be left as the default values.
- Create three hub price scenarios for your downside case, upside case, and expected case. These scenarios should be loaded with hub prices for the parent entities in the hierarchy created above. Specify the names of these scenarios in the workspace dictionary A&D Corporate Cash Flow Inputs - Economics Sensitivity Settings.
Tip
There is a script included in the package called A&D Economics Load Scenario Data that can be used to copy the hub prices signals from the workspace into a scenario.
- Set all values in the included workspace dictionaries and workspace values.
Tip
The easiest way to find all of the workspace values for the package is through the Configure option in the Workspace Settings packages tab, accessed by clicking the gear icon at the bottom left of the window in the PetroVisor app.
Optional Configuration
If you wish to use the Quarterly Inputs options, you should go to the data view filter titled "A&D Corporate Cash Flow Quarterly Inputs" and fill in the desired quarterly schedules there.
Run Workflow
After configuring the package, run the workflows by triggering the included schedule for the workflow A&D Corporate Cash Flow Reset Signals.
Data Requirements
The following data is required on the well level
The following data is required on the parent level
Further comments
The workflows in this package will automatically create scenarios to hold the results from running the workflow. It is only necessary to manually create the hub price scenarios.