Enterprise, SME & User saas

Enterprise SaaS, consumer and SME financial fundraising model in excel

AN AWESOME EXCEL MODEL FOR STARTUPS

Forecast an Enterprise (and B2B/B2C) SaaS company

  • enterprise saas financial model overview
  • enterprise saas financial model overview
  • enterprise saas financial model overview
  • enterprise saas financial model overview
  • saas enterprise financial model overview
  • enterprise saas financial model overview
  • enterprise saas
  • enterprise saas financial model overview
  • enterprise saasfinancial model overview
  • enterprise saas financial model overview
  • enterprise saas financial model overview
  • enterprise saas financial model overview
  • Enterprise SaaS

    For enterprise SaaS startups with big 3 year contracts that are a huge pain to forecast due to long sales cycles!. Also has same functionality as the SME SaaS model for clients with monthly and annual contracts. Self-onboard and sales supported customers. Think Buffer, Zapier, Hubspot, or Xero. Cohort model with all the capability you expect including expansion revenue, churn and full marketing funnel.

  • Massive and complete

    619,324 formulas across 38 sheets. 143 charts and 32 PivotTables

  • Heavy lifting done for you

    You only need to input your assumptions into the yellow boxes. The model is fully integrated across sheets with smart automations inbuilt to help you to scale up and down

  • For those that want to impress

    This is larger than your CFO or investor has ever seen. You will level up your SaaS KPI knowledge as you learn to get the most out of it

  • This is NOT for wannabees

    This is for grown ups that want to take their SaaS business seriously. If you want a model to quickly fill in "because an investor asked for one" don't go here

  • It is 100% worth every cent

    2 reasons: 1/ you couldn't even hire someone to make this, 2/ it's not a model- it's a structured learning process. You need to use it to understand what I'm saying, and it does blow minds!

For large, complex enterprise SaaS companies with enterprise, consumer and SME customers. There is no model like this on the internet. Features highly granular revenue forecasting with monthly cohort level modeling. A full stack of marketing options drive leads/registrations for consumer and SME customers. Forecast enterprise clients down to a product basis and magically observe the exact month revenue will come according to payment schedules. 5 years (60 months) of detailed P&L for actual, forecast and combined, as well as cash based analysis. Manually plan out your hiring of staff and automate sales and support staff depending on how you scale. Charts, KPIs, all your COGS mapped out. Unique source and use sheet illustrates your plan for your pitch deck. And a lot more...

Image
Image
Image

Excel

Unlocked

Integrated

  • Excel financial model
  • Built for PC and Mac
  • Not for Google Sheets
  • Entire model is editable by you
  • Nothing is locked or restricted
  • Fully integrated model
  • Each sheet acts as a module connected to each other which update immediately
Image
Image
Image

Updates

No modeling needed

Easy to maintain

  • Model is updated with new features
  • I'll email you updates when they're done
  • Everything works out of the box
  • Just input your assumptions
  • Designed to be easy to update monthly
  • Just change the forecast month then add in you new month of actuals
Image
Image
Image

Support

Simple & Detailed

Automations

  • If you're really stuck, ping me an email or catch me if I'm online and I'll help you figure out what to do for free
  • You can hire me per hour if you need a lot of help on whatever it is you need
  • Staff and marketing sheet have a simple and detailed version with a switch
  • Do things quickly, or in a lot of detail
  • Sheets also have on/off switches is you don't want to use a sheet
  • Support and sales staff added as you need them based on your assumptions
  • Payments, tech, and other costs scale to your forecasts. Set and forget
Image

FOR ALL TYPES OF ENTERPRISE SAAS STARTUPS

Model designed for all enterprise-focused clients with a long sales cycle. Also serves SME clients separately

Image
Image
Image
Image
Image
Vincent feedback
Melissa feedback
Image

2 pricing options

Get a filled in model, or the filled in model + a blank version of the file.

Filled in model

Filled in + blank

  • The base model has been populated with numbers so you can see how it works
  • You can edit it however you want
  • This version comes with 2 Excel files
  • In addition there is a blank version of the file with no assumptions in it to save you time if you want to start from scratch
Image

Quick walkthrough

Here's me explaining the video fairly briefly and pretending to enjoy it (All videos will be updates)

Image

Who the heck is hawking me a financial model!?

Hey! It's me Alexander Jarvis. I like Excel and I love SaaS.

Image
  • I'm the #1 seller of startup financial models in the world
  • Worked in M&A (Lazard financial institutions group)
  • I intimately know startup and what VCs care about having done both for over 10 years
  • TEDx, Top Quora Writer, accelerator mentor, fund advisor etc
  • I don't like bragging, so just read my blog and download free tools to see if I know what I'm talking about
  • I made the first version of this model for my own $20m raise
Image

Free training course

I've made an 24 part training course to help you hit the ground running (It's also free)

enterprise saas model charts
enterprise saas model tech team
enterprise saas model sales staff automation sheets

There are a lot of cool features under the hood

An insightful and useful model needs to work for you, not against you.

My models do require thought on inputs, but there are 37 sheets to support you to derive all the outputs that you need without any coding.

On this page I'm going to very briefly allude to some of the functionality on each sheet so you have an idea what's going down in funky town. 

enterprise saas model architecture

37 sheets

There are lots of sheets in the model. Check out what they are so you can get an idea of what's in there. It's a list from the model with just one brief line per sheet. Writing this stuff is boring and know you don't want to read it either. Just saying.

Image

Want to know more?

Let's run through details and answer your FAQs

Details on the model

FAQ

Image

Want this model in a different currency? Now you can!

Convert all currencies in the model into one of 17 different currencies with a button mash

This model uses formatted currencies in $ (Why I use US Dollars). I often get asked if it is available in other currencies such as €? So I made an Excel PC addin to do that (It was hard!)

At the press of a button you can now convert the model into 17 different currencies. You just need to purchase the productivity addin.

Here are the currencies you can use with the macro:

Currency list The format you will see
EUR
USD $
GBP £
YEN ¥
INR
Krone kr
BAHT ฿
RUB
Peso
BRL R$
RM RM
Rp Rp
HKD HK$
ILS
KPW
RMB ¥
CHF CHF
Image

Part of the productivity addin

All my favourite hacks and time saving tools in one place

Image

More than likely, you aren't a huge Excel nerd like me, so you probably don't know about macros? These are hacks to make modeling in Excel much more faster and less painful. I love them!

I've been making models for years, so you can be sure I know what is useful and what is not. I decided to not just make the currency conversion macro, but add in all my most used hacks. You just hit a button and it will do handy things.

What can you do?

  • Automatically format your cells so they have 'investment banking' standard black, blue and green
  • Change the zoom and cell position of every sheet so it looks great when others read it
  • Save a backup of your model (v1, v2, v3) at the push of a button so you never get a corrupt model
  • Add error checks to your formulas
  • And a whole bunch of other nerdy things you'll understand when you are making models yourself!

NOTE:

  • This is for PC. Gates hates Mac so.... All the plugins other than 'check sheet sizes' work in Mac, but I don't warrant anything if you are on Mac (Sorry). I'm trying to find a developer to rewrite the code for Mac so the images, tips etc work too
  • Currency conversion only works on 50Folds models. It won't on any other model (My code looks for certain cells... There is a hack- ask if you want to know)
Image

2 pricing options

Get a filled in model, or the filled in model + a blank version of the file.

Filled in model

Filled in + blank

  • The base model has been populated with numbers so you can see how it works
  • You can edit it however you want
  • This version comes with 2 Excel files
  • In addition there is a blank version of the file with no assumptions in it to save you time if you want to start from scratch
Image

Purchase guide and note

Let's just get clear so you know how it works and what to expect

Buying models

Getting the model

  • Payment and delivery of the model is 100% automated!
  • There's 3 upsell pages (Don't hate me for trying). At the end you can press download to get the file immediately
  • It's hosted on SamCart and payment is via Stripe (Secure)
  • There are no refunds. These are digital goods you can't return
  • If you have questions ask me first in the chat or via email
  • If you aren't sure if this is the right model for you, ask me!
  • As soon as you pay there is the end page to press download
  • After you buy you get confirmation emails from SamCart
  • Delivery of the model is automated
  • Note: I don't know why, but some clients get emails slow
  • The file comes in a zip file. You need to unzip it (e.g. WinZip)
  • If you're really stuck, ping me an email or via chat box!
Image

Benchmarking for your financial model

This is a fantastic presentation to use when forecasting in your financial model and making sure your metrics are in line with reality. Flick through the deck as you work through each section of the model and check you are trending towards these numbers. It's perfectly ok for your numbers to look a little crazy in the early days (When you have a few customers and little revenue, no metrics/ratios will make sense). What matters is how you evolve.

Periodic Table of SaaS Operations

Comments 9

  1. Post
    Author

    Hi – If I have a long sales cycle business and I also have customers like a normal saas will this work for me? Thanks Alex

    1. Post
      Author

      Hey Simon- Absolutely. The model is massive. It covers both what I call SME and enterprise customers.
      – Your SME are going to be monthly/annual types of customers.
      – Your enterprise are long sales cycle customers which you will define and ideally have some sort of line of sight.
      You can cover pretty much anything SaaS in it.
      If you have any qu, email me.
      ADJ

  2. Post
    Author

    Alexander. Interesting. I have been looking for a model to do enterprise and have not found one. I have a complicated business, can this do everythihng I need?

    1. Post
      Author

      Hi Chirayu – Sorry for delay. No model will be able to do everything you can think of, but this will do a lot. I made it for a real fundraise and a growing company selling large tickets. I can tell you that it does a hell of a lot! It took me months to make… FML 😉 Any questions message me.

  3. Post
    Author
    1. Post
      Author
  4. Post
    Author
    1. Post
      Author

      Hi Jane – Yes. It is made in Excel. Don’t put this in Google Sheets. It’s too large. GS makes sense when you want to share simple stuff with team. This model is when you want to do something complicated. It’s complicated, but it beats the hell out of attempting to do yourself! It was painful to make…

  5. Hi Alex does it work for actual figures too? I need to track the monthly expenses and actual revenue / costs and summarize these figures in a single view
    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.