How the schedule is built
Monthly interest
Remaining balance × yearly rate ÷ 12, rounded to the cent.
Principal
Payment minus that month’s interest, which is why early payments are mostly interest.
Last payment
Adjusted by a few cents so the balance ends at exactly zero and the totals match.
Make the most of it
Extra payments: 300,000 at 6% over 20 years costs 2,149.29 a month. Add an extra monthly payment to see the months and interest you save.
Payment dates: Pick the first payment month to label every row and see the payoff date.
Excel: Download the schedule as CSV and open it in Excel or Google Sheets.
Flat rate: With a flat rate the profit is shown spread evenly over the payments; how a lender credits profit on early payoff may differ.
FAQ
Why is most of the payment interest at first?
Interest is charged on the balance, which is largest at the start. Each payment lowers the balance, so the interest falls and more goes to principal.
Do extra payments save interest?
On a reducing balance, yes, because interest is charged on what is left. With a flat rate it depends on your contract.
Will it match my bank’s schedule?
Very closely, but banks may count the actual days in each month or add fees, so cents can differ.
