Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#8
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vesting Schedule Formula | Excel Discussion (Misc queries) | |||
I need a formula to help me calculate years of vesting for 401K. | Excel Worksheet Functions |