vesting

  1. A

    Calculate value based on date = date in another cell

    Hi all, How do I calculate vested shares, in a particular month, based on the vesting date? For example, I am trying to solve for Cells I2 and N2, the correct answer will be 25,000, however I don't know how to set up the formula to calculate based on the date in row 1. D2:G2 are the vesting...
  2. A

    Formula for Equity Vesting - After Year one 25% vested followed by quarteryly vesting.

    I'm attempting to write a formula to calculate the amount of vested equity based on award date and current date. If award date is 1/1/2013 for 50,000 units than on 1/1/2014 25% have vested. The remaining 75% will vest on a quarterly bases. I'd like it updated in real time based on today's...
  3. B

    How to create a spreadsheet with alterable cells using vesting schedules

    Hi! I have a chart with four columns: shares, grant date, vesting schedule, and prior sales. With this information, I have to create a spreadsheet that calculates how many of Employee X's shares will be vested on any given future date, taking into consideration (i.e. adding alterable cells)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top