SmartHelping / SaaS Startup Planning / Excel
SaaS Financial Model: Growth Driven by Staffing Ratios
Build a five-year SaaS forecast from sales hiring, account executive quotas, and staffing ratios. Connect customer growth to support and engineering needs, operating costs, funding requirements, and integrated financial statements.
The template is available to download immediately after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & spreadsheet preview
See how hiring and quota assumptions drive the forecast.
Sales hiring, customer growth & team capacity
Start with the sales team, then let the defined ratios scale the plan.
Set SDR hiring and the account executive (AE) ratio. Customer sign-ups follow AE quota attainment, while support requirements and the engineering budget determine additional staffing.
Set starting SDR headcount and monthly hiring
Enter starting SDR headcount and the number of SDRs hired per month. Adjust the monthly hiring rate separately for each year and define when SDR and AE hiring begins.
Define the number of AEs per SDR
Set the ratio of account executives to SDRs. The ratio can change each year, so the sales team structure can evolve over the five-year forecast.
Set customer quotas and the AE ramp-up
Enter the number of new paying customers an AE is expected to sign each month at full quota. Use up to five monthly ranges to define how quota attainment builds toward 100%, with the option to reach full quota sooner.
Scale customer service with customer demand
Define customer service staffing requirements for both monthly sign-ups and current active customers. Enter annual salaries for SDRs, AEs, and customer service staff in each of the five years.
Engineering headcount
Link the engineering team to a revenue-based budget.
Allocate a percentage of revenue to engineering for each year. Set the mix of up to two engineer types and their annual salaries; the model uses those assumptions to calculate engineering headcount.
Operating costs, startup investment & funding
Connect the growth plan to its cash requirements.
Two ways to calculate COGS
Use a monthly cost per active user, a direct percentage of revenue, or both. These assumptions let direct costs scale with the business.
Fixed operating expenses
Plan executive hires and other general and administrative expenses, sales and marketing expenses, and research and development expenses.
Startup costs and capital expenditures
Include one-time startup costs and capex assumptions. The updated model includes depreciation logic for capital expenditures.
Investor equity, debt, and owner funding
Enter investor equity and debt assumptions. If those proceeds do not cover the total cash requirement, the model calculates the additional equity needed from owners.
Integrated financial statements & summaries
Follow the operating assumptions through the financial results.
Integrated income statement, balance sheet, and cash flow statement
The updated model includes fully integrated financial statements, connecting the operating and financing assumptions across the three reports.
Monthly and annual P&L detail
Review projected profit and loss at both monthly and annual levels, alongside the cash flow summary.
Cap table
The updated template includes a capitalization table as part of the financial planning workbook.
Executive and contribution/distribution summaries
Review the executive summary and the annual contribution/distribution summary to see the combined effects of your assumptions.
SaaS operating metrics
Evaluate customer economics and staffing productivity.
CAC and CAC payback
Review customer acquisition cost and the CAC payback period in months.
LTV and LTV-to-CAC
Review customer lifetime value and the ratio of lifetime value to customer acquisition cost.
Average revenue per employee
Compare forecast revenue with the team size produced by the staffing assumptions.
Average revenue per user
Review average revenue per user alongside the customer and revenue forecast.
More templates in one purchase
Included in the SaaS financial model bundle.
SaaS & Recurring Revenue Financial Models Bundle
Explore the collection of SaaS, subscription, and recurring revenue templates, including this model.
Explore the bundleQuestions before you start
A few useful details.
What starts the growth forecast?
Starting SDR headcount and planned monthly SDR hires establish the sales hiring plan. The AE-to-SDR ratio determines account executive staffing, and AE quota attainment drives new customer sign-ups.
What does an AE's monthly quota measure?
It measures the number of new paying customers an account executive is expected to sign each month. The ramp-up assumptions determine how quickly an AE reaches full quota.
How does the AE ramp-up work?
The model supports up to five monthly ranges for quota attainment. Set the ranges and attainment levels to fit the ramp-up you want to model, including reaching full quota sooner.
Can sales hiring start after the first forecast month?
Yes. The model includes timing logic for SDR and AE hiring to begin after the first month when needed.
How is engineering headcount calculated?
Set the annual engineering budget as a percentage of revenue, choose the mix of up to two engineer types, and enter their annual salaries. Those assumptions determine engineering headcount.
What happens if investor equity and debt are insufficient?
The model calculates additional owner equity needed when the assumed investor equity and debt proceeds do not cover the total cash requirement.
Are financial statements and a cap table included?
Yes. The updated template includes integrated income statement, balance sheet, and cash flow statement reporting, a cap table, and capex with depreciation logic.
How do I get the Excel template?
The template is available to download immediately after the $125 USD one-time purchase. It is also included in the SaaS financial model bundle linked above. For questions about your setup, contact SmartHelping.
SaaS planning driven by hiring and productivity
Connect the team you build to the growth you forecast.
SaaS Ratio Growth Model — $125, one-time purchase.
