calculate_price_sensitivity
Calculate NPV across multiple oil and gas price scenarios to assess project sensitivity and generate tornado charts for investment decisions.
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 |