Home / Catalog / IT / SaaS / By Customer Funnel Structure

Horizontal B2B SaaS Financial Model

Description

This financial model is built for a horizontal B2B SaaS company that serves multiple industries or functional areas, not a narrow vertical. It reflects the complexity of a subscription-based platform with diverse customer segments—from small businesses to enterprises—and a range of pricing plans, including flat subscriptions, usage-based tiers, and annual contracts. The model captures the full customer journey: acquisition through marketing and sales activities, onboarding, recurring billing, and expansion via upgrades and cross-sells. Unlike a generic template, it handles the nuances of MRR/ARR waterfalls, separating new business, expansion, contraction, and churn on a cohort basis.

The operational side is modeled with a realistic build-up of cloud infrastructure costs that scale with usage and users, not as a fixed percentage of revenue, and a detailed payroll plan that accounts for the phased hiring of engineering, sales, and support staff. Sales and marketing are driven by a lead funnel with conversion rates and cost per lead, which feeds into new logo acquisition and customer acquisition cost (CAC). The model also tracks deferred revenue from prepaid contracts and its impact on cash flow, ensuring that cash and accrual views are aligned with SaaS accounting practices.

Designed for decision-making, the model includes a comprehensive set of SaaS KPIs—LTV, CAC payback, magic number, net revenue retention—and automatically generates monthly financial statements (P&L, cash flow, balance sheet) for a multi-year forecast. Scenario management and sensitivity tables allow testing assumptions around growth rates, churn, pricing, and hiring pace. The structure is flexible enough to accommodate a product-led growth motion, a sales-led motion, or a hybrid, and can be adapted to evaluate fundraising rounds, valuation, and exit scenarios.

Modeling specifics

Cohort-level MRR/ARR waterfall with new, expansion, contraction, and churn buckets, allowing segment-specific retention curves.
Customer acquisition modeling with separate input for marketing-driven and sales-driven leads, conversion rates, and CAC by channel.
Dynamic payroll plan for engineering, sales, and G&A with role-based hiring schedules, salary inflation, and overhead allocation.
Cloud/server cost driver tied to active users, data volume, or transactions, using a step-function to reflect real-world cost jumps.
Deferred revenue schedule for annual and multi-year prepaid contracts, with automated recognition to align with GAAP/IFRS.
Unit economics dashboard that calculates LTV, CAC, LTV/CAC ratio, and CAC payback period by customer segment.
Integration of a “magic number” and efficiency metrics to monitor go-to-market productivity.
Multi-scenario model with toggle for low/base/high growth, churn, and expansion assumptions, and a sensitivity matrix on valuation.

What's included in the base version

Revenue model with cohort-level MRR/ARR waterfall, churn, and expansion revenue.
Sales & marketing funnel with lead generation, conversion, and CAC calculation by channel.
Payroll plan with hiring ramp and role-based compensation for all departments.
Cloud infrastructure cost module driven by platform usage metrics.
Integrated monthly financial statements (Income Statement, Cash Flow, Balance Sheet).
Key SaaS metrics dashboard (MRR, ARR, LTV, CAC, payback, net revenue retention, magic number).
Scenario manager with base, upside, and downside cases, and sensitivity tables on KPIs.
Cash flow and runway analysis with investment drawdowns and equity rounds.

Common modeling mistakes

Ignoring expansion revenue from upsells and cross-sells in the MRR waterfall — understates ARR growth by 20–30% in later years and masks the health of existing accounts.
Modeling churn as a constant percentage across all customer cohorts — inflates customer lifetime by 15–25%, leading to overestimated LTV and terminal value.
Using a single blended CAC instead of segment-specific acquisition costs — distorts unit economics and payback period by 30–50%, making unprofitable segments appear viable.
Recognizing all subscription revenue when cash is collected rather than deferring prepaid annual contracts — overstates early-period cash flow by up to 30% and misstates working capital.
Treating server costs as a fixed percentage of revenue without step-function increases — underestimates gross margin erosion of 5–10 percentage points at scale.