SaaS co visualisations & data inc oomph factor

I’ve previously linked to this spreadsheet and am reposting to say I think that it’s been updated with the latest rounds of ERs - but please feel free to point out if I’ve missed something or made a mistake

https://docs.google.com/spreadsheets/d/1T9AO9ZMUAtVms4hzvbtX…

It’s fairly self explanatory. The formulae for the 3 SaaS valuation models considered is linked in the document. Interpret as you will

As a bonus - two links that should be required reading for these types of companies

Some historical reading on the SAAS Granddaddy, CRM and the power of long term compounding business modles
https://davidcummings.org/2012/09/13/notes-from-salesforce-c…

The SaaS business model in more depth
https://www.slideshare.net/DavidSkok/the-saas-business-model…

61 Likes

Interesting atuff…will have to open on pc later as mobile crowds a lot of the icons.

Makes me want to be a data scientist and figure out if their were/are backtested correlations we could make tied to stock price appreciation.

Dreamer

1 Like

There is no correlation between oomph factor and ev/s. It is a completely random scatter plot.

I’d discourage anyone from using it.

The correlations I see are, trusting the numbers and figures presented are

Gross profit to EV/S
Growth to EV/S
Rule of 40 to EV/S

2 Likes

Makes me want to be a data scientist and figure out if their were/are backtested correlations we could make tied to stock price appreciation.

Id love to figure out a way to visualise the impact of time in a gap minder.org-esque manner to see the progress along the axes over time for some of the companies…

Also worth mentioning that the CAP data and other qualitative factors aren’t directly captured in the table. Somewhat inferred from high current year ev/s, but that and the EV to market opportunity ratio are key factors to consider

2 Likes

Id love to figure out a way to visualise the impact of time

I thought the same thing, tchalla. I’ve seen similar graphs where they’re “animated” as companies or products or populations grow or shrink over time. It’s much easier to see changes like that or pick up on patterns in a graphical, animated format, than with just numbers in a table.

Take the rev growth vs EV/S plot, if that could be animated with numbers say, weekly or monthly, like a time lapse video, it would be very easy to see what companies are accelerating their growth rate, or reducing their EV/S number, by just watching which dots are moving the direction you want, and how fast. The size of the dots representing the companies could also change size and/or color representing a couple more metrics over time you wanted to look at so that you could see at least 4 interrelated factors over time.

I wish I knew how to do something like that (or had the time to learn, but can’t currently with a full time job), but maybe someone in the forum already knows how to do it without much difficulty. Obviously the results would only be as good as the data being fed in.

I’m also sure if we had that capability, we could come up with many use cases for it other than the example I gave above. It wouldn’t be any more “predictive” than other methods of looking at the numbers, just another way of viewing results.

Thanks foodles

this is the type of thing I’d like to create - does anyone have a suggestion as to how?

https://www.gapminder.org/tools/#$chart-type=bubbles

1 Like

Yep, exactly what I had seen before and was thinking of.

http://vizabi.org/tutorials/2017/04/03/show-your-data/

2 Likes