Amortization

The table that splits each loan payment into interest and principal and tracks the balance period by period. Interest is always rr times the current balance, and what separates the four Loan types is how the principal is scheduled.

When to use

Use it whenever a question asks for the interest or principal in a given payment, or the Outstanding Balance after some years. Excel PMT, IPMT and PPMT build the schedule for an equal-payment Mortgage.

See Lesson 05.

Appears in