Public company comparables.

executive (42)

A few years ago I wrote about reading a Profit & Loss statement, which is a foundational executive skill. I also subsequently wrote about ways to measure your engineering organization. Despite having written those, I still spend a lot of time wondering about effective ways to represent an engineering organization to your board of directors.

Over the past few years, one of the most useful charts I’ve found for explaining an R&D organization is a scatterplot of R&D spend as a % of margin versus YoY growth of last twelve months (LTM) revenue. Unlike so many other measures, this is an explicit measure of your R&D organization value as an investment relative to peer organizations.

Until recently, I assumed building this dataset required reading financial filings but my strategic finance partner at Carta, Tyler Braslow, pointed out that you can get all of this data for the tech section from Meritech Analytics, for free.

The image shows a webpage for Meritech Analytics, which offers a public software benchmarking solution with features for analyzing SaaS company metrics. It includes options to sign up or explore features, and provides tools like regression analysis for users.

When you login to Meritech, you’re dropped into a table of public company comparables for tech companies. This is the exact dataset I’d been looking for to build this chart.

The image displays a table from the Meritech Software Index showing various metrics such as market cap, enterprise value, and percentage price changes for different companies like Adobe and AppLovin. It also includes averages (mean and median) for these metrics over specified periods.

After logging in, you can then copy the contents of that table into a Google Sheets spreadsheet or Excel, or whatever you’re most comfortable with.

The image shows a spreadsheet from Google Sheets titled “PublicComps,” displaying financial data for various companies, including columns for price changes, market capitalization, enterprise value, and several valuation metrics. The data is presented with calculations for mean and median values across the companies listed.

Within that sheet, the columns you care about are:

  • % YoY Growth LTM Rev (column Q for me) – how much “last twelve months revenue” has grown year over year, as a percentage
  • % LTM Margins for R&D (column U for me) – how much R&D spend is as a percentage of last twelve months margin
  • LTM Revenue (column O for me) – although I don’t show this in the scatterplot, I find this one useful for debugging outlier values

Hiding the other columns gives you a much simpler table.

The image is a table listing companies along with their Last Twelve Months (LTM) Revenue, Year-over-Year (YoY) Growth percentage, and LTM R&D margins. Notably, Adobe has the highest LTM Revenue at $21,505 with an 11% YoY growth and 14% R&D margin.

From that table, you’re then able to build the scatterplot. Note that being “higher” means your R&D spend as a percentage of LTM margin is higher, which is a bad thing. The best companies are to the bottom and to the right; the worst companies are to the top and to the left.

The scatter plot displays the relationship between R&D Spend as a percentage of margin and Year-over-Year Revenue Growth, with data points clustered mostly in the 10%-30% range for both axes. Each point is labeled with a percentage representing the R&D Spend as a percentage of margin.

With this chart as a starting point, you can then plot your company in and show where you stand. You could also show how your company’s position in the chart has evolved over time: hopefully improving. Finally, you might want to cull some of these data points to better determine your public company comparables. The Meritech dataset has 106 entries, but you might prefer a more representative thirty entries.