Employee ESOP & Options Vesting Administrator - Google Sheet

Managing an Employee Stock Ownership Plan (ESOP) or option pool is a mathematical minefield for early-stage founders. When tracking standard 4-year vesting schedules, 1-year cliffs, and exercised shares across dozens of early hires, standard spreadsheets inevitably break. Founders frequently miscalculate cliff dates, issue fractional shares, or accidentally grant more equity than the board authorized—leading to catastrophic legal cleanups and massive lawyer fees during Series A due diligence.

To solve this, startups are routinely forced to pay $3,000 to $5,000+ a year for cap table platforms like Carta or Pulley before they even have meaningful revenue.

The Employee ESOP & Options Vesting Administrator completely replaces that bloated SaaS tax. Built natively and exclusively for Google Sheets, it provides founders with an institutional-grade equity ledger and a stunning, cybernetic dark-mode executive dashboard to monitor cap table dilution in real time:

• Automated Vesting & Fractional Share Prevention: Input the grant date, total shares, vest term, and cliff. The engine automatically calculates the exact elapsed months and vested shares. Crucially, it utilizes a strict ROUNDDOWN algorithm to prevent the issuance of fractional decimal shares, keeping your cap table perfectly clean for future audits.
  

• The "Trojan Horse" Pool Depletion Sentinel: Set a minimum threshold for your unallocated option pool. If you model a new hire and their grant breaches your board-authorized buffer, the dashboard instantly flashes a high-visibility alarm: 🚨 POOL CRITICAL: Board Authorization Required for Expansion.
  

• The Imminent Cliff Forecaster: Prevent accidental equity unlocks. The ledger continuously tracks exactly how many months remain until a new hire’s 1-year cliff hits, automatically triggering a ⚠️ CLIFF IMMINENT warning so you can make definitive retention or termination decisions before massive equity vests.
  

• Dynamic Cap Table Dilution Matrix: You never need to hunt through your ledger to find your top equity holders. The dashboard uses an automated background query to pull your Top 15 option holders, dynamically sorting them by total vested shares and calculating their exact percentage dilution against the total pool.
  

• Digitally Shrink-Wrapped Architecture: Engineered strictly as a cloud-native Google Sheet. Only the soft yellow (#FEF08A) input cells are unlocked. Your master vesting algebra, query filters, and visual dashboards are fully protected to ensure zero calculation drift or broken #REF! cells.
  

Stop paying thousands of dollars in recurring software fees just to track standard employee stock options. Establish complete institutional command over your ESOP, execute flawless vesting math, and export clean, grid-free PDF cap table summaries directly from your web browser.