ExcelUser18
New Member
- Joined
- May 3, 2017
- Messages
- 34
Hi all,
I'm looking to build what I believe should be an easy schedule to show how stock units that vest over a 3 year period.
For example, if I was awarded $10K today, I'd vest $3.3k for the next 3 years and by year 3, I'd have earned the full $10k. The second component would be that each year, I'd earn a new $10k which would start vesting on the same schedule. So $10k in year 0 would fully vest in year 3 (1/3 for each year), the $10k in year 1 would fully vest in year 4 (1/3 for each year), and $10k in year 2 would fully vest in year 5 (1/3 for each year), so on and do forth.
Does anyone have any idea how to set up a chart where I can show each years awarded stock, vested stock, and total amounts? Could the chart also reflect different vesting periods (semi annually, quarterly, etc)?
I honestly have no idea how to start this and maybe I'm not searching correctly but I can't seem to find a simple excel. Any help would be really appreciated
I'm looking to build what I believe should be an easy schedule to show how stock units that vest over a 3 year period.
For example, if I was awarded $10K today, I'd vest $3.3k for the next 3 years and by year 3, I'd have earned the full $10k. The second component would be that each year, I'd earn a new $10k which would start vesting on the same schedule. So $10k in year 0 would fully vest in year 3 (1/3 for each year), the $10k in year 1 would fully vest in year 4 (1/3 for each year), and $10k in year 2 would fully vest in year 5 (1/3 for each year), so on and do forth.
Does anyone have any idea how to set up a chart where I can show each years awarded stock, vested stock, and total amounts? Could the chart also reflect different vesting periods (semi annually, quarterly, etc)?
I honestly have no idea how to start this and maybe I'm not searching correctly but I can't seem to find a simple excel. Any help would be really appreciated
