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,
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
This post maybe of help
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/PV-for-modified-number-of-payments-and-payment-amount/td-p/668119
Hi , no this doesn't help. Thanks for looking.
Thanks @ncrlelia so much.
There is one more column in the calculation. Is there a way to add it in the calculation ??
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.
