📊 Excel Implementation Instructions
To create the actual Excel file, use these specifications:
Sheet 1: Summary Dashboard
A1: Employee Name | B1: Position | C1: Total Shares | D1: Vested | E1: Unvested | F1: % Vested
A2: Lance Davis | B2: CEO | C2: 4,500,000 | D2: =VestingCalc!B50 | E2: =C2-D2 | F2: =D2/C2
A3: Fredrick Waihenya | B3: CTO | C3: 4,000,000 | D3: =VestingCalc!C50 | E3: =C3-D3 | F3: =D3/C3
Sheet 2: Vesting Calculations
A1: Date | B1: Lance Vested | C1: Fredrick Vested | D1: Paul Reynolds | E1: Ross Emory | F1: Dalvin
Sejour | G1: Desire Nzengo | H1: TheMu Inc
A2: =StartDate | B2: =IF(A2>=LanceCliffDate, LanceCliffShares, 0) | C2: =IF(A2>=FredrickCliffDate,
FredrickCliffShares, 0) | [Similar formulas for advisors]
Key Excel Formulas:
Cliff Vesting: =IF(TODAY()>=CliffDate, TotalShares*0.25, 0)
Monthly Vesting: =IF(TODAY()>CliffDate, MIN((DATEDIF(CliffDate,TODAY(),"M")/36)*TotalShares*0.75,
TotalShares*0.75), 0)
Total Vested: =CliffVested + MonthlyVested
📋 Excel Formulas Reference
Key Formulas for Excel Implementation:
1. Cliff Vesting Calculation
=IF(TODAY()>=EDATE(StartDate,12), TotalShares*0.25, 0)
2. Monthly Vesting After Cliff
=IF(TODAY()>EDATE(StartDate,12),
MIN(DATEDIF(EDATE(StartDate,12),TODAY(),"M")*(TotalShares*0.75/36),
TotalShares*0.75), 0)
3. Total Vested Shares
=CliffVested + MonthlyVested
4. Vesting Percentage
=TotalVested/TotalShares*100
5. Acceleration Trigger (Single - 50%)
=IF(SaleDate<>"", TotalShares*0.5 + TotalVested, TotalVested)
Excel Sheet Structure:
| Sheet Name |
Purpose |
Key Columns |
| Summary |
Overview Dashboard |
Employee, Total Shares, Vested, % Complete |
| Vesting_Schedule |
Monthly calculations |
Date, Lance, Fredrick |
| Configuration |
Settings & Variables |
Start Date, Total Shares, Cliff Period |
| Acceleration |
Sale scenarios |
Trigger Events, Accelerated Vesting |