Categories
Uncategorized

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: https://imgur.com/a/9hm6xzi

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 (https://i.imgur.com/42HdKq1.png) 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 *