Ok, when I search google, I find a ton of spreadsheets. But, none seem to do exactly what I'm looking for. I have different loans. I have the start date, the APR, the monthly payment I'm making. It seems like from that, it should be able to calculate how much of payment for month 1 is principal and interest and same for the following months until it's 0.
But, all the spreadsheets I've found are asking for more information. They're wanting to know the loan term such as 5 years or whatever. How does that affect anything? It's not like, if it hits 5 years and there's still a balance they'll write it off. I get most of the time, when you take out a loan, it's for a certain period. They guarantee if you pay X it will be paid off in Y. But, I had some financial problems a few years ago so those numbers are way off. So, it would be nice to just put in the start amount, the start date, how much paying a month, what the apr is and have it show me every month how much is going towards principal and interest.
