Smart Loan Payment Schedule (Data Science)

Solution Description:

Quick-to-implement end-to-end analytics on Loan Payment Schedule for Banks. Amortization is the process of spreading out a loan into a series of fixed payments. The loan is paid off at the end of the payment schedule.


  • Alteryx’ s analytics provide complete visibility of the loan payment schedule and lets you estimate your monthly loan repayments. It also determines out how much of your repayments will go towards the principal and how much will go towards interest. Simply input your loan amount, interest rate, loan term and repayment start date then click “Calculate“.
  • Alteryx workflows are highly iterative and self-documenting and can easily be re-run with new data/new values entered manually, adjusted with new fields and business rules, and automated on a schedule.

Sample output