Annuity on $1 Loan Table Creator

How to Use the Annuity on $1 Loan Table Creator

1. Interest Rate (i) : Columns

   • Columns (20 max): Enter the number of interest rate columns to display (up to 20).
   • Starting Rate (%): Enter the starting interest rate for the first column.
   • Increments (%): Enter the percentage increment between each column.

2. Periods (n) : Rows

   • Rows (50 max): Enter the number of period rows to display (up to 50).
   • Starting Period: Enter the starting period (e.g., 1 for the first period).
   • Increments: Enter the increment value for periods between rows.

3. Create Table:

   • After entering the above details, click “Create Table” to generate the annuity table. The table will show annuity factors for different periods and interest rates, useful for financial calculations and loan amortization planning.

Example Scenarios

1. Example 1:

   • Columns: 5
   • Starting Rate (%): 2
   • Increments (%): 1
   • Rows: 10
   • Starting Period: 1
   • Increments: 1
   • Result: The table will display annuity factors for periods 1 to 10 and interest rates of 2%, 3%, 4%, 5%, and 6%.

2. Example 2:

   • Columns: 4
   • Starting Rate (%): 5
   • Increments (%): 0.5
   • Rows: 15
   • Starting Period: 5
   • Increments: 2
   • Result: The table will display annuity factors for periods 5, 7, 9, 11, 13, and 15, with interest rates of 5%, 5.5%, 6%, and 6.5%.