calculate_price_sensitivity
Calculate net present value across multiple oil and gas price scenarios to analyze financial sensitivity and create tornado charts for petroleum projects.
Instructions
Calculate NPV across multiple price scenarios for sensitivity/tornado charts.
Args: monthly_oil_bbl: Monthly oil production (bbl) per period. monthly_gas_mcf: Monthly gas production (Mcf) per period. monthly_water_bbl: Monthly water production (bbl) per period. opex_monthly: Monthly operating expense ($). capex: Total capital expenditure ($). price_scenarios: List of dicts with 'oil_price' and 'gas_price'. discount_rate: Annual discount rate. Default 0.10. royalty_pct: Royalty fraction (0-1). Default 0.125.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| monthly_oil_bbl | Yes | ||
| monthly_gas_mcf | Yes | ||
| monthly_water_bbl | Yes | ||
| opex_monthly | Yes | ||
| capex | Yes | ||
| price_scenarios | Yes | ||
| discount_rate | No | ||
| royalty_pct | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |