Amortization Calculator (2024)

Amortization

Monthly Payment: $1,619.92

Total of 120 Payments: $194,390.67

Total Interest: $34,390.67

0 yr

5 yr

10 yr

#BEGINNING BALANCEINTERESTPRINCIPALENDING BALANCE
1$160,000.00$6,158.27$13,280.79$146,719.21
2$146,719.21$5,617.19$13,821.87$132,897.34
3$132,897.34$5,054.07$14,385.00$118,512.34
4$118,512.34$4,468.00$14,971.06$103,541.28
5$103,541.28$3,858.06$15,581.01$87,960.27
6$87,960.27$3,223.26$16,215.80$71,744.47
7$71,744.47$2,562.61$16,876.46$54,868.01
8$54,868.01$1,875.03$17,564.03$37,303.97
9$37,303.97$1,159.45$18,279.62$19,024.36
10$19,024.36$414.71$19,024.36$0.00
#BEGINNING BALANCEINTERESTPRINCIPALENDING BALANCE
1$160,000.00$533.33$1,086.59$158,913.41
2$158,913.41$529.71$1,090.21$157,823.20
3$157,823.20$526.08$1,093.84$156,729.36
4$156,729.36$522.43$1,097.49$155,631.86
5$155,631.86$518.77$1,101.15$154,530.72
6$154,530.72$515.10$1,104.82$153,425.90
7$153,425.90$511.42$1,108.50$152,317.39
8$152,317.39$507.72$1,112.20$151,205.20
9$151,205.20$504.02$1,115.90$150,089.29
10$150,089.29$500.30$1,119.62$148,969.67
11$148,969.67$496.57$1,123.36$147,846.31
12$147,846.31$492.82$1,127.10$146,719.21
Year 1 End
13$146,719.21$489.06$1,130.86$145,588.35
14$145,588.35$485.29$1,134.63$144,453.72
15$144,453.72$481.51$1,138.41$143,315.31
16$143,315.31$477.72$1,142.20$142,173.11
17$142,173.11$473.91$1,146.01$141,027.10
18$141,027.10$470.09$1,149.83$139,877.26
19$139,877.26$466.26$1,153.66$138,723.60
20$138,723.60$462.41$1,157.51$137,566.09
21$137,566.09$458.55$1,161.37$136,404.72
22$136,404.72$454.68$1,165.24$135,239.48
23$135,239.48$450.80$1,169.12$134,070.36
24$134,070.36$446.90$1,173.02$132,897.34
Year 2 End
25$132,897.34$442.99$1,176.93$131,720.40
26$131,720.40$439.07$1,180.85$130,539.55
27$130,539.55$435.13$1,184.79$129,354.76
28$129,354.76$431.18$1,188.74$128,166.02
29$128,166.02$427.22$1,192.70$126,973.32
30$126,973.32$423.24$1,196.68$125,776.64
31$125,776.64$419.26$1,200.67$124,575.97
32$124,575.97$415.25$1,204.67$123,371.30
33$123,371.30$411.24$1,208.68$122,162.62
34$122,162.62$407.21$1,212.71$120,949.91
35$120,949.91$403.17$1,216.76$119,733.15
36$119,733.15$399.11$1,220.81$118,512.34
Year 3 End
37$118,512.34$395.04$1,224.88$117,287.46
38$117,287.46$390.96$1,228.96$116,058.49
39$116,058.49$386.86$1,233.06$114,825.43
40$114,825.43$382.75$1,237.17$113,588.26
41$113,588.26$378.63$1,241.29$112,346.97
42$112,346.97$374.49$1,245.43$111,101.54
43$111,101.54$370.34$1,249.58$109,851.95
44$109,851.95$366.17$1,253.75$108,598.20
45$108,598.20$361.99$1,257.93$107,340.27
46$107,340.27$357.80$1,262.12$106,078.15
47$106,078.15$353.59$1,266.33$104,811.82
48$104,811.82$349.37$1,270.55$103,541.28
Year 4 End
49$103,541.28$345.14$1,274.78$102,266.49
50$102,266.49$340.89$1,279.03$100,987.46
51$100,987.46$336.62$1,283.30$99,704.16
52$99,704.16$332.35$1,287.58$98,416.58
53$98,416.58$328.06$1,291.87$97,124.72
54$97,124.72$323.75$1,296.17$95,828.54
55$95,828.54$319.43$1,300.49$94,528.05
56$94,528.05$315.09$1,304.83$93,223.22
57$93,223.22$310.74$1,309.18$91,914.04
58$91,914.04$306.38$1,313.54$90,600.50
59$90,600.50$302.00$1,317.92$89,282.58
60$89,282.58$297.61$1,322.31$87,960.27
Year 5 End
61$87,960.27$293.20$1,326.72$86,633.55
62$86,633.55$288.78$1,331.14$85,302.40
63$85,302.40$284.34$1,335.58$83,966.82
64$83,966.82$279.89$1,340.03$82,626.79
65$82,626.79$275.42$1,344.50$81,282.29
66$81,282.29$270.94$1,348.98$79,933.31
67$79,933.31$266.44$1,353.48$78,579.83
68$78,579.83$261.93$1,357.99$77,221.84
69$77,221.84$257.41$1,362.52$75,859.32
70$75,859.32$252.86$1,367.06$74,492.27
71$74,492.27$248.31$1,371.61$73,120.65
72$73,120.65$243.74$1,376.19$71,744.47
Year 6 End
73$71,744.47$239.15$1,380.77$70,363.69
74$70,363.69$234.55$1,385.38$68,978.32
75$68,978.32$229.93$1,389.99$67,588.32
76$67,588.32$225.29$1,394.63$66,193.69
77$66,193.69$220.65$1,399.28$64,794.42
78$64,794.42$215.98$1,403.94$63,390.48
79$63,390.48$211.30$1,408.62$61,981.85
80$61,981.85$206.61$1,413.32$60,568.54
81$60,568.54$201.90$1,418.03$59,150.51
82$59,150.51$197.17$1,422.75$57,727.76
83$57,727.76$192.43$1,427.50$56,300.26
84$56,300.26$187.67$1,432.25$54,868.01
Year 7 End
85$54,868.01$182.89$1,437.03$53,430.98
86$53,430.98$178.10$1,441.82$51,989.16
87$51,989.16$173.30$1,446.63$50,542.53
88$50,542.53$168.48$1,451.45$49,091.09
89$49,091.09$163.64$1,456.29$47,634.80
90$47,634.80$158.78$1,461.14$46,173.66
91$46,173.66$153.91$1,466.01$44,707.65
92$44,707.65$149.03$1,470.90$43,236.76
93$43,236.76$144.12$1,475.80$41,760.96
94$41,760.96$139.20$1,480.72$40,280.24
95$40,280.24$134.27$1,485.65$38,794.58
96$38,794.58$129.32$1,490.61$37,303.97
Year 8 End
97$37,303.97$124.35$1,495.58$35,808.40
98$35,808.40$119.36$1,500.56$34,307.84
99$34,307.84$114.36$1,505.56$32,802.28
100$32,802.28$109.34$1,510.58$31,291.69
101$31,291.69$104.31$1,515.62$29,776.08
102$29,776.08$99.25$1,520.67$28,255.41
103$28,255.41$94.18$1,525.74$26,729.67
104$26,729.67$89.10$1,530.82$25,198.85
105$25,198.85$84.00$1,535.93$23,662.92
106$23,662.92$78.88$1,541.05$22,121.88
107$22,121.88$73.74$1,546.18$20,575.69
108$20,575.69$68.59$1,551.34$19,024.36
Year 9 End
109$19,024.36$63.41$1,556.51$17,467.85
110$17,467.85$58.23$1,561.70$15,906.15
111$15,906.15$53.02$1,566.90$14,339.25
112$14,339.25$47.80$1,572.12$12,767.13
113$12,767.13$42.56$1,577.37$11,189.76
114$11,189.76$37.30$1,582.62$9,607.14
115$9,607.14$32.02$1,587.90$8,019.24
116$8,019.24$26.73$1,593.19$6,426.05
117$6,426.05$21.42$1,598.50$4,827.55
118$4,827.55$16.09$1,603.83$3,223.72
119$3,223.72$10.75$1,609.18$1,614.54
120$1,614.54$5.38$1,614.54$0.00
Year 10 End

There was an error with your calculation.

Table of Contents

  1. What is Amortization?
  2. Paying Off a Loan Over Time
  3. Amortization Schedule
  4. Spreading Costs
  5. Not all assets can be depreciated
  6. Amortizing Start-up Costs

Amortization Calculator (1)

There are different calculators on this website that can help with specific types of amortization calculations. The Amortization Calculator can do most of the work, but other calculators might be better suited for more specific cases.

  • Mortgage Calculator
  • Auto Loan Calculator
  • Investment Calculator
  • Business Loan Calculator
  • Personal Loan Calculator
  • FHA Loan Calculator
  • Annuity Calculator

What is Amortization?

Amortization describes paying off debt with regular payments. There are two types of amortization.

  1. The first is when you slowly and systematically repay a loan.
  2. The second type is when a business pays for something expensive and spreads the value of an asset over long periods.

Paying Off a Loan Over Time

When someone takes out a mortgage, car loan, or personal loan, they usually make monthly payments to the lender, called “amortization.” The amount owed is used to compute interest. That means that part of the monthly payment goes towards the loan's interest. The remainder is used to reduce the amount of money owed on the loan.

As more of the principal is paid off over time, interest accrues at a lower rate. Check how this works by looking at the amortization table.

Credit cards are entirely different from other types of loans. They are not amortized. They are an example of revolving debt, where the balance owed can be carried over from month to month, and the amount repaid each month can change. Our Credit Cards Payoff Calculator can help you create a plan to pay off your credit cards.

Other types of loans that work similarly include interest-only loans and balloon loans. An interest-only loan comprises a period where you only have to pay the interest on the loan. A balloon loan has a large principal payment at the end of the loan.

Amortization Schedule

An amortization schedule shows each payment you will make on an amortizing loan. This includes the total payment amount, the interest, and the principal.

When you make a payment on an amortized loan, part of that payment is used to pay the interest on the loan, and another part goes towards reducing the principal balance. The chart shows how much of your annual and monthly payments go toward paying interest and how much goes toward paying off your principal.

The amount that goes toward the principal debt fluctuates depending on when you make that particular payment in the repayment schedule. The amortization schedule provides information on how much of each payment is allocated to each of these parts: interest, principal paid to date, and balance.

Just be aware that most basic amortization schedules do not consider extra payments borrowers can make. Amortization schedules rarely consider fees. An amortization plan typically only applies to fixed-rate loans; it does not apply to adjustable-rate mortgages, variable-rate loans, or credit lines.

Spreading Costs

Some businesses sometimes purchase expensive items used for a long time and classified as investments. The cost of these investments, which often include costly equipment or even machinery and buildings, is usually spread out. For example, if a company purchases a costly factory, it can distort financial reports. For greater accuracy, the cost of the factory is allocated to the number of years it is expected to last.

The investment cost is divided into smaller portions called “depreciation.” Depreciation is an expense used to calculate how much an asset is worth over its lifetime. This amount is then used to reduce taxes each year until the expected lifetime of the asset expires. This is often done when the company purchases so-called “tangible assets.” These are physical things, like machinery, equipment, or even an entire factory, as in our example.

But also, when a company spends money on a patent or copyright, it can sometimes be written off. These assets are called “intangible assets.” Under U.S. law, Section 197, the value of these intangible assets can also be deducted each month or year. Like with any other amortization, you can figure out how much this will be yearly by using amortization schedule.

There are different intangible assets. Some examples are:

  • Patents, copyrights, including formulas, patterns, know-how, or designs.
  • Records, and operating systems, including information concerning customers.
  • Supplier relationships (like the value of future purchases)
  • Customers and customer relationships.
  • Government licenses or permits.
  • Covenants not to compete.
  • Trademarks and trade names or franchises.
  • Contracts for the use of intellectual property.
  • A company’s reputation (Goodwill)
  • Current employees, their experience, education, and training.
  • A business worth when it is still running (going-concern value).

Not all assets can be depreciated

The IRS says that some assets are not considered intangible, even if they have a specific value for the company. These include business interests, contracts, land, computer software, etc. Intangible assets not gained when you buy a business are also not considered.

The same is valid for interest on a property or debt that has no connection with the actual purchase of a business and certain transaction costs. Some intangible assets, such as goodwill, have indefinite useful lives and are not legally amortized for tax.

Amortizing Start-up Costs

In the U.S., start-up costs, defined as costs incurred to explore the feasibility of establishing or acquiring a going concern and the costs of establishing a going concern, can only be amortized under certain conditions.

These must be expenses deductible as expenses of doing business if incurred by an existing going concern and must be incurred before the commencement of active business. Examples of such payments include consultant fees, financial analysis of potential acquisitions, advertising costs, and employee benefits.

The business owner must pay these costs before their business can be called operating.

According to IRS guidance, the initial costs of starting a business must be amortized.

Related Calculators

Auto Loan CalculatorFinanceLoan CalculatorFinanceMortgage CalculatorFinancePersonal Loan CalculatorFinanceMortgage Payment CalculatorFinanceBusiness Loan CalculatorFinanceCar Loan CalculatorFinanceRefinance CalculatorFinanceFHA Loan CalculatorFinanceHome Loan CalculatorFinance
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.

What is the formula for calculating amortization expense? ›

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 a simple loan? ›

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.

What is the most commonly used method of amortization? ›

There are several ways to calculate the amortization of intangibles. 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 rule of 72 in amortization? ›

What is the Rule of 72? Here's how it works: Divide 72 by your expected annual interest rate (as a percentage, not a decimal). The answer is roughly the number of years it will take for your money to double. For example, if your investment earns 4 percent a year, it would take about 72 / 4 = 18 years to double.

Is there an 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 the formula for asset amortization? ›

The formula to calculate amortization is equal to the historical cost of the intangible asset subtracted by its residual value, which is then divided by the useful life assumption.

What is the formula for calculating loan amount? ›

all you need are the details like the amount borrowed, interest rate, and loan tenure to calculate your monthly EMI. the formula for calculation is: EMI = [p x r x (1+r)^n]/[(1+r)^n-1]

How to calculate accumulated amortization? ›

Accumulated amortization is calculated by dividing the value of the underlying intangible asset with years of its useful life. The division allows companies to report the same amount as amortization cost throughout the intangible asset life.

How to calculate depreciation amortization? ›

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.

What is an example of amortization? ›

Example A: A business has a $10,000 software license, which it expects will come to an end in five years. Using the straight-line method, the amortization expense would be $2,000 per year for the next five years. At the end of five years, the carrying amount of the asset will be zero.

How to calculate amortization from financial statements? ›

For simplicity, we'll use the straight-line method in this example. First, the company must determine the asset's value at the end of its useful life. This salvage value, or residual value, is subtracted from the purchase price and then divided by the number of years in the asset's useful life.

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 in years = Interest.

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.

References

Top Articles
Latest Posts
Article information

Author: Jamar Nader

Last Updated:

Views: 6455

Rating: 4.4 / 5 (55 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Jamar Nader

Birthday: 1995-02-28

Address: Apt. 536 6162 Reichel Greens, Port Zackaryside, CT 22682-9804

Phone: +9958384818317

Job: IT Representative

Hobby: Scrapbooking, Hiking, Hunting, Kite flying, Blacksmithing, Video gaming, Foraging

Introduction: My name is Jamar Nader, I am a fine, shiny, colorful, bright, nice, perfect, curious person who loves writing and wants to share my knowledge and understanding with you.