Dynamic Property Portfolio Risk Assessment Dashboard

Create an advanced Excel dashboard that calculates multi-dimensional risk scores for real estate investments using weighted scoring across 12 critical parameters: location volatility, market appreciation trends, rental yield potential, property age, maintenance costs, economic zone classification, demographic shifts, infrastructure development proximity, environmental risk factors, zoning regulations, tax implications, and liquidity index. Develop a dynamic scoring mechanism that automatically color-codes and ranks properties from low to high risk, with interactive slicers allowing instant recalculation and scenario modeling.