Create a mortgage payment schedule

I am trying to make a mortgage paydown calculator and need to create a payment schedule based on the number of years left in the mortgage. So if number of years remaining is say, 22, there will be 22 rows with each row showing principal & interest payments + remaining amount.

This number of rows is variable, since it depends on how many years are remaining on mortgage and this varies for each user.

How can I do this in Bubble? I can obviously do calculations in each row for principal, interest and remaining amount. But how do I repeat this calculation X times, where X is number of remaining years?

Hey there, did you ever figure this out?


Hopefully someone can still answer this question, since I’m looking for a certain solution as well.