FinanceRate Difference Result between Excel and Alteryx

Question

I used the exact same inputs to calculate Rate using Excel and Alteryx, but I got different answers (Difference is under Col I in Excel Attached). Anyone is the community had similar issue?

Alteryx Developers: do you know why there is a difference? and how to reconcile between Alteryx and Excel?

Thank you.

Interest Rate.yxzp

Rate Alteryx vs Excel.xlsx

JessieC · Answer

@TeresaZhang7517 - solution would be to calculate it with the formula for future value = present value x (1+ interest rate)^n

In this formula, the superscript n refers to the number of interest-compounding periods that will occur during the time period you're calculating for.

https://www.business.org/finance/investing/how-to-calculate-future-value-of-an-investment/

In Alteryx, create column in Formula where Future Value = [Present Value]*POW(1+[interest rate], n)

TeresaZhang7517 · Answer

Hi,

I am a newbie. And I have a same issue, do you have any solutions? Need your help.

petershen517 · Answer

Hi jamielaird,

Thank you for the fast response. I rounded to 6 decimals under both Excel and Alteryx, but the difference starts from the third decimal, so I don't think this is due to rounding or precision. Per the link in your reply "In the case of Excel, although Excel can store numbers from 1.79769313486232E308 to 2.2250738585072E-308, it can only do so within 15 digits of precision. This limitation is a direct result of strictly following the IEEE 754 specification and is not a limitation of Excel. This level of precision is found in other spreadsheet programs as well."

Interest Rate.yxzp

Rate Alteryx vs Excel Output.xlsx