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 the amount of amortization? ›

A loan amortization schedule is calculated using the loan amount, loan term, and interest rate. If you know these three things, you can use Excel's PMT function to calculate your monthly payment. In our example above, the information to enter in an Excel cell would be =PMT(3.5%/12,360,150000).

How do you calculate amortization value? ›

You can follow these steps to calculate the amortization for an intangible asset:
  1. Find the basis and residual value. Calculating the amortization of an intangible asset is like calculating its depreciation. ...
  2. Divide by the remaining months. ...
  3. Record the cost on your income statement.
Jul 1, 2024

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.

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.

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

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.

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 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 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 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.

How is amortized cost calculated? ›

The key elements of the amortised cost calculation are: The amount at which the financial asset or liability is measured at initial recognition. Minus any principal repayments. Plus or minus the cumulative amortisation of any difference between the initial amount and maturity amount using the effective interest method.

How do you 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 amortization in simple words? ›

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.

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

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. Multiply that number by your remaining loan balance to find out how much you'll pay in interest that month.

References

Top Articles
Quincy Hall’s incredible charge and 4 other takeaways from a dramatic night of track and field at the Olympics | CNN
Olympic quick hits: Masked shot putter steals the limelight, daughters of footy stars shine in the pool, and gold medallist pays tribute to dead dog
Hub.vacation Club.com
Ogre From Halloweentown
Social Security Administration Lubbock Reviews
24 Hour Car Wash Queens Ny
Air Chat En Espanol
Between Friends Comic Strip Today
Amazon Ups Drop Off Locations Near Me
Dr Frita Mcrae Fisher Husband
Umass Medhub
Craig Woolard Net Worth
8x20, 8x40 Shipping containers storage container for rent or sale - general for sale - by dealer - craigslist
What You Need to Know About County Jails
Www.1Tamilmv.con
Rooms for rent in Pompano Beach, Broward County, FL
Pokewilds Wiki
Bullocks Grocery Weekly Ad
Skyward New Richmond Wi
Great Clips Coupons → 20% Off | Sep 2024
Word Jam 1302
Dyi Urban Dictionary
Animal Eye Clinic Huntersville Nc
Pole Barns 101: Everything You Need to Know - Big Buildings Direct
2010 Ford F-350 Super Duty XLT for sale - Wadena, MN - craigslist
Exploring Green-Wood Cemetery: New York Citys First Garden Cemetery | Prospect Park West Entrance,Brooklyn,11218,US | October 6, 2024
Space Coast Rottweilers
Ok Google Zillow
Harris Teeter Weekly Ad Williamsburg Va
Cavender's Boot City Killeen Photos
Reasonabiu
Course schedule | Fall 2022 | Office of the Registrar
Age Gabriela Moura's Evolution from Childhood Dreams to TikTok Fame - Essential Tribune
Lufthansa LH456 (DLH456) from Frankfurt to Los Angeles
Baldurs Gate 3 Igg
Lincoln Financial Field Section 110
Cbs Scores Mlb
Dumb Money Showtimes Near Maya Cinemas Salinas
Boise Craigslist Cars And Trucks - By Owner
Iconnect Seton
Americas Cardroom Promo Code For Existing Users
Dust Cornell
New York Sports Club Carmel Hamlet Photos
Watch ESPN - Stream Live Sports & ESPN Originals
China Rose Plant Care: Water, Light, Nutrients | Greg App 🌱
Tacos Diego Hugoton Ks
Kens5 Great Day Sa
The Stock Exchange Kamas
911 Active Calls Caddo
5613192063
Omaha World-Herald from Omaha, Nebraska
Truck Trader Pennsylvania
Latest Posts
Article information

Author: Otha Schamberger

Last Updated:

Views: 5695

Rating: 4.4 / 5 (75 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Otha Schamberger

Birthday: 1999-08-15

Address: Suite 490 606 Hammes Ferry, Carterhaven, IL 62290

Phone: +8557035444877

Job: Forward IT Agent

Hobby: Fishing, Flying, Jewelry making, Digital arts, Sand art, Parkour, tabletop games

Introduction: My name is Otha Schamberger, I am a vast, good, healthy, cheerful, energetic, gorgeous, magnificent person who loves writing and wants to share my knowledge and understanding with you.