BlogSaaSStandard Model

How to Model SaaS using the Standard Financial Model

An overview of how to use the Standard Financial Model to model consumer, SMB, and enterprise SaaS.

Standard Financial Model
$ 149
USD
4.7
(78)
2,601
Download to Microsoft Excel™ and Copy to Google Sheets™

The Standard Financial Model works well for SaaS businesses by default, with no edits required, but easy to customize for specific requirements for the conversion funnel, business model mix, and type of SaaS business. The video above details the acquisition, conversion, retention, revenues, and billings structure and how to use it for different types of SaaS businesses.

Common Modifications

  • Adding more growth channels. It is common to add more growth channels to detail the acquisition strategy in more detail, and to assume different growth rates by channel. Straightforward to do: simply replicate the existing growth block of calculations on the Revenues sheet, replicate the relevant assumptions on Get Started, or create your own set of calculations using the logic relevant for that channel, and add it into the line used to calculate conversions.
  • Expanding the sales funnel. By default the model assumes one conversion point (for example, leads converting to subscribers), but often users will want to model a conversion funnel with multiple conversion steps (for example, leads converting to qualified leads converting to subscribers). The simple way to model that is to use a conversion rate on Get Started that is reflective of the overall conversion rate (just multiply each conversion rate), or if more detail is required, an additional conversion step can be added on Forecast by replicating the structure using the same or simpler methodology for conversions.
  • Using the sales team channel. This is prebuilt in the model on the Revenues sheet, but not prelinked. Usage is covered in the video above, but in short, you can use this section to assume the growth in your sales team, your assumptions on the time it takes them to ramp up to full productivity, the leads/clients/sales they generate per month, and use that in the existing growth calculations.
  • Adding pricing tiers. This can be done with a simple edit to the assumptions on Get Started. Create a table with the different tiers (on Get Started or a new sheet), input the pricing tiers, assume the percentage of subscribers/clients/etc that are on each tier, and calculate the weighted-average using SUMPRODUCT, and input that into the average revenue assumption on Get Started. If more detail is required, then you can add additional revenue builds using the same methodology as the annual and monthly split detailed below.
  • Modeling land and expand revenue models. A land and expand revenue strategy is where a company works to increase usage, seats, or add services over time as the customer grows ("expands") their usage of the service. The model is prebuilt to handle that, just go to the Revenues sheet and use the Average Revenue per Subscriber/Client/Etc assumption to increase average revenue over time to reflect that revenue growth over time. This will automatically be applied as a lag from when customers start. Optionally, even though it's not an input, you can also modify this per monthly cohort if you have a need for that level of detail.
  • Adding annual and monthly subscribers separately. Pricing plans for monthly and annual prices can be modeled in simple and complicated ways. The simple way is to assume a weighted-average revenue per month, reflective of the portion of users on each plan. If there are significant differences between monthly and annual plans, or you simply want to model them separately to model the cash impacts more accurately, the easiest way to do that is to replicate the revenue build, and add an assumption for the percentage of new subscribers that select monthly or annual billing. You can then link the additional revenue build into the Forecast sheet and the model will aggregate the revenues and billings from each accordingly, and automatically handle the impact on cash and deferred revenues.
  • Using the SaaS Forecasting Tool. The free SaaS Forecasting Tool is an alternative way to forecast SaaS businesses with a simpler build structure, in approximately 10x less lines of code (a pro!) but with less features around growth, conversion, and cohort modeling (a con). It is straightforward to use the tool to replace the prebuilt revenue model in the Standard Model, or to use it to model additional SaaS revenue components in an easier way than replicating the prebuilt revenue model.
  • Using your own SaaS revenue build. The model can be used for a wide variety of SaaS businesses, and you can also import and use any model or other template you are using. Details at BYOM.

Cost of Sales and Operating Expenses

While the video above does not cover how to model the associated expenses with operating a SaaS business, the model is prebuilt to handle marketing and growth expenses, cost of sales (e.g. hosting, infrastructure, customer support) and other operating expenses (staff, overhead, and more). Modeling expenses is covered at Forecast.

FAQ

Common questions and more details at Standard Financial Model. I provide free and paid onboarding support and custom model services, and contact me anytime for questions.

Related: Building an Early-Stage SaaS Financial Model, on the Role Forward podcast with Mosaic.

Sign up for new posts and products

You'll be redirected to my email provider to confirm. Unsubscribe anytime. Here's how I use your data.