ƒx

Excel Revenue Per Employee Formula

hr Difficulty:
One-Click Copy
Total_Revenue / Full_Time_Equivalent_Employees

Quick context

  • Works in both Excel and Google Sheets.
  • Use when you need consistent, auditable results.
  • Copy the snippet above and adjust only the ranges.

When to use

Measures the average revenue generated by each employee.

Assess organizational efficiency.

Calculate Revenue Per Employee

Assess organizational efficiency.

Inputs

  • Total_Revenue Total revenue for the period.
  • Full_Time_Equivalent_Employees Number of FTEs.

Practical Example

=1000000 / 50

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.