KPI calculator

SaaS Quick Ratio Calculator

Enter your values to calculate SaaS Quick Ratio. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

SaaS Quick Ratio books Books that help you understand SaaS Quick Ratio and related business metrics more deeply. Explore resources → SaaS Quick Ratio audiobooks Audiobook searches for learning SaaS Quick Ratio while commuting, walking, or working. Explore resources → Startup metrics resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Subscription business resources Practical resources for turning SaaS Quick Ratio into reports, dashboards, and business decisions. Explore resources →

Calculate SaaS Quick Ratio

New MRR Expansion MRR Churned MRR Contraction MRR

Result—

Formula

(New MRR + Expansion MRR) / (Churned MRR + Contraction MRR)

Excel formula

=IFERROR((B2+C2)/(D2+E2),0)

Power BI DAX measure

SaaS Quick Ratio =
DIVIDE(
    [New MRR] + [Expansion MRR],
    [Churned MRR] + [Contraction MRR]
)

Read the complete SaaS Quick Ratio formula guide →