Eric
|
Links
|
Kids
|
Talks
|
Software
|
Contact
option-vest - Stock option vesting calculator
NAME
option-vest - Stock option vesting calculator
SYNOPSIS
option-vest [opts] options:strike:vest-start:vest-months[:cliff[:exer]]...
OPTIONS
-d --debug Debug mode. -h --help Print help and exit. -q --quiet Quiet mode. -v --version Print version and exit.
-p --price N Stock price (or ticker symbol). -m --as-of YYYY/MM Month of interest (defaults to current month).
ARGUMENTS
options Number of options
strike Strike price
vest-start Vesting start month in format YYYY/MM (e.g., 1998/05)
vest-months Number of months to complete vesting.
cliff Number of months 'till cliff.
exer Number of shares exercises
DOWNLOAD
The option-vest Perl script is available here:
http://www.anvilon.com/software/download/option-vest
A nice web interface is available here:
http://www.anvilon.com/option-vest/
DESCRIPTION
The option-vest program accepts information about one or more stock option grants and calculates how many options are vested and unvested. It also shows the value of the options at a given stock price and calculates the earnings after the cost of the options (the strike price) is taken into consideration.
EXAMPLES
Here is a sample command and its output.
$ option-vest -as-of 1998/07 -price 12.00 1000:3.00:1996/06:48:12 500:9.75:1998/05:12
as of date: 1998/07 stock price: $12.00 1000 options at $3.00, vest 1996/06 for 48 mo, 12 mo cliff 500 options at $9.75, vest 1998/05 for 12 mo
Remaining Total Exercised Vested Unvested -------- --------- --------- -------- 1,000/48 x 25 - 0 = 520 480 500/12 x 2 - 0 = 83 417 -------- --------- --------- -------- 1,500 0 603 897 options
$18,000.00 $0.00 $7,236.00 $10,764.00 value ($12.00) -7,875.00 -0.00 -2,369.25 -5,505.75 cost -------------- -------------- -------------- -------------- $10,125.00 $0.00 $4,866.75 $5,258.25 earnings
options value cumulative date vesting ($12.00) cost earnings earnings ---------- ------- ---------- -------- ---------- ----------- 1998/08 63 $756 - $473 = $284 $284 1998/09 62 $744 - $463 = $281 $565 1998/10 63 $756 - $473 = $284 $848 1998/11 63 $756 - $473 = $284 $1,132 1998/12 62 $744 - $463 = $281 $1,413 1999/01 62 $744 - $470 = $275 $1,688 1999/02 63 $756 - $473 = $284 $1,971 1999/03 62 $744 - $463 = $281 $2,252 1999/04 63 $756 - $473 = $284 $2,536 1999/05 63 $756 - $473 = $284 $2,819 1999/06 21 $252 - $63 = $189 $3,008 1999/07 20 $240 - $60 = $180 $3,188 1999/08 21 $252 - $63 = $189 $3,377 1999/09 21 $252 - $63 = $189 $3,566 1999/10 21 $252 - $63 = $189 $3,755 1999/11 21 $252 - $63 = $189 $3,944 1999/12 21 $252 - $63 = $189 $4,133 2000/01 20 $240 - $60 = $180 $4,313 2000/02 21 $252 - $63 = $189 $4,502 2000/03 21 $252 - $63 = $189 $4,691 2000/04 21 $252 - $63 = $189 $4,880 2000/05 21 $252 - $63 = $189 $5,069 2000/06 21 $252 - $63 = $189 $5,258
CAVEATS
This program may have bugs or errors in it. The user should verify all calculations by hand or using other software before making decisions.
There are quite a few rounding operations which take place, which may affect the accuracy of final numbers.
Some of the displayed numbers may not show all significant digits, especially in the case of monthly value, cost, and earnings.
Trading costs, and tax considerations are not taken into account. For more information, please talk to a qualified accountant, lawyer, broker, and psychiatrist.
Some of your option grants may vest at different times during the month. This program groups all of these together, so you may have to wait until the middle or end of a month to be able to excercise them.
AUTHOR
Eric Hammond <ehammond@thinksome.com>
$Id: index.html,v 1.5 2003/06/28 03:16:49 erich Exp $
Eric Hammond
| Credits |