Description

This free Google Sheets mortgage tracker lets you build a complete amortization schedule for any fixed-rate mortgage. Enter your loan amount, interest rate, and loan term to calculate your monthly payment, interest paid, principal paid, and remaining balance for each period. The spreadsheet also supports extra principal prepayments, so you can see how additional payments affect your amortization schedule over time. Pair it with the step-by-step YouTube tutorial for a full walkthrough of how each formula works.