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.

Loan Planner

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.

Loan Planner Loan Planner Loan Planner