Stress scenario — churn doubles

Nexus Financial Services · SQL · advanced

The brief

Elena:

Model the impact if our 2024 churn rate doubled in 2025. For each industry, calculate:

- Current 2024 churn rate - Projected 2025 churn rate (current × 2) - 2024 churn count - Projected 2025 churn count (using projected rate × current active customers) - Deposit dollars at risk (current active deposits in that industry × projected churn rate)

Order by deposit dollars at risk descending.

This tells the board which industry segments are most exposed if our retention work fails.

Independent grading

88/100

Achieved 11 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more