Ratio-Based SaaS Model – Smarter Scaling Logic

This model makes it easier to forecast the scaling out of a SaaS model that is dependent on Account Executives to attain new customers.

, ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Tutorial Video:

This model forecasts out for a period of 5 years. There are monthly and annual summaries to display assumption effects. The logic is based primarily on ratios.

Ratios Include:
1. Amount of AE’s per SDR’s plus SDR’s added per month in each of the 5 years.
2. Quota per AE per month.
3. Quota attainment in first 3/6/9/12 months per AE.
4. Count of CS reps per new monthly deals and per active users.
5. Percentage of revenue allocated to engineering.

The above ratios are the main calculations that make the scaling of this model smarter. There are also assumptions for up to 3 pricing tiers, churn per tier, and running fixed expenses as well as COGS. COGS run off of a cost per active user per month and/or a direct % of revenue.

You can enter the possibility of a P+i loan as well as investor equity. Any additional cash required will automatically flow to owner equity requirements. The user can define the % of the company the investor gets with their investment as well.

There are equity contributions and distributions that run based on the free cash flow as well as a high-level executive summary that shows the project operations.

Advanced metrics for this include CaC, LTV, revenue per employee and per user, CaC payback, and LTV to CaC ratio. All metrics have accompanying charts. There are additional charts that show general financial performance, cash flow, user growth by type, and MRR by type.

Logic exists for one-time revenue of new customers if applicable i.e. setup fees.

Anything that does not apply to your situation can be zeroed out.


File type: .xlsx

Write a Review

Get these templates too for a discount!

Price: $315.00

A package of financial models for Software as a Service (SaaS) businesses and its related sectors in Excel. This bundle…

Add to wish list
Add to cart Excluding 0% tax

Price: $225.00

This is a combined collection of Excel and Google Sheets financial model templates for Accounting and related uses, such as:…

Add to wish list
Add to cart Excluding 0% tax

Starting at: $99.00

I have added all the industry specific financial models all into one bundled package. Included Models: 1. Mining Operation 2.…

Add to wish list
Add to cart Excluding 0% tax