Building a Loan Amortization Schedule in Google Sheets
How to build a full month-by-month amortization schedule in Sheets using PMT, IPMT, and PPMT, plus a running balance that hits exactly zero at term end.
Loans
Sheet
Updated
How to build a full month-by-month amortization schedule in Sheets using PMT, IPMT, and PPMT, plus a running balance that hits exactly zero at term end.