Replicate the PV excel formula in Alteryx

[Data_Alter]

Hello,

I am looking to replicate the PV formula I had in my excel model into Alteryx. I have tried but getting big difference.

I have attached an example of the formula I had. 

Please can someone help me with this.

Thanks,

[atcodedog05]

Hi @Data_Alter 

This post maybe of help

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/PV-for-modified-number-of-payments-and...

[Data_Alter]

Hi , no this doesn't help. Thanks for looking.

[ncrlelia · Accepted solution]

Hi @Data_Alter 

Please see attached my suggested solution. 

1. Calculate # of periods

2. Generate rows equivalent to the # of periods

3. Calculate the cumulative PV in each period

4. Last period's PV is the present value of the investment

Hope it helps.

Cheers,

Lelia

[Data_Alter]

Thanks @ncrlelia so much.

There is one more column in the calculation. Is there a way to add it in the calculation ??

[ncrlelia]

Hi @Data_Alter,

Happy that I'm able to help. Regarding the calculation of the PV of a future value, I've updated the solution with an additional Multi-Row Formula.

1. Treat Period ID = 1 as the future (last period)

2. Discount the future value in a compounding manner for subsequent periods.

Please see attached the updated workflow. I noticed that both of my results are a few decimals away from that of Excel. I'm not very sure why is that so, I believe it is due to rounding.

Cheers,

Lelia