Loan Amortization Tracker (Excel)

Track any fixed-rate loan — mortgage, auto, personal — month by month. Enter three numbers and the sheet builds a complete amortization schedule up to 480 months, computing your payment with the same PMT formula banks use.

n

What’s Inside

n

• Inputs for loan amount, rate and term — payment computed automatically
• Full schedule: payment, interest, principal and balance for every month
• Extra Payment column: add any amount in any month and watch the schedule shorten in real time
• Total interest summary that updates as you experiment

n

How to Use It

n

Fill the three yellow input cells. To model early payoff, type extra amounts into the blue Extra Payment column — the balance recalculates and the schedule simply ends sooner. Compare scenarios first with the Loan Payment Calculator or the Mortgage Payment Calculator, then track your real loan here.