# Stock-Based Compensation

See how employee equity awards vest over time and how those grants flow through compensation expense.

- Canonical: https://finamodel.com/templates/stock-based-compensation
- Excel download: https://finamodel.com/templates/stock-based-compensation.xlsx
- Category: Corporate Finance
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: CFOs & FP&A, Founders & operators, CFOs, Controllers, FP&A teams, Equity admins
- Tags: stock based compensation, sbc, asc 718, vesting, equity awards

## Overview

This stock-based compensation model gives finance teams a practical view of options, RSUs, performance awards, and employee share plans. It brings grant details, vesting, expense, and remaining cost together in a monthly schedule.

Use it when preparing budgets, forecasting payroll costs, or explaining equity compensation to management and auditors. Different grant types remain easy to compare without turning the workbook into an accounting manual.

## What's included

- Eight tranches: founder options, CEO options, executive options, engineering RSUs, sales RSUs, performance SUs, ESPP, new-hire RSUs
- Per-tranche awards granted, grant-date fair value, vesting months, cliff months, elapsed service, forfeiture rate
- Grant Master with net awards, grant value, monthly straight-line expense, opening unrecognised, weighting
- Per-tranche Vesting Schedule with cliff-and-graded cumulative vested across 12 months and a final-month column
- Per-tranche Expense Schedule with ASC 718 expense, panel total row, and annual total column
- SBC Register: panel monthly opening / expense / closing unrecognised plus cumulative expense, cumulative vested, vested in month, SBC vs payroll
- Dashboard with annual SBC, opening and closing unrecognised, cumulative vested at M12, SBC vs payroll, weighted remaining vesting, peak month
- Per-tranche composition block with grant value, opening unrecognised, and annual expense
- Status thresholds for SBC vs payroll (green / amber) and weighted remaining vesting period (green / amber)
- Eight tranches spanning founder / executive options, RSUs, PSUs, ESPP, and new-hire pool
- Per-tranche awards, grant-date fair value, vesting months, cliff months, elapsed service, forfeiture rate
- Grant Master with net awards, grant value, monthly straight-line expense, opening unrecognised, weight
- Per-tranche Vesting Schedule with cliff-and-graded cumulative vested across 12 months
- Per-tranche Expense Schedule with ASC 718 straight-line expense and an annual total column
- SBC Register: panel monthly opening / expense / closing unrecognised plus cumulative expense and vested awards
- Dashboard with annual SBC, opening and closing unrecognised, SBC vs payroll, weighted remaining vesting, peak month
- Per-tranche composition block: grant value, opening unrecognised, annual expense
- Status thresholds for SBC vs payroll (green / amber) and weighted remaining vesting period

## Stock-Based Compensation Model: How the Template Works

This stock-based compensation model template gives finance teams a structured way to project equity award costs. It translates grant details and vesting assumptions into monthly expense, unrecognised balances, and dilution metrics.

The design supports budgeting, forecasting, and audit discussions by showing the relationships between awards, service, and financial statement impact.

### Grant-Level Inputs and Operating Drivers

The model covers eight award tranches, each with its own grant package and vesting terms. Inputs include awards granted, grant-date fair value per award, vesting period, cliff months, elapsed service months, expected forfeiture rate, grant month within the 12-month window, achievement probability, and actual forfeitures.

- A modifications block handles incremental fair value and cancellation acceleration, while operating drivers capture payroll, revenue, diluted shares outstanding, average share price, and statutory withholding. A forfeiture method switch toggles between expected and actual forfeiture treatment.

- These assumptions feed every downstream schedule, so flexing any input cell updates the expense and vesting calculations.

### Calculation Flow and Vesting Convention

The calculation starts by converting gross awards into net expected awards using forfeiture and achievement probability. Grant value is net awards multiplied by fair value, and monthly expense is that value spread straight-line over the vesting period.

- Expense is recognised only when the month is at or after the grant month and the service-month-end is within the vesting term. Vesting follows a cliff-then-linear-from-grant convention: zero before the cliff, a catch-up to the cliff fraction at the cliff anniversary, then straight-line accrual thereafter.

- Modification expense adds incremental fair value over remaining vesting, and a monthly forfeiture true-up adjusts at month 12 under the actual method. Cumulative vested awards are computed on both expected and gross bases, with a hidden baseline column ensuring the vested-in-month figure correctly references the pre-window position.

### Outputs and Integrity Checks

The SBC Register rolls forward opening unrecognised expense, base, modification, true-up and total expense, closing unrecognised, cumulative expense, cumulative vested, vested in month, net shares delivered after withholding, and intensity ratios against payroll and revenue.

- The Dashboard summarises annual SBC, unrecognised balances, burn rate, overhang, weighted-average remaining vesting period, peak monthly expense, and treasury-stock-method incremental dilutive shares.

- Ten PASS/FAIL checks validate roll-forward identity, vested-versus-awards caps, non-negative expense, monthly sums equalling annual totals, function allocation summing to 100% per tranche, probability bounds, vesting greater than or equal to cliff, positive revenue and diluted shares, and a valid forfeiture method.

### Practical Use and Documented Scope

This model helps operators estimate equity compensation expense for budgets, forecasts, and management reporting. It lets different award types — options, RSUs, performance shares, ESPP, and new-hire pools — sit side by side for comparison.

- The function-allocation block traces SBC into COGS, R&D, S&M, and G&A buckets, while net shares delivered and TSM incremental shares support dilution analysis. Several items are deliberately out of scope: modification accounting nuance, ESPP look-back fair value, periodic PSU true-ups, market-condition PSU re-estimation, Black-Scholes decomposition, tax effects, full cap-table mechanics, and integration with downstream financial statements.

- The public download is a values-only preview; the underlying model captures these relationships without providing live formulas.

## Built for the SBC accrual

When the question is "how much stock comp lands this quarter, and what is the unrecognised balance after that?", a clean per-tranche register is the cleanest answer. This template gives controllers an audit-ready SBC accrual that ties to the IS expense line and the unrecognised-SBC footnote every month.

## Designed for one-edit responsiveness

Every input - awards, fair value, vesting, cliff, elapsed, forfeiture, threshold - is a per-tranche input cell. Flex one number and the per-tranche expense, panel roll-forward, and dashboard status all recompute - no formula rewrites.

## Honest about cliff vesting

ASC 718 attributes expense straight-line from grant date even though cliff awards legally vest in a lump. The Vesting Schedule formula tracks the legal vesting separately - cumulative vested is zero before the cliff, fully vested at the vesting-month mark, and linearly graded in between - so the dashboard distinguishes the expense path from the share-count path.

## Built for the SBC accrual

When the question is "how much stock comp lands this quarter, and what is the unrecognised balance after that?", a clean per-tranche register is the cleanest answer. This template gives controllers an audit-ready SBC accrual that ties to the IS expense line and the unrecognised-SBC footnote every month.

## Designed for one-edit responsiveness

Every input - awards, fair value, vesting, cliff, elapsed, forfeiture, threshold - is a per-tranche input cell. Flex one number and the per-tranche expense, panel roll-forward, and dashboard status all recompute - no formula rewrites.

## Honest about cliff vesting

ASC 718 attributes expense straight-line from grant date even though cliff awards legally vest in a lump. The Vesting Schedule formula tracks the legal vesting separately - cumulative vested is zero before the cliff, fully vested at the vesting-month mark, and linearly graded in between - so the dashboard distinguishes the expense path from the share-count path.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: tranche panel, payroll baseline, and dashboard thresholds.

- Eight tranches with awards, fair value, vesting, cliff, elapsed, forfeiture
- Monthly cash payroll for SBC-vs-payroll intensity
- SBC-vs-payroll and weighted-remaining-vesting thresholds (green / amber)

### Grant Master

Per-tranche grant value, monthly expense, opening unrecognised, and weighting.

- Net awards = awards * (1 - forfeiture)
- Grant value = net awards * fair value
- Monthly straight-line expense = grant value / vesting months
- Remaining vesting months = MAX(0, vesting - elapsed)
- Opening unrecognised = remaining * monthly expense
- Weight = opening unrecognised * remaining months (weighted-average numerator)
- Panel-total row for net awards, grant value, monthly expense, opening unrecognised, weight

### Vesting Schedule

Per-tranche cliff-and-graded cumulative vested awards across 12 months.

- Service month end = elapsed + (current month index)
- Zero before cliff; full net awards at vesting; linear graded in between
- Final-month column on the right
- Panel total row at the bottom for cap-table input

### Expense Schedule

Per-tranche ASC 718 monthly expense with panel and annual totals.

- Expense recognised flat while service_month_end is at or below vesting months
- Annual total column on the right
- Panel total row at the bottom feeds the SBC Register and Dashboard

### SBC Register

Panel-level monthly SBC roll-forward.

- Opening unrecognised rolls from prior month closing; first month from Panel_Opening_Unrec
- Expense pulls from Expense Schedule panel total via named ranges
- Closing unrecognised = MAX(0, opening - expense)
- Cumulative expense rolls forward across 12 months
- Cumulative vested pulls from Vesting Schedule panel total via named ranges
- Vested in month = cumulative - prior cumulative
- SBC vs payroll = expense / monthly payroll (with zero guard)

### Dashboard

Headline metrics with traffic-light status and per-tranche composition.

- Annual SBC expense, opening and closing unrecognised SBC
- Cumulative expense and cumulative vested awards at M12
- SBC vs annual payroll with On track / Watch / Heavy status
- Weighted-average remaining vesting period with On track / Watch / Short status
- Peak monthly expense and the month it occurs
- Expense growth M12 vs M1
- Per-tranche composition: grant value, opening unrecognised, annual expense

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: tranche panel, payroll baseline, and dashboard thresholds.

- Eight tranches with awards, fair value, vesting, cliff, elapsed, forfeiture
- Monthly cash payroll for SBC-vs-payroll intensity
- SBC-vs-payroll and weighted-remaining-vesting thresholds (green / amber)

### Grant Master

Per-tranche grant value, monthly expense, opening unrecognised, and weighting.

- Net awards = awards * (1 - forfeiture)
- Grant value = net awards * fair value
- Monthly straight-line expense = grant value / vesting months
- Remaining vesting months = MAX(0, vesting - elapsed)
- Opening unrecognised = remaining * monthly expense
- Weight = opening unrecognised * remaining months (weighted-average numerator)
- Panel-total row for net awards, grant value, monthly expense, opening unrecognised, weight

### Vesting Schedule

Per-tranche cliff-and-graded cumulative vested awards across 12 months.

- Service month end = elapsed + (current month index)
- Zero before cliff; full net awards at vesting; linear graded in between
- Final-month column on the right
- Panel total row at the bottom for cap-table input

### Expense Schedule

Per-tranche ASC 718 monthly expense with panel and annual totals.

- Expense recognised flat while service_month_end is at or below vesting months
- Annual total column on the right
- Panel total row at the bottom feeds the SBC Register and Dashboard

### SBC Register

Panel-level monthly SBC roll-forward.

- Opening unrecognised rolls from prior month closing; first month from Panel_Opening_Unrec
- Expense pulls from Expense Schedule panel total via named ranges
- Closing unrecognised = MAX(0, opening - expense)
- Cumulative expense rolls forward across 12 months
- Cumulative vested pulls from Vesting Schedule panel total via named ranges
- Vested in month = cumulative - prior cumulative
- SBC vs payroll = expense / monthly payroll (with zero guard)

### Dashboard

Headline metrics with traffic-light status and per-tranche composition.

- Annual SBC expense, opening and closing unrecognised SBC
- Cumulative expense and cumulative vested awards at M12
- SBC vs annual payroll with On track / Watch / Heavy status
- Weighted-average remaining vesting period with On track / Watch / Short status
- Peak monthly expense and the month it occurs
- Expense growth M12 vs M1
- Per-tranche composition: grant value, opening unrecognised, annual expense

## Features

- **ASC 718 straight-line attribution:** Monthly expense per tranche is grant value (net of expected forfeitures) divided by vesting months and recognised flat while service_month_end is at or below total vesting months. Switch to actual-forfeiture method by overriding the forfeiture rate per period.
- **Cliff-and-graded vesting in one formula:** Cumulative vested awards per tranche resolve cliff first (zero before cliff), full vesting at vesting-month end, and a linear graded fraction in between. The same formula handles options with a 1-year cliff and ESPPs with no cliff.
- **Payroll-intensity and remaining-period status:** Dashboard tags SBC vs annual payroll against on-track / watch / heavy thresholds and weighted-average remaining vesting against on-track / watch / short thresholds. Both signals are weighted by opening unrecognised so the heaviest tranches drive the rating.

## Use cases

- **Quarterly close SBC accrual:** Controllers flex any input - awards granted, fair value, vesting, forfeiture - and the per-tranche expense, panel roll-forward, and dashboard recompute. Useful for the SBC accrual that closes alongside IS / BS at quarter-end.
- **Refresh-grant impact testing:** Add a new tranche or bump an existing one and see the next-12-month SBC expense path, the new opening unrecognised, and the weighted-average remaining vesting shift on the dashboard.
- **IPO and post-IPO SBC planning:** Stack the founder, executive, and broad-based RSU tranches with realistic forfeiture, cliff, and elapsed inputs to model the expected SBC ramp through and after IPO.

## Frequently asked questions

### What is a stock-based compensation model?

A stock-based compensation (SBC) model is an equity-award register that translates per-tranche grant packages into an ASC 718 income-statement expense schedule and an unrecognised-SBC balance path. It is how CFOs, controllers, and FP&A teams accrue SBC each period and explain the next-12-month expense trajectory to the board.

### How is the monthly expense computed?

Monthly expense per tranche = awards * (1 - forfeiture rate) * fair value / vesting months. The expected-forfeiture method applies the forfeiture haircut up-front, so the recognised expense is flat across the vesting period.

### How does cliff vesting fit into ASC 718?

ASC 718 requires expense to be attributed straight-line from grant date over the requisite service period, even though cliff awards legally vest in a lump at the cliff date. This template tracks both paths: the expense is straight-line on the Expense Schedule, while the Vesting Schedule shows the legal vesting curve (zero before cliff, full at vesting, linear in between).

### Does it true up for actual forfeitures?

No. The template uses the expected-forfeiture method, where the forfeiture rate is applied up-front. ASC 718 also permits an actual-forfeiture method that trues up each period as awards are forfeited. Switching is a per-period adjustment to the forfeiture input.

### Can I extend it beyond 12 months?

Yes. The builder is parameterised by N_MONTHS - bump it and rerun. The Expense Schedule, Vesting Schedule, and SBC Register all use a column-position trick so the formulas adapt to a wider horizon.

## Related templates

- [Cap Table Management Model](https://finamodel.com/templates/cap-table-model)
- [ESOP Pool Model](https://finamodel.com/templates/esop-pool-model)
- [3 Statement Model](https://finamodel.com/templates/3-statement-model)