SaaS Financial Dashboard

Your SaaS financial dashboard is ready — 912 live formulas, zero errors. Here's what's inside:

⚙ Variables sheet — your single source of truth. Edit any of the 10 blue input cells (churn rate, CAC, ARPU, growth rates, margins) and the entire model recalculates. LTV, LTV:CAC ratio, and CAC payback period are derived automatically at the bottom.

📊 P&L sheet — a full 36-month forecast across 7 rows of logic:

• Customer waterfall (beginning → new adds → churned → ending)
• MRR bridge (new MRR + expansion MRR − churned MRR = net new MRR → total MRR)
• Revenue → COGS → Gross Profit → OpEx (S&M, R&D, G&A) → EBITDA
• Unit economics per month: LTV, CAC (with annual efficiency improvement), LTV:CAC, payback period

🎯 Dashboard sheet — 8 live KPI cards pulling Month 36 values, plus 4 charts:

• MRR Growth trajectory
• LTV vs CAC side-by-side (the key SaaS health metric)
• Customer growth curve
• EBITDA path to profitability

To stress-test a scenario, just change the churn rate on Variables from 2.5% → 5% and watch LTV collapse and payback blow out across all 36 months instantly.