Establish a customer-based valuation formula

I have a start-up and I would like to know the value of each user as they sign up. When they sign-up they will tell us how much revenue they will generate us in a year so I would like to have an excel calculator that calculates the value of every user using the LTV in order to produce a global company valuation as the user base grows.

Here is a reference: https://tanay.substack.com/p/customer-based-valuation