Calculating LTV That Actually Holds Up in a Board Deck

The simplified formula answers a narrower question than most people think it does: it tells you the present value of revenue, not profit, assuming churn stays perfectly constant forever, which it never does. Two problems compound from there. First, revenue isn't the same as what the business actually keeps after delivering the product, so ignoring gross margin can overstate LTV by a wide margin for any account that requires heavy support or has expensive infrastructure costs behind it. Second, churn rates calculated from a single recent quarter are noisy, especially for a company with a smaller customer base, and a single unusually good or bad quarter can swing the resulting LTV figure dramatically.

Say a company has an average account paying twelve thousand dollars a year, with a gross margin of seventy percent after accounting for hosting, support, and payment processing costs specific to serving that account. That gives a gross margin dollar figure of eighty four hundred dollars a year per account.

Now look at realized churn rather than a single quarter's churn rate: of the accounts that started a given year, what share actually canceled by the end of it, averaged across the last several years rather than just the most recent one. Say that figure comes out to fifteen percent annually. The simplified average customer lifetime is one divided by the churn rate, or about six point seven years.

Multiplying gross margin dollars by that lifetime gives a rough LTV of around fifty six thousand dollars, well below the roughly one hundred fourteen thousand dollars you'd get from naively dividing full revenue by the same churn rate. The gap between those two numbers is exactly the distortion that gross margin corrects for, and it's large enough to change a payback period conversation.

A single blended LTV number hides more than it reveals once a customer base has any real variety in it. An account acquired through a low touch self-serve motion typically has a different margin profile and a different churn rate than one acquired through an enterprise sales process with dedicated support. Calculating LTV separately by segment, whether that's acquisition channel, company size, or product tier, usually reveals that the blended average is actively misleading for at least one segment, either overstating the value of accounts that are actually expensive to retain or understating the value of accounts that are quietly your most profitable.

A few habits keep the number honest once it leaves your spreadsheet:

• State the time window the churn rate is based on. A rate calculated from the last twelve months is a very different claim than one calculated from the last three years, and a board deck should say which one you used.
• Don't blend gross margin across a period where your cost structure changed materially, such as a hosting migration or a support headcount change, without noting it.
• Recalculate at a fixed cadence, such as quarterly, rather than reusing a number from a year ago because it's convenient. Realized churn and margin both drift.
• Show the segmented numbers alongside the blended one when the audience is making a decision that depends on which segment is actually being discussed, such as where to invest in acquisition.

LTV on its own is mostly a curiosity. It becomes useful once it's paired with acquisition cost to judge payback and with a segment breakdown to guide where the business invests next, whether that's sales headcount, marketing spend, or which customer success motion gets built out. A number calculated carefully but never connected to a decision is just an exercise, and the effort of getting gross margin and realized churn right is only worth it if the resulting figure actually changes what the team does next.