BA II Plus: the amortisation worksheet
Outstanding balance, interest paid and principal repaid over any range of payments, without building a schedule by hand.
4 min read
Set the loan up in TVM first
The AMORT worksheet reads whatever is in the TVM registers, so the loan must be solved there first. For a 250,000 loan over 20 years at 5.5%: 20 N, 5.5 I/Y, 250000 PV, 0 FV, CPT PMT gives −20,919.83.
Reading one payment or a range
2ND · AMORT prompts for P1 and P2, the first and last payment numbers of the range you care about. Setting both to 8 gives the eighth payment alone; setting P1 = 1 and P2 = 8 gives the cumulative figures for the first eight.
| Keys | Effect |
|---|---|
| 2ND · AMORT | Open the worksheet. |
| 8 · ENTER · ↓ · 8 · ENTER · ↓ | P1 = P2 = 8: just the eighth payment. |
| ↓ | BAL = 180,297.95, the balance immediately after payment 8. |
| ↓ | PRN = 10,429.80, the principal repaid by payment 8. |
| ↓ | INT = 10,490.03, the interest portion of payment 8. |
The check that catches setup errors
PRN + INT must equal the payment, every time. If it does not, the TVM registers do not describe the loan you think they do — usually because FV was left non-zero from a previous question.