User Manual

2: TVM and Amortization Worksheets 55
Example: Loan Amortization
(continued from previous example)
Use the Amortization worksheet to generate an amortization
schedule for the first three years of the loan. Assume that the
first payment is in April; therefore, the first year has 9 payment
periods. There are 12 payment periods per year thereafter.
Procedure Keystrokes Display
Select the Amortization
worksheet.
& \
P1= 1.00
Set ending period to 9.
#
9
!
P2= 9.00

Display first year amortization
data.
#
#
#
BAL=
PRN=
INT=
119,407.46

-592.54

-8,194.70

Change beginning period to 10.
#
10
!
P1= 10.00

Change ending period to 21.
#
21
!
P2= 21.00

Display second year
amortization data.
#
#
#
BAL=
PRN=
INT=
118,551.85

-855.61

-10,860.71

Move to
P1
and press
%
to
enter next range of payments.
#
%
P1= 22.00

Display
P2
.
#
P2= 33.00

Display third year
amortization data.
#
#
#
BAL=
PRN=
INT=
117,614.86

-936.99

-10,779.33

Note that the principal and interest are displayed as negative
because they are outflows.