20061001
7-5 Amortization
This calculator can be used to calculate the principal and interest portion of a monthly
installment, the remaining principal, and amount of principal and interest repaid up to any
point.
u Formula
a: interest portion of installment PM1 (INT)
b: principal portion of installment PM1 (PRN)
c: balance of principal after installment PM2 (BAL)
d: total principal from installment PM1 to payment of installment PM2 (ΣPRN)
e: total interest from installment PM1 to payment of installment PM2 (ΣINT )
*a + b = one repayment (PMT )
c
a
b
1 payment
Number of Payments
1 PM1 PM2 Last.............. ..................... ............
c
a
b
1 payment
Number of Payments
1 PM1 PM2 Last.............. ..................... ............
1 payment
Number of Payments
1 PM1
PM2
Last............... ..................
...............
d
e
1 payment
Number of Payments
1 PM1
PM2
Last............... ..................
...............
d
e
7-5-1
Amortization
20070101