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:
- Revenue by cohort, by users
- 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.