FinanceFormula-based · Runs in your browser

Interest Rate on Table Creator

Create compound-interest factor tables across a range of periodic interest rates for a selected number of periods.

Preparing saved example…

Inputs

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

Local save controls below
Required
Required
Required
%
Required
%
Required
%
Required

Result

Updates as valid inputs change.

Calculated locally
Rates in table
Minimum factor
Maximum factor
Factor type

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.

    factor is evaluated at n periods for each rate from the start through end rate

  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 compound-interest factor tables across a range of periodic interest rates for a selected number of periods.

How it works

The calculator evaluates factor is evaluated at n periods for each rate from the start through end rate. 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

6
  • ?factorType= Table factor

    Choice · Required · Default: pvif · Accepted values: pvif, fvif, pvifa, fvifa

  • ?periods= Number of periods

    Number · Required · Default: 10

  • ?startRate= Starting rate per period

    Percentage · Required · Default: 1

  • ?endRate= Ending rate per period

    Percentage · Required · Default: 10

  • ?rateStep= Rate increment

    Percentage · Required · Default: 1

  • ?paymentTiming= Annuity timing

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

Outputs

4
  • rowCount Rates in table

    Whole number · Primary output

  • minimumFactor Minimum factor

    Number

  • maximumFactor Maximum factor

    Number

  • factorDescription Factor type

    Text

Inputs and results

The inputs are Table factor, Number of periods, Starting rate per period, Ending rate per period, Rate increment, Annuity timing. Results include Rates in table, Minimum factor, Maximum factor, Factor type.

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.