Market Data
Calculators/Amortization Schedule Calculator
Financing

Amortization Schedule Calculator

Build a complete amortization schedule to track principal, interest, and remaining balance over time.

$

Total loan amount

%

Annual interest rate

yrs

Years to repay the loan

Download Excel Version
Use this calculator offline in Excel with full formulas
.XLSX
Formula
M = P[r(1+r)^n] / [(1+r)^n - 1]
Pro Tips
1.The schedule splits each payment into interest and principal from the rate, term, and amount you enter.
2.A term shorter than the amortization leaves unpaid principal at the end.
Related Calculators
Loan Payment Calculator→DSCR Calculator→LTV Calculator→
ScoreOM