SaaS Metrics & MRR Dashboard — Excel Model with LTV, CAC & Rule of 40

Understand and forecast the unit economics of your SaaS or subscription business with this automated 24-month MRR and metrics model.

It builds a full month-by-month MRR bridge — new, expansion, contraction, and churned revenue — and turns it into the KPIs investors and boards actually ask for, without a single manual calculation.

What This Model Does:

• Builds a rolling 24-month MRR bridge (Starting MRR + New + Expansion − Contraction − Churned = Ending MRR).

• Tracks active customer count, ARR, and average revenue per account (ARPA).

• Computes Customer Lifetime Value (LTV), CAC payback period, the SaaS magic number, and Rule of 40.

• Visualizes MRR movement with a dashboard chart and KPI cards.

• Provides two-way sensitivity grids for Ending MRR and LTV:CAC ratio.

• Runs 10 automated validation checks to catch bad inputs before you present the numbers.
  
  

Who It Is For:

• SaaS founders and finance teams reporting monthly metrics to their board or investors,

• RevOps and growth teams tracking the health of the customer base,

• Anyone preparing a fundraising deck who needs defensible LTV/CAC and Rule of 40 figures,

• Consultants building recurring-revenue models for clients.
  
  

What Is Included:

The workbook contains 9 professionally formatted sheets:

• 00 Cover,

• 01 Instructions,

• 02 Assumptions,

• 03 Inputs,

• 04 Calculations (24-month MRR bridge and KPI engine),

• 05 Dashboard,

• 06 Sensitivity,

• 07 Checks,

• 09 Version History.
  
  

All calculations use native Excel formulas — no macros, no VBA. Blue cells are unlocked inputs, black cells are protected formulas.

Sheet protection password: BKFinance2026.