What it is
The option activity table in the notes starts with a rollforward by series and the weighted-average exercise price. This workbook builds it and agrees the closing balance to the capitalization table.
Each series shows opening, grants, exercises, forfeitures, expirations and closing, with weighted-average prices, exercisable units and approximate intrinsic value.
When to use it
- Preparing or auditing the stock option note.
- Reconciling the cap table to the equity records.
- Tracking warrants issued with financing.
What’s inside
- Series tab with quantities and weighted-average prices
- Summary tab with closing balance, average price and checks
- Flags for negative balances and cap table differences
- Legend tab
Standard cited
This template follows ASC 718. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Is the intrinsic value exact?
It is approximate because it uses a weighted-average price for each series. Use grant-level data for the disclosed figure.
Do I need one row per grant?
One row per series is enough for the rollforward.
Related templates
- Equity and Stock-Based Compensation Audit Program
- Stock-Based Compensation Expense Schedule (Graded Vesting)
- Equity Rollforward Template (Corporation and LLC)
- Earnings Per Share Workbook (ASC 260)
Last updated 11/06/2026. All free templates.