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.

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.

How to solve amortization problems? ›

Amortization Formula
  1. PMT=P⋅(rm)[1−(1+rm)−mt]
  2. P is the balance in the account at the beginning (the principal, or amount of the loan)
  3. r is the annual interest rate in decimal form.
  4. t is the length of the loan, in years.
  5. m is the number of compounding periods in one year.
May 26, 2022

How do you beat an amortization schedule? ›

3 Loan-Amortization Tips
  1. Add Extra Dollars to Your Monthly Payment. If your total mortgage loan is $100,000 and your fixed monthly payment is $500, add $100 or more to each monthly mortgage payment to pay down the loan more quickly. ...
  2. Make a Lump-Sum Payment. ...
  3. Make Bi-weekly Payments.
Mar 8, 2023

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.

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.

How to calculate amortised cost of a loan? ›

Amortised cost model
  1. (1)the amount at which the instrument was initially recognised;
  2. (2)MINUS any repayments of principal;
  3. (3)PLUS or MINUS cumulative amortisation, using the effective interest method, of the difference between the initial recognition amount and the maturity amount, and any fees or transaction costs;

How to calculate amortization in Excel? ›

How to create an amortization schedule in Excel
  1. Create column A labels. ...
  2. Enter loan information in column B. ...
  3. Calculate payments in cell B4. ...
  4. Create column headers inside row seven. ...
  5. Fill in the "Period" column. ...
  6. Fill in cells B8 to H8. ...
  7. Fill in cells B9 to H9. ...
  8. Fill out the rest of the schedule using the crosshairs.
Feb 3, 2023

Is it bad to pay off a loan early? ›

Yes, paying off a personal loan early could temporarily have a negative impact on your credit scores. But any dip in your credit scores will likely be temporary and minor. And it might be worth balancing that risk against the possible benefits of paying off your personal loan early.

Does paying extra principal change amortization schedule? ›

Paying a little extra towards your mortgage can go a long way. Making your normal monthly payments will pay down, or amortize, your loan. However, if it fits within your budget, paying extra toward your principal can be a great way to lessen the time it takes to repay your loans and the amount of interest you'll pay.

Why do lenders typically use the amortization calculation formula? ›

Amortization is important because it helps businesses and investors understand and forecast their costs over time. In the context of loan repayment, amortization schedules provide clarity concerning the portion of a loan payment that consists of interest versus the portion that is 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]).

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 amortized interest

Divide your interest rate by the number of payments you'll make that year. If you have a 6 percent interest rate and you make monthly payments, you would divide 0.06 by 12 to get 0.005.

How do you make an amortization spreadsheet? ›

How to create an amortization schedule in Excel
  1. Create column A labels. ...
  2. Enter loan information in column B. ...
  3. Calculate payments in cell B4. ...
  4. Create column headers inside row seven. ...
  5. Fill in the "Period" column. ...
  6. Fill in cells B8 to H8. ...
  7. Fill in cells B9 to H9. ...
  8. Fill out the rest of the schedule using the crosshairs.
Feb 3, 2023

References

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Foster Heidenreich CPA

Last Updated:

Views: 6457

Rating: 4.6 / 5 (56 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Foster Heidenreich CPA

Birthday: 1995-01-14

Address: 55021 Usha Garden, North Larisa, DE 19209

Phone: +6812240846623

Job: Corporate Healthcare Strategist

Hobby: Singing, Listening to music, Rafting, LARPing, Gardening, Quilting, Rappelling

Introduction: My name is Foster Heidenreich CPA, I am a delightful, quaint, glorious, quaint, faithful, enchanting, fine person who loves writing and wants to share my knowledge and understanding with you.