Annuity Payment Table

What Is an Annuity Payment Table?

An annuity payment table (also known as a loan payment factor table or mortgage factor table) shows the periodic payment needed to amortize a $1 loan at various interest rates and over various numbers of periods. Each cell in the table contains a factor that, when multiplied by the actual loan amount, gives the periodic payment required to fully repay the loan. These tables are widely used in finance, real estate, and accounting to quickly determine loan payments without performing complex calculations.

The Annuity Payment Table Creator generates these factors using the standard loan payment formula. By providing interest rates as column headers and time periods as row headers, the table allows you to look up the appropriate factor for any combination of rate and term.

The Annuity Payment Formula

The payment factor for a $1 loan is calculated using the standard amortization formula:

Where:

• PMT is the periodic payment per $1 of loan amount
• i is the interest rate per period (in decimal form)
• n is the number of payment periods

When the interest rate is 0%, the formula simplifies to PMT = 1 / n, since the payment is simply the loan amount divided by the number of periods with no interest charge.

How to Use the Annuity Payment Table

The table is organized with interest rates across the top (columns) and time periods down the left side (rows). To find the payment factor for a specific loan:

1. Find the column matching your interest rate per period
2. Find the row matching the number of payment periods
3. Read the factor at the intersection of that column and row
4. Multiply the factor by your actual loan amount to get the periodic payment

Example Calculation

Suppose you want to borrow $10,000 at an annual interest rate of 6% and pay it back over 5 years with monthly payments. The interest rate per period is 6% / 12 = 0.5% per month, and the number of periods is 5 × 12 = 60 months.

Looking up the intersection of i = 0.50% and n = 60 in the table gives a factor of approximately 0.01933. The monthly payment would be $10,000 × 0.01933 = $193.30.

Customizing the Annuity Table

The Annuity Payment Table Creator offers full control over the table dimensions:

• Interest Rate Columns: Set the number of columns (up to 20), the starting interest rate, and the increment between columns. This allows you to create a table that covers exactly the range of rates you are interested in.
• Period Rows: Set the number of rows (up to 50), the starting period number, and the increment between rows. This lets you focus on the specific loan terms relevant to your analysis.

The table updates in real time as you adjust any of these parameters, making it easy to explore different scenarios and find the exact factor you need.

Applications of Annuity Payment Tables

Annuity payment factors are used in many areas of finance and business:

• Mortgage calculations: Real estate professionals use these tables to quickly estimate monthly mortgage payments for different loan amounts and interest rates.
• Loan comparisons: Borrowers can compare the payment impact of different interest rates and loan terms side by side.
• Financial planning: Planners use annuity factors to calculate loan payments for business financing, equipment purchases, and personal loans.
• Education: Finance students and educators use these tables to understand the relationship between interest rates, loan terms, and payment amounts.
• Accounting: Accountants use payment factors to calculate lease payments, bond amortization, and other time value of money applications.

Understanding the Results

The factor displayed in each cell represents the periodic payment required per dollar borrowed. A factor of 0.1000 means you would pay $0.10 per period for each dollar borrowed. The factors decrease as the interest rate decreases or the number of periods increases, because the payment is spread over more periods or the cost of borrowing is lower.