Alright, I made some major adjustments to
the spreadsheet. Here's how it looks like if Elon waits until Jan 2028 to exercise all 12 stock option awards.
View attachment 275365
assumptions:
1. outstanding shares go up 3M from current 169M by time Tranche 1 is met
2. outstanding shares go up by 4M between tranches (includes Elon's stock option grant, employee stock plans, and cap raises)
3. Tax rate is 50%. Assuming taxed as income and includes federal and california state taxes.
4. Elon's "net" is value of stock received because he has required 5 year holding period after exercising option