Formula
MRRₜ₊₁ = MRRₜ × (1 − Churn) + New MRRₜ
FAQ
Why grow new MRR separately?
Acquisition capacity usually improves (or degrades) over time. Modeling additions growth makes the forecast far more realistic than a flat monthly addition.
How do I sanity-check the output?
Compare implied end-state growth rate and net revenue retention against your history and segment norms — if the forecast implies implausible retention, adjust churn.