SaaS LTV Calculator - Get a better approximation of your true customer LTV

The simple LTV=ARPA/Churn formula has several important limitations. Using cohort data, this sheet helps you get a better approximation of LTV.

Add a comment

Replies

Best
Loving this ! Thanks for creating and sharing this! Will be sharing this in our community :)
Super usefull. Thanks
As always, super helpful content from and the P9 team! Well done.
Love the Google sheet ! Thanks for sharing.
one of the first SaaS metric templates I ever discovered and used was from over 5 years. Really happy to see the tradition continues this many years later. Keep them coming Christoph!
Nice template.
I will be using this – till I can persuade the ChartMogul guys to support Shopify apps!
This is a very helpful content
Really helpful! Thanks for posting this.
I think the idea is a good one. My only concern is that Gross Profit will vary overtime especially when you consider COGS will increase as a startup scales up and revenue may fluctuate a little due to more services or upselling tactics.