Automated Long-Term Incentive (LTI) Grant Schedule & Vesting Tracker

This workbook structures long-term incentive grants (RSUs, performance units, options) across employees and produces vesting schedules, accounting expense allocations, and forecasted dilution. Each grant row contains grant attributes and an associated vesting schedule table that can be time-based, milestone-based, or performance-conditioned. The model computes recognized expense per reporting period using the grant's fair value and vesting percentages, aggregates expense to department/cost-center levels, and estimates future payout liabilities. It includes termination rule logic to apply proration or forfeiture scenarios and scenario toggles for accelerated vesting or clawback provisions. Audit columns show source documents and approval metadata for governance. The tracker also surfaces upcoming vesting cliffs and tax withholding estimates for payroll coordination. This tool supports compensation committees and payroll teams by centralizing LTI visibility and simplifying accounting tasks under relevant standards (ASC 718 / IFRS 2) when paired with fair-value inputs.