The Slidebean Financial Model
Knowledge Base

The Staff Sheet

Organized into sections for various company roles, the Staff Sheet allows for detailed input and monitoring of staff-related costs, tailor roles and expenses, track salary increments, and plan for new hires.

Article by 
Caya
 | 
Book Consulting Call
Last updated 
February 13, 2024

The Staff Sheet is a crucial component of the Slidebean Financial Model,  designed to manage and forecast the company's payroll expenses. It provides a detailed layout to input, monitor, and project various staff-related costs and their impact on the company's financial health.

The Staff Sheet is organized into distinct sections, each representing different roles within the company, such as Operations, Product, Marketing & Sales, and Customer Support. Notice how these roles are BLUE, and can therefore be edited or renamed.

Roles Definition

The Staff sheet is designed so you think of 'roles' instead of unique employees.

Role (Input)

This column lists the various positions within the company, such as CEO, COO, Office Manager, and other specific roles in different departments.

Expense Category (Dropdown)

Each role is categorized under an expense category, which is used to generate the 'Use of Funds' charts on the Dashboard. The dropdown options can be edited on the Settings Sheet.

AVOID using names and unique roles on the staff sheet.

Instead, define roles, and estimate the hires of multiple employees in that 'role'. While some roles like the CTO might be unique, other roles like 'Full Stack Developers' can be used to estimate the scaling of multiple employees with similar cost to the company.

Salary Inputs

Annual Salary (Input)

The Annual Salary offered to a given role, before overhead, taxes, benefits, and other costs. This is NOT the salary the employee receives, but rather, the agreed upon wage for that employee.

Payroll Taxes + Benefits (Input)

A percentage that accounts for additional employment costs such federal and city taxes, health insurance, pension, and other employee benefits.

In the US, 25% is a good reference for the 'overhead' cost per employee: including a basic health insurance and required taxes.
If you would like to account for contractors on your Staff sheet (also called 1099 employees in the US), you can set this value to 0%.

Annual Increase (Input)

The projected annual salary increase rate for a given, indicating how salaries may rise over time due to inflation, promotions, or performance increments.

Annual increments are estimated for the role itself, exactly 12 months after the first hire for that expense line.

Monthly Salary (formula)

The base monthly wage paid to the role, before any deductions or overhead costs.

Monthly Cost to Company  (formula)

The actual monthly cost of an employee to the company.

Team Scaling

The monthly company headcount is tallied on the Headcount Section of the SG&A sheet.

In a regular model, you'd be required to input the number of employees per month, and scrolling back and forth to scale them accordingly. Instead, we've designed a system to estimate the number of employees for each role with a reduced number of inputs. Then, the model transforms that employee count into a cost value on the Payroll section of the SG&A Sheet.

First Hire (input)

Indicates the month and year when the first hire for each role is expected.

Hires Added per Period (input)

Specifies the number of new hires added for each role in a given period.

How Often New Hires Are Added (dropdown)

Defines the frequency of new hires, such as annually, quarterly, or monthly. Unique roles can be set to 'Never'.

Maximum Team (input)

Sets the cap on the number of individuals in each role. If set to 0, it implies the position is not currently active or required. If set to 1, it implies the position is a unique role, such as the CEO or CTO.

Relevant articles

The Assumptions Sheet

Related to: 

The Assumptions Sheet lets users input key variables impacting business forecasts. It includes sections like Capital Expenditures and Loans, guiding the automatic estimation of costs like computer purchases and setting depreciation periods for various assets.

Getting Started

This article serves as an introduction to the template, guiding you through its various components and how to effectively utilize them.

The Settings Sheet

The Settings Sheet allows you to set company-specific parameters like start dates, currency, and tax rates, ensuring all other sheets align with your unique business context.

Driver-based Modeling Basics

Related to: 

The basics of driver based modeling

Financial Modelling examples

Learn to model  🚀

A LIVE 1-week workshop to create investor-proof projections, estimate your fundraising needs, and track the core KPIs for any kind of startup
Learn more
Slidebean logo
© Copyright 2024 Slidebean Incorporated. All rights reserved.
Made with 💙️ in New York City and San Jose