Sharp EL738C EL-738 Operation Manual - Page 35

Calculating mortgage payments and generat, ing an amortization schedule - generator

Page 35 highlights

8. Press i to calculate the next period of the amortization schedule. 9. Repeat steps 5 to 7 above. • If you press @ during "AMRT P1" and "AMRT P2" entry, the values for the next period of payment will be automatically calculated and displayed. • To end amortization calculations, press s. Pressing s during entry will clear the value entered. 1 Calculating mortgage payments and generating an amortization schedule 1. Calculate the monthly payment of a 20-year loan with a loan amount of $90,000 and a 5.45% APR. Procedure Set all the variables to default values. Key operation . b Display 000 Make sure ordinary annuity is set (BGN is not displayed). Set TVM solver variables and calculate payment. . w 12 Q s 20 . < N 90000 v 0 T 5.45 f @ u Answer: The monthly payment is $616.56. PMT= -61656 Now generate an amortization schedule for the first 5 years of the loan. If the first payment is in August, the first year has 5 payment periods and the following years have 12 payment periods each. 2. Calculate the amortization schedule for the first year. Procedure Key operation Change to amortization * 1 Q calculation and enter 1 (August) for the starting payment. Enter 5 (December) for i 5 Q the ending payment. Display the remaining i balance. Display AMRT P1= 100 AMRT P2= 500 BALANCE= 8895148 34

  • 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

34
8.
Press
i
to calculate the next period of the amortization
schedule.
9.
Repeat steps 5 to 7 above.
• If you press
@
during “AMRT P1” and “AMRT P2” entry,
the values for the next period of payment will be automatically
calculated and displayed.
• To end amortization calculations, press
s
. Pressing
s
during entry will clear the value entered.
Calculating mortgage payments and generat-
ing an amortization schedule
1.
Calculate the monthly payment of a 20-year loan with a loan
amount of $90,000 and a 5.45% APR.
Procedure
Key operation
Display
Set all the variables to
default values.
.
b
000
Make sure ordinary annuity is set (
BGN
is not displayed).
Set TVM solver vari-
ables and calculate
payment.
.
w
12
Q
s
20
.
<
N
90000
v
0
T
5.45
f
@
u
PMT=
-61656
Answer:
The monthly payment is $616.56.
Now generate an amortization schedule for the first 5 years of the
loan. If the first payment is in August, the first year has 5 payment
periods and the following years have 12 payment periods each.
2.
Calculate the amortization schedule for the first year.
Procedure
Key operation
Display
Change to amortization
calculation and enter 1
(August) for the starting
payment.
*
1
Q
AMRT
P1=
100
Enter 5 (December) for
the ending payment.
i
5
Q
AMRT
P2=
500
Display the remaining
balance.
i
BALANCE=
8895148
1