Loan Amortization Calculator With Amortization Schedules (2024)

Loan Amortization Calculator With Amortization Schedules (1)

Loan Payment Calculator With Amortization Schedule

This calculator will compute a loan's payment amount at various payment intervals -- based on the principal amount borrowed, the length of the loan and the annual interest rate. Then, once you have computed the payment, click on the "Create Amortization Schedule" button to create a chart you can print out.

We also offer more specific mortgage amortization & auto amortization calculators.

Simply enter the amount borrowed, the loan term, the stated APR & how frequently you make payments. We will quickly return your payment amount, total interest expense, total amount repaid & the equivalent interest-only payments to show how much you would end up spending on interest if you did not pay down the balance.

Enter the loan amount in the calculator if you know how much you will finance. If you are uncertain of how much you need to borrow, you can have it automatically calculated by entering any associated purchase, sales tax & application fees in the first section which appears if you expand the "Optional Advanced Data" drop down.

At the bottom of the calculator you can choose to create a share link for your calculation. We also provide the ability to create an inline amortization table below the calculator, or a printer friendly amortization table in a new window. Our site also offer specific calculators for auto loans & mortgages.

Current Potomac Personal Loan Rates

We publish current Potomac personal loan rates to help borrowers compare rates they are offered with current market conditions and connect borrowers with lenders offering competitive rates.

Amortization Calculations

Loan Amortization Calculator With Amortization Schedules (2)

Borrowed funds are paid back over time, using a variety of accounting methods. Once cash is borrowed, a repayment timeline begins, taking several factors into account. There is no cookie cutter approach to loan repayment, because the terms and conditions associated with each loan are unique. The length of time it takes to repay loans and the total amount of interest paid are functions of the agreements made between borrowers and lenders.

As repayment progresses, each billing cycle requires a particular payment, which is split between amounts applied to principal, and totals due resulting from interest charges. Amortization calculator tracks your responsibility for principal and interest payments, helping illustrate how long it will take to pay off your loan.

Schedules Show Payments

Loan Amortization Calculator With Amortization Schedules (3)

Amortization schedules use columns and rows to illustrate payment requirements over the entire life of a loan. Looking at the table allows borrowers to see exactly how loans are paid back, including the breakdown between interest and principal amounts applied.

If you are considering a major purchase, requiring a loan, amortization calculator furnishes a tool for predicting what payments will be. By inputting information like total loan amount, and interest terms, total payment schedules can be crafted for a variety of scenarios.

Affordability, especially for homes and vehicles, hinges on a number of influences, including personal income and total outstanding debt. As you assess your ability to finance major purchases, use amortization schedules to look ahead, outlining each future payment and its due date. Change calculations by altering parameters, creating side-by-side comparisons of amortization schedules.

The following table is an example of the type of table you can generate using the above calculator.

Payment # Payment Principal Interest Balance
1 $438.33 $271.66 $166.67 $24,728.34
2 $438.33 $273.47 $164.86 $24,454.87
3 $438.33 $275.30 $163.03 $24,179.57
4 $438.33 $277.13 $161.20 $23,902.44
5 $438.33 $278.98 $159.35 $23,623.46
6 $438.33 $280.84 $157.49 $23,342.62
7 $438.33 $282.71 $155.62 $23,059.91
8 $438.33 $284.60 $153.73 $22,775.31
9 $438.33 $286.49 $151.84 $22,488.82
10 $438.33 $288.40 $149.93 $22,200.42
11 $438.33 $290.33 $148.00 $21,910.09
12 $438.33 $292.26 $146.07 $21,617.83
Year 1 $3,382.17 $1,877.79
13 $438.33 $294.21 $144.12 $21,323.62
14 $438.33 $296.17 $142.16 $21,027.45
15 $438.33 $298.15 $140.18 $20,729.30
16 $438.33 $300.13 $138.20 $20,429.17
17 $438.33 $302.14 $136.19 $20,127.03
18 $438.33 $304.15 $134.18 $19,822.88
19 $438.33 $306.18 $132.15 $19,516.70
20 $438.33 $308.22 $130.11 $19,208.48
21 $438.33 $310.27 $128.06 $18,898.21
22 $438.33 $312.34 $125.99 $18,585.87
23 $438.33 $314.42 $123.91 $18,271.45
24 $438.33 $316.52 $121.81 $17,954.93
Year 2 $3,662.90 $1,597.06
25 $438.33 $318.63 $119.70 $17,636.30
26 $438.33 $320.75 $117.58 $17,315.55
27 $438.33 $322.89 $115.44 $16,992.66
28 $438.33 $325.05 $113.28 $16,667.61
29 $438.33 $327.21 $111.12 $16,340.40
30 $438.33 $329.39 $108.94 $16,011.01
31 $438.33 $331.59 $106.74 $15,679.42
32 $438.33 $333.80 $104.53 $15,345.62
33 $438.33 $336.03 $102.30 $15,009.59
34 $438.33 $338.27 $100.06 $14,671.32
35 $438.33 $340.52 $97.81 $14,330.80
36 $438.33 $342.79 $95.54 $13,988.01
Year 3 $3,966.92 $1,293.04
37 $438.33 $345.08 $93.25 $13,642.93
38 $438.33 $347.38 $90.95 $13,295.55
39 $438.33 $349.69 $88.64 $12,945.86
40 $438.33 $352.02 $86.31 $12,593.84
41 $438.33 $354.37 $83.96 $12,239.47
42 $438.33 $356.73 $81.60 $11,882.74
43 $438.33 $359.11 $79.22 $11,523.63
44 $438.33 $361.51 $76.82 $11,162.12
45 $438.33 $363.92 $74.41 $10,798.20
46 $438.33 $366.34 $71.99 $10,431.86
47 $438.33 $368.78 $69.55 $10,063.08
48 $438.33 $371.24 $67.09 $9,691.84
Year 4 $4,296.17 $963.79
49 $438.33 $373.72 $64.61 $9,318.12
50 $438.33 $376.21 $62.12 $8,941.91
51 $438.33 $378.72 $59.61 $8,563.19
52 $438.33 $381.24 $57.09 $8,181.95
53 $438.33 $383.78 $54.55 $7,798.17
54 $438.33 $386.34 $51.99 $7,411.83
55 $438.33 $388.92 $49.41 $7,022.91
56 $438.33 $391.51 $46.82 $6,631.40
57 $438.33 $394.12 $44.21 $6,237.28
58 $438.33 $396.75 $41.58 $5,840.53
59 $438.33 $399.39 $38.94 $5,441.14
60 $438.33 $402.06 $36.27 $5,039.08
Year 5 $4,652.76 $607.20
61 $438.33 $404.74 $33.59 $4,634.34
62 $438.33 $407.43 $30.90 $4,226.91
63 $438.33 $410.15 $28.18 $3,816.76
64 $438.33 $412.88 $25.45 $3,403.88
65 $438.33 $415.64 $22.69 $2,988.24
66 $438.33 $418.41 $19.92 $2,569.83
67 $438.33 $421.20 $17.13 $2,148.63
68 $438.33 $424.01 $14.32 $1,724.62
69 $438.33 $426.83 $11.50 $1,297.79
70 $438.33 $429.68 $8.65 $868.11
71 $438.33 $432.54 $5.79 $435.57
72 $438.47 $435.57 $2.90 $0.00
Year 6 $5,039.08 $221.02
Grand Total 25,000.00 6,559.90

Amortizing Loan Advantages

Loans are issued under a variety of terms, requiring borrowers to meet myriad repayment conditions. Some loans are weighted unevenly, calling for lump payments toward the end of financing periods. Amortization loans spread the principal payments more evenly, distributing the burden over the entire course of a loan's life. As final amortized payments near, borrowers are not subject to balloon payments or other irregularities. Instead, the original purchase price of the asset continues to amortize until it is completely paid-off.

Balloon loans, or bullet loans, operate under a different set of rules than standard amortizing loans. While both credit options are used to finance the same things: Homes, cars and other expensive purchases, the way they get paid back are entirely different. To start, bullet loans require large payments toward the end of each loan's life. Borrowers pay toward balloon loans over time, just like their amortizing counterparts, but their payments are applied primarily to interest obligations. As a result, loans carry through to their conclusions with large principal balances still intact. The only way to satisfy balloon mortgages and other similar credit instruments is to wipe out the entire remaining balance with one final payment.

While bullet loans serve vital functions for borrowers short on cash, they lead to problems when managed improperly. In many cases, balloon amounts are refinanced into conventional amortizing loans as they come due, spreading the payments out further. Whenever possible, use amortizing loan advantages to keep budgets manageable. Use loan payment calculator with amortization schedule to outline your debt responsibilities.

Loan Amortization Calculator With Amortization Schedules (2024)

FAQs

How do you calculate loan payments on 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.

Is there an Excel formula for amortization? ›

Excel PPMT Function (Principal)

The PPMT function in Excel calculates the periodic principal amortization owed on the loan, which, to reiterate from earlier, should increase after each payment period.

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;

Can I make my own amortization schedule? ›

User-friendliness: Excel is relatively user-friendly, so making an amortization schedule within the Excel program is fairly easy to do. Because of this, virtually anyone can create one of these schedules for their own business or personal financial purposes.

What is the formula for loan amortization installment? ›

Loan Amortization Formula

That is, if you are calculating monthly payment then 'i' should be taken as 'Interest Rate/12' In case the loan is for 2 years and the payments are to be made monthly, then n will be equal to: 12 x 2 = 24.

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.

Does Excel have an amortization schedule template? ›

Yes, Excel has a simple loan amortization schedule template available. It's fairly basic, so if you only need something with no frills, it can work for you.

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 formula for calculating loans in Excel? ›

To calculate EMIs and interest for Personal Loans using Excel, input the loan amount, annual interest rate and loan tenure into separate cells. Then, use the formula =PMT(B2/12, B3, B1) in the EMI cell where B2 is the interest rate, B3 is the tenure and B1 is the loan amount.

What is the formula for calculating amortized cost? ›

The amortization amount is calculated by taking the cost of the intangible asset minus any salvage value, divided by the number of years in its useful life.

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.

What is an example of amortization of a loan? ›

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.

How to open loan amortization schedule in Excel? ›

How to Create a Loan Amortization Schedule in Excel
  1. Step 1: Open a new Spreadsheet and Define Input Cells. ...
  2. Step 2: Create an Amortization Table with Labels. ...
  3. Step 3: Calculate Total Payments (PMT Formulae) ...
  4. Step 4: Calculate interest (IPMT formulae) ...
  5. Step 5: Calculate Principal (PPMT Formulae)
Jul 8, 2024

What is the difference between amortization and amortization schedule? ›

The amortization of loans is the process of paying down the debt over time in regular installment payments of interest and principal. An amortization schedule is a table or chart that outlines both loan and payment information for reducing a term loan (i.e., mortgage loan, personal loan, car loan, etc.).

How are the monthly payments on an amortized loan allocated? ›

Typically, the majority of each payment at the beginning of the loan term pays for interest and a smaller amount pays down the principal balance. Assuming regular payments, more of each following payment pays down your principal. This reduction of debt over time is amortization.

What is the formula for PMT? ›

For loans, the PMT function in XLS can be used to calculate the monthly payment. The mathematical formula for this PMT function is P = (Pv*R) / [1 - (1 + R)^(-n)] . Therefore, for a loan of $10,000 at an interest rate of 10% per annum, to be paid in one year, the result using PMT function is $879.16.

What is the formula for 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 draw a loan amortization schedule? ›

It's relatively easy to produce a loan amortization schedule if you know what the monthly payment on the loan is. 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.

References

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Pres. Lawanda Wiegand

Last Updated:

Views: 6005

Rating: 4 / 5 (51 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Pres. Lawanda Wiegand

Birthday: 1993-01-10

Address: Suite 391 6963 Ullrich Shore, Bellefort, WI 01350-7893

Phone: +6806610432415

Job: Dynamic Manufacturing Assistant

Hobby: amateur radio, Taekwondo, Wood carving, Parkour, Skateboarding, Running, Rafting

Introduction: My name is Pres. Lawanda Wiegand, I am a inquisitive, helpful, glamorous, cheerful, open, clever, innocent person who loves writing and wants to share my knowledge and understanding with you.