Loan Amortization Schedule Calculator

Build a complete amortization schedule with extras, multiple payment frequencies, optional escrow & PMI, CSV export, and print-friendly output. Accurate, accessible, and fast for professional use.

%
Payment frequency *

Extra payments (optional)

$
$

Escrow & PMI (optional)

$
$
$

PMI applies until LTV ≤ 80% (when balance ≤ 80% of home value). We compute PMI each period from the current balance and allocate it to the all-in payment.

Results

Periodic payment

—

# Payments

—

Total interest

—

Total paid (loan)

—

Payoff date

—

All-in payment*

—

* All-in includes escrow (tax + insurance) and PMI while applicable.

Each row shows how your payment is split across interest and principal, extras, PMI/escrow, and the remaining balance.
# Date Payment Interest Principal Extra PMI Escrow All-in Balance
Page — of —

Data Source and Methodology

Authoritative reference: OpenStax, “Algebra and Trigonometry,” Section 3.7 Financial Formulas (Amortization), 2016 — and standard finance texts on fixed-rate amortization. These sources ground the formulas and definitions used here.

Modeling notes: Payments follow a fixed-rate amortization with period rate \( r = \frac{\text{APR}}{m} \) where \( m \) is payments per year (12, 26, or 52). Extras shorten the term unless your lender recasts. Escrow (tax + insurance) and PMI are added to show an “all-in” outflow; the core schedule remains P&I.

The Formula Explained

Payment: \( P = \dfrac{L\,r}{1 - (1+r)^{-n}} \), where \( L \) is principal, \( r \) the period rate, and \( n \) total periods.
Per period \(k\): \( \text{Interest}_k = B_{k-1}\,r \), \( \text{Principal}_k = P - \text{Interest}_k \), \( B_k = B_{k-1} - \text{Principal}_k - \text{Extra}_k \).
Zero-rate case: \( P = \dfrac{L}{n} \), \( \text{Interest}_k = 0 \).

Frequently Asked Questions (FAQ)

Do extra payments change my required payment?

No. Required payment stays fixed; extras reduce term and total interest. Some lenders offer optional recast programs—check your agreement.

How does PMI end?

PMI is applied each period until LTV ≤ 80% (balance ≤ 80% of home value). The tool removes PMI automatically once the condition is met.

Why might my lender’s numbers differ?

Daily interest accrual, posting dates, rounding, and fees can create small differences versus this idealized monthly model.

Tool developed by Ugo Candido. Finance accuracy reviewed by the CalcDomain Editorial Board.
Last accuracy review: