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 , 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.