Replicating Excel NPV function
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
wonka1234
10 - Fireball
‎06-05-2022
08:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
Trying to replicate excels NPV function.
In excel I get: =NPV(C78,M7:M65)
$35,157,235.57 |
in alteryx im getting
sample data:
C78 or Rate used =
0.002953 |
Values:
Sum of these:
665,765 |
952,516 |
939,105 |
925,875 |
912,772 |
899,792 |
887,002 |
874,346 |
861,851 |
849,485 |
837,288 |
825,222 |
813,281 |
801,495 |
789,829 |
778,325 |
766,928 |
755,617 |
744,503 |
733,503 |
722,648 |
711,904 |
701,310 |
690,832 |
680,462 |
670,231 |
660,104 |
650,118 |
640,234 |
630,417 |
620,778 |
611,236 |
601,824 |
592,507 |
583,323 |
574,244 |
565,256 |
556,393 |
547,619 |
538,970 |
530,415 |
521,912 |
513,569 |
505,310 |
497,167 |
489,105 |
481,161 |
473,311 |
465,538 |
457,877 |
450,292 |
442,818 |
435,434 |
428,101 |
420,899 |
413,764 |
406,738 |
399,775 |
392,928 |
any help would be appreciated.
Labels:
- Labels:
- Custom Tools
4 REPLIES 4
17 - Castor
‎06-05-2022
09:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @wonka1234,
Can you share your excel sheet? I did this in Excel and Alteryx and got the same result:
‎06-05-2022
04:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt I sumed the column in my excel and get
37,891,024 |
not sure whats going on here... your saying your alteryx and excel getting same amount...
then doing my NPV in excel still getting
$35,157,235.60 |
‎06-05-2022
04:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ahhh the rate needs to be converted to a %... thats why
lira_luis
5 - Atom
‎06-14-2024
07:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
e possÃvel que o discount rate seja dimanico, indicando uma coluna por exemplo
