HP 30b HP 20b Business Consultant and HP 30b Business Professional User's Guid - Page 39

Creating an Amortization Schedule

Page 39 highlights

Creating an Amortization Schedule You borrow 140,000.00 for 360 months at 10% interest. Create an amortization schedule for the loan. How much interest did you pay for the first year? What is the balance of your loan after the first year? See Table 3-4. The example below is calculated with Chain set as the operating mode, but it can be performed in RPN, Chain, or Algebraic. Table 3-4 Amortization Example Keys Display 12:[ Description Inputs 12 as the number of payments per year. This value is 12 by default, but it maintains its current entered value when TVM Reset is used. 30:^ Inputs 360 (30 times 12 payments per year) as the number of payments for the 30-year loan. 10Y Inputs 10 as the interest rate percentage per year. 1400 00V 0F M Inputs the value of the loan at the time of the first payment. Inputs 0 as the future value of the loan (zero balance). Calculates the monthly payment. A < < < Displays the number of periods to group together in the amortization schedule. Default is the current value of P/YR. Displays the first period of the group of periods to amortize. Displays the current balance remaining after the first year. Displays the current amount of the principal applied towards the loan for the first year. Time Value of Money 31

  • 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

Time Value of Money
31
Creating an Amortization Schedule
You borrow 140,000.00 for 360 months at 10% interest. Create an amortization schedule for
the loan. How much interest did you pay for the first year? What is the balance of your loan
after the first year? See Table 3-4. The example below is calculated with
Chain
set as the
operating mode, but it can be performed in RPN, Chain, or Algebraic.
Table 3-4
Amortization Example
Keys
Display
Description
12:[
Inputs
12
as the number of payments per year.
This value is 12 by default, but it maintains its
current entered value when TVM Reset is used.
30:^
Inputs
360
(30 times 12 payments per year) as the
number of payments for the 30-year loan.
10Y
Inputs
10
as the interest rate percentage per year.
1400
00V
Inputs the value of the loan at the time of the first
payment.
0F
Inputs
0
as the future value of the loan (zero
balance).
M
Calculates the monthly payment.
A
Displays the number of periods to group together
in the amortization schedule. Default is the current
value of
P/YR
.
<
Displays the first period of the group of periods to
amortize.
<
Displays the current balance remaining after the
first year.
<
Displays the current amount of the principal
applied towards the loan for the first year.