Texas Instruments BA-20 Profit Manager User Manual - Page 42

Example: Computing Payments and Generating an Amortization Schedule, Computing Mortgage Payments

Get Texas Instruments BA-20 Profit Manager PDF manuals and user guides View all Texas Instruments BA-20 Profit Manager manuals
Add to My Manuals
Save this manual to your list of manuals

Page 42 highlights

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. To Press Set all variables to defaults. & } ! Set payments per year to 12. & [ 12 ! Return to standard-calculator & U mode. Enter number of payments using payment multiplier. 30 & Z , Enter interest rate. 6.125 - Enter loan amount. 120000 . Compute payment. % / RST P/Y= Display 0.00 12.00 0.00 N= 360.00 I/Y= 6.13 PV= 120,000.00 PMT= -729.13* 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 Select the Amortization worksheet. Set beginning period to 1. Set ending period to 9. Display 1st year amortization data. Change beginning period to 10. Change ending period to 21. Press Display & \ P1= 0 1 ! P1= 1.00 # 9 ! P2= 9.00 # BAL= 118,928.63* # PRN= -1071.37* # INT= -5,490.80* # 10 ! P1= 10.00 # 21 ! P2= 21.00 38 Time-Value-of-Money and Amortization Worksheets

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
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