Compound Interest Table

Requires a Wolfram Notebook System

Interact on desktop, mobile and cloud with the free Wolfram CDF Player or other Wolfram Language products.

Requires a Wolfram Notebook System

Edit on desktop, mobile and cloud with any Wolfram Language product.

These kinds of tables for looking up compound interest for various factors are very commonly used in engineering economics.

[more]

Some definitions: = effective interest rate per unit period (normally one year) = number of interest periods = a present sum of money = a future sum of money equivalent to but interest periods from the present at interest rate = an end-of-period cash receipt or disbursement in a uniform series continuing for periods with the entire series equivalent to or at interest rate = uniform period-by-period increase or decrease in cash receipts or disbursement; the arithmetic gradient

[less]

Contributed by: Vivek J Joshi (March 2011)
Open content licensed under CC BY-NC-SA


Snapshots


Details

A single payment is a one-time investment of compounded at interest rate for periods that will reach a value . Or you can use the inverse, a discount factor, expressing the portion of a desired final value that must be invested to grow to in periods when invested at percent.

A uniform payment means that instead of a one-time investment, equal amounts are paid into a fund that compounds at interest rate for each of the periods. " given " gives the portion of the desired future accumulated amount that must be contributed at each time period to reach the desired goal. " given " shows the amount that must be paid to amortize an amount borrowed over the same period, with interest paid rather than earned on the outstanding balance—for example, a conventional mortgage.

The inverses of those quantities are " given " and " given ". Notice that " given " shows the value of the accumulated sum of an amount , saved in each of periods and compounding at interest rate . On the other hand, " given " is the present value of an amount that can be paid off by making payments of amount .

For example, the factor for 30 years at 5% is 15.3725, so payments of $12,000 a year would pay off a loan of 12000×15.3725 = $184,470 at that rate over that period. The factor of 66.4388 means that the same $12,000 a year contributed to, for example, a retirement savings account earning 5% would grow in 30 years to $797,265.60.

The arithmetic gradient series shows accumulations and amortizations possible by using increasing (rather than level) payments, where the amount of the payment starts at zero, but changes by dollars per year. Otherwise, this part of the Demonstration should be interpreted like the level payment accumulation and amortization factor series. Note that series of payments or contributions that start above zero and then increase at a fixed rate can be calculated as the sum of two terms—a level payment series for the initial amount and a gradient series for the increases.

Reference: T. G. Eschenbach, D. G. Newnan, and J. P. Lavelle, Engineering Economic Analysis, New York: Oxford Univ. Press, 2004.



Feedback (field required)
Email (field required) Name
Occupation Organization
Note: Your message & contact information may be shared with the author of any specific Demonstration for which you give feedback.
Send