analytics_monte_carlo_simulation
Run Monte Carlo simulations to analyze financial risks and plan scenarios by modeling variables with probability distributions in Excel.
Instructions
Run Monte Carlo simulation for risk analysis and scenario planning
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scenarioName | Yes | Name of the scenario being analyzed | |
| description | No | Description of what this simulation models | |
| formula | Yes | Formula using variable names (e.g., 'revenue - costs - taxes') | |
| iterations | No | Number of simulation iterations | |
| variables | Yes | ||
| worksheetName | No | Monte Carlo Analysis |