Dynamic Revenue Projection Model with Monte Carlo Simulation

Create an advanced Excel workbook that performs Monte Carlo simulation for revenue forecasting across multiple business scenarios. The model should include 500 iterations, allow input of key variables like average sale price, potential market size, and conversion rates, and generate probabilistic revenue distributions with confidence intervals. Implement dynamic data tables and tornado charts to visualize potential outcomes, with built-in VBA macros to automatically refresh and recalculate simulations when underlying data changes.