|
This function displays/prints a table showing amortizing payments for a range of loan
amounts and interest rates and an amortization schedule for the chosen loan. When you
request this function, you may fill in the loan values you want in the data entry boxes in
the left side of the screen. As you do so, the loan amounts, interest rates, and payments
shown in the table are updated to reflect the values you enter. You may move any payment
shown in the table (and the associated Loan Amount and Interest Rate) to the center of the
table by clicking on the Payment Amount shown in the Table.
Loan View is normally set to Payment Table, but you may click on Amortization
at any time to show an Amortization Schedule for the Loan Amount, Interest Rate and
Payment at the center of the Payment Table. Changing any of the values in the entry boxes
to the left side automatically recalculates the Payment Table.
Loan $ Amount and Loan $ Increment control the top row of the
payment table. Loan $ Amount is used as the middle loan amount in the top of the
table. Loan $ Increment is used to generate the other loan amounts on the loan amount line
of the table. For example, if you enter a Loan $ Increment of $1,000, the loan amounts on
the top line will differ by $1,000, as shown in this screen.
Interest Rate and Increment Rate control the rate column along
the left side of the table in a similar fashion. Entering 10 as the Interest Rate means
that 10% will be the middle rate in this column, and a .125 Increment Rate means that each
rate in the column will be .125% greater than the rate above, as shown in this screen.
Number of Payments and Payment Timing allow you vary the length
of the loan and the payment frequency. Payment Timing may be set to Weekly, BiMonthly,
Monthly, Quarterly, SemiAnnual or Annual Payments. When you
change the Payment Timing, Number of Payments is automatically recomputed to make the loan
length the same, so resetting the Payment Timing from Monthly to Quarterly when the Number
of Payments is 360 will cause the Number of Payments to be reset to 120.
First Payment sets the date of the first payment (for use in the Amortization
Schedule)
|