calculate-loan

01 Loan payments

Amortization Schedule by Hand: Formula and Example

Calculator No. 01-20769 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An amortization schedule by hand is a month-by-month table showing how each fixed loan payment is split between interest and principal, and how the balance falls. Enter the loan amount, annual interest rate, and term below to calculate the monthly payment and total interest; the example and formula show how to build the schedule yourself.

Formula

For a fixed-rate loan with monthly payments, calculate the payment using:

M = P × r ÷ [1 − (1 + r)−n]

  • P is the starting principal, in dollars.
  • APR is the annual interest rate entered as a percentage.
  • r is the monthly rate as a decimal: APR ÷ 1200.
  • n is the number of monthly payments: loan term in years × 12.
  • M is the fixed monthly payment, in dollars.

The calculator applies the formula to the supplied APR and term. In a hand-built schedule, round the calculated payment to cents, then work through one payment period at a time. For month k, calculate interest as the opening balance multiplied by r; subtract that interest from the payment to find principal repaid; then subtract principal repaid from the opening balance.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a 5-year term:

  1. Monthly rate: 8 ÷ 1200 = 0.0066667, or about 0.66667%.
  2. Number of payments: 5 × 12 = 60.
  3. Payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53, rounded to cents.
  4. Total of scheduled payments: $405.53 × 60 = $24,331.80.
  5. Total interest under this rounded-payment estimate: $24,331.80 − $20,000 = $4,331.80.

For the first schedule row, the opening balance is $20,000.00. Interest is $20,000 × 0.0066667, or $133.33 when rounded to cents. Principal repaid is $405.53 − $133.33 = $272.20, leaving a closing balance of $19,727.80. That closing balance becomes the next month’s opening balance.

Assumptions

  • The interest rate stays fixed for the full modeled term.
  • Payments are level monthly payments made at the end of each monthly period.
  • Interest is calculated monthly at APR ÷ 12; the APR is treated as a nominal annual rate.
  • The calculation excludes fees, taxes, insurance, PMI, and escrow because they are not inputs.

Build the Schedule Row by Row

Once the monthly payment is known, set up columns for payment number, opening balance, payment, interest, principal, and closing balance. The opening balance in the first row is the original loan principal. For every later row, carry forward the previous row’s closing balance. A spreadsheet can do the arithmetic, but the same process works with a calculator and paper.

  1. Multiply the opening balance by the monthly rate to find that month’s interest.
  2. Subtract the interest from the scheduled payment to get the principal portion.
  3. Subtract the principal portion from the opening balance to find the closing balance.
  4. Repeat for each month, carrying forward the balance and rounding consistently.

In the example’s second month, interest is approximately $19,727.80 × 0.0066667 = $131.52. The principal portion is $405.53 − $131.52 = $274.01, leaving about $19,453.79. Because the balance is lower, the next month’s interest is lower too. With an unchanged payment, a larger share of each later payment generally goes to principal.

Reading the Results and Rounding

The monthly payment is the scheduled amount under the stated assumptions, not necessarily the full amount due on a real loan statement. Total interest is calculated here as rounded monthly payment multiplied by the number of payments, minus principal. The schedule’s final row should bring the balance close to zero, but repeated cent-level rounding can leave a small residual. Lenders may adjust the final payment or use more precise calculations, so a hand-built table may differ slightly from an official statement.

For a schedule, retain cents in each row and use the rounded interest and principal values consistently. Avoid rounding the monthly rate to a whole percentage or dividing the APR by 100 without then dividing by 12: 8% APR corresponds to a monthly decimal rate of 0.08 ÷ 12, not 8 ÷ 12. If the loan has a variable rate, changing payment, extra payments, or a different payment frequency, this fixed-payment schedule will not represent those terms without recalculation.

When This Method Applies—and Its Limits

This method describes a standard fully amortizing loan with equal monthly payments, a fixed rate, and interest accruing on the outstanding balance. “Fully amortizing” means the scheduled payments are designed to repay principal and interest over the stated term. It is useful for understanding why early payments contain proportionally more interest and for checking the arithmetic behind a simple payment estimate.

It is not a complete model for every borrowing arrangement. A loan may include an initial interest-only period, a balloon balance, fees added to the amount financed, irregular payment dates, daily interest, a changing rate, or other contractual details. A quoted APR may also reflect items that are not represented by this simple monthly-rate formula. Use the actual payment amount, rate, balance, and schedule supplied in the loan documents when checking a specific account.

Common Questions About Hand Calculations

Frequently Asked Questions

How do I calculate the interest portion of a payment?
Multiply the balance at the start of that payment period by the monthly interest rate. For a fixed APR with monthly periods, the rate as a decimal is APR ÷ 1200.

Why does the principal portion increase over time?
When the balance declines, interest calculated on that balance also declines. If the total payment stays fixed, the amount left after interest is deducted increases the principal portion.

Does an amortization schedule include taxes and insurance?
Not in this calculation. It models principal and interest only; taxes, insurance, PMI, escrow, and loan fees require separate inputs or figures.

Why might my hand-calculated balance differ from a statement?
Differences can result from rounding, payment dates, daily rather than monthly interest, fees, extra payments, or terms that differ from the fixed-rate assumptions. The lender’s account schedule uses the loan’s actual terms and transaction history.

Can I use this method when I make extra payments?
Yes, as a manual extension: include the extra amount in the payment for the month, apply interest first, and subtract the remainder from principal. Recalculate subsequent balances, and follow the loan’s stated treatment of extra payments.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →