Loan Planner
Displays a table showing amortizing payments for a range of loan amounts and interest rates. You fill in the loan values you want in the data entry boxes in the left side of the screen, and 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. Changing the Loan View at the screen right bottom to 'Amortization' displays an amortization schedule for the chosen loan/payment.
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)
Displays a table showing amortizing payments for a range of loan amounts and interest rates. You fill in the loan values you want in the data entry boxes in the left side of the screen, and 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. Changing the Loan View at the screen right bottom to 'Amortization' displays an amortization schedule for the chosen loan/payment.
