How to Calculate a Loan Amortization Schedule: Formulas & Step-by-Step Guide (2026)

# How to Calculate a Loan Amortization Schedule: Formulas, Mechanics & Strategies

Whether you are financing a commercial property, taking out a residential mortgage, or managing corporate debt, understanding your **loan amortization schedule** is essential to minimizing total interest expenses.

A loan amortization schedule is a complete chronological table detailing each periodic payment over the lifetime of a fixed-rate loan. In the early stages of any term loan, the overwhelming majority of each payment goes directly toward interest. Over time, that ratio gradually flips until payments primarily retire the principal balance.

In this in-depth guide, we will unpack the exact amortization formula, show you how to calculate each row manually, and demonstrate how extra principal payments dramatically shorten loan lifespans using our client-side [loan calculator](/calculators/loan).

---

1. The Standard Loan Amortization Formula

For any fixed-rate amortizing debt, the fixed monthly payment ($M$) is calculated using the standard annuity formula:

$$M = P \left[ \frac{r(1 + r)^n}{(1 + r)^n - 1} \right]$$

Variable Definitions: - **$M$**: Periodic monthly payment. - **$P$**: Principal balance (initial loan amount borrowed). - **$r$**: Periodic interest rate (Annual Percentage Rate divided by 12 months, expressed as a decimal). - **$n$**: Total number of payments (loan term in years $\times$ 12).

---

2. Step-by-Step Calculation Example

Let's run through a realistic financing scenario: - **Principal ($P$)**: \$300,000 - **Annual Interest Rate**: 6.0% (Annual $APR$) - **Loan Term**: 30 Years (360 monthly payments)

Step 1: Determine Periodic Interest Rate ($r$) $$r = \frac{0.06}{12} = 0.005 \text{ (0.5\% per month)}$$

Step 2: Determine Total Number of Payments ($n$) $$n = 30 \times 12 = 360$$

Step 3: Compute the Fixed Monthly Payment ($M$) $$M = 300,000 \times \left[ \frac{0.005(1 + 0.005)^{360}}{(1 + 0.005)^{360} - 1} \right]$$

$$(1.005)^{360} \approx 6.022575$$

$$M = 300,000 \times \left[ \frac{0.005 \times 6.022575}{6.022575 - 1} \right] = 300,000 \times \left[ \frac{0.030113}{5.022575} \right] \approx \$1,798.65$$

Your total fixed monthly principal and interest payment is **\$1,798.65**.

---

3. Dissecting an Amortization Schedule Row-by-Row

Once the fixed monthly payment ($M$) is locked in, each individual month's payment is split between **Interest** and **Principal Reduction**:

1. **Monthly Interest Due**: $$\text{Interest}_t = \text{Remaining Balance}_{t-1} \times r$$ 2. **Monthly Principal Reduction**: $$\text{Principal}_t = M - \text{Interest}_t$$ 3. **New Ending Balance**: $$\text{Ending Balance}_t = \text{Remaining Balance}_{t-1} - \text{Principal}_t$$

Amortization Schedule Breakdown (First 3 Months vs. Year 25)

| Payment # | Starting Balance | Payment ($M$) | Interest Paid | Principal Paid | Ending Balance | | :--- | :--- | :--- | :--- | :--- | :--- | | **Month 1** | \$300,000.00 | \$1,798.65 | \$1,500.00 (83.4%) | \$298.65 (16.6%) | \$299,701.35 | | **Month 2** | \$299,701.35 | \$1,798.65 | \$1,498.51 (83.3%) | \$300.14 (16.7%) | \$299,401.21 | | **Month 3** | \$299,401.21 | \$1,798.65 | \$1,497.01 (83.2%) | \$301.64 (16.8%) | \$299,099.57 | | **Month 300 (Yr 25)** | \$88,412.30 | \$1,798.65 | \$442.06 (24.6%) | \$1,356.59 (75.4%) | \$87,055.71 | | **Month 360 (Yr 30)** | \$1,789.70 | \$1,798.65 | \$8.95 (0.5%) | \$1,789.70 (99.5%) | **\$0.00** |

Notice that in Month 1, **\$1,500.00** of your \$1,798.65 payment goes purely to interest! Only \$298.65 actually pays down your debt.

---

4. The Wealth Multiplier: Making Extra Principal Payments

Because interest is calculated directly against the remaining unpaid balance, **every extra dollar applied directly to principal stops generating interest compounding permanently**.

What happens if you add an extra \$200/month? - **Base 30-Year Loan:** Total interest paid = **\$347,514.57** (Loan term: 360 months). - **With \$200/month Extra Principal:** - Total interest paid = **\$263,410.12** - **Net Interest Saved**: **\$84,104.45** - **Loan Payoff Time**: Shortened by **6.2 years** (74 months)!

**Strategic Tip:** When making additional debt payments, always explicitly instruct your loan servicer that the additional funds should be applied as a **Principal-Only Curtailment**, rather than held as a prepay reserve for the upcoming month.

---

5. Summary & Interactive Simulation

To plan your exact amortization schedule with custom payoff dates, tax deductions, or accelerated lump-sum payments, use our instant, client-side [loan calculator](/calculators/loan) or [mortgage calculator](/calculators/mortgage). None of your financial figures or loan balances leave your browser.