What Is an Amortization Schedule? How to Calculate with Formula (2024)

What Is Amortization?

Amortization is an accounting technique used to periodically lower the book value of a loan or an intangible asset over a set period of time. Concerning a loan, amortization focuses on spreading out loan payments over time. When applied to an asset, amortization is similar to depreciation.

Key Takeaways

  • Amortization typically refers to the process of writing down the value of either a loan or an intangible asset.
  • Amortization schedules are used by lenders, such as financial institutions, to present a loan repayment schedule based on a specific maturity date.
  • Intangibles are amortized (expensed) over time to tie the cost of the asset to the revenues it generates, in accordance with the matching principle of generally accepted accounting principles (GAAP).
  • Negative amortization may happen when the payments of a loan are lower than the accumulated interest, causing the borrower to owe more money instead of less.
  • Most accounting and spreadsheet software have functions that can calculate amortization automatically.

What Is an Amortization Schedule? How to Calculate with Formula (1)

Understanding Amortization

The term “amortization” refers to two situations. First, amortization is used in the process of paying off debt through regular principal and interest payments over time. An amortization schedule is used to reduce the current balance on a loan—for example, a mortgage or a car loan—through installment payments.

Second, amortization can also refer to the practice of spreading out capital expenses related to intangible assets over a specific duration—usually over the asset’s useful life—for accounting and tax purposes.

Amortization of Loans

Amortization can refer to the process of paying off debt over time in regular installments of interest and principal sufficient to repay the loan in full by its maturity date.

A loan amortization schedule represents the complete table of periodicloan payments, showing the amount ofprincipalandinterestthat comprise each level payment until the loan is paid off at the end of its term. A higher percentage of the flat monthly payment goes toward interest early in the loan, but with each subsequent payment, a greater percentage of it goes toward the loan’s principal.

Amortization can be calculated using most modern financial calculators, spreadsheet software packages (such as Microsoft Excel), or online amortization calculators. When entering into a loan agreement, the lender may provide a copy of the amortization schedule (or at least have identified the term of the loan in which payments must be made).

Amortization schedules can be customized based on your loan and your personal circumstances. With more sophisticated amortization calculators you can compare how makingaccelerated paymentscanaccelerate your amortization. If for example, you are expecting an inheritance or you get a set yearly bonus, you can use these tools to compare how applying that windfall to your debt can affect your loan'smaturity dateand yourinterest costover the life of the loan.

Accountants use amortization to spread out the costs of an asset over the useful lifetime of that asset.

How to calculate loan amortization

The formula to calculate the monthly principal due on an amortized loan is as follows:

PrincipalPayment=TMP(OLB×InterestRate12Months)where:TMP=TotalmonthlypaymentOLB=Outstandingloanbalance\begin{aligned}&\text{Principal Payment} = \text{TMP} - \Big ( \text{OLB} \times \frac { \text{Interest Rate} }{ \text{12 Months} } \Big ) \\&\textbf{where:} \\&\text{TMP} = \text{Total monthly payment} \\&\text{OLB} = \text{Outstanding loan balance} \\\end{aligned}PrincipalPayment=TMP(OLB×12MonthsInterestRate)where:TMP=TotalmonthlypaymentOLB=Outstandingloanbalance

Typically, the total monthly payment is specified when you take out a loan. However, if you are attempting to estimate or compare monthly payments based on a given set of factors, such as loan amount and interest rate, then you may need to calculate the monthly payment as well. If you need to calculate the total monthly payment for any reason, the formula is as follows:

TotalPayment=LoanAmount×[i×(1+i)n(1+i)n1]where:i=Monthlyinterestpaymentn=Numberofpayments\begin{aligned}&\text{Total Payment} = \text{Loan Amount} \times \Bigg [ \frac { i \times (1 + i) ^n }{ (1 + i)^n - 1 } \Bigg ] \\&\textbf{where:} \\&i = \text{Monthly interest payment} \\&n = \text{Number of payments} \\\end{aligned}TotalPayment=LoanAmount×[(1+i)n1i×(1+i)n]where:i=Monthlyinterestpaymentn=Numberofpayments

You’ll need to divide your annual interest rate by 12. For example, if your annual interest rate is 3%, then your monthly interest rate will be 0.25% (0.03 annual interest rate ÷ 12 months). You'll also multiply the number of years in your loan term by 12. For example, a four-year car loan would have 48 payments (four years × 12 months).

Preparing amortization schedules

Amortization schedules usually have six columns, each communicating information to the borrower and lender. The six columns are often laid out as shown below:

PeriodBeginning Loan BalancePaymentInterestPrincipalEnding Loan Balance
Month or periodAmount of debt owed at the start of the month or periodAmount due each month (often a fixed amount over the term of the loan)Amount of interest included in the payment (loan balance * 1/12 of interest)Amount of principal included in loan payment (Payment - Interest)Amount of debt owed at the end of the month or period (Beginning Loan Balance - Principal)
  • The period is the timing of each loan payment, often represented on a monthly basis. However, each row on an amortization represents a payment so if a loan is due bi-weekly or quarterly, the period will be the same. This column helps a borrower and lender understand which payments will be broken down in what ways. This may either be shown as a payment number (i.e., Payment 1, Payment 2, etc.) or a date (i.e. 1/1/2023, 2/1/2023, etc.).
  • The beginning loan balance is the amount of debt owed at the beginning of the period. This amount is either the original amount of the loan or the amount carried over from the prior month (last month's ending loan balance equals this month's beginning loan balance).
  • The payment is the monthly obligation calculated above. This will often remain constant over the term of the loan. Though you usually calculate the payment amount before calculating interest and principal, payment is equal to the sum of principal and interest.
  • The interest portion is the amount of the payment that gets applied as interest expense. This is often calculated as the outstanding loan balance multiplied by the interest rate attributable to this period's portion of the rate. For example, if a payment is owed monthly, this interest rate may be calculated as 1/12 of the interest rate multiplied by the beginning balance. Always be mindful of how a lender calculates, applies, and compounds your annual percentage rate as this impacts your schedule. As the outstanding loan balance decreases over time, less interest should be charged each period.
  • The principal portion is simply the left over amount of the payment. This is the total payment amount less the amount of interest expense for this period. As the outstanding loan balance decreases over time, less interest will be charged, so the value of this column should increase over time.
  • The ending loan balance is the difference between the beginning loan balance and the principal portion. This represents the new debt balance owed based on the payment made for the new period.

Pros and Cons of Loan Amortization

Amortized loans feature a level payment over their lives, which helps individuals budget their cash flows over the long term. Amortized loans are also beneficial in that there is always a principal component in each payment, so that the outstanding balance of the loan is reduced incrementally over time.

The main drawback of amortized loans is that relatively little principal is paid off in the early stages of the loan, with most of each payment going toward interest. This means that for a mortgage, for example, very little equity is being built up early on, which is unhelpful if you want to sell a home after just a few years.

Amortization of Intangible Assets

Amortization can also refer to the amortization of intangibles. In this case, amortization is the process of expensing the cost of anintangible asset over the projected life of the asset. It measures the consumption of the value of an intangible asset, such as goodwill, a patent, a trademark, or copyright.

Amortization is calculated in a similar manner to depreciation—which is used for tangible assets, such as equipment, buildings, vehicles, and other assets subject to physical wear and tear—and depletion, which is used for natural resources.

When businesses amortize expenses over time, they help tie the cost of using an asset to the revenues that it generates in the same accounting period, in accordance with generally accepted accounting principles (GAAP). For example, a company benefits from the use of a long-term asset over a number of years. Thus, it writes off the expense incrementally over the useful life of that asset.

The amortization of intangibles is also useful in tax planning. The Internal Revenue Service (IRS) allows taxpayers to take a deduction for certain expenses: geological and geophysical expenses incurred in oil and natural gas exploration, atmospheric pollution control facilities, bond premiums, , lease acquisition, forestation and reforestation, and intangibles, such as goodwill, patents, copyrights, and trademarks.

The IRS has schedules that dictate the total number of years in which to expense tangible and intangible assets for tax purposes.

Why Is Amortization Important?

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. This can be useful for purposes such as deducting interest payments on income tax forms. It is also useful for planning to understand what a company's future debt balance will be after a series of payments have already been made.

Amortizing intangible assets is important because it can reduce a business's taxable income, and therefore its tax liability, while giving investors a better understanding of the company’s true earnings. Intangible assets also have a finite useful life; over time, trademarks or patents may lose their value due to obsolescence. Amortizing intangible assets is also a reflection of how a company has "used up" the benefit of these assets.

Amortization vs. Depreciation

Amortization and depreciation are similar concepts, in that both attempt to capture the cost of holding an asset over time. The main difference between them, however, is that amortization refers to intangible assets, whereas depreciation refers to tangible assets. Examples of intangible assets include trademarks and patents; tangible assets include equipment, buildings, vehicles, and other assets subject to physical wear and tear.

Another difference is the accounting treatment in which different assets are reduced on the balance sheet. Amortizing an intangible asset is performed by directly crediting (reducing) that specific asset account. Alternatively, depreciation is recorded by crediting an account called accumulated depreciation, a contra asset account. The historical cost of fixed assets remains on a company's books; however, the company also reports this contra asset amount as a net reduced book value amount.

Finally, the calculation of each can be different. This is especially true when comparing depreciation to the amortization of a loan. Intangible assets are often amortized over their useful life using the straight-line method, while fixed assets often use a much more broad set of calculation methods (i.e., declining balance method, double-declining balance method, sum-of-the-years' digits method, or the units of production method).

Example of Amortization

Let’s look at a four-year, $30,000 auto loan at 3% interest. The monthly payment is going to be $664.03. That is arrived at as follows:

$30,000×(0.0025×(1.0025÷48)1.0025÷481)\begin{aligned}&\$30,000 \times \Bigg ( \frac { 0.0025 \times (1.0025 \div 48) }{ 1.0025 \div 48 } - 1 \Bigg ) \\\end{aligned}$30,000×(1.0025÷480.0025×(1.0025÷48)1)

In the first month, $75 of the $664.03 monthly payment goes tointerest.

$30,000loanbalance×3%interestrate÷12months\begin{aligned}&\$30,000 \ \text{loan balance} \times 3\% \ \text{interest rate} \div 12 \ \text{months} \\\end{aligned}$30,000loanbalance×3%interestrate÷12months

The remaining$589.03 goes toward principal.

$664.03totalmonthlypayment$75interestpayment\begin{aligned}&\$664.03 \ \text{total monthly payment} - \$75 \ \text{interest payment} \\ \end{aligned}$664.03totalmonthlypayment$75interestpayment

The total payment stays the same each month, while the portion going to principal increases and the portion going to interest decreases. In the final month, only $1.66 is paid in interest, because the outstanding loan balance at that point is very minimal compared with the starting loan balance.

Loan Amortization Schedule
PeriodTotal Payment DueComputed Interest DuePrincipal DuePrincipal Balance
$30,000
1$664.03$75$589.03$29,410.97
2$664.03$73.53$590.50$28,820.47
3$664.03$72.05$591.98$28,228.49
4$664.03$70.57$593.46$27,635.03
5$664.03$69.09$594.94$27,040.09
6$664.03$67.60$596.43$26,443.66
7$664.03$66.11$597.92$25,845.74
8$664.03$64.61$599.42$25,246.32
9$664.03$63.12$600.91$24,645.41
10$664.03$61.61$602.42$24,042.99
11$664.03$60.11$603.92$23,439.07
12$664.03$58.60$605.43$22,833.64
13$664.03$57.08$606.95$22,226.69
14$664.03$55.57$608.46$21,618.23
15$664.03$54.05$609.98$21,008.24
16$664.03$52.52$611.51$20,396.73
17$664.03$50.99$613.04$19,783.69
18$664.03$49.46$614.57$19,169.12
19$664.03$47.92$616.11$18,553.02
20$664.03$46.38$617.65$17,935.37
21$664.03$44.84$619.19$17,316.18
22$664.03$43.29$620.74$16,695.44
23$664.03$41.74$622.29$16,073.15
24$664.03$40.18$623.85$15,449.30
25$664.03$38.62$625.41$14,823.89
26$664.03$37.06$626.97$14,196.92
27$664.03$35.49$628.54$13,568.38
28$664.03$33.92$630.11$12,938.28
29$664.03$32.35$631.68$12,306.59
30$664.03$30.77$633.26$11,673.33
31$664.03$29.18$634.85$11,038.48
32$664.03$27.60$636.43$10,402.05
33$664.03$26.01$638.02$9,764.02
34$664.03$24.41$639.62$9,124.40
35$664.03$22.81$641.22$8,483.18
36$664.03$21.21$642.82$7,840.36
37$664.03$19.60$644.43$7,195.93
38$664.03$17.99$646.04$6,549.89
39$664.03$16.37$647.66$5,902.24
40$664.03$14.76$649.27$5,252.96
41$664.03$13.13$650.90$4,602.06
42$664.03$11.51$652.52$3,949.54
43$664.03$9.87$654.16$3,295.38
44$664.03$8.24$655.79$2,639.59
45$664.03$6.60$657.43$1,982.16
46$664.03$4.96$659.07$1,323.09
47$664.03$3.31$660.72$662.36
48$664.03$1.66$662.36$0.00

What Is Negative Amortization?

Negative amortization is when the size of a debt increases with each payment, even if you pay on time. This happens because the interest on the loan is greater than the amount of each payment. Negative amortization is particularly dangerous with credit cards, whose interest rates can be as high as 20% or even 30%. In order to avoid owing more money later, it is important to avoid over-borrowing and to pay off your debts as quickly as possible.

What Does Amortization Mean for Intangible Assets?

Amortization measures the declining value of intangible assets, such as goodwill, trademarks, patents, and copyrights. This is calculated in a similar manner to the depreciation of tangible assets, like factories and equipment. When businesses amortize intangible assets over time, they are able to tie the cost of those assets with the revenue generated over each accounting period and deduct the costs over the lifetime of the asset.

Why Is Amortization Important in Accounting?

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. This can be useful for purposes such as deducting interest payments for tax purposes. Amortizing intangible assets is also important because it can reduce a company’s taxable income and therefore its tax liability, while giving investors a better understanding of the company’s true earnings.

How Do You Amortize a Loan?

A loan is amortized by determining the monthly payment due over the term of the loan. Next, you prepare an amortization schedule that clearly identifies what portion of each month's payment is attributable towards interest and what portion of each month's payment is attributable towards principal.

Since part of the payment will theoretically be applied to the outstanding principal balance, the amount of interest paid each month will decrease. Your payment should theoretically remain the same each month, which means more of your monthly payment will apply to principal, thereby paying down over time the amount you borrowed.

What Is a 30-Year Amortization Schedule?

A 30-year amortization schedule breaks down how much of a level payment on a loan goes toward either principal or interest over the course of 360 months (for example, on a 30-year mortgage). Early in the life of the loan, most of the monthly payment goes toward interest, while toward the end it is mostly made up of principal. It can be presented either as a table or in graphical form as a chart.

The Bottom Line

Amortization is a technique of gradually reducing an account balance over time. When amortizing loans, a gradually escalating portion of the monthly debt payment is applied to the principal. When amortizing intangible assets, amortization is similar to depreciation, where a fixed percentage of an asset's book value is reduced each month. This technique is used to reflect how the benefit of an asset is received by a company over time.

What Is an Amortization Schedule? How to Calculate with Formula (2024)

FAQs

How to calculate amortization schedule? ›

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.

What is the formula for calculating Amortisation? ›

You can use the equation: I=P*r*t, where I=Interest, P=principal, r=rate, and t=time.

What is the Excel formula for amortization? ›

Alternatively, we can use Excel's IPMT function, which has the following syntax: =IPMT(rate, per, nper, pv, [fv], [type]). Again, we are focused on the required arguments: Rate: The interest rate of the loan. Per: This is the period for which we want to find the interest and must be in the range from 1 to nper.

What is amortization with an example? ›

First, amortization is used in the process of paying off debt through regular principal and interest payments over time. An amortization schedule is used to reduce the current balance on a loan—for example, a mortgage or a car loan—through installment payments.

What is included in the amortization schedule? ›

An amortization schedule is presented as a table that outlines key loan characteristics like payment amount, interest vs. principal, and the current balance. An “amortizing loan” is another way of saying a “reducing loan” (for which the balance outstanding reduces at each payment).

How do you calculate amortization schedule using straight line method? ›

In finance, a straight-line basis is a method for calculating depreciation and amortization. It is calculated by subtracting an asset's salvage value from its current value and dividing the result by the number of years until it reaches its salvage value.

How to calculate amortization in accounting? ›

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. Salvage value - If the asset has any monetary value after its useful life.

What is the difference between depreciation and Amortisation? ›

Key Takeaways

Amortization and depreciation are two methods of calculating the value for business assets over time. Amortization is the practice of spreading an intangible asset's cost over that asset's useful life. Depreciation is the expensing a fixed asset as it is used to reflect its anticipated deterioration.

How is amortization formula derived? ›

For an amortisation schedule, define the function D ( t ), which represents the principal amount outstanding at period t. A formula for the principal amount outstanding in any given period can be derived given a scheduled payment ( m ) and contracted nominal interest rate (R = (1 + i)).

How do you calculate depreciation and amortization in Excel? ›

Straight Line Depreciation with SLN

Straight line depreciation evenly divides the purchase price less any salvage value by the useful life in years. In Excel it looks like this: =SLN(2000,200,5) or =SLN(price, salvage,life)

What is the formula for the monthly 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.

How to calculate monthly loan payments? ›

The formula is: M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1], where M is the monthly payment, P is the loan amount, i is the interest rate (divided by 12) and n is the number of monthly payments.

How to create an amortization schedule? ›

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.

How to calculate amortized cost? ›

Key Formulas
  1. Amortized Cost = Purchase Price - Repayments + Amortization of Discounts/Premiums.
  2. Amortization Amount Per Period = (Discount or Premium Amount) / Number of Periods.
Dec 21, 2023

What are the three types of amortization? ›

Similar to what obtains for the depreciation of tangible assets, there are three primary methods of amortization: the straight-line method, the accelerated method, and the units-of-production method.

What is the formula for amortized cost? ›

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. Salvage value - If the asset has any monetary value after its useful life.

How do you calculate amortization on financial statements? ›

How do you calculate amortization?
  1. The first step is to identify both the basic and residual value. The basic value is the amount that was paid to get the asset. ...
  2. Once you have the value, divide that by the years of the intangible asset's useful life. ...
  3. Now, each year, record the value of the asset on the income statement.
Oct 5, 2023

How to calculate depreciation and amortization? ›

The formula for calculating the amortization on an intangible asset is similar to the one used for calculating straight-line depreciation: you divide the initial cost of the intangible asset by the estimated useful life of the intangible asset.

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Laurine Ryan

Last Updated:

Views: 5804

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Laurine Ryan

Birthday: 1994-12-23

Address: Suite 751 871 Lissette Throughway, West Kittie, NH 41603

Phone: +2366831109631

Job: Sales Producer

Hobby: Creative writing, Motor sports, Do it yourself, Skateboarding, Coffee roasting, Calligraphy, Stand-up comedy

Introduction: My name is Laurine Ryan, I am a adorable, fair, graceful, spotless, gorgeous, homely, cooperative person who loves writing and wants to share my knowledge and understanding with you.