38 Time-Value-of-Money and Amortization Worksheets
Example: Computing Payments and Generating an
Amortization Schedule
This example shows you how to use the TVM and Amortization
worksheets to calculate the monthly payments on a 30-year loan and
generate an amortization schedule for the first three years of the loan.
Computing Mortgage Payments
Calculate the monthly payment with a loan amount of $120,000 and
6.125% APR.
Answer: The computed monthly payment, or outflow, is $729.13.
Generating an Amortization Schedule
Generate an amortization schedule for the first three years of the loan. If
the first payment is in April, the first year has nine payment periods.
(Following years have 12 payment periods each.)
To Press Display
Set all variables to defaults. & } !
RST 0.00
Set payments per year to 12. & [ 12 !
P/Y=
12.00
Return to standard-calculator
mode.
& U
0.00
Enter number of payments
using payment multiplier.
30 & Z ,
N=
360.00
Enter interest rate.
6.125 -
I/Y=
6.13
Enter loan amount.
120000 .
PV=
120,000.00
Compute payment. % /
PMT=
-729.13
*
To Press Display
Select the Amortization worksheet. & \
P1= 0
Set beginning period to 1. 1 !
P1=
1.00
Set ending period to 9. # 9 !
P2=
9.00
Display 1st year amortization data. #
#
#
BAL=
PRN=
INT=
118,928.63
*
-1071.37*
-5,490.80*
Change beginning period to 10. #
10 !
P1=
10.00
Change ending period to 21. #
21 !
P2=
21.00
To Next Page
Loading...
Need help?
General
