blog home

# GP6 - Amortization Tables (PMT) in Microsoft Excel

Most K201 students find the unit on amortization tables to be pretty easy. Once you've done one, you've done them all! Nevertheless, today we present two different problems that involve using the PMT formula to construct an amortization table (if you're curious as to how the PMT formula actually works, see this article for an explanation of how to derive and solve the geometric series for amortizing loans.)