Patient Retention & Revenue Calculator

Explore how improved patient retention impacts the number of active patients and revenue month by month. Adjust inputs to see both Scenario 1 (low retention) and Scenario 2 (high retention) in the chart.

Parameters & Input

Selected: 12 months
Monthly churn (months 1-3): – / –
Monthly churn (month 4+): – / –
Monthly retention (months 1-3): – / –

Key Results

Active Patients
Scenario 1 (Final Month)
–
Active Patients
Scenario 2 (Final Month)
–
Additional
Patients
–
Additional Revenue
(€)
–

Excel Formula Calculations

Core Formulas

R3 = 3-month retention rate
Monthly churn = 1 - R3^(1/3)
Monthly retention = R3^(1/3)
Active patients = Sum of all cohorts
Revenue = Active × Products × Price

Excel Equivalents

E7 = 1 - E6 (churn from retention)
E8 = 1 - POWER(1 - E7, 1/3)
Monthly retention = POWER(E6, 1/3)
Active(month) = NEW + PREV × retention
K3 = P28 - P51 (patient difference)

Chart – Active Patients per Month

Monthly Data Table

Month Active Patients S1 Revenue S1 (€) Active Patients S2 Revenue S2 (€)