Spreadsheet

Interactive loan amortization spreadsheet

Quick Parameters

Modify these values to automatically update the corresponding cells in the sheet.

%
📅
Key Metrics
Total Paid: -
Total Interest: -
Estimated Monthly: -
-
fx
Cell Functions: =SUM(Range) =ROUND(Value, Decimals) =PMT(Rate, Nper, PV) *Press F2 or double-click to edit cell. Use Arrow keys to navigate.

Dynamic Amortization Chart

Interactive visualization of Remaining Balance and accumulated amortization over time.

Remaining Balance
Accumulated Amortization