Amortization Calculator (2024)

home / financial / amortization calculator

Print

Amortization Calculator (1)

Amortization schedule


YearInterestPrincipalEnding Balance
1$11,769.23$8,483.33$191,516.67
2$11,246.00$9,006.57$182,510.10
3$10,690.49$9,562.07$172,948.02
4$10,100.72$10,151.84$162,796.18
5$9,474.58$10,777.98$152,018.20
6$8,809.82$11,442.75$140,575.45
7$8,104.05$12,148.51$128,426.94
8$7,354.76$12,897.80$115,529.13
9$6,559.25$13,693.31$101,835.82
10$5,714.68$14,537.89$87,297.94
11$4,818.01$15,434.55$71,863.38
12$3,866.04$16,386.52$55,476.86
13$2,855.36$17,397.21$38,079.66
14$1,782.34$18,470.23$19,609.43
15$643.13$19,609.43$-0.00

While the Amortization Calculator can serve as a basic tool for most, if not all, amortization calculations, there are other calculators available on this website that are more specifically geared for common amortization calculations.

Mortgage CalculatorAuto Loan Calculator
Investment CalculatorBusiness Loan Calculator
Personal Loan CalculatorFHA Loan Calculator
VA Mortgage CalculatorAnnuity Calculator

What is Amortization?

There are two general definitions of amortization. The first is the systematic repayment of a loan over time. The second is used in the context of business accounting and is the act of spreading the cost of an expensive and long-lived item over many periods. The two are explained in more detail in the sections below.

Paying Off a Loan Over Time

When a borrower takes out a mortgage, car loan, or personal loan, they usually make monthly payments to the lender; these are some of the most common uses of amortization. A part of the payment covers the interest due on the loan, and the remainder of the payment goes toward reducing the principal amount owed. Interest is computed on the current amount owed and thus will become progressively smaller as the principal decreases. It is possible to see this in action on the amortization table.

Credit cards, on the other hand, are generally not amortized. They are an example of revolving debt, where the outstanding balance can be carried month-to-month, and the amount repaid each month can be varied. Please use our Credit Card Calculator for more information or to do calculations involving credit cards, or our Credit Cards Payoff Calculator to schedule a financially feasible way to pay off multiple credit cards. Examples of other loans that aren't amortized include interest-only loans and balloon loans. The former includes an interest-only period of payment, and the latter has a large principal payment at loan maturity.

Amortization Schedule

An amortization schedule (sometimes called an amortization table) is a table detailing each periodic payment on an amortizing loan. Each calculation done by the calculator will also come with an annual and monthly amortization schedule above. Each repayment for an amortized loan will contain both an interest payment and payment towards the principal balance, which varies for each pay period. An amortization schedule helps indicate the specific amount that will be paid towards each, along with the interest and principal paid to date, and the remaining principal balance after each pay period.

Basic amortization schedules do not account for extra payments, but this doesn't mean that borrowers can't pay extra towards their loans. Also, amortization schedules generally do not consider fees. Generally, amortization schedules only work for fixed-rate loans and not adjustable-rate mortgages, variable rate loans, or lines of credit.

Spreading Costs

Certain businesses sometimes purchase expensive items that are used for long periods of time that are classified as investments. Items that are commonly amortized for the purpose of spreading costs include machinery, buildings, and equipment. From an accounting perspective, a sudden purchase of an expensive factory during a quarterly period can skew the financials, so its value is amortized over the expected life of the factory instead. Although it can technically be considered amortizing, this is usually referred to as the depreciation expense of an asset amortized over its expected lifetime. For more information about or to do calculations involving depreciation, please visit the Depreciation Calculator.

Amortization as a way of spreading business costs in accounting generally refers to intangible assets like a patent or copyright. Under Section 197 of U.S. law, the value of these assets can be deducted month-to-month or year-to-year. Just like with any other amortization, payment schedules can be forecasted by a calculated amortization schedule. The following are intangible assets that are often amortized:

  1. Goodwill, which is the reputation of a business regarded as a quantifiable asset
  2. Going-concern value, which is the value of a business as an ongoing entity
  3. The workforce in place (current employees, including their experience, education, and training)
  4. Business books and records, operating systems, or any other information base, including lists or other information concerning current or prospective customers
  5. Patents, copyrights, formulas, processes, designs, patterns, know-hows, formats, or similar items
  6. Customer-based intangibles, including customer bases and relationships with customers
  7. Supplier-based intangibles, including the value of future purchases due to existing relationships with vendors
  8. Licenses, permits, or other rights granted by governmental units or agencies (including issuances and renewals)
  9. Covenants not to compete or non-compete agreements entered relating to acquisitions of interests in trades or businesses
  10. Franchises, trademarks, or trade names
  11. Contracts for the use of or term interests in any items on this list

Some intangible assets, with goodwill being the most common example, that have indefinite useful lives or are "self-created" may not be legally amortized for tax purposes.

According to the IRS under Section 197, some assets are not considered intangibles, including interest in businesses, contracts, land, most computer software, intangible assets not acquired in connection with the acquiring of a business or trade, interest in an existing lease or sublease of a tangible property or existing debt, rights to service residential mortgages (unless it was acquired in connection with the acquisition of a trade or business), or certain transaction costs incurred by parties in which any part of a gain or loss is not recognized.

Amortizing Startup Costs

In the U.S., business startup costs, defined as costs incurred to investigate the potential of creating or acquiring an active business and costs to create an active business, can only be amortized under certain conditions. They must be expenses that are deducted as business expenses if incurred by an existing active business and must be incurred before the active business begins. Examples of these costs include consulting fees, financial analysis of potential acquisitions, advertising expenditures, and payments to employees, all of which must be incurred before the business is deemed active. According to IRS guidelines, initial startup costs must be amortized.

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

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

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.

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

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

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
Office Cabinets - Ready To Assemble & Pre-Assembled - The RTA Store
Brittany Furlan Talks Using 'Comedy to Cope', Life with Tommy Lee and Mental Health Struggles
Frases para un bendecido domingo: llena tu día con palabras de gratitud y esperanza - Blogfrases
Joi Databas
Uhauldealer.com Login Page
Craigslist Monterrey Ca
Skamania Lodge Groupon
Greedfall Console Commands
Coverage of the introduction of the Water (Special Measures) Bill
The 10 Best Restaurants In Freiburg Germany
Craigslist Parsippany Nj Rooms For Rent
Erskine Plus Portal
Red Wing Care Guide | Fat Buddha Store
Craigslist Nj North Cars By Owner
Poplar | Genus, Description, Major Species, & Facts
CHESAPEAKE WV :: Topix, Craigslist Replacement
Swimgs Yung Wong Travels Sophie Koch Hits 3 Tabs Winnie The Pooh Halloween Bob The Builder Christmas Springs Cow Dog Pig Hollywood Studios Beach House Flying Fun Hot Air Balloons, Riding Lessons And Bikes Pack Both Up Away The Alpha Baa Baa Twinkle
Midway Antique Mall Consignor Access
Bill Devane Obituary
fltimes.com | Finger Lakes Times
Trini Sandwich Crossword Clue
Darksteel Plate Deepwoken
Nashville Predators Wiki
Mani Pedi Walk Ins Near Me
Craigslist Panama City Fl
Craigslist Free Stuff Santa Cruz
Epro Warrant Search
Chelactiv Max Cream
Xsensual Portland
SN100C, An Australia Trademark of Nihon Superior Co., Ltd.. Application Number: 2480607 :: Trademark Elite Trademarks
How To Tighten Lug Nuts Properly (Torque Specs) | TireGrades
Bleacher Report Philadelphia Flyers
Wku Lpn To Rn
Jazz Total Detox Reviews 2022
The Procurement Acronyms And Abbreviations That You Need To Know Short Forms Used In Procurement
Craftsman Yt3000 Oil Capacity
La Qua Brothers Funeral Home
Indiana Jones 5 Showtimes Near Jamaica Multiplex Cinemas
Phone number detective
Bus Dublin : guide complet, tarifs et infos pratiques en 2024 !
Puffco Peak 3 Red Flashes
Section 212 at MetLife Stadium
Unveiling Gali_gool Leaks: Discoveries And Insights
Lawrence E. Moon Funeral Home | Flint, Michigan
Petfinder Quiz
Tropical Smoothie Address
Underground Weather Tropical
Christie Ileto Wedding
Automatic Vehicle Accident Detection and Messageing System – IJERT
Electric Toothbrush Feature Crossword
Service Changes and Self-Service Options
Palmyra Authentic Mediterranean Cuisine مطعم أبو سمرة
Latest Posts
Article information

Author: Prof. An Powlowski

Last Updated:

Views: 6353

Rating: 4.3 / 5 (44 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Prof. An Powlowski

Birthday: 1992-09-29

Address: Apt. 994 8891 Orval Hill, Brittnyburgh, AZ 41023-0398

Phone: +26417467956738

Job: District Marketing Strategist

Hobby: Embroidery, Bodybuilding, Motor sports, Amateur radio, Wood carving, Whittling, Air sports

Introduction: My name is Prof. An Powlowski, I am a charming, helpful, attractive, good, graceful, thoughtful, vast person who loves writing and wants to share my knowledge and understanding with you.