Startup financial models – Templates compared for SaaS

Posted by admin on

> Guides

| Apr 20, 2020

Card image cap

As a founder, there comes a time when you need a business plan, complete with financial forecasts, income statements, and fancy graphs that will impress your investors.

Don't build it from scratch - use an existing model. 

A financial model allows you to draft financial projections easily, fast, and in a professional manner. A great template will also force you to think through all the aspects of your project and make sure you really get the financial logic behind your business. 

It can be annoying but trust me, it's worth your time.

This post compares the top 12 templates of financial models for SaaS startups. I have personally tested each model. I have ranked them on 40+ items along 5 categories. I've looked at both spreadsheets and SaaS apps, and both free and paid solutions.

If you are looking at building your SaaS financials, this article is for you.

Table of content

Methodology - What makes a great financial model for SaaS startups?

Here is the methodology I used to build this benchmark.

I compared 40 points across 5 categories: (a) financial statements, (b) analysis capabilities, (c) revenue modeling, (d) cost modeling, (e) extra features. A detailed analysis of each model is available below. In each case, I tested the software/spreadsheet myself.

Criteria 1: Financial statements

  • Time scale: Are the statements over 1 year, 3 years or more? You usually want 3 years as a minimum when you speak with professional investors.
  • Income statement: Does the template include an income statement? You usually want a monthly income statement, at least for year 1.
  • Cash flow statement: Same as income statement
  • Balance sheet: Same as income statement
  • GAAP/IFRS: Are the statements compliant with GAAP and/or IFRS rules?
  • Currency: How many currencies are available?

Criteria 2: Analysis capabilities

  • Financial analysis: Number of typical financial metrics included e.g. breakeven point, quick ratio, average inventory, etc.
  • SaaS analysis: Number of typical SaaS metrics included e.g. MRR growth, SaaS magic number, CAC/LTV, etc.
  • Graphs: Number of built-in graphs
  • Costs by P&L category: Does the template break down costs into P&L categories (CoGS, RD, G&A, etc.)
  • Costs by departments: Does the model break down costs into departments (sales, marketing, CS, engineering, etc)
  • VS Scenarios: Does the template allow you to compare multiple scenarios?
  • VS Industry comparables: Does the template compare your financials against industry comparables?
  • VS Actuals: Does the template allow you to run your model versus your actual numbers?

Criteria 3: Revenue modeling

  • New client acquisition: How do you enter new clients into the model? Possibilities include: entering a number manually for each month or year (it sucks); autofill the model from a base number and a growth rate (sucks a bit less); autofill several streams - each stream represents a different type of client e.g SMB/enterprise (better); or even fully model each acquisition channel (the best, very rare)
  • Offerings: How many offers can you define and how precisely can you model them? This includes the possibility to create one-off offers, recurring offers, or a combo, but also the possibility to create introduction times and end times for specific offers.
  • Pricing model: How many pricing models can you define and how precisely: tiers (free, basic, premium), revenue models (per seat, per usage, etc), automatically increase or decrease the plans price over years.
  • Existing clients: Can you model expansion, contraction, churn, reactivation?
  • Commitment: Can you model monthly VS yearly VS multi-annual contracts?
  • Service revenue: Can you model punctual service revenue on top of all the other pricing models and offerings?
  • Enterprise specific: Does the template offer specific features to model complex enterprise sales, such as landing/expansion, custom product developments, various sales cycles, etc?

Criteria 4: Costs modeling

  • Direct labor costs: The best templates allow you to correlate direct labor costs with relevant metrics. For example, your sales staff is calculated based on forecasted income and sales target per account executive. Same for customer success payroll with number of customers and workload target per CS staff.
  • Direct non-labor costs: just like with labor costs, the best templates allow you to link some direct non-labor costs with relevant metrics. For instance, server costs can be a % of MRR.
  • Indirect labor costs: same as above. Even for indirect costs, some templates find smart ways to tie them to some aspect of the business.
  • Indirect non-labor costs: same as above
  • Payment terms: Can you define the payments terms with your vendors and suppliers? May be useful if there is a hardware component to your offer.
  • Hardware-friendly: This is a special mention for templates that model things like shipping costs, inventory delay, etc.

Criteria 5: Extra features

  • Documentation : Is there proper documentation in the model and on the website? Are there good explainer videos? What kind of direct support (chat, email) comes with the template?
  • Languages: In what language is the template available?
  • Third-party integration: Third-party integrations can be useful to input or update data over time, or to display advanced graphs.
  • Excel spreadsheet: Can you access your financials as a Microsoft Excel spreadsheet? This is a must if you need to share it with investors.
  • Google Sheets: Does the model work in Google Sheets? Not all models that work in Microsoft Excel work in Google, so you may want to consider that point.
  • Editable formulas: Some templates do not allow you to modify formulas - which is a massive bummer when it comes to customization.

Granted, it's not a perfect methodology. One could argue forever about whether cap tables should be included in a financial model for startups. But it's the best I could come up with - without being a finance nerd myself :)

Disclaimers: affiliation, impartiality, and non-finito

Before jumping to the heart of the matter, please allow me three disclaimers:

  • Affiliation: Some links in the article are affiliated - which means that if you end up buying a template through one of those links, I'll get a few $$$. This doesn't cost you anything, and allows me to keep writing useful articles for you.
  • Impartiality: Regardless of whether there is a referral in place or not, I am committed to providing you with an honest opinion. I take great pride in being an independant, honest, and trusted source of information for entrepreneurs.
  • Non finito: This is a non-finite work. I am happy to update the article if you bring new, relevant information to my knowledge. I am also happy to fix any mistake or clarify any confusion that you may find in the article.

1. "FISY Innovation Plan" by Remi Berthier

Fisy Innovation Plan, by Rémi Berthier

For years, this template has been the go-to financial model for French entrepreneurs. However, it didn't age well.

Analysis capabilities are limited: only a handful of financial metrics, zero SaaS metrics, a couple of graphs, and it's impossible to categorize costs. Modeling, be it for revenue or costs, is all too basic and requires a lot of manual input. Also, it's entirely in French.

Having said that, it remains a free-of-charge, easy-to-use, easy-to-customize template that covers all the basics while including specificities to the French ecosystem such as CIR, JEI, etc.

This model makes a lot of sense for French entrepreneurs looking for a simple solution. For the others, keep on reading.

 
 

2. "SaaS Financial Plan 2.0" by Christoph Janz

SaaS Financial Plan 2.0, by Christoph Janz

This template was built by SaaS apostle Christoph Janz, and you can tell. It packs a punch of SaaS knowledge in a sleek, clear spreadsheet. You'll find lots of good stuff: basic/pro/enterprise plans, churn/upgrade/downgrade, an elegant client acquisition model and a wealth of graphs and charts.

It's not all rosy, though. You want a 5 years forecast? No, you only need 2. You want to sell annual pro plans? Too bad, pro plans are monthly and that's that. Also, no balance sheet.

This template works great if you are a typical SaaS startup and fits the vision that Christoph put into his financial plan. If not, you may be better off considering templates with broader horizons.

 
 

3. "SaaS Financial Model" by Jaakko Piipponen

SaaS Financial Model, by Jaakko Piipponen

This one got updated just before publishing the article, so I have to scratch my old review and write a new one. I'll take care of that soon enough.

In the meantime, don't hesitate to take a look.

 

4. "Standard SaaS Financial Plan for Startups and SMBs" by Ben Murray

SaaS Financial Plan for Startups and SMBs, by Ben Murray

This template published by Ben Murray, AKA the SaaS CFO, has a lot in common with Chris Janz's model: it's free, it's SaaS-centric and it's really good overall.

But that's where similarities stop. Let's look at what differentiates them:

  • Cost modeling: Janz does a much better job as many costs are tied to activity metrics. With Murray, you have to fill it all manually. Janz 1 - 0 Murray
  • Commitment: Murray allows you to define which plans are annual and which are monthly. Janz does not. Janz 1 - 1 Murray
  • Client acquisition: Murray wants you to manually input new clients each month, where Janz includes 3 acquisition channels. Janz 2 - 1 Murray
  • Murray also allows you to add service revenue and offers up to 5 years of forecasts. Janz 2 - 2 Murray
  • Since its latest update, Murray's model also allows you to input your actual number and compare them with your forecasts. Janz 2 - 3 Murray

At the end of the day, Murray's SaaS template is great - maybe the best amongst the free templates. It is a bit disappointing when it comes to modeling new client acquisition and costs, though.

To explore more powerful (and paid) templates, read on!

 

5. "SaaS Startup" by Pro Forma

SaaS Startup Kit, by Pro Forma

The SaaS startup kit is the first paying template we're looking at: one-time $99.

Because you're paying, you obviously get a lot more in return: balance sheet, cap table, GAAP/IFRS compliance, 161 currencies to choose from, a ton of financial metrics and graphs, and advanced capabilities to model your costs and your revenue, including for hardware startups.

Now, because we are paying, we are a lot pickier. And I see 3 problems with this SaaS Startup Kit. First, you cannot account for upgrades and downgrades (you can model churn, though). Second, you cannot break down costs by P&L categories or departments. Third, the formulas are "locked ' so you cannot edit them. That's a big problem if, like me, you like looking under the hood. But maybe you don't care?

 
 

All in all, I cannot tell you not to look at the SaaS startup kit. It has a lot going for it, and at $99, it's priced right. But if you can stretch your budget a little more, look at the next model - it may well be the right one.

6. "SaaS Financial Model" by Taylor Davidson

"SaaS Financial Model" by Taylor Davidson

Let me start right off the bat: this "SaaS Financial Model" by Taylor Davidson is one of the best templates out there.

For $149, you get all the financial statements you may wish for, laid out over 5 years, and GAAP-compliant. Additional tabs are built-in for fundraising (assess needs and uses), valuation (ownership, DCF, waterfall exit, ROI), variants (simplified scenarios), and impact (for purpose-driven startups). Bonus point: the model works in Microsoft Excel and Google Sheets, supports all currencies, and is fully editable.

In terms of analysis capabilities, the template generates boatloads of financial and SaaS metrics, as well as 20+ beautiful graphs. Costs can be broken down by departments and P&L categories so you can make sense of all that good stuff. SaaS experts will especially appreciate the granularity provided by monthly cohort analysis - a rarity!

Modeling revenue and costs is extremely versatile. Instead of pre-modeling everything for you, the template provides you with very unique features (Pricing, Pipeline, Drivers) that allow you to customize it to your needs. Here are a few examples of what you can do:

  • You can build as many subscription plans as you want.
  • Contract length is not limited to monthly or annual but can be anything you want.
  • Billings are separate from contract cycles, so can do an annual contract with quarterly billings, or 3-year contract with annual billings, or annual contract with monthly billings
  • All costs, direct and indirect, labor and non-labor, can be tied to relevant activity metrics (revenue, headcount, etc.) which is what you would expect from this kind of template.
  • All costs can also be tied that are *not* tied to an activity metric, say periodic costs that occur quarterly or annually, or costs that increase a % over time, or costs that are a % of salaries, or a % of revenues, for example. This is all built-in within the Drivers sheet and an absolute delight to use.
  • For Enterprise sales, you can model a good old Pipeline in the Pipeline sheet and attribute different numbers of seats and "likelihood to close" to each deal.

True, it takes a bit of time to wrap your head around the internal logic of that model. But once you master it, there is virtually no limit to what you can do.

Thankfully, this financial model is well-documented. The website includes a long, detailed "Getting Started" page as well as specific articles and videos for technical points. The highlight is definitely the email support - I've consistently received detailed replies within 24 hours - at zero extra cost. Kudos to that.

Long story short - if you are willing to shell out $149 for a SaaS financial model, Taylor Davidon's template is arguably one of the absolute best you can get your hands on. The other one is the model built by Alexander Jarvis - read on to learn about it.

 

7. "SaaS: SME & Users" by Alexander Jarvis

8. "SaaS: Enterprise, SME & Users" by Alexander Jarvis

"SaaS: SME & Users" by Alexander Jarvis

"SaaS: Enterprise, SME & Users" by Alexander Jarvis

It's hard to write a serious review about this template - everything about it is absolutely ridiculous. It is ridiculously rich, ridiculously detailed, ridiculously powerful. It's the kind of template that you use when you want to make a statement, like impress your investors or make your CFO feel irrelevant. It's heavy, bold, and over-the-top, in the best way possible. Brace yourselves, let's dive in.

This template by Alexander Jarvis comes in 2 versions. The "SaaS: SME & Users" is perfectly fine for most SaaS businesses. It sells at $319. The "SaaS: Enterprise, SME & Users" retails at $1,299 and includes extra logic to model enterprise sales. Because of their complexity, both models only work in Microsoft Excel (no Google Sheets).

In return for your money, you get the most advanced modeling capabilities - period.

  • Each acquisition channel is modeled in great details: paid, organic, blog, social, emailing, and channel partners. Each channel can be assigned its own conversion rate from visitor to user. You can also differentiate between the customers that self-onboard and those who require sales intervention.
  • You can design composite offerings based on usage fee, monthly fee and/or a one-time service fee. The templates allow 3 paid plans - typically basic, premium, pro - as well as a free trial plan, and each of these plans can exist with a monthly or annual commitment.
  • Customers can upgrade, downgrade or churn, and you can even schedule module releases at different points in time, so you create new revenue streams over the years.
  • All costs, direct and indirect, labor and non-labor, are modeled in a clever way i.e. they are tied to relevant activity metrics

I cannot stress enough how detailed this model is. Here is an example: the "email marketing" tab (yes, there is such a thing) takes into account 12+ inputs including stuff like the % of recipients who will share the newsletter with their friends. I love this kind of detail because it gives actionable points when thinking about execution. It also makes it easier to defend your numbers in front of investors because you can explain the underlying assumptions. If it's too much for you, you can always deactivate the advanced fields with the switch and focus on the core input.

If you buy the $1,299 version, you get an extra slew of tabs specifically dedicated to enterprise sales in all its complexity: enterprise-specific products and offerings, geographies, sales cycles, "land and expand", custom development, etc. If you are building the next Oracle or Palantir, that stuff alone is invaluable.

Documentation is ok. Instructions and comments are included inside the template, but not much in terms of FAQ/articles on the website. Having said that, I particularly appreciated the tutorial videos: one 28-min overview and 20 shorter videos that each cover a specific tab.

You want more? Time to talk about analysis capabilities. Alexander Jarvis' model is most lavish when it comes to that point. 50+ graphs are readily available - and that's without counting the sparklines that are peppered throughout the sheet. Because modeling is so detailed, the template can provide advanced SaaS metrics such as marketing leverage or expansion % of new MRR. Of course, costs can be allocated to P&L categories and departments so you really understand what's going on in your model.

When it comes to financial statements, the $319 version gives you only 3 years of forecasts, with no balance sheet and no cap table. The $1,299 version does a bit better with 5-year forecasts, but still no sign of balance sheet nor cap table. Some would argue that an early-stage startup doesn't need formal financial statements... However, this template does include a tab to compare your forecasts to your actuals, and another tab listing down industry metrics - both are very welcome additions.

If you want the best spreadsheet ever, it boils down to comparing Taylor Davidson's and Alexander Jarvis' templates, and picking the one that fits you the most. See the final section "Conclusion" for a side-by-side of both models.

 
 

However, some prefer using a specialized SaaS app to build your financial model. If that's your case, check out the last 4 models.

9. "EY Finance Navigator" by Alex and Wout

EY Finance Navigator, by Alex and Wout

The Finance Navigator was developed by Alexander Matthiessen and Wout Bobbink from EY's Dutch office. It's a SaaS app: you pay a monthly subscription to access an online tool. It's a fundamentally different approach from the spreadsheet-based models we've explored so far.

The Finance Navigator costs $30 per month without commitment or $380 over an 18 month period. For that price, you get very exhaustive financial statements: income statements, cash flow statements, and balance sheets over 10 years - no cap table though. All currencies are available and you can export the statements to a clean, well-designed spreadsheet format (only numbers, no formulas).

Documentation is good, with in-app guidance, website posts, a Q&A, and a 37 min walkthrough video. The tool was clearly thought to be user-friendly and the onboarding is best-in-class. You will have zero difficulties using EY's Finance Navigator whatsoever.

Unfortunately, simplicity is a double-edged sword. Revenue and cost modeling is super basic. For example, revenue is defined as a base number for month 1, then a monthly growth rate. No channels, no conversion rate, no pricing plans. The same goes for costs: you cannot tie costs to specific activity metrics, so you have to input them manually. Because it's a SaaS application, you cannot customize the model by adding fields or modifying formulas. And because it's so basic, there is only the bare minimum in terms of analysis capabilities.

At the end of the day, EY's Finance Navigator holds a lot of promises. UX is great and they have a couple of nice features like comparables and scenarios. The product has evolved over the years, adding up features and getting more usable. In my estimation, it's not quite enough to be used by advanced SaaS entrepreneurs. The product is geared towards traditional businesses - think bakery, restaurant, consulting, who just want clean and easy financials. Not the right pick for SaaS people - yet. I'd love to revisit the tool in a year and see what progress has been made.

 
 

10. "Liveplan" by Palo Alto Software

Liveplan, by Palo Alto Software

Liveplan sells its financial modeling SaaS app at $20 per month ($360 over 18 months), which makes it a close competitor to EY Finance Navigator.

Starting with the strong points, Liveplan offers exhaustive statements over 5 years: income statements, cash flow statements, and balance sheets. Compared with EY's model, you have a bit more control over revenue modeling: offerings can be defined as recurring fees, billable hours, and a one-time upfront fee can also be added. Pricing can be increased automatically over time, churn can be factored in, and you can model monthly or annual plans.

When looking at cost modeling, you can adjust payment terms for clients and suppliers. There are also specific variables for hardware products. Documentation is just fine, with a tutorial video per section embedded directly in the app, as well as plenty of instructions. Liveplan exists in 5 languages, and integrates with Quickbooks, which allows importing your actual numbers and comparing them with your forecasts. You can also export your financials into a (numbers-only) spreadsheet to share with your investors.

Now, although Liveplan's software has more powerful modeling capacities than EY's, it remains insufficient in my estimation. Here are just a few examples.

  • Direct labor costs can be set as a % of revenue, but do not update the number of employees accordingly.
  • Indirect costs can only be set as a constant, a % of overall revenue, or a % of a specific revenue.
  • New client acquisition is just manual input - as in you manually input "2" clients in March and "4" clients in April. There is no channel modeling whatsoever.
  • Costs cannot be broken down by P&L categories nor departments.

When modeling is too superficial, it translates into poor analysis capabilities. In Liveplan's case, you do have a dozen financial metrics available (net cash flow, account payable, cash on hand…) and another dozen graphs. But SaaS metrics are absent, which is a bummer for SaaS entrepreneurs.

At the end of the day, LivePlan was built for non-tech entrepreneurs. Perfect for a bike shop owner, but not quite there for SaaS people.

Don't take my word for it: there is a 60-day trial, so give it a spin for free and make up your own mind.

 
 

11. "Summit" by Matt Wensing

Summit, by Matt Wensing

Summit is a young startup (founded 2019) that brings a fresh take on the whole financial modeling thing with a SaaS solution.

Let's make it clear - Summit is not meant for fundraising. Forecasts on Summit are made for an 18-month period only. Costs cannot be allocated to P&L categories and departments, nor can you differentiate between labor/non-labor or direct/indirect costs. Therefore, you won't be able to generate any financial statements that your investors may require . Hell, you can't even export a spreadsheet!

So why talk about Summit? Because Summit is pretty awesome when it comes to piloting your SaaS startup with a financial model. Here is how it works. First you connect your live metrics (Stripe, Baremetrics, etc.) to your Summit account. This allows Summit to derive your future growth from the current trends. The next step consists in optimizing that future growth. To do that, you define a baseline scenario around 20+ metrics from sales, product, finance, then you play around with those variables to maximize your MRR or any other metric you like. What if we increase our close rate? What if we raise funds and funnel that money into paid ads? You instantly get clear answers. What's more, the clean dashboards and convenient built-infeature makes it easy and even pleasant to run those analyses and share with your team. It's a really fresh experience - no comparison possible with fuddy-duddy spreadsheets.

Summit is still a young product and there is room for improvement: currencies, tax rates, expansion and contraction of existing clients, one-off revenue. In particular, client acquisition would greatly benefit from more granularity and native integrations with social media accounts for instance.

At the end of the day, Summit is not meant to build financial statements, but to make decisions in a data-driven way. It's such a refreshing approach in the space that I highly recommend trying it out. Bonus point: it's 100% free for now, so it's a no-brainer.

 
 

12. "Causal" by Taimur and Lukas

Causal, by Taimur and Lukas

At first glance, Causal seemed very similar to Summit. It's also a SaaS solution, also founded in 2019, also bringing a new approach to modeling. But that's where the comparison stops because the philosophy behind Causal is quite unique.

Causal is not just a financial modeling tool for SaaS startups. It's a modeling tool that aims at replacing Excel for every modeling need you may have. This means that (a) Causal is super versatile and goes much deeper than Summit, and (b) Causal is much more complex with a steeper learning curve than Summit.

Looking at revenue and cost modeling, you can model anything you want on Causal with an interface that's 10x more modern and user-friendly than a spreadsheet. The same thing goes for analysis capabilities: you can generate dashboards, tables, and graphs for absolutely anything - including any financial statement your investors may want. You can also connect live data sources (Stripe and Google Sheets for now, more to come) to automatically update your models with real-time metrics.

As a SaaS entrepreneur, you don't have time to build a model from scratch. Lucky you, Causal has built-in templates - including two SaaS models built by Taylor Davidson himself (see template #6). You are then able to augment or fine-tune those models to suit your specific needs.

In terms of documentation, there are a few videos, a live chat as well as a walkthrough when you start a new model. That's not much, but Causal assumes that you are a modeling "nerd" and that your usual work environment is massive spreadsheets. If that's the case, you'll be just fine. Assuming you have the time and desire to put in the hours to learn a new tool, Causal may very well be the ultimate platform for financial modeling.

 
 

Conclusion: this is the best financial model for SaaS startups

 

Best free spreadsheet

If you want a "good enough" model but are not willing to pay for it, go for Ben Murray's (model #4) or Chris Janz's (model #2). Customize them a bit to offset their weaknesses.

See below a side-by-side comparison of the differences between both models.

 

Best paid spreadsheet

If you want the best financial model spreadsheet out there and are willing to pay for it, go for Taylor Davidson's (model #6) or Alexander Jarvis' (models #7/#8). They are by far the best stuff on the market today.

See below a side-by-side comparison of the differences.

 

Best software

If you want to experience the future of financial modeling, go for Summit (model #11) or Causal (model #12) - while keeping in mind that both are very different.

See below a side-by-side comparison of the differences between both models.

 

Thanks for reading. Don't hesitate to leave a question in the, I try topersonally to each one of them.

Card image cap

Essays

Uncover the perfect metrics to a SaaS IPO roadmap - timeframe, growth rate, EBITDA, funding, exit milestones, sales, and headcount.

Sep 17, 2018

Card image cap

A typical tech startup lifecycle consists of 3 major stages: Garage, Growth Machine, and Unicorn. Framework based on Steve Blank, Reid Hofman, Brian Balfour, Morgan Brown.

Jan 16, 2017


[ comments ]