SaaS Financial Plan – Multi-Tier Pricing | Acquisition Funnel | Full 3-Statement | KPI Dashboard

This SaaS Financial Plan in Excel is purpose-built for founders, CFOs, and finance professionals who need a rigorous, investor-ready forecast without sacrificing usability.

Unlike basic SaaS templates that model a single pricing tier and require manual monthly entry, this model drives revenue from the ground up through a 3-channel acquisition funnel (Organic, Paid, and Partner), automatically allocating new customers across three pricing tiers — Starter, Growth, and Enterprise — each with its own ARPU, churn rate, expansion MRR rate, and annual vs. monthly billing split. Deferred revenue is recognized in accordance with GAAP principles.

The model produces a complete set of financial outputs:

• A fully structured SaaS Income Statement with gross margin and EBITDA,


• An indirect-method Cash Flow Statement with burn rate and runway tracking,


• A Balance Sheet with deferred revenue and PP&E.
  
  

A dedicated Annual Summary tab condenses all three statements into clean calendar-year columns.

The KPI Dashboard surfaces the metrics investors ask about most — MRR, ARR, NRR, ARPA, LTV, blended CAC, LTV:CAC ratio, CAC payback period, SaaS Magic Number, and Rule of 40 — with benchmark flags that indicate whether each metric is on track.

Additional features include:

• A scenario toggle (Base, Upside, Downside),


• Department-level YoY growth rates for headcount and operating expenses,


• A configurable forecast horizon of 12 to 60 months,


• Dynamic calendar-year FY columns that adapt to any model start date,


• A visual gray-out of inactive forecast periods.
  
  

Eight built-in charts round out the package.