Amortization

Excel 365: Build a Loan Amortization Schedule in One Formula (No Helper Columns)

Most amortization tables are a fragile ladder of copy-down formulas that shatter the moment you insert a row. Here's the classic PMT/IPMT/PPMT build, and the Excel 365 dynamic-array version that spills the whole schedule from a single cell — plus a free workbook.