Skip to content
Finance Calc Kit
Retirement

Annuity Payment Table

Generate annuity payment factor tables for loans. Free online annuity table creator with customizable interest rates and periods.

Loan calculation & table parameters

$

Interest rate columns (i)

%
%

Time period rows (n)

Periodic payment (2.0% over 1 periods)

$10,200.00

Click any cell in the table below to inspect that specific term

Payment factor per $1

1.02000

1 / PVFA(2.0%, 1)

Total payments

$10,200.00

1 × $10,200.00

Total interest

$200.00

Interest over full term

Payment breakdown for $10,000.00 at 2.0% (1 periods)

  • Principal$10,000.0098.0%
  • Total interest$200.002.0%

How annuity payment factors are calculated

The annuity payment factor (Capital Recovery Factor) calculates the periodic amount required to repay $1 of present loan balance with interest.

  1. Identify the periodic interest rate and periods

    Periodic rate i = 2.0% (0.020000 decimal), number of periods n = 1.

  2. Apply the capital recovery factor formula

    Factor(i,n)=i×(1+i)n(1+i)n−1\mathrm{Factor}(i, n) = \frac{i \times (1 + i)^n}{(1 + i)^n - 1}

    Compounding factor (1 + i)^1 = 1.020000. Resulting factor is 1.02000.

  3. Multiply by principal loan amount

    PMT=P×Factor(i,n)\mathrm{PMT} = P \times \mathrm{Factor}(i, n)

    For $10,000.00 principal: $10,000.00 × 1.02000 = $10,200.00 per period.

Annuity payment factor table

Click any cell to inspect loan metrics and visualize principal vs interest.

Period (n) \ Rate (i)2.0%2.5%3.0%3.5%4.0%
n = 11.020001.025001.030001.035001.04000
n = 20.515050.518830.522610.526400.53020
n = 30.346750.350140.353530.356930.36035
n = 40.262620.265820.269030.272250.27549
n = 50.212160.215250.218350.221480.22463
n = 60.178530.181550.184600.187670.19076
n = 70.154510.157500.160510.163540.16661
n = 80.136510.139470.142460.145480.14853
n = 90.122520.125460.128430.131450.13449
n = 100.111330.114260.117230.120240.12329
How to use this matrix: Each cell shows the periodic payment needed to amortize a $1 loan. Multiply the factor by any loan balance to determine the required installment.
Report tool

What is an annuity payment table?

An annuity payment table (also known as a capital recovery factor table or loan payment factor table) provides the exact periodic installment required to amortize a $1 present loan balance across various interest rates and payment periods. By multiplying the factor found in the table by any principal amount, borrowers and financial analysts can determine the exact regular payment needed to fully pay off an obligation with interest.

These factor matrices are widely used in commercial lending, lease evaluations, and financial analysis. If you are modeling wealth accumulation rather than loan repayments, see how deposits grow over time with the annuity calculator. If you are looking for a full period-by-period balance breakdown, examine the amortization calculator or the EMI calculator. For loans with accelerated payoff schedules, explore the amortization equal principal payments calculator and the advanced loan calculator.

The capital recovery factor formula

The annuity payment factor represents the mathematical inverse of the Present Value of an Annuity Factor (PVFA). For a periodic interest rate ii and total payment periods nn, the factor is calculated as:

Payment Factor(i,n)=i×(1+i)n(1+i)n−1=i1−(1+i)−n=1PVFA(i,n)\mathrm{Payment\ Factor}(i, n) = \frac{i \times (1 + i)^n}{(1 + i)^n - 1} = \frac{i}{1 - (1 + i)^{-n}} = \frac{1}{\mathrm{PVFA}(i, n)}

When the interest rate is zero (i=0i = 0), no interest accrues and the factor simplifies to equal division across all periods:

Payment Factor(0,n)=1n\mathrm{Payment\ Factor}(0, n) = \frac{1}{n}

To calculate the total periodic installment (PMT\mathrm{PMT}) for a loan with principal balance PP, multiply the principal by the table factor:

PMT=P×Payment Factor(i,n)\mathrm{PMT} = P \times \mathrm{Payment\ Factor}(i, n)

How to use and customize the table

The matrix organizes interest rates across columns and payment periods down rows:

  1. Determine your periodic rate: For monthly loans, divide the annual nominal interest rate by 12 (e.g. 6% annual rate becomes 0.50% monthly). For quarterly or annual loans, divide by 4 or 1 respectively.
  2. Find the period count: Locate the row corresponding to the total number of payments (e.g. 5 years monthly = 60 periods).
  3. Read the payment factor: Find the intersection of your periodic rate column and period row.
  4. Multiply by your loan balance: Multiplying this factor by your borrowed sum gives your regular recurring payment.

Worked example: Equipment loan payment lookup

Suppose a business borrows $10,000 for equipment at an annual interest rate of 6% with monthly repayments over 5 years:

  • Periodic interest rate: i=6%12=0.50%=0.005i = \frac{6\%}{12} = 0.50\% = 0.005
  • Payment periods: n=5×12=60 monthsn = 5 \times 12 = 60\text{ months}
  • Annuity factor lookup: 0.005×(1.005)60(1.005)60−1≈0.0193328\frac{0.005 \times (1.005)^{60}}{(1.005)^{60} - 1} \approx 0.0193328
  • Monthly payment: $10,000×0.0193328=$193.33 per month\$10{,}000 \times 0.0193328 = \$193.33\text{ per month}
  • Total payments over 60 months: 60×$193.33=$11,599.6860 \times \$193.33 = \$11{,}599.68
  • Total interest cost: $11,599.68−$10,000=$1,599.68\$11{,}599.68 - \$10{,}000 = \$1{,}599.68

Key applications in finance and lending

Annuity payment factor tables provide quick, reliable answers in multiple professional contexts:

  • Sensitivity Analysis: Quickly assess how a 0.25% or 0.50% rate increase alters borrowing costs across multiple potential loan tenures.
  • Commercial & Capital Budgeting: Estimate capital recovery requirements for machinery, equipment leases, and long-term project financing.
  • Financial Education: Demonstrate the inverse relationship between repayment duration and periodic installment size.

Frequently asked questions

What is the difference between an annuity payment factor and a present value factor?
An annuity payment factor (capital recovery factor) calculates the periodic installment needed to pay off $1 of present loan balance. A present value annuity factor (PVFA) calculates how much a series of future $1 payments is worth today. Mathematically, the payment factor is the exact reciprocal of the present value factor: Payment Factor = 1 / PVFA.
How do I calculate payments in other currencies like EUR, GBP, or CAD?
Because payment factors are ratios per unit of principal, they are currency-neutral. Simply multiply the factor from the table by your loan balance in any currency to get the periodic installment in that currency.
Why do payment factors decrease as the number of periods increases?
Spreading the repayment over more installments reduces the principal portion due in each individual cycle. However, extending the term increases the overall interest paid across the life of the loan.
What does a payment factor of 1.0 or higher mean?
A factor of 1.0 or greater occurs when a loan must be repaid in a single period (n = 1). At n = 1 with a 5% interest rate, the factor is 1.05, meaning you repay the entire $1 principal plus $0.05 interest in one installment.
Can I export or copy the generated table data?
Yes. Use the Copy button to place clean CSV formatted data onto your clipboard, or click Export CSV to download a spreadsheet-ready file with all custom rates and periods.
Are my financial entries kept private?
All calculations and table generation run entirely inside your browser. No loan figures or parameters are ever sent to external servers.

Resources and references

The formulas and methods in this calculator were checked against these independent sources.