Replicating Excel NPV function

Question

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.

lira_luis · Answer

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

Captura de tela 2024-06-14 115437.png

wonka1234 · Answer

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

wonka1234 · Answer

@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