Financial Reporting

 View Only

Stock Compensation Expense Report (a simplified overview)

By Calvin Cheng posted 07-02-2023 15:29

  

One of the reports in Carta’s Financial Reporting suite is the SBC Expense report.  This report provides companies with a journal entry that debits the stock compensation expense account and credits the additional paid in capital account.  Overtime, companies have requested this report to include more data.  As a result there currently is a lot of things happening within this report.  However, we only have to look at several columns to understand what is happening in the report.

This walkthrough is intended to provide a simplified overview on how expense is determined for standard time-based vesting options and restricted stock.  I will not talk about how to estimate for future forfeitures, awards with performance/milestone based vesting schedules, ISO/NSO split awards, modifications/repricings, or cost center allocation.

IMPORTANT: any awards listed in the ‘Errors’ tab are excluded from the report.  Until the errors have been resolved, the report is considered incomplete and companies should not use it for a ‘base report’ when building the subsequent reporting period.  

Many errors are related to data issues (over-exercises, missing stakeholder relationships, missing cancellation treatment, etc.).  If you need assistance understanding or resolving an error, please reach out to us by sending an email to  718@carta.com

The calculation of expense can be seen in the ‘tranches’ tab which lists each vesting increment in its own row.

  1. Bring over the fair value per share from the ‘option values’ and ‘intrinsic values’ tabs (column E)

  2. Multiply the fair value per share by the quantity of shares to determine the total fair value (column F)

  3. Determine the % of service completed (column I) by dividing the number of service days completed (column G) and the total service days (column H)

  4. Multiply % of service completed by the total fair value to determine the cumulative expense to date (column J)

    • If there is a termination date (column C), cumulative expense for that vesting tranche is zero

  5. The journal entry for total expense for the period (column L) is the cumulative expense (column J) minus what has already been recognized in prior periods (column K)

 

Report period 1/1/2021 to 12/31/2021:

 

Report period 1/1/2022 to 12/31/2022:

------------------------------
Did you find this post helpful or have any further questions?  Please reach out Carta's dedicated Financial report team with any comments or feedback by emailing us at 718@carta.com.
------------------------------
0 comments
1029 views

Permalink