| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NPV vs XNPV
Hi there,
hoping someone can clarify something.... Why do you get different NPV values using NPV and XNPV, if the timeframes are equal distance for the XNPV calculation? I understand XNPV is for when the cashflow is not periodic?? But surely if the dates are periodic (in this case annually over 12 years) it should give the same result as the standard NPV calculation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XNPV | Excel Discussion (Misc queries) | |||
| NPV vs. XNPV | Excel Worksheet Functions | |||
| xnpv with actual/360 | Excel Worksheet Functions | |||
| Formula XNPV | Excel Discussion (Misc queries) | |||
| XNPV function | Excel Worksheet Functions | |||
Threaded Mode
