What a loan payment table shows you

A loan payment table is a month-by-month breakdown of what happens to your loan as you pay it down. Each row shows the payment you make, how much of that payment goes toward interest, how much goes toward principal (the actual loan amount), and what you still owe after that payment. The table lets you see exactly when your loan will be paid off and how much interest you will pay in total.

You do not need software or a calculator to build one. If you know three numbers—the loan amount, the interest rate, and the monthly payment—you can construct the entire table with basic arithmetic. The math is the same whether you are looking at a car loan, a personal loan, or a mortgage.

Key Takeaways

  • A payment table tracks principal, interest, and remaining balance for each payment period, starting from the original loan amount.
  • The monthly interest charge is calculated by multiplying the remaining balance by the monthly interest rate (annual rate divided by 12).
  • Each payment is split: interest comes first, and whatever is left over reduces the principal.
  • The table ends when the remaining balance reaches zero, which tells you the exact payoff date.
  • Building the table by hand takes time but shows you exactly how your money moves through the loan.

Gather the three numbers you need

Before you start, write down the loan amount (called the principal), the annual interest rate, and the monthly payment amount. For a $10,000 loan at 6% annual interest with a $200 monthly payment, you would write down those three figures.

If you do not have the monthly payment amount yet, you will need to calculate it first using the standard loan payment formula. That formula is: Payment = P × [r(1+r)^n] / [(1+r)^n − 1], where P is the principal, r is the monthly interest rate (annual rate divided by 12), and n is the number of months. Many lenders publish this number on your loan documents, so check there first before doing the calculation yourself.

Set up your table columns

Create five columns: Payment Number, Payment Amount, Interest Charged, Principal Paid, and Remaining Balance. Payment Number starts at 0 (before any payment) and counts up. Payment Amount stays the same every row (unless you have a variable-rate loan, which is different). The other three columns change with each row.

In row 0, put your original loan amount in the Remaining Balance column. Everything else in row 0 is zero. This is your starting point. Row 1 is your first payment.

Calculate interest and principal for each payment

Here is the core math that repeats every row. Take the Remaining Balance from the previous row and multiply it by your monthly interest rate. The monthly interest rate is your annual rate divided by 12. If your annual rate is 6%, your monthly rate is 0.06 ÷ 12 = 0.005.

For the first payment on a $10,000 loan at 6% annual interest: Remaining Balance is $10,000. Monthly interest rate is 0.005. Interest Charged = $10,000 × 0.005 = $50. Your payment is $200, so Principal Paid = $200 − $50 = $150. New Remaining Balance = $10,000 − $150 = $9,850.

In row 2, you start with $9,850. Interest Charged = $9,850 × 0.005 = $49.25. Principal Paid = $200 − $49.25 = $150.75. New Remaining Balance = $9,850 − $150.75 = $9,699.25. The pattern is identical every row: calculate interest on what you owe, subtract it from your payment, and the rest reduces what you owe.

Continue until the balance reaches zero

Keep repeating the calculation for each month. The interest charged gets smaller every row because the remaining balance shrinks. The principal paid gets slightly larger every row for the same reason. Eventually, the remaining balance will drop below your monthly payment amount.

When that happens, your final payment will be smaller than your regular payment. For example, if your remaining balance is $75 and your regular payment is $200, you only pay $75 plus whatever interest has accrued that month. After that payment, the remaining balance is zero and the loan is paid off. The row number where this happens is your payoff month.

What the finished table tells you

Once the table is complete, add up all the Interest Charged column. That is your total interest paid over the life of the loan. Add up all the Principal Paid column and it should equal your original loan amount (within a few cents due to rounding). The number of rows is the number of months until payoff.

The table also shows you what happens if you pay extra. If you paid $250 instead of $200 in month 1, the remaining balance would be lower, interest in month 2 would be smaller, and you would reach zero faster. You can use the table to model different payment amounts and see how they change your payoff date and total interest.

Common mistakes to watch for

The most frequent error is using the annual interest rate instead of the monthly rate. Always divide the annual rate by 12 before multiplying. Another mistake is rounding too early. Carry decimals through the calculation and round only at the end of each row, or you will accumulate small errors that throw off later rows.

A third mistake is forgetting that the final payment is usually different from all the others. Do not force the last payment to be the same amount as the rest. Calculate it based on what is actually owed, including that month's interest. If you try to make it match the regular payment, your remaining balance will not reach exactly zero.

Frequently Asked Questions

Do I have to build the table by hand or can I use a spreadsheet?

A spreadsheet is faster and less error-prone. You enter the formulas once and copy them down. But building it by hand teaches you how the loan actually works, which is why many people do it at least once. The math is identical either way.

What if my loan has a variable interest rate?

A variable rate changes over time, so your monthly interest rate changes. You cannot build the entire table at once because you do not know future rates. Build it month by month, updating the rate when it changes. This is one case where a spreadsheet that you update regularly is much more practical than a hand-built table.

Why is my final payment different from all the others?

Because the remaining balance in the final month is usually not a round number. If you owe $87.43 plus $0.44 in interest, your final payment is $87.87, not your regular $200. This is normal and expected.

Can I use this table to compare two different loans?

Yes. Build a table for each loan using the same number of months, then compare total interest paid and final payoff dates. This shows you the real cost of each loan, not just the advertised rate.