ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Vesting Formula (https://www.excelbanter.com/excel-worksheet-functions/163381-vesting-formula.html)

cjyardley

Vesting Formula
 
What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!

Alan Beban[_2_]

Vesting Formula
 
cjyardley wrote:
What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!

I sent an email to you at and it got
bounced???

Alan Beban

cjyardley

Vesting Formula
 
That is odd...how do I send you my direct email without sharing it with
everyone else?

"Alan Beban" wrote:

cjyardley wrote:
What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!

I sent an email to you at and it got
bounced???

Alan Beban


Alan Beban[_2_]

Vesting Formula
 
Odd? Is correct??

Some people post something like

cjmylastnameatdiscussionsdotmicrosoftdotcom

and expect that the address harvesters won't harvest the correct email
address.

Alan Beban

cjyardley wrote:
That is odd...how do I send you my direct email without sharing it with
everyone else?

"Alan Beban" wrote:


cjyardley wrote:

What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!


I sent an email to you at
and it got
bounced???

Alan Beban


cjyardley

Vesting Formula
 
Ok, try that email address now. Thanks.

"Alan Beban" wrote:

Odd? Is correct??

Some people post something like

cjmylastnameatdiscussionsdotmicrosoftdotcom

and expect that the address harvesters won't harvest the correct email
address.

Alan Beban

cjyardley wrote:
That is odd...how do I send you my direct email without sharing it with
everyone else?

"Alan Beban" wrote:


cjyardley wrote:

What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!

I sent an email to you at
and it got
bounced???

Alan Beban



Alan Beban[_2_]

Vesting Formula
 
cjyardley wrote:
Ok, try that email address now. Thanks.

"Alan Beban" wrote:


Odd? Is correct??


Nope. I used the above and it got bounced again--

"The original message was received at Thu, 25 Oct 2007 18:39:28 -0500
from ppp-71-139-52-158.dsl.snfc21.pacbell.net [71.139.52.158]

----- The following addresses had permanent fatal errors -----

(reason: 550 Host unknown)

----- Transcript of session follows -----
550 5.1.2 ... Host unknown (Name
server: discussions.microsoft.com.: host not found)



Reporting-MTA: dns; nlpi001.prodigy.net
Received-From-MTA: DNS; ppp-71-139-52-158.dsl.snfc21.pacbell.net
Arrival-Date: Thu, 25 Oct 2007 18:39:28 -0500
Content-Type: text/plain

Final-Recipient: RFC822;

Action: failed
Status: 5.1.2
Remote-MTA: DNS; discussions.microsoft.com
Diagnostic-Code: SMTP; 550 Host unknown
Last-Attempt-Date: Thu, 25 Oct 2007 18:39:29 -0500"

Alan Beban[_2_]

Vesting Formula
 
cjyardley wrote:
What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!


I have a proprietary Excel program for tracking employee (and
consultant) stock options. It includes formulas for immediate and 1- to
5-year vesting, with and without 1-year and 6-month cliffs.

I'm not willing to share a formula in this public forum, but if you can
post some contact information I'll be happy to talk to you more privately.

Alan Beban

cjyardley

Vesting Formula
 
I'm probably going to get a ton of spam, but oh well.

Email is cyardley
at
revance

Thanks.

"Alan Beban" wrote:

cjyardley wrote:
What is a good formula for tracking vested options under the following
schedule:

after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting
after 4 years.

Thanks!


I have a proprietary Excel program for tracking employee (and
consultant) stock options. It includes formulas for immediate and 1- to
5-year vesting, with and without 1-year and 6-month cliffs.

I'm not willing to share a formula in this public forum, but if you can
post some contact information I'll be happy to talk to you more privately.

Alan Beban



All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com