Early exercise model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQR
1
common parameters
2
409a valuation at grant$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000$5,000,000
3
State AMT rate7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%7.3%
4
State income rate12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%
5
State capital gains rate
12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%12.3%
6
parametersExit for $0, early exerciseExit for $0, no early exerciseExit for $100m, sell immediatelyExit for $100m, sell immediatelyExit 100m, stock-> 0 in same tax yrExit 100m, stock-> 0 next tax yrEarly exercise, sell for $100mLeave halfway through, no EELeave halfway through, EEExit for $1b, wait to sellExit for $1b, sell immediatelyExit $1b, stock-> 0 in same tax yrExit $1b, stock-> 0 next tax yrEarly exercise, sell for $1bLeave halfway through, no EELeave halfway through, EE
7
Equity percentage0.50%0.50%0.50%0.50%0.50%0.50%0.50%0.25%0.25%0.50%0.50%0.50%0.50%0.50%0.25%0.25%
8
Valuation at exercise (assuming no dilution)$0$0$100,000,000$100,000,000$100,000,000$100,000,000$5,000,000$100,000,000$5,000,000$1,000,000,000$1,000,000,000$1,000,000,000$1,000,000,000$5,000,000$1,000,000,000$5,000,000
9
Valuation at sale (assuming no dilution)$0$0$100,000,000$100,000,000$0$0$100,000,000$100,000,000$100,000,000$1,000,000,000$1,000,000,000$0$0$1,000,000,000$1,000,000,000$1,000,000,000
10
Sell >1 year after exercise?
yesnoyesnonoyesyesnoyesyesnonoyesyesnoyes
11
34
final results
35
AMT you have to pay before you get money$0$0$167,438$0$0$167,438$0$0$0$1,753,688$0$0$1,753,688$0$0$0
36
Tax-inclusive gain/loss (ex. AMT credit)-$25,000$0$307,563$258,277-$25,000-$192,438$333,260$129,138$166,630$3,221,313$2,705,107-$25,000-$1,778,688$3,490,460$1,352,553$1,745,230
37
Effective equity amount
--0.308%0.258%--0.333%0.129%0.167%0.322%0.271%--0.349%0.135%0.175%
38
Loading...
Main menu