Compound interest (CUMIPMT Formula in Excel)

[TimBailey]

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

[RolandSchubert · Accepted 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