How to create a payment payment projection in Zoho Creator?

How to create a payment payment projection in Zoho Creator?

Hey there! I'm new to Zoho Creator. I want to create an app that lets me register loans. That way, when I enter some information like the amount loaned, interest rate and time, it will create a table containing the amount to be paid by the user, for example every month.

For example:

Interest rate: 10%
Time: 12 months
Amount: $ 1200

Payment table:

1. Month 1: loan principal -> $ 100, Interest-> $ 10
2. Month 2: loan principal -> $ 100, Interest-> $ 10
3. Month 3: loan principal -> $ 100, Interest-> $ 10

And so on. How can I create this payment table? what tools are there available in Zoho Projects for that?