Hi community, I’m trying to build an amortization / repayment schedule in Bubble.io for a finance app idea I have. I’m struggling with two things:
- How I should set up my database to intake and compute the values? Should I use one or multiple tables?
- Intake example: Debt amount, APR, debt duration
- Output example: End balance, principle, interest (all by month)
- How to perform complex calculations for a time range (based on the debt duration… will change every time). I’ve downloaded the mathjs plug-in but don’t know how to use it. I’m open to other ideas.
Would love insights from you all! Please send over links, examples, or other helpful posts that have answered this previously.
Thanks in advance for the help.