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.

How do you calculate amortization value? ›

The formula for amortization subtracts the residual value from the initial value and then divides it by the useful life. The residual value is usually credited to the accumulated amortization account in the journal entries, as it reduces the total amount that needs to be amortized over the asset's lifespan.

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

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

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? ›

It's an easy way to calculate just how long it's going to take for your money to double. Just take the number 72 and divide it by the interest rate you hope to earn. That number gives you the approximate number of years it will take for your investment to double.

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.

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;

What is the formula for calculating loan amount? ›

E = P*r*(1+r)^n/((1+r)^n-1) where, E is EMI. P is the principal loan amount, r is the rate of interest calculated monthly, and.

How to calculate amortization from 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 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 do you calculate amortized value? ›

Subtract the residual value of the asset from its original value. Divide that number by the asset's lifespan. The result is the amount you can amortize each year. If the asset has no residual value, simply divide the initial value by the lifespan.

What is an example of amortization? ›

What Is an Example of Amortization? A company may amortize the cost of a patent over its useful life. Say the company owns the exclusive rights over a patent for 10 years, and the patent is not to renew at the end of the period.

What is amortization on financial calculator? ›

Amortization is the process of paying off a debt over time in equal installments. As you make payments, one portion goes toward the loan principal (the amount you borrowed) while the other goes toward 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.

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.

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

Top Articles
Haunted Mansion Showtimes Near Marcus Majestic Cinema Of Omaha
Nier Automata Chapter Select Unlock
Police in Germany arrest 25 people allegedly planning to overthrow the government
FTC challenge of biggest grocery deal ever captures Albertsons exec's surprise: 'You are basically creating a monopoly in grocery with the merger'
Rpg Maker Fullscreen
Myusu Canvas
Onedrive Txstate
Cars for Sale by Owner in Shreveport, LA
The TBM 930 Is Another Daher Masterpiece
Silnafil 25mg Tablet: View Uses, Side Effects, Price and Substitutes | 1mg
WHAT WE CAN DO | Arizona Tile
Kwik Kar Guymon Ok
Tnt Dinar Calls
Academic Calendar University Of Tampa
Tesla Holiday Update 2023.44.30.1 Includes FSD Beta 11.4.9 - TeslaNorth.com
Specialkfree Cooler.com
Best Restaurants Ventnor
‘Ant-Man and the Wasp: Quantumania’ Star Evangeline Lilly Is Finally Starting to Get a Handle on Hope van Dyne
Alex Bodger Stab Video
Katmoie
Indiana Jones 5 Showtimes Near Regal La Live
GOV.UK One Login: Designing for inclusion at scale
Emory Vein Clinic
Used Troy Bilt Tiller For Sale Craigslist
Ridgeline Endoscopy Center Dr Pool
Larry A.k.a Lvrd Pharaoh
Student Choice Odysseyware
World Wide Technology | LinkedIn
Fitbit FB504 Smart Watch User Manual FB505 FB504 user manual english
Mayas Mexican Pell City
History | Experience Meadville
248-898-5000
Rising Periscope Ru
Ncaaf Reference
Nyc To Tlv Google Flights
Kinepolis Nîmes Multiplexe - IMAX
Hyundai Scottsdale
Funeral Questions and Answers
Topeka Pets Craigslist
Ucsd Sfs
Wednesday Morning Gifs
Slmd Skincare Appointment
My Name Is Glenn Quagmire Lyrics
0Gomovies: Free Malayalam, Tamil & Hindi Movies - UK Journal
Covington Va Craigslist
Workstation. Scentsy.com
How to Find Who Your Competitors Are - Qualtrics
The Complete list of all Supermarkets in Curaçao  | Exploring Curaçao
Pet Urine Removal Bardstown Ky
Recent Vanderburgh County Arrest
Craigslist Greencastle
Latest Posts
Article information

Author: Corie Satterfield

Last Updated:

Views: 5549

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.