Mortgage

Also known as · Spitzer Loan

The equal-payment (annuity or Spitzer) Loan: the total payment is constant every period, so early payments are mostly interest and the principal share grows over time. The level payment is E=rL1−(1+r)−nE=\frac{rL}{1-(1+r)^{-n}}, or PMT(r,n,-L) in Excel.

When to use

Expect to compute the level payment, split one instalment with IPMT/PPMT, or find the Outstanding Balance as the PV of the remaining payments.

See Lesson 05.

Appears in