Equity Grant Modeling Advisor
Model equity grants, valuations, and vesting scenarios for compensation decisions
What You Can Do
This skill helps you analyze equity grant impacts, model complex vesting schedules, and evaluate valuations for compensation decisions. You can compare grant structures, calculate tax implications, and build detailed financial models to support equity and long-term incentive planning. It's designed for finance professionals, HR leaders, and executives who need to understand the full impact of equity compensation.
Features
Compare the total compensation value of equity grants versus cash bonuses, accounting for vesting schedules and potential valuations
Model complex vesting scenarios including cliffs, accelerated vesting, and various vesting patterns for different grant types
Evaluate company valuations, calculate per-share prices, and analyze how valuations affect grant values over time
Estimate tax consequences for different equity types (NSO, ISO, RSU) across various sale scenarios and vesting events
Model shareholder dilution from new grants, calculate ownership percentages, and project future dilution scenarios
Build side-by-side comparisons of different grant structures, vesting terms, and strike prices to support negotiation decisions
Recommend optimal grant pricing and strike prices based on company valuation, market conditions, and compensation objectives
Generate detailed models and assumptions that export cleanly to Excel for board presentations and financial planning
Example Output
Example 1: Grant Value Comparison
| Scenario | Grant Type | Shares/Units | Strike Price | 4-Year Vesting | Year 4 Value @$50/sh | Tax Impact |
|---|---|---|---|---|---|---|
| Offer A | RSU | 10,000 | N/A | 1yr cliff + 3yr | $500,000 | ~$125,000 |
| Offer B | NSO | 25,000 | $12 | 1yr cliff + 3yr | $950,000 | ~$237,500 |
| Offer C | ISO | 20,000 | $10 | 1yr cliff + 3yr | $800,000 | ~$80,000 (QSBS) |
Example 2: Vesting Impact Analysis
RSU Vesting Schedule (10,000 units, $30/share)
- Year 1: 2,500 units vest → $75,000 (taxable income)
- Year 2: 2,500 units vest → $75,000 (or more if price appreciates)
- Year 3: 2,500 units vest → $75,000
- Year 4: 2,500 units vest → $75,000
- Total vested value: $300,000 base (plus upside)
Example 3: Dilution Scenario
Current cap table: 10M shares outstanding, $100M valuation ($10/share)
New Series B financing: 5M shares at $15/share ($75M round)
Your ownership: 100k shares → dilution from 1.0% to 0.67%
Post-Series B value: Same 100k shares now worth $1.5M (was $1M)
What's Included
- Grant Valuation Framework: Templates for analyzing equity grant types (RSU, NSO, ISO, SAR), calculating fair values, and understanding vesting impact
- Vesting Schedule Analyzer: Detailed breakdowns of vesting patterns, cliff periods, acceleration triggers, and double-trigger events
- Tax Consequence Calculator: Methods for estimating AMT, NQD timing, Section 83(b) elections, and long-term capital gains implications
- Scenario Comparison Models: Side-by-side analysis frameworks to evaluate competing offers, different strike prices, and vesting terms
- Valuation Impact Projections: Models showing how different company valuations affect grant values and ownership percentages over time
Who It's For
- CFO and Finance Leaders
- Compensation and HR Specialists
- Startup Founders and CEOs
- Equity Plan Administrators
- Investment Bankers and Financial Advisors
Best For
- Stock option and RSU evaluation
- Executive compensation planning
- Equity offer negotiation
- Long-term incentive strategy
- Shareholder dilution analysis
You might also like
Generate professionally-written, legally compliant benefits communications tailored to your employee population. This skill transforms complex benefits information into clear, accessible employee guides, FAQs, and educational materials while maintaining compliance with federal and state regulations. Reduce HR administrative burden by automating the creation of consistent, audit-ready benefits documentation.
by huifer
Build detailed job architecture frameworks that define roles, competencies, career paths, and organizational structure. You'll generate job descriptions, competency models, leveling matrices, and succession plans tailored to your organization's strategic objectives and culture. Claude helps you create consistent, evidence-based job architectures that align hiring, development, and performance management.
by huifer
This skill analyzes complex multi-country expatriate tax scenarios and automatically calculates equalization obligations to ensure employees' tax burdens remain neutral across assignments. You'll generate compliance documentation, tax calculations, and payroll impact summaries that account for international tax treaties, local regulations, and currency fluctuations to support fair and compliant expatriate compensation.
by huifer
You can submit complex visa sponsorship cases to receive comprehensive analysis of legal pathways, eligibility assessment across multiple visa categories, and detailed compliance strategies. The skill evaluates case facts against current immigration law, identifies viable pathways ranked by feasibility, and generates actionable compliance checklists with timelines and cost estimates to guide your sponsorship strategy.
by huifer
You can streamline complex multi-jurisdiction tax calculations, ensure compliance with local regulations, and generate clear employee communications. This skill handles the intricate calculations required to equalize tax burdens across different countries, tracks regulatory requirements, and produces audit-ready documentation—reducing manual work and minimizing compliance risk for your global mobility program.
by huifer
Create enterprise-grade total rewards programs that balance competitive compensation, benefits architecture, and employee engagement. Conduct market benchmarking, model ROI across program options, and develop strategic recommendations that improve retention while optimizing cost. Generate detailed program roadmaps with implementation timelines and success metrics.
by huifer
This skill helps you develop clear, compelling communication strategies that translate complex compensation and benefits data into value propositions your workforce actually understands. You'll get tailored messaging frameworks for different employee segments, along with templates for explaining pay equity, benefits, and total compensation in ways that drive engagement and satisfaction.
by huifer
Create comprehensive leave management policies, compliance documentation, and decision workflows tailored to your organization. Generate employee communications, accrual calculations, and audit-ready approval processes. Build decision trees for complex leave scenarios (FMLA, ADA, state-specific rules) and produce implementation guides that your HR team can deploy immediately.
by huifer