Here is the problem:
I am granted stocks on 10/10/03, 1000 shares. After one year, 25% of those shares are available. The remaining 75% are available in equal monthly installments during the remaining 3 years.
How do I use excel to calculate the available shares if the user enters today's day?
I have no idea how to start, so any thoughts would be greatly appreciately.
I am granted stocks on 10/10/03, 1000 shares. After one year, 25% of those shares are available. The remaining 75% are available in equal monthly installments during the remaining 3 years.
How do I use excel to calculate the available shares if the user enters today's day?
I have no idea how to start, so any thoughts would be greatly appreciately.