FinanceFormula-based · Runs in your browser

Annuity on Loan Table Creator

Create an equal-payment loan amortization table for an ordinary annuity or annuity due.

Preparing saved example…

Inputs

Enter the values you know. Optional fields may be left empty.

Local save controls below
Required
$
Required
%
Required
Required
Required

Result

Updates as valid inputs change.

Calculated locally
Periodic payment
Total interest
Total of payments
Number of payments
Effective annual rate

Saved locally, explained clearly

Drafts, calculations, scenarios, and workflow progress stay in this browser unless you export them.

Opening local database…

Calculation steps

Follow what happened from the selected formula to the displayed answer.

Show substituted values and intermediate working
Calculate current inputs to see the working.
  1. 1

    Formula selected

    The calculator uses the following formula or method.

    payment = PV × i ÷ [1 − (1+i)^−n], adjusted by ÷(1+i) for beginning-of-period payments

  2. 2

    Values entered

    Your values are placed into the calculation.

    Enter values to see what is used in this step.

  3. 3

    Result calculated

    The formula or method produces the following result values.

    Results will appear after a successful calculation.

  4. 4

    Answer formatted

    Displayed values are rounded and formatted using each output’s configured precision.

Scenario comparison

Save working scenarios, then select two or three to compare. Formula versions and inputs remain visible.

No scenarios saved for this calculator yet.

Recent calculations

Successful calculations are retained locally according to your privacy settings.

No local history for this calculator yet.

Data and privacy

What this calculator does

Create an equal-payment loan amortization table for an ordinary annuity or annuity due.

How it works

The calculator evaluates payment = PV × i ÷ [1 − (1+i)^−n], adjusted by ÷(1+i) for beginning-of-period payments. Inputs are checked before calculation, and invalid values such as zero denominators or out-of-range selections produce a clear error instead of a misleading result.

Input query strings and outputs

Use an input name in this page’s URL as ?name=value, and join additional inputs with &. Portable shared links may instead use the compact ?ac= state parameter.

Input query strings

5
  • ?principal= Loan amount

    Money · Required · Default: 25,000

  • ?annualRate= Annual nominal interest

    Percentage · Required · Default: 7.5

  • ?paymentsPerYear= Payments per year

    Number · Required · Default: 12

  • ?years= Term in years

    Number · Required · Default: 4

  • ?paymentTiming= Payment timing

    Choice · Required · Default: end · Accepted values: end, begin

Outputs

5
  • payment Periodic payment

    Currency · Primary output

  • totalInterest Total interest

    Currency

  • totalPaid Total of payments

    Currency

  • paymentCount Number of payments

    Whole number

  • effectiveAnnualRate Effective annual rate

    Percentage

Inputs and results

The inputs are Loan amount, Annual nominal interest, Payments per year, Term in years, Payment timing. Results include Periodic payment, Total interest, Total of payments, Number of payments, Effective annual rate.

Sources
  • No external reference is listed for this calculator. Its formula and variable definitions are shown above.
Limitations
  • Estimates use the rates, timing, and assumptions entered. Fees, taxes, lender rules, and future changes are included only where explicitly shown.