SAAS Products

This excel template is driven by ratios of different sales and customer reps within the context of a SaaS business that gets most of their new customers by means of the activity of sales people. This startup model goes out for a period of 5 years on a monthly and annual basis.

To start off the model, the user can enter the start month and starting headcount of SDR (sales directors) and AE’s (Account Executives) as well as the monthly amount of each added over 5 years. A Deal Quota is defined for AE’s as well as the % of that deal quota the average AE will attain in the first 5 quarters they start working. The fully loaded salaries are definable per year for SDR, AE, and CS (customer service reps). Customer service reps use a ratio based on the number of new customers a single CS representative can handle in order to populate their headcount. Engineers headcounts are defined based on the percentage of revenue allocated to their department. Based on their fully loaded salaries against the revenue available to spend on them, the headcount is defined. There is a % to define type 1 vs. type 2 engineers. Three pricing tiers exist and there are configurable inputs for the % of new customers that fall into a given tier. Each pricing tier has its own churn rate that can change over time and there is an input for one-time setup fees the customer must pay. Fixed expenses, capex, and one-time startup costs all have their own schedules as well as costs of goods sold per user and cost of goods sold as a direct % of revenue. Based on all the assumptions, a 5-year monthly and annual P&L detail will populate automatically as well as an Executive Summary and Cash Distribution schedule that shows project cash flow as well as investor repayment and owner payouts if applicable. There are assumptions to account for debt service and terminal value as well. Common SaaS key metrics are displayed, including: CaC (customer acquisition cost), Month to Pay Back CaC, LTV (average customer lifetime value), LTV to CaC ratio, and annual revenue per employee. Visuals were built to show those as well as many financial highlights.