#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 783
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 783
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vesting Schedule Formula slrog123 Excel Discussion (Misc queries) 3 September 19th 07 10:10 PM
I need a formula to help me calculate years of vesting for 401K. Diana Excel Worksheet Functions 2 May 24th 06 09:36 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"