What a loan payment table shows you

A loan payment table breaks down each payment you make into two parts: the amount that goes toward interest and the amount that reduces what you actually owe (called principal). It shows you the remaining balance after each payment, so you can see exactly when the loan ends and how much interest you pay over the life of the loan.

Most lenders provide this table when you sign loan documents—it's called an amortization schedule. But if you want to build one yourself to verify the numbers or understand how different payment amounts would change your timeline, the math is straightforward and uses only four pieces of information: the loan amount, the interest rate, the payment amount, and how often you pay.

Key Takeaways

  • A payment table shows how much of each payment goes to interest versus principal, and what you owe after each payment.
  • You need four numbers to build one: the starting loan amount, the annual interest rate, your payment amount, and your payment frequency (monthly, weekly, etc.).
  • Interest is calculated on the remaining balance each period, so early payments are mostly interest and later payments are mostly principal.
  • You can build a payment table in a spreadsheet or use an online calculator, but understanding the formula helps you spot errors in what a lender gives you.

The four numbers you need

Loan amount is what you borrowed at the start. If you took out $10,000, that's your starting balance.

Annual interest rate is the percentage the lender charges per year. If your rate is 6% per year, you'll use 0.06 in the calculation. If you have a monthly payment, you divide the annual rate by 12 to get the monthly rate (0.06 ÷ 12 = 0.005).

Payment amount is what you pay each period. This stays the same for most loans (called a fixed-rate loan). If you don't know your payment amount yet, you can calculate it using a loan payment formula, but most lenders tell you this number upfront.

Payment frequency is how often you pay: weekly, biweekly, monthly, quarterly, or annually. Most personal loans and mortgages use monthly payments.

How to calculate interest and principal for each payment

The formula for each row of your table is the same. Start with the balance you owe at the beginning of that period.

Interest for this period = Beginning balance × Monthly interest rate. If you owe $10,000 and your monthly rate is 0.005 (which is 6% annual ÷ 12), the interest is $10,000 × 0.005 = $50.

Principal for this period = Your payment amount − Interest for this period. If you pay $200 and interest is $50, then $200 − $50 = $150 goes toward principal.

Ending balance = Beginning balance − Principal for this period. If you owed $10,000 and paid $150 toward principal, you now owe $10,000 − $150 = $9,850.

That ending balance becomes the beginning balance for the next row. You repeat this for every payment until the balance reaches zero.

Building a payment table in a spreadsheet

Open a spreadsheet (Excel, Google Sheets, or any free alternative) and set up six columns: Payment Number, Beginning Balance, Interest, Principal, Payment Amount, and Ending Balance.

In the first row, enter Payment 1. The beginning balance is your loan amount. Calculate interest (beginning balance × monthly rate), then principal (payment amount − interest), then ending balance (beginning balance − principal). The payment amount column just repeats your fixed payment.

In the second row, enter Payment 2. The beginning balance is now the ending balance from Payment 1. Copy the formulas down from row 1 and paste them into row 2. Then copy row 2 and paste it down as many times as you need—once for each payment in your loan term.

Stop when the ending balance reaches zero or goes negative. If it goes slightly negative (like −$2.50), your last payment is smaller than the others by that amount. This is normal and happens because of rounding.

What the table tells you about your loan

Look at the Interest column in your finished table. Early payments are almost all interest; later payments are almost all principal. This is why paying extra toward principal early in the loan saves you the most money—you stop that interest from compounding on a large balance.

Add up all the interest payments in your table. That's the total interest you'll pay over the life of the loan. Subtract your original loan amount from the total of all payments you make, and you get the same number. If you borrowed $10,000 and made payments totaling $12,500, you paid $2,500 in interest.

If you want to see how a larger payment would change your timeline, build a second table with a higher payment amount. The loan will end sooner, and you'll pay less total interest. This is how you can compare different payment strategies before committing to one.

Checking a lender's payment table against yours

When your lender gives you an amortization schedule, compare it to one you've built. The payment amounts should match exactly. The interest and principal columns should be very close—small differences (a few cents) come from rounding, but large differences mean something is wrong.

Check that the beginning balance in row 2 matches the ending balance in row 1. Check that interest is calculated on the correct balance. If the numbers don't line up, ask the lender to explain the difference. Sometimes lenders use daily interest calculations instead of monthly, which changes the numbers slightly.

If you're paying biweekly or weekly instead of monthly, the math is the same—just divide the annual rate by 26 (for biweekly) or 52 (for weekly) instead of 12. The lender's table should reflect your actual payment schedule.

When a payment table changes

If your loan has a variable interest rate, the payment table changes when the rate changes. The lender will give you a new schedule showing the new interest amount and how many payments remain. Your payment amount might also change.

If you make an extra payment toward principal, the next row of your table shifts—the beginning balance is lower, so interest is lower, and the loan ends sooner. Some lenders let you recalculate your schedule online; others require you to ask for a new one.

If you refinance (pay off the old loan with a new one), you're starting a completely new table with a new loan amount, rate, and term.

Frequently Asked Questions

What if my payment amount is different every month?

If you have a variable-rate loan or a graduated payment plan, the payment amount changes according to your loan agreement. Build your table the same way, but enter the actual payment amount for each row instead of copying the same number down. Interest still calculates on the remaining balance.

Why does my last payment look different from the others?

The last payment is often smaller because of rounding. If your calculation shows an ending balance of −$3.47, your final payment is $3.47 less than the regular amount. This is normal and expected. Some lenders roll the difference into the second-to-last payment instead.

Can I use this to figure out how much faster I'd pay off the loan if I paid extra?

Yes. Build a second table using a higher payment amount. The loan will end sooner, and you'll see exactly how many payments you save and how much interest you avoid. This is useful for comparing whether it makes sense to pay extra each month.

What if the lender's table doesn't match mine?

Check that you're using the correct interest rate (some lenders quote annual rates, others quote monthly rates). Verify the payment frequency—daily interest calculations produce different numbers than monthly ones. If you still can't match it, contact the lender and ask them to explain their calculation method.

Do I need to build a payment table if the lender already gave me one?

No, but building one yourself helps you understand how your loan works and lets you test what-if scenarios (like paying extra or refinancing). It's also a way to verify the lender's numbers are correct.