Student Enrollment Predictive Capacity Forecasting Model

Design an advanced Excel predictive model using historical enrollment data, demographic trends, and regression analysis to forecast student capacity for the next 5 academic years. The model should include dynamic Monte Carlo simulation with confidence intervals, incorporate external data sources like regional population growth, and create interactive dashboard visualization showing potential enrollment scenarios. Include VBA macro functionality to automatically update projections when new data is imported.