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.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab and a list of every built-in check with its result. |
| Inputs | Period dates and the grant register: holder, function, award type, grant date, units, fair value, vesting terms and termination date. |
| Schedule | For each grant: status, units vested, unvested and forfeited, expense to date, this month and year to date, and unrecognised cost. |
| Journal Entry | The monthly entry by function, with the credit to equity. |
| Reconciliation | Comparison with the general ledger, the unvested award roll-forward and disclosure measures. |
| Fair Value | A Black-Scholes calculator for the grant-date fair value of options. |
| Lists | Functions with their expense accounts. |
Features
- Options and restricted stock units, with a cliff and monthly, quarterly or annual vesting.
- Straight-line expense by day over the vesting period, never less than the fair value of vested units.
- Forfeitures recognised when they occur: on termination, expense on unvested units is reversed.
- Expense by function, mapped to your own accounts.
- Unvested award roll-forward: opening, granted, vested, forfeited and closing.
- Unrecognised compensation cost and the weighted-average period over which it will be recognised.
- Black-Scholes calculator for option fair value.
Instructions
- On the Lists tab, enter your functions and accounts.
- On the Inputs tab, enter the period dates and one row per grant.
- Use the Fair Value tab to value options.
- Enter a termination date when a holder leaves.
- Review the Schedule tab and post the entry.
- 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
- Present Value CalculatorCalculate what a future sum of money is worth today at a given discount rate and number of years.
- Employee Cost CalculatorCalculate the full yearly cost of an employee including payroll taxes and benefits, and the loaded hourly rate.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
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.