Annuity on $1 Loan Table Creator

Create a printable table for the annuity (mortgage) payment (PMT) of a borrowed amount of $1. Payment (PMT) is calculated from the formula:

PMT = PV × i × [(1 + i)n / ((1 + i)n − 1)]

When PV = $1 the equation becomes:

PMT = $1 × i × [(1 + i)n / ((1 + i)n − 1)]

where PMT is the recurring, identical payment for a loan of $1, i is the interest rate in decimal form and n is the number of periods (n ≠ 1). PMT is the Payment to be paid at the end of each equal period on a loan of $1 an Interest Rate i% per period for n Number of Time Periods to payoff the loan or mortgage.

PMT = i × [(1 + i)n / ((1 + i)n − 1)]

You can then look up the payment factor in the table and use this value to calculate the annuity payment amount for the series of payments.

Example: if $1 is borrowed at i = 2% interest per time period and the amount is to be paid back in equal amounts over n = 10 time periods then the amount paid back per time period is 0.1113 * $1 = $0.11 rounded to cents.

Example Table:

n / i 2.00% 2.25% 2.50% 2.75% 3.00%
11.02001.02251.02501.02751.0300
20.51500.51690.51880.52070.5226
30.34680.34840.35010.35180.3535
40.26260.26420.26580.26740.2690
50.21220.21370.21520.21680.2184
60.17850.18000.18150.18310.1846
70.15450.15600.15750.15900.1605
80.13650.13800.13950.14100.1425
90.12250.12400.12550.12690.1284
100.11130.11280.11430.11570.1172

Example: You want to borrow $1,000 at an annual interest rate of 3% per year and pay it back over 5 years. How much will you need to pay per year to pay back the loan?

  • Create a table that includes i = 3% and n = 5 (see above table)
  • Look up PMT to find 0.2184
  • Use it as a factor to calculate $1,000 × 0.2184 = $218.40 which is your payment amount per year
Scroll to Top