LTV calculation w/cohorts

Hi everyone,

I'm currently in the process of trying to figure out some #'s for an assignment I'm working on. The cohort basis is here:

For each cohort, I've calculated:

  1. Revenue by cohort, by users
  2. LTV for each cohort = Revenue – COGS – CAC

Is the LTV simply just adding up the CoD for all cohorts and simply dividing it by the # of users?

If so, then is what I have here ( correct?

I've seen multiple posts online showing different equations, so any help would be appreciated.
FYI: This is an ecommerce subscription company.

submitted by /u/djfc
[link] [comments]

Leave a Reply

Your email address will not be published. Required fields are marked *