| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What gets XNPV to calculate correctly if initial values are zero?
I calculated a XNPV on a series of cash flows. The cash flow in the first 27
years is zero and then there are positive cash flows for another 25 years. The calculation read the first positive cash flow as if it were at time zero instead of discounting it back 27 years. I ended up just using a PV, but would like to figure out how to use the XNPV function for this series of cash flows. Thanks for any ideas. Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Excel won't calculate my formulas correctly. | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
| calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions | |||
Threaded Mode
