Used to determine the periodic payment amount due on a loan (typically a mortgage), based on the amortization process.
The amortization repayment model factors varying amounts of both interest and principal into every installment, though the total amount of each payment is the same.
An amortization schedule calculator is often used to adjust the loan amount until the monthly payments will fit comfortably into budget, and can vary the interest rate to see the difference a better rate might make in the kind of home or car one can afford. An amortization calculator can also reveal the exact dollar amount that goes towards interest and the exact dollar amount that goes towards principal out of each individual payment. The amortization schedule is a table delineating these figures across the duration of the loan in chronological order.
The formula
The calculation used to arrive at the periodic payment amount assumes that the first payment is not due on the first day of the loan, but rather one full payment period into the loan.
While normally used to solve for A, (the payment, given the terms) it can be used to solve for any single variable in the equation provided that all other variables are known. One can rearrange the formula to solve for any one term, except for i, for which one can use a rootfinding algorithm.
The annuity formula is:
Where:
For a 30year loan with monthly payments,
Note that the interest rate is commonly referred to as an annual percent (e.g. 8% APR), but in the above formula, since the payments are monthly, the rate i must be in terms of a monthly percent. Converting an annual interest rate (that is to say, annual percentage yield or APY) to the monthly rate is not as simple as dividing by 12, see the formula and discussion in APR. However if the rate is stated in terms of "APR" and not "annual interest rate", then dividing by 12 is an appropriate means of determining the monthly interest rate.
Other uses
While often used for mortgagerelated purposes, an amortization calculator can also be used to analyze other debt, including shortterm loans, student loans and credit cards.
See also
Real Estate Finance Books
