| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Present Value of equal payments of a future value
I have a known future value = $300,000 worth of stock options in year 2012.
A third of this value $100,000 will vest on 12/31/2010. A third of this value $100,000 will vest on 12/31/2011. A third of this value $100,000 will vest on 12/31/2012. Estimated rate of increase per year 5%. How do I find the present value at the end of each year for the vested stock options and have my present value plus interest earned equal my future value. I have tried to use PV tables and get a total of PV amounts plus interest that is greater then my future value. -- Thanks Q |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| present value of a future amount | Excel Worksheet Functions | |||
| Present value and future value | Excel Worksheet Functions | |||
| How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
| How can I figure present value of a stream of payments? | New Users to Excel | |||
| calculating the future value of a present value | Excel Worksheet Functions | |||
Threaded Mode
