Amortization Calculator (2024)

The amortization calculator or loan amortization calculator is a handy tool that not only helps you to compute the payment of any amortized loan, but also gives you a detailed picture of the loan in question through its amortization schedule. The main strength of this calculator is its high functionality, that is, you can choose between different compounding frequencies (including continuous compounding), and payment frequencies You can even set an extra payment.

You can also study the loan amortization schedule on a monthly and yearly bases, and follow the progression of the balances of the loan in a dynamic amortization chart. If you read on, you can learn what the amortization definition is, as well as the amortization formula, with relevant details on this topic. For these reasons, if you would like to get familiar with the mechanism of loan amortization or would like to analyze a loan offer in different scenarios, this tool will be of excellent help.

If you are more interested in other types of repayment schedule, you may check out our loan repayment calculator, where you can choose balloon payment or an even principal repayment options as well. In case you would like to compare different loans, you may make good use of the APR calculator as well.

What is amortized loan? - the amortization definition

The repayment of most loans is realized by a series of even payments made on a regular basis. The popular term in finance to describe loans with such a repayment schedule is an amortized loan. Accordingly, we may phrase the amortization definition as "a loan paid off by equal periodic installments over a specified term". Typically, the details of the repayment schedule are summarized in the amortization schedule, which shows how the payment is divided between the interest (computed on the outstanding balance) and the principal. The amortization chart might also represent the unpaid balance at the end of each period. A few examples of loan amortization are automobile loans, home mortgage loans, student loans, and many business loans.

As in general the core concept that governs financial instruments is the time value of money, the loan amortization is similarly strongly connected to the present value and future value of money. More specifically, there is a concept called the present value of annuity that conforms the most to the loan amortization framework.

💡 You can learn more about these concepts from our time value of money calculator.

To see why, let's consider the following simple example. Suppose you borrow $1,000, which you need to repay in five equal parts due at the end of every year (the amortization term is five years with a yearly payment frequency). The lender charges you 12 percent interest, that is calculated on the outstanding balance at the beginning of each year (therefore, the compounding frequency is yearly).

The illustration below represents the timeline of this example, where PMT is the yearly payment or installment. To find PMT, we need to find a value such that the sum of their present values equals the loan amount: $1,000.

Amortization Calculator (1)Amortization Calculator (2)

The solution of this equation involves complex mathematics (you may check out the IRR calculator for more on its background); so, it's easier to rely on our amortization calculator. After setting the parameters according to the above example, we get the result for the periodic payment, which is $277.41.

Loan amortization schedule - the amortization table

The specific feature of amortized loans is that each payment is the combination of two parts: the repayment of principal and the interest on the remaining principle . The amortization chart below, which appears in the calculator as well, represents the payment schedule of the previous example. As you can see, the interest payments are typically high in early periods and decrease over time, while the reverse is true for the principal payments. The lowering interest amount is matched by the increasing amount of principal so that the total loan payment remains the same over the loan term.

Amortization Calculator (3)

The large unpaid principal balance at the beginning of the loan term means that most of the total payment is interest, with a smaller portion of the principal being paid. Since the principal amount being paid off is comparably low at the beginning of the loan term, the unpaid balance of the loan decreases slowly. As the loan payoff proceeds, the unpaid balance declines, which gradually reduces the interest obligations, making more room for a higher principal repayment. Logically, the higher the weight of the principal part in the periodic payment, the higher the rate of decline in the unpaid balance.

It may be easier to understand this concept if it is displayed as a graph of the relevant balances, which is why this option is also displayed in the calculator.

Amortization Calculator (4)

An amortized loan is a form of credit where the loan is paid off with equal, consecutive payments over a specified period. An amortization schedule shows the structure of these consecutive payments: the interest paid, the principal repaid, and the unpaid balance at the end of each period, which must reach zero during the amortization term.

What is the amortization formula?

As you have now gained some insight into the logic behind the amortized loan structure, in this section you can learn two basic formulas employed in our amortization calculator:

  • Monthly repayment formula

P=A×i1(1+i)tP = \frac{A \times i}{1-(1 + i)^{-t}}P=1(1+i)tA×i

  • Unpaid balance formula

B=A×(1+i)tPi×((1+i)t1)B = A \times (1 + i)^t - \frac{P}{i} \times ((1 + i)^t - 1)B=A×(1+i)tiP×((1+i)t1)

Where

  • PPP - monthly payment amount
  • AAA - loan repayment amount
  • iii - periodic interest rate
  • ttt - number of periods
  • BBB - unpaid balance

For more details and formulas, you may check BrownMath.com, where you can also check the precise derivation of the related equations.

Amortization calculator with extra payments

It is worth knowing that the amortization term doesn't necessarily equal to the original loan term; that is, you may pay off the principal faster than the time estimated with the periodic payments based on the initial amortization term. An obvious way to shorten the amortization term is to decrease the unpaid principal balance faster than set out in the original repayment plan. You may do so by a lump sum advance payment, or by increasing the periodic installments.

In this calculator, you can set an extra payment, which raises the regular payment amount. The power of such an extra payment is that its amount is directly allocated to the repayment of the loan amount. In this way, the principal balance decreases in an accelerating fashion, resulting in a shorter amortization term and a considerably lower total interest burden.

The beneficial effect of extra payments is especially profound when the initial loan term is relatively long, such as most mortgage loans. When you set the extra payment in this calculator, you can follow and compare the progress of new balances with the original plan on the dynamic chart, and the amortization schedule with extra payment.

Since the shorter repayment period with advance payments mean lower interest earnings to the banks, lenders often try to avert such action with additional fees or penalties. For this reason, it is always advisable to negotiate with the lender when altering the contractual payment amount.

Disclaimer

The results of this calculator, due to rounding, should be considered as just a close approximation financially. For this reason, and also because of possible shortcomings, the calculator is created for instructional purposes only.

Amortization Calculator (2024)

FAQs

What is the easiest way to calculate amortization? ›

To calculate amortization, first multiply your principal balance by your interest rate. Next, divide that by 12 months to know your interest fee for your current month. Finally, subtract that interest fee from your total monthly payment. What remains is how much will go toward principal for that month.

How do you calculate amortization value? ›

There is a mathematical formula to calculate amortization in accounting to add to the projected expenses. Amortization of an intangible asset = (Cost of asset-salvage value)/Number of years the asset can add value.

What is the most commonly used method of amortization? ›

The most common way to do so is by using the straight line method, which involves expensing the asset over a period of time.

What is the formula for total amortization? ›

Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for a loan with monthly repayments, divide the result by 12 to get your monthly interest. Subtract the interest from the total monthly payment, and the remaining amount is what goes toward principal.

Is there an Excel formula for amortization? ›

The beginning loan amount changes each month since a portion of the principal balance is being repaid as part of the monthly payment. Alternatively, we can use Excel's IPMT function, which has the following syntax: =IPMT(rate, per, nper, pv, [fv], [type]).

How do you calculate effective amortization? ›

Interest expense is calculated as the effective-interest rate times the bond's carrying value for each period. The amount of amortization is the difference between the cash paid for interest and the calculated amount of bond interest expense.

What is the formula for the monthly loan payment? ›

Monthly Payment = (P × r) ∕ n

Again, “P” represents your principal amount, and “r” is your APR. However, “n” in this equation is the number of payments you'll make over a year. Now for an example. Let's say you get an interest-only personal loan for $10,000 with an APR of 3.5% and a 60-month repayment term.

What is the formula for interest payment? ›

The simple interest expense formula is Interest Expense = Principal x Rate x Time.

What is the formula for simple interest? ›

Simple interest is calculated with the following formula: S.I. = (P × R × T)/100, where P = Principal, R = Rate of Interest in % per annum, and T = Time, usually calculated as the number of years. The rate of interest is in percentage R% (and is to be written as R/100, thus 100 in the formula).

How to calculate amortization expense? ›

Assuming the straight-line method is used, the company divides the capitalized cost by the estimated useful life, and that gives you the amortization expense per year to recognize in the financial statements. Similar to depreciation, amortization is a non-cash expense, so there is no cash flow impact.

Why do lenders typically use the amortization calculation formula? ›

Amortization helps businesses and investors understand and forecast their costs over time. In the context of loan repayment, amortization schedules provide clarity into what portion of a loan payment consists of interest versus principal.

Which three methods are used to calculate amortized cost? ›

There are generally three methods for performing amortized analysis: the aggregate method, the accounting method, and the potential method. All of these give correct answers; the choice of which to use depends on which is most convenient for a particular situation.

How do you calculate simple interest amortization? ›

Formula for calculating simple interest

You can calculate your total interest by using this formula: Principal loan amount x interest rate x loan term = interest.

Top Articles
Latest Posts
Article information

Author: Prof. An Powlowski

Last Updated:

Views: 5353

Rating: 4.3 / 5 (64 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Prof. An Powlowski

Birthday: 1992-09-29

Address: Apt. 994 8891 Orval Hill, Brittnyburgh, AZ 41023-0398

Phone: +26417467956738

Job: District Marketing Strategist

Hobby: Embroidery, Bodybuilding, Motor sports, Amateur radio, Wood carving, Whittling, Air sports

Introduction: My name is Prof. An Powlowski, I am a charming, helpful, attractive, good, graceful, thoughtful, vast person who loves writing and wants to share my knowledge and understanding with you.