calculator

BA II Plus: Amortization Schedule Step by Step

Use the BA II Plus amortization worksheet to split loan payments into interest and principal.

TL;DR

After solving the loan payment with TVM, use the AMORT worksheet to identify beginning balance, principal paid, interest paid, and ending balance over a selected payment range.

Formula Reference

Interest component

Interest = beginning balance x periodic rate

Principal repayment equals payment minus interest.

BA II Plus Keystrokes

  1. Solve the loan payment in TVM first
  2. Press 2nd AMORT
  3. Set P1 to the first payment number
  4. Set P2 to the ending payment number
  5. Scroll to BAL, PRN, and INT
  6. Press 2nd CLR TVM before the next unrelated loan

Worked Example

  • Problem: $10,000 loan, 5 percent, 3 annual payments.
  • Solve PMT, then use AMORT with P1 = 1 and P2 = 1.
  • The worksheet shows the interest and principal portions for payment 1.

Common Mistakes

  • Opening AMORT before solving PMT.
  • Using the wrong payment range.
  • Confusing cumulative principal with ending balance.

Related Guides