Walk me through how you create a revenue model for a company
Answer
There are two main ways to build a revenue model. You can easily get away with just the first paragraph for each strategy, but I included examples because if you can conceptualize this beyond the “book answer” you will stand out.
Bottoms Up
Get down to average revenue per customer (revenue / customer count) and then find out how much it costs to add a customer. Use forecasted sales expenses to determine how much new revenue will be driven. This is simplified but conceptually will get you through the question
Ex. Let’s say a company has $100mm in revenue and 100 customers and it costs ~$1mm to acquire a customer
This means they have roughly $1mm revenue per customer. Now, let’s say they lose ~10% of their customers per year, and have forecasted $15mm of sales expenses next year
So, for next year you would multiply 100 Customers * 10% to determine that 10 customers will leave next year. Then multiply this by the average revenue per customer of $1mm to determine that the company will lose $10mm of revenue. Now our base for next year is $90mm
We will now use the customer acquisition cost of $1mm and divide the $15mm of sales expenses for next year to determine that the company will add $15mm of revenue next year from 15 new customers
Revenue next year = $100mm (last year’s revenue) - $10mm (attrited revenue) + $15mm (new customers) = $105mm in revenue next year
Top-Down
Use market metrics like TAM and SAM to estimate overall market size, estimate current market share and then forecast how that will change in the future to get to revenue
Ex. In a $100mm market, we have 10% penetration currently but think it can get to 30% in 5 years. So, if we’re at $10mm of revenue now you would forecast to $30mm in 5 years
This one is pretty useless unless you’re working with extremely high growth, differentiated solutions that have a self-serve aspect that makes sales & marketing not core to growth. I’ve never had to use this for a revenue model
Why this matters to bankers
Bankers must build revenue models in the most defensible and detailed way possible for their clients. It’s critical to choose the right way to build a model to defend it against potential buyers and build confidence in your client’s forecasts.