ESOP Pool ModelFree Financial Model Download
Model ESOP grants with vesting, annual burn rate, and cap table dilution. No double-counting of unvested equity or missing the founder dilution impact.
Free download. No sign-up required.
About this model
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.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
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
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.
Frequently asked
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.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Cap Table Management Model
Equity ownership tracking and scenario modeling.
Bridge Round Financing Model
Convertible note and SAFE financing analysis.
Convertible Note and SAFE Model
Model SAFE and convertible note terms with conversion triggers and equity rounds.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.