Become a member
Sign in
A Spreadsheet for Calculating Subscription Lifetime Value
322
3
Eric Stromberg
Vince Ghossoub
Vince Ghossoub
Sep 9, 2018 · 1 min read

Thank you for the good model, especially that it’s so simple. Q: You calculated the Lifetime as the sum of the consecutive cohort retention rates, ending at Month 60. What if you have 13 months of data? what is 61? Do you have to assume a hard stop? Or would you rather estimate the limit to which the lifetime tends over infinite time? ideas how to?

    Vince Ghossoub

    Written by

    Vince Ghossoub

    Write the first response

    Discover Medium

    Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

    Make Medium yours

    Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

    Become a member

    Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade
    AboutHelpLegal