Medical Equipment Inventory Predictive Analytics Dashboard

Create an advanced Excel dashboard using Power Query and Power Pivot that predicts medical equipment lifecycle, maintenance needs, and replacement costs for a multi-facility healthcare network. The solution must incorporate: 1) Real-time depreciation calculations, 2) Predictive maintenance scheduling algorithms, 3) Cost-benefit analysis for equipment replacement, 4) Visual risk assessment matrix showing equipment reliability scores. Include conditional formatting that automatically highlights critical maintenance windows and potential budget implications.