If you are looking for a quick and easy way to create a loan payment schedule, I found this easy to use (and free) excel loan amortization spreadsheet.
Simply input the loan amount, start date, interest rate, term and payment frequency. It’s easy to see how adding a little extra to each month’s payment impacts the end balance and time to payoff.
I use the spreadsheet for personal loans and consumer loans. Plug-in your car loan or mortgage and start paying off your debt.
Download the spreadsheet for excel.