Comment by lloeki

> all of your expressions look like ($K4 - $S$1) rather than (principal - payment).

Numbers.app has the nice feature (among others) to use column/row headers to name cells/colums/rows in formulas in a readable manner.