In Excel: compute the payment with =PMT(rate/12, years*12, -amount), then split each month into interest (=balance*rate/12) and principal (=payment-interest).
On this page7
Calculate the level payment with =PMT(rate/12, years*12, -amount).
In the first schedule row, interest = opening balance × rate/12.
Principal = payment − interest; new balance = opening balance − principal.
Copy the row down for every month; the balance should reach zero on the final payment.
What this does
An amortization schedule shows where every payment goes: early on, most of it is interest and little touches the balance; over time the split flips and principal dominates. Seeing that crossover is what makes the schedule useful — it explains why overpaying early saves so much more interest than overpaying late. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “excel credit card payoff spreadsheet”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected sheet change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
On a €250,000 loan at 3.8% over 25 years, the payment is about €1,292. In month one, interest is 250000×3.8%/12 ≈ €792 and only ≈€500 reduces the balance. By the final year almost the entire payment is principal. The yearly table above aggregates all 300 months so you can read the principal/interest split at a glance. Use this fixed-payment schedule to compare constant-rate loan offers and read the yearly principal, interest and balance. Fees, variable rates and extra payments need a separately extended model. It is the difference between knowing your monthly payment and understanding the assumptions behind your loan schedule. Check the referenced cells, argument order and result type in your workbook. Start with the worked example before changing an input, then compare the changed result with the calculation you expected. An error value or a result of a different type is a reason to inspect the inputs and arguments.
In Google Sheets
Google Sheets support for this task has not been verified. Check the function, arguments and workflow in the target product before transferring the example. Matching formula notation does not establish identical behaviour. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. For “excel credit card payoff spreadsheet”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.
Common mistakes
- Letting rounding leave a tiny non-zero balance at the end — adjust the last payment to clear it.
- Applying the annual rate per month instead of rate/12.
- Forgetting that extra principal payments change every subsequent interest row.
- Building 360 rows by hand instead of copying one correct formula row down.
Frequently asked questions
Why is so much early payment interest?
Interest is charged on the outstanding balance, which is largest at the start. As the balance falls, the interest portion shrinks and principal grows.
Can this calculator model overpayments?
This calculator assumes equal monthly payments at a constant rate and has no extra-payment input. To compare overpayments, extend your worksheet schedule with the additional principal and recalculate the remaining balance and later interest.
Can I build this in Google Sheets?
Yes — PMT and the row formulas are identical in Google Sheets, so the same schedule works without any changes.
Other ways people ask this
On the way here you may have searched this as “credit card payoff excel formula”, “excel spreadsheet credit card payoff” and “excel formula for credit card payoff” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “credit card payoff excel formula”, “excel spreadsheet credit card payoff”, “excel formula for credit card payoff” all point at the one operation explained on this page, which is why they all lead here.