# ChartMogul finds standard SaaS LTV forecasts miss actual cohort revenue by more than 50% nearly three times in ten

ChartMogul stress-tested the standard ARPA ÷ churn LTV formula against 35,512 real customer cohorts and found 28.3% missed actual 12-month revenue by more than 50%. The errors are systematic, with blended ARPA responsible for most of the variation and the bias changing as cohorts mature.

The median SaaS LTV forecast looks almost right at 12 months, but that average hides huge misses in both directions. For acquisition budgets, payback planning and company valuation, ChartMogul’s new 3,331-company analysis argues for treating LTV as a directional indicator rather than a precise revenue forecast.

- Status: Active
- Published: 2026-08-30T09:14:46+12:00
- Updated: 2026-08-30T09:14:46+12:00
- Categories: SaaS, Indie Business, Product & Growth, Product Economics
- Tags: ChartMogul, customer lifetime value, SaaS economics, SaaS metrics
- Canonical HTML: https://beyondthe.news/dossiers/chartmogul-saas-ltv-forecast-error-cohort-revenue-arpa-churn-2026

## What changed

ChartMogul’s newly published 2026 SaaS LTV report tests a foundational SaaS metric against what customers actually paid. The company analyzed 35,512 quarterly customer cohorts from 3,331 ChartMogul accounts spanning Q1 2020 through Q4 2024. At each cohort’s formation it calculated LTV from the account’s blended ARPA and trailing six-month logo churn rate, then compared the implied revenue with actual MRR generated over 12, 24 and 36 months. The median 12-month error is only -2.4%, but 28.3% of cohorts miss actual revenue by more than 50% in either direction. ChartMogul finds those misses are structured rather than random: blended ARPA mismatch explains 84.9% of the variation in prediction accuracy, and expansion causes the median bias to flip from overprediction at 12 months to underprediction at longer horizons.

## Why it matters

LTV influences how much SaaS companies are willing to spend on customer acquisition, what payback period they tolerate, how they value segments and how they discuss future economics with investors. A formula that is directionally useful but frequently wrong by more than 50% can create expensive false precision. The report does not mean builders should abandon LTV. It shows why cohort revenue curves, payback period and net-MRR movements need to sit beside it, especially for smaller SaaS companies where signup ARPA, churn and expansion can differ sharply from company-wide averages.

## The reassuring median hides very large cohort-level errors

The typical 12-month cohort generated 2.4% less revenue than the standard LTV calculation predicted, which makes the formula look accurate in aggregate. But 28.3% of cohorts were wrong by more than 50% in absolute terms. Large positive and negative errors offset one another, leaving a median that looks much more precise than the underlying distribution.

## Blended ARPA is the biggest source of variation

The standard formula uses company-wide ARPA, which includes long-tenured customers that may have added seats, upgraded or expanded spend. A newly acquired cohort has not had time to accumulate that expansion. ChartMogul reports that ARPA mismatch explains 84.9% of the variation in cohort prediction accuracy, making it the strongest measured reason one cohort’s LTV estimate is more reliable than another’s.

## Churn assumptions are cohort-specific too

The model also applies the account’s trailing six-month logo churn rate to the new cohort. In reality, enterprise buyers, SMBs, trial converters and customers acquired through different channels can have different survival curves. The median ARPA and churn errors partly cancel at 12 months, which is another reason the headline median looks deceptively good.

## The error changes direction as customers expand

At 12 months the median prediction error is -2.4%, meaning LTV slightly overpredicts revenue. At 24 months the median becomes +6.9%, and at 36 months +14.4%, meaning the original LTV increasingly understates realized revenue. ChartMogul attributes the reversal to expansion among surviving customers, which gradually overwhelms the initial ARPA mismatch.

## Higher-paying customers did not always stay longer

Within ChartMogul’s SMB/B2C-heavy dataset, the cheapest signup-MRR quartile retained 74% of customers after 12 months versus 45% for the most expensive quartile. Across companies, 37.2% showed a negative relationship where bigger customers churned sooner, 48.9% showed no meaningful relationship and only 13.9% showed the expected pattern of bigger customers staying longer. ChartMogul cautions that its dataset mix matters and that this pattern is not universal.

## Use LTV as a direction, not a spending authorization

ChartMogul recommends complementing LTV with metrics grounded in actual cohort behavior. Payback period can be more useful for bounded near-term acquisition economics; cohort revenue curves show what customers actually generated; and net MRR movements expose expansion, contraction, churn and reactivation that one LTV number compresses together.

## Key details

- The report analyzes 35,512 quarterly customer cohorts from 3,331 ChartMogul company accounts.
- Cohorts span Q1 2020 through Q4 2024, with actual revenue observed using platform data through June 2026.
- LTV was calculated at cohort formation using blended account ARPA divided by trailing six-month logo churn.
- Median 12-month prediction error is -2.4%, but 28.3% of cohorts are wrong by more than 50% in either direction.
- ChartMogul says ARPA mismatch explains 84.9% of the variation in prediction accuracy.
- Median error changes to +6.9% at 24 months and +14.4% at 36 months as customer expansion accumulates.
- The cheapest signup-MRR quartile shows 74% 12-month survival versus 45% for the most expensive quartile in ChartMogul’s dataset.
- Only 13.9% of companies in the study show a meaningful positive relationship where larger signup customers stay longer.

## Builder takeaways

- Do not set CAC ceilings or acquisition budgets from a single company-wide LTV number without comparing the estimate with realized cohort revenue.
- Calculate acquisition economics by cohort or segment when customer size, channel, product tier or sales motion materially changes retention and expansion.
- Track signup ARPA separately from blended ARPA; mature customers that have expanded can make new cohorts look more valuable than they are initially.
- Use 12–24 month payback and cohort revenue curves for operational decisions that do not require an infinite-lifetime estimate.
- Recalculate LTV assumptions as cohorts mature because expansion can reverse the direction of the original forecast error.
- If moving upmarket, verify that larger customers actually retain better in your own data rather than assuming enterprise price automatically means enterprise stickiness.

## What to watch

- Independent datasets testing whether the same LTV error patterns appear outside ChartMogul’s customer base.
- Whether AI-native and usage-based SaaS models make blended ARPA/churn LTV formulas even less stable.
- How LTV accuracy changes when calculated with cohort-specific ARPA and retention rather than company-wide inputs.
- Whether SaaS operators shift acquisition and valuation workflows toward realized cohort revenue or bounded payback metrics.

## Uncertainties

- The dataset consists of ChartMogul customer accounts and skews toward SMB businesses with a meaningful B2C component, so the observed customer-size/retention relationship may not generalize to enterprise-heavy SaaS.
- ChartMogul is both the data provider and analyst; the methodology is inspectable but the underlying customer-level dataset is not public.
- The study tests the standard ARPA ÷ logo-churn formulation. More sophisticated LTV models using gross margin, cohort-specific retention or probabilistic survival can behave differently.

## Sources

- [The SaaS LTV Report: Why LTV Predictions Are Systematically Wrong](https://chartmogul.com/reports/saas-ltv-report/) — ChartMogul · primary_dataset. Primary 2026 study, methodology and results covering 35,512 cohorts from 3,331 ChartMogul accounts.
- [Benchmark your SaaS growth](https://chartmogul.com/reports/) — ChartMogul · primary_dataset_index. Current ChartMogul research index listing the 2026 SaaS LTV report and headline findings.