Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hello,
i'm trying to reprogram the NPV function as in Excel but i can't seem to understand how excel gets the result it is giving for instance in the help i see this example: annual discount rate: 10% initial cost: 10000 return first year: 3000 return second year: 4200 return third year: 6800 Can someone explain me (step by step) how excel is giving me the result of 1188.44? i thought it was: 3000/1.1 + 4200/1.21 + 6800/1.331 but that gives me something else? Any help would be appreciated, Stig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Question about financial calculation PMT | Excel Worksheet Functions | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Calculation question | Excel Discussion (Misc queries) | |||
Help, Multiple conditional calculation | New Users to Excel |