Replicating Excel NPV function

[wonka1234]

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.

[IraWatt]

Hey @wonka1234,

Can you share your excel sheet? I did this in Excel and Alteryx and got the same result:

[wonka1234]

@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

[wonka1234]

ahhh the rate needs to be converted to a %... thats why

[lira_luis]

e possível que o discount rate seja dimanico, indicando uma coluna por exemplo