Hiiii. I'm in need of a debt amortization template, but I'd like it to support irregular payments and simple interest. Everything I find online assumes there's compound interest and a term. I'm lost with: what will the remaining principal (column C) & remaining interest (column D) formulas be? I assume the simple interest for D3 would be like: =C2*(G5*(DAYS(A3, A2))) Remaining principal, C3: oh my god how. Do I subtract B3 from C3 only if the formula detects D2 is less than or equal to 0 I'm in over my head with the necessary conventions and formatting. Am I even on the right track to get useful data from this?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Simple-interest debt tracker, w/o terms/monthlies

Thread starter pitriDish
Start date Sep 4, 2024

pitriDish

New Member

Sep 4, 2024

Hiiii.

I'm in need of a debt amortization template, but I'd like it to support irregular payments and simple interest. Everything I find online assumes there's compound interest and a term.

I'm lost with:

what will the remaining principal (column C) & remaining interest (column D) formulas be?
- I assume the simple interest for D3 would be like: =C2*(G5*(DAYS(A3, A2)))
- Remaining principal, C3: oh my god how. Do I subtract B3 from C3 only if the formula detects D2 is less than or equal to 0

I'm in over my head with the necessary conventions and formatting. Am I even on the right track to get useful data from this?