# ESOP Pool Model Model ESOP grants with vesting, annual burn rate, and cap table dilution. No double-counting of unvested equity or missing the founder dilution impact. - Canonical: https://finamodel.com/templates/esop-pool-model - Excel download: https://finamodel.com/templates/esop-pool.xlsx - Category: Corporate Finance - Model type: Valuation - Difficulty: Intermediate - Audiences: CFOs & FP&A, Bankers & advisors, Founders, CFOs, HR leaders, Equity specialists - Tags: esop, equity, vesting, dilution, cap-table ## Overview An ESOP (Employee Stock Ownership Plan) pool model projects the dilution impact of equity grants to employees over a five-year period. The model tracks how many shares are granted each year based on hiring (new hires receive 2% of fully diluted shares each), retention grants (0.8% of outstanding options annually to keep key staff), and how many of those grants vest. With a standard four-year vesting cliff (zero vesting until Year 1, then 25% per year), the model tracks which grants are still unvested, which have vested and are exercisable, and which employees exercise to buy shares. The workbook ensures the option pool never becomes exhausted (expansion events at funding rounds top up the pool), and shows the dilution to founders and investors as the fully diluted share count grows from exercise activity. When employees exercise options at the original strike price (409A fair value at grant), the company receives cash proceeds. The model tracks the share-based compensation (SBC) expense under ASC 718 accounting: each grant is valued at Black-Scholes fair value at grant date (typically 40% of underlying FMV), then expensed straight-line over the vesting period. This template is essential for growth-stage startups planning equity budgets, compensation committees assessing dilution, and investors performing cap table modeling. ## What's included - Grant schedule by employee level with vesting curves (typically 4-year cliff) - Annual ESOP pool burn and remaining pool balance - Share count impact on cap table and fully diluted shares - Dilution to founders and earlier investors - Tax treatment and 409A valuation considerations - Valuation impact (ASP) as share count increases ## ESOP Pool Model: How It Works, What It Captures and Who It Helps This ESOP pool model template projects a venture-backed startup's equity compensation programme over five years. It tracks pool availability, vesting and forfeitures, dilution for founders and investors, share-based compensation expense and exercise proceeds. The document explains the model's operating drivers, calculation flow, outputs and practical application for anyone evaluating whether the template fits their planning needs. ### What the ESOP Pool Model Tracks and Why It Matters The model is a standalone equity compensation tracker built to answer four planning questions: how large an option pool must be to fund a hiring programme, what dilution founders and investors face as options are granted and exercised, what share-based compensation expense hits the income statement under straight-line attribution, and when cash exercise proceeds arrive. - It is not a three-statement or project-finance model, so it omits operating revenue, balance sheet and debt. - Instead, it concentrates on the capital-structure mechanics that determine whether a pool is large enough and how ownership shifts over five annual periods. ### What Drives the Numbers? The primary drivers sit on the Assumptions sheet: hiring plan headcount additions, grant per hire, refresh grant rate, pool expansion events, vesting and cliff periods, forfeiture rate, exercise rate, 409A fair market value growth, and the Black-Scholes inputs for volatility, risk-free rate, expected term and dividend yield. - A scenario toggle lets you switch between base, bull and bear multipliers on forfeiture, exercise and fair-market-value growth, so the effective named ranges consumed by the rest of the model adjust without changing the underlying base inputs. - This design keeps the model acyclic while letting you test more aggressive or conservative assumptions in a controlled way. ### Following the Calculation Flow The calculation follows a directed acyclic graph to avoid circular references. Pool_Summary first computes total grants by capping new-hire and refresh demand at opening pool plus expansion; this does not reference vesting. - Vesting_Schedule then takes those grants as cohort inputs and rolls forward unvested, vested and forfeited shares using the cliff and vesting period. Pool_Summary subsequently completes its closing pool row by reading current-period forfeitures from Vesting_Schedule. - Exercise_Proceeds and SBC_Expense sit downstream, reading vested cumulative shares and grant values, and Dilution_Analysis reads outstanding options. This one-way flow ensures every sheet depends only on prior stages, which is why the model recalculates cleanly. ### Outputs and Practical Use Outputs include an annual pool roll-forward, a five-cohort vesting schedule, fully diluted ownership percentages by stakeholder, an option overhang block showing granted and unallocated reserves, share-based compensation expense, exercise proceeds and a checks sheet. - The overhang block is particularly useful because it reports dilution both as a net outstanding figure and as a fully diluted pool percentage, giving founders a term-sheet view of the reserve. - The model is aimed at founders or finance leads planning a hiring programme who need to see whether the existing pool supports planned grants without a top-up, and how forfeitures and exercises affect cap-table dilution over time. - Its focus on equity mechanics means it complements rather than replaces a full operating model. ## Tracks grants from pool to dilution See how each grant tranche flows through vesting schedules into fully diluted share counts and ownership percentages. ## Connects to your cap table Understand exactly how ESOP issuance reduces founder and investor ownership before and after each funding round. ## Models retention and burn rate Forecast how long your current pool lasts under different hiring plans, and when you will need to request a pool refresh from the board. ## Tracks grants from pool to dilution See how each grant tranche flows through vesting schedules into fully diluted share counts and ownership percentages. ## Connects to your cap table Understand exactly how ESOP issuance reduces founder and investor ownership before and after each funding round. ## Models retention and burn rate Forecast how long your current pool lasts under different hiring plans, and when you will need to request a pool refresh from the board. ## Features - **Vesting waterfall and burndown:** Track total pool, vested, and unvested shares; forecast annual grants and remaining pool runway. - **Cap table dilution projection:** Show fully diluted share count before and after ESOP grants and impact on founder ownership %. - **409A valuation integration:** Link to 409A fair market value and model tax implications of grants and exercises. ## Use cases - **Series funding cap table planning:** Allocate ESOP pool pre-raise to support employee recruitment while managing dilution. - **Equity grants and retention planning:** Model retention power of vesting schedules and refresher grants to reduce attrition. - **Acquisition impact analysis:** Calculate exit proceeds to employees under various acquisition scenarios. ## Frequently asked questions ### What is a typical ESOP pool size? Early-stage startups allocate 10-20% of fully diluted equity. Mature companies may use 5-10%. The pool is set and refreshed at board discretion. ### What is a 4-year vest with 1-year cliff? The employee earns nothing for 12 months, then vests 25% of the grant, then 1/48 per month for the remaining 36 months. ### How does ESOP dilute my ownership? ESOP shares increase the denominator in the fully diluted share count, reducing your ownership percentage unless you participate pro-rata in new fundraising. ### Who uses ESOP pool models? Founders, CFOs, HR leaders, and equity specialists use them during fundraising rounds, new hire planning, and board conversations about pool size. ### How do I calculate exit proceeds to employees? Apply the per-share exit price to vested shares held by each employee, net of any exercise price and applicable taxes, under each acquisition scenario. ## Related templates - [Cap Table Management Model](https://finamodel.com/templates/cap-table-model) - [Bridge Round Financing Model](https://finamodel.com/templates/bridge-round-financing-model) - [Convertible Note and SAFE Model](https://finamodel.com/templates/convertible-safe-model)