| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
present value of "past" and future amounts
Hi, I am trying to compare two financial scenarios.
In both of them I have: - years when the money is earned or will be earned (lets say A2 €“ A10) - Amounts of money earned in the past and those which will be earned (lets say B2 €“ B10) Which formula do I use to calculate the NetPresentValue of all the money (past and future)? Thanks, thanks, thanks........ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Last cell" in Excel 2003 is way past end of data, how do i fix? | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Help with handling large amounts of data - determine "MIN IF" ? | Excel Worksheet Functions | |||
| Range name of "\0"? - How can I slide this past Excel? | Excel Worksheet Functions | |||
| Can you add the "Change Case" feature to Excel on future versions | Excel Discussion (Misc queries) | |||
Linear Mode
