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. Integrated 3-statement model and cap table.

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

 

Tutorial Video:

Recent Updates: Added a fully integrated monthly and annual Income Statement, Balance Sheet, and Cash Flow Statement as well as capex with depreciation and a capitalization table.

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

You must log in to submit a review.