Loan Interest and Repayment Calculator
Shows relationship between principal and interest
Start new thread

Loan Interest and Repayment Calculator - Shows relationship between principal and interest

by•
Free loan calculator showing interest vs principal repayments. See your full amortisation schedule, total interest paid, and explore what-if scenarios with extra repayments.Built to show non finance literate people how the relationship works over time with repayments, how you can change your loan life by adding repayments.

Add a comment

Replies

Best
Maker
📌
I was building a simple PMT function in excel to show someone how to work out interest over time, when I realised it wasn't that simple if you were not from a finance background. Instead of trying to explain the different elements of an excel function and then how to use this to calculate interest and principal, I thought I'd build a straight forward app that would require minimal technical background or skill to input loan details, put also show your monthly repayment over time both graphically, and in a table where you could see the changes over time. Adding in a what-if scenario made sense as things change over time. Interested to know if you find this helpful.

honestly this looks really useful for people who get confused by loan math. one thing that would help a lot is letting users save or share their scenarios with a simple link, so you can show your partner or compare two loan options side by side without retyping all the numbers.

Maker

 Thanks for the feedback, really appreciated, will see what is involved here. Once you start saving data linked to a user privacy issues start creeping in!