Dynamic Revenue Forecasting Model with Monte Carlo Simulation

Create an advanced Excel forecasting model that uses Monte Carlo simulation to predict revenue scenarios with probabilistic outcomes. The model should incorporate historical data, allow for multiple input variables (sales volume, pricing, market conditions), and generate a probability distribution of potential revenue outcomes. Design interactive input cells that allow users to adjust key assumptions, with visualization of potential scenarios using dynamic charts. Include confidence intervals, standard deviation calculations, and a summary dashboard that highlights best-case, worst-case, and most likely revenue projections.