Rounding Robin

Home › Templates › Stock-Based Compensation Template (ASC 718)

Stock-Based Compensation Template (ASC 718)

A stock-based compensation schedule under ASC 718 for up to 150 option and restricted stock unit grants. It calculates vesting, expense for the month and year, and unrecognised cost, and produces the journal entry by function and the disclosure roll-forward.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab and a list of every built-in check with its result.
InputsPeriod dates and the grant register: holder, function, award type, grant date, units, fair value, vesting terms and termination date.
ScheduleFor each grant: status, units vested, unvested and forfeited, expense to date, this month and year to date, and unrecognised cost.
Journal EntryThe monthly entry by function, with the credit to equity.
ReconciliationComparison with the general ledger, the unvested award roll-forward and disclosure measures.
Fair ValueA Black-Scholes calculator for the grant-date fair value of options.
ListsFunctions with their expense accounts.

Features

Instructions

  1. On the Lists tab, enter your functions and accounts.
  2. On the Inputs tab, enter the period dates and one row per grant.
  3. Use the Fair Value tab to value options.
  4. Enter a termination date when a holder leaves.
  5. Review the Schedule tab and post the entry.
  6. Enter general ledger balances on the Reconciliation tab.

Notes

Covers equity-classified awards with service conditions. Performance and market conditions, modifications, exercises, expirations and tax effects are not covered. Fair value inputs are estimates that require judgment.

Related calculators

More accounting templates

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.