Hello,
I am looking for a way to replicate the compound interest (=CUMIPMT) formula in Alteryx. Example below:
Interest Rate: 3.5%
Number of Periods: 60 months
Amount: $10,000
Desired Result:
Total Interest Paid: $915.05
Monthly Payment: $181.92
Solved! Go to Solution.
Hi @TimBailey ,
in Alteryx you can use a Formula tool and the function FinancePMT to calculate the monthly payment. Total interest paid can be calculated based on the result:
Alteryx results exactly match the Excel result.
I've attached a sample workflow. Let me know if it works for you.
Best,
Roland
User | Count |
---|---|
61 | |
24 | |
23 | |
21 | |
20 |