Advanced Credit Risk Scoring Model with Probabilistic Weighting

Develop a sophisticated Excel-based credit risk assessment model using Monte Carlo simulation and probabilistic scoring. Create a VBA macro that dynamically calculates risk probabilities across multiple financial variables including debt-to-income ratio, credit history, and current market conditions. The model should generate a comprehensive risk score with confidence intervals, incorporating both historical data and predictive analytics. Include conditional formatting to visually represent risk levels and create an interactive dashboard that allows sensitivity analysis of key risk parameters.