Enterprise SaaS Financial Model - Varying Contract Terms

 I have done a wide range of SaaS financial models. However, none of them include logic to account for customers that may be on varying contract lengths. This template has solved for that by including 'contract term' as a variable input. The accompanying logic needed to make it dynamic was difficult, but well worth the functionality.



Pricing


The template will be sent to you after purchase via your PayPal/purchasing e-mail. This is included in the SaaS financial model template bundle.
  • The model itself will forecast up to a 5-year period by month and by year.
  • There are up to 3 customer tiers
  • Each tier has its own assumptions for:
    • Contract length (in months)
    • Retention rate - adjustable each year
    • Total contract value for term - adjustable each year
    • % increase in contract value at renewal
    • Starting users and growth of those users
    • Ad Spend (adjustable each year)
    • Cost per Acquisition (adjustable each year)
    • % improvement in retention
Model Update - Now enter 'yes/no' to define if cash is collected at the start month of contracts or spread evenly across the contracts for each customer configuration.



The user of this financial model can adjust the average contract length of each customer tier to any number from 1 to 60.

There are a few headcount categories that are driven by ratios. They include customer support (up to two types with different fully loaded salaries) and sales reps (up to two types with different fully loaded salaries). The customer reps are calculated based on an input for the number of CS persons needed per active customer in each tier. This can be a number less than 1 i.e. 0.1 would mean a CS person can handle up to 10 customers.

For the sales reps, the ratio is based on total added customers per month.

The rest of the template is fairly similar to the rest of the builds I have done. There is a control tab to define the start year, debt and equity contributions as well as the % of the business going to investors, the exit year, and the exit value (based on a trailing 12-month revenue multiple from the exit month)

There are a lot of visuals to show the most important key metrics that are related to SaaS businesses. These include CaC (customer acquisition cost), LTV (lifetime value per customer), Month to pay back CaC, LTV to CaC ratio, and more.

The model presents itself with an Executive Summary tab to show the highest level financial line items (revenues, expenses, EBTIDA, Cash flow). Also, there is a DCF analysis for the project itself, for investors, and for owners as well as equity multiples, and total ROI. Visuals make it easy to see the cash distributions as well.

One of the important pieces of dynamic logic that exists in this includes the idea of renewals. Since contract lengths can vary, the renewal month is different for each cohort. The model allows for this to happen and has references to know when a renewal is triggered and the resulting revenue per contract / number of customers left in a cohort at any given point in time.

There is also a spot for general operating expenses that are common in an enterprise SaaS organization. I tried to put enough slots for General and Administrative, Sales and Marketing, and Research and Development to account for a wide range of company sizes. These items allow for a defined start month and a varying cost value in each year.

The churn is displayed so that if the expansion revenue ends up resulting negative churn, you will actually see the monthly churn as a negative value visually.

You can easily plug the results of this forecast into formal financial statements (Income Statement, Balance Sheet, and Cash Flow Statement) with the addition of this 3-statement financial model.

Screenshots of Template:
enterprise saas debt and equity structure

enterprise saas revenue assumptions

enterprise saas CS rep scaling

enterprise saas AE and SDR scaling

enterprise saas OpEx schedule

enterprise saas COGS schedule

enterprise saas executive summary

enterprise saas monthly pro forma 1

enterprise saas monthly pro forma 2

enterprise saas monthly pro forma 3

enterprise saas monthly pro forma 4

enterprise saas monthly pro forma 5

enterprise saas monthly cash flow

enterprise saas KPI

enterprise saas DCF Analysis

enterprise saas revenue visualization

enterprise saas user growth visualization

enterprise saas CaC visualization

enterprise saas LTV visualization