Apple iWork '09 - Manual (Page 354)

The Completed Amortization Table
To complete the table, it would be necessary to select cells A10:A11 and extend the selection down to
A32 to include all 24 periods in the hypothetical loan. Then C9:F9 would be selected and extended to
C32:F32 to complete the formulas. Here is the complete table, showing the entire amortization using
the formulas shown in the previous table.
Final Comments
Note that the values returned by IPMT (column C) and PPMT (column D) do add up each month to
the PMT calculated in cell B6 (as shown in column F). Also note that the final principal remaining, as
shown in cell E32, is $30,000, as specified for balloon in cell B4.
354 Chapter 13 Additional Examples and Topics