This Excel workbook converts monthly recurring revenue and SaaS employee costs into the Return on SaaS Employees (ROSE) ratio, showing how much recurring revenue the company produces for each unit of employee-related expense.
Enter monthly recurring revenue (MRR), salaries and wages, payroll taxes, bonuses and commissions, employee benefits, and full-time-equivalent headcount. The template totals workforce-related expenses, calculates ROSE for each month, and charts the ratio beside employee count so management can review organizational revenue efficiency over time.
Connect workforce cost to recurring revenue
Relate MRR directly to the employee expenses required to support sales, service, product development, and operations.
Track monthly ROSE movement
Compare the calculated ratio from January through December instead of relying on a single point-in-time efficiency measure.
Review staffing and cost trade-offs
See ROSE alongside full-time-equivalent employees to examine whether changes in headcount and compensation coincide with stronger or weaker recurring-revenue output.
How efficiently is recurring revenue covering employee investment?
ROSE divides recurring revenue by total SaaS employee-related expenses. A higher result indicates more recurring revenue relative to the workforce cost entered for that month; a lower result signals that employee expense has increased faster than recurring revenue, or that recurring revenue has declined relative to the cost base.
Organize monthly MRR and employee-cost data in one consistent annual view.
Combine salaries and wages, payroll taxes, bonuses and commissions, and benefits into total employee-related expense.
Calculate a monthly ROSE ratio using the recurring-revenue and workforce-cost figures entered.
Compare ROSE with full-time-equivalent headcount to add staffing context to the financial result.
Identify months where revenue efficiency improved or weakened and investigate the operating changes behind the movement.
What is inside the workbook?
The workbook uses a compact monthly structure rather than a broad financial model. Editable operating inputs feed a calculated employee-expense total and monthly ROSE output, while a chart summarizes the relationship between the ratio and SaaS employee headcount across the year.
Editable monthly inputs
Input rows cover recurring revenue, four employee-cost categories, and SaaS employees measured as full-time equivalents.
Calculated financial outputs
The sheet totals employee-related expenses and calculates ROSE for each month using the recurring-revenue and cost data provided.
Annual visual review
A combined chart plots monthly employee count as columns and the ROSE ratio as a line, making direction and month-to-month changes easier to interpret.
The verified workbook view shows monthly MRR, separate employee-cost inputs, total employee-related expense, FTE headcount, calculated ROSE values, and a January-to-December comparison chart.
Review the calculation and trend in one view
The table keeps the underlying inputs visible next to the calculated ratio, helping users trace a change in ROSE back to revenue, compensation, taxes, incentives, benefits, or headcount. The chart then highlights whether efficiency changes are isolated to one month or form a broader pattern.
For example, a rising ratio may reflect MRR growth without a matching increase in employee expense, while a falling ratio may follow new hiring, higher compensation, lower recurring revenue, or a combination of those factors. Reading the ratio with its source rows prevents a temporary staffing investment from being confused with a permanent deterioration in operating productivity.
How do you use the template?
Gather the monthly source data
Use recurring-revenue records, payroll or profit-and-loss data, and headcount reports to collect the figures requested by the worksheet.
Enter revenue, cost, and FTE values
Populate each month with MRR, salaries and wages, payroll taxes, bonuses and commissions, benefits, and full-time-equivalent employees.
Interpret the ratio with its drivers
Review the monthly ROSE output and chart, then examine the underlying revenue and employee-cost lines before drawing conclusions about hiring or workforce efficiency.
Who is this template for?
The template is designed for SaaS founders, finance leaders, people operations teams, revenue operators, and investors who want a focused measure of recurring revenue relative to employee investment. It can support monthly management reviews, workforce planning discussions, hiring analysis, and internal performance tracking where MRR and employee costs are recorded consistently. Because ROSE is a revenue-efficiency ratio rather than a profit measure, it is best interpreted alongside margins, growth, retention, and cash requirements.
For a broader SaaS operating view, use the SaaS Quick Ratio to examine recurring-revenue expansion and contraction, the CAC to LTV Ratio Calculator to assess customer acquisition economics, and the Rule of 40 in SaaS to review growth and profitability together. The Subscription Revenue workbook can help structure recurring-revenue analysis before that revenue is compared with workforce cost.
Choosing a selection results in a full page refresh.
