WebToolsEdge
CalculatorsFeatured

Amortization Schedule Calculator

Calculate loan payments and generate a full amortization schedule with principal, interest, remaining balance, extra payments, and CSV export.

Amortization Schedule Calculator

Build a full loan repayment schedule with principal, interest, balance, extra payments, and CSV export.

Principal vs interest chart

Visual split across the calculated loan life.

43.9% principal / 56.1% interest

Principal $250,000.00 Interest $318,861.22
Payment amount

$1,580.17

per month payment before optional extra payments

Total interest paid$318,861.22
Total amount paid$568,861.22
Payoff length360 months
Effective annual rate6.697%
Scheduled periods360 months
Final balance$0.00

Extra payments are applied every period and can shorten the payoff schedule. Balloon payment is treated as the planned final balance and included in the final payoff row.

Amortization schedule

Payment-by-payment principal, interest, and remaining balance.

#DatePaymentPrincipalInterestRemaining balance
12026-09-01$1,580.17$226.00$1,354.17$249,774.00
22026-10-01$1,580.17$227.23$1,352.94$249,546.77
32026-11-01$1,580.17$228.46$1,351.71$249,318.31
42026-12-01$1,580.17$229.70$1,350.47$249,088.61
52027-01-01$1,580.17$230.94$1,349.23$248,857.67
62027-02-01$1,580.17$232.19$1,347.98$248,625.48
72027-03-01$1,580.17$233.45$1,346.72$248,392.04
82027-04-01$1,580.17$234.71$1,345.46$248,157.32
92027-05-01$1,580.17$235.98$1,344.19$247,921.34
102027-06-01$1,580.17$237.26$1,342.91$247,684.07
112027-07-01$1,580.17$238.55$1,341.62$247,445.53
122027-08-01$1,580.17$239.84$1,340.33$247,205.69
132027-09-01$1,580.17$241.14$1,339.03$246,964.55
142027-10-01$1,580.17$242.45$1,337.72$246,722.10
152027-11-01$1,580.17$243.76$1,336.41$246,478.34
162027-12-01$1,580.17$245.08$1,335.09$246,233.26
172028-01-01$1,580.17$246.41$1,333.76$245,986.86
182028-02-01$1,580.17$247.74$1,332.43$245,739.12
192028-03-01$1,580.17$249.08$1,331.09$245,490.03
202028-04-01$1,580.17$250.43$1,329.74$245,239.60
212028-05-01$1,580.17$251.79$1,328.38$244,987.81
222028-06-01$1,580.17$253.15$1,327.02$244,734.66
232028-07-01$1,580.17$254.52$1,325.65$244,480.13
242028-08-01$1,580.17$255.90$1,324.27$244,224.23
252028-09-01$1,580.17$257.29$1,322.88$243,966.94
262028-10-01$1,580.17$258.68$1,321.49$243,708.26
272028-11-01$1,580.17$260.08$1,320.09$243,448.18
282028-12-01$1,580.17$261.49$1,318.68$243,186.68
292029-01-01$1,580.17$262.91$1,317.26$242,923.78
302029-02-01$1,580.17$264.33$1,315.84$242,659.44
312029-03-01$1,580.17$265.76$1,314.41$242,393.68
322029-04-01$1,580.17$267.20$1,312.97$242,126.47
332029-05-01$1,580.17$268.65$1,311.52$241,857.82
342029-06-01$1,580.17$270.11$1,310.06$241,587.72
352029-07-01$1,580.17$271.57$1,308.60$241,316.15
362029-08-01$1,580.17$273.04$1,307.13$241,043.10
372029-09-01$1,580.17$274.52$1,305.65$240,768.58
382029-10-01$1,580.17$276.01$1,304.16$240,492.58
392029-11-01$1,580.17$277.50$1,302.67$240,215.08
402029-12-01$1,580.17$279.01$1,301.16$239,936.07
412030-01-01$1,580.17$280.52$1,299.65$239,655.55
422030-02-01$1,580.17$282.04$1,298.13$239,373.52
432030-03-01$1,580.17$283.56$1,296.61$239,089.96
442030-04-01$1,580.17$285.10$1,295.07$238,804.86
452030-05-01$1,580.17$286.64$1,293.53$238,518.21
462030-06-01$1,580.17$288.20$1,291.97$238,230.02
472030-07-01$1,580.17$289.76$1,290.41$237,940.26
482030-08-01$1,580.17$291.33$1,288.84$237,648.93
492030-09-01$1,580.17$292.91$1,287.27$237,356.03
502030-10-01$1,580.17$294.49$1,285.68$237,061.53
512030-11-01$1,580.17$296.09$1,284.08$236,765.45
522030-12-01$1,580.17$297.69$1,282.48$236,467.76
532031-01-01$1,580.17$299.30$1,280.87$236,168.45
542031-02-01$1,580.17$300.92$1,279.25$235,867.53
552031-03-01$1,580.17$302.55$1,277.62$235,564.98
562031-04-01$1,580.17$304.19$1,275.98$235,260.78
572031-05-01$1,580.17$305.84$1,274.33$234,954.94
582031-06-01$1,580.17$307.50$1,272.67$234,647.44
592031-07-01$1,580.17$309.16$1,271.01$234,338.28
602031-08-01$1,580.17$310.84$1,269.33$234,027.44
612031-09-01$1,580.17$312.52$1,267.65$233,714.92
622031-10-01$1,580.17$314.21$1,265.96$233,400.71
632031-11-01$1,580.17$315.92$1,264.25$233,084.79
642031-12-01$1,580.17$317.63$1,262.54$232,767.16
652032-01-01$1,580.17$319.35$1,260.82$232,447.82
662032-02-01$1,580.17$321.08$1,259.09$232,126.74
672032-03-01$1,580.17$322.82$1,257.35$231,803.92
682032-04-01$1,580.17$324.57$1,255.60$231,479.36
692032-05-01$1,580.17$326.32$1,253.85$231,153.03
702032-06-01$1,580.17$328.09$1,252.08$230,824.94
712032-07-01$1,580.17$329.87$1,250.30$230,495.07
722032-08-01$1,580.17$331.66$1,248.51$230,163.42
732032-09-01$1,580.17$333.45$1,246.72$229,829.97
742032-10-01$1,580.17$335.26$1,244.91$229,494.71
752032-11-01$1,580.17$337.07$1,243.10$229,157.64
762032-12-01$1,580.17$338.90$1,241.27$228,818.74
772033-01-01$1,580.17$340.74$1,239.43$228,478.00
782033-02-01$1,580.17$342.58$1,237.59$228,135.42
792033-03-01$1,580.17$344.44$1,235.73$227,790.98
802033-04-01$1,580.17$346.30$1,233.87$227,444.68
812033-05-01$1,580.17$348.18$1,231.99$227,096.50
822033-06-01$1,580.17$350.06$1,230.11$226,746.44
832033-07-01$1,580.17$351.96$1,228.21$226,394.48
842033-08-01$1,580.17$353.87$1,226.30$226,040.61
852033-09-01$1,580.17$355.78$1,224.39$225,684.83
862033-10-01$1,580.17$357.71$1,222.46$225,327.12
872033-11-01$1,580.17$359.65$1,220.52$224,967.47
882033-12-01$1,580.17$361.60$1,218.57$224,605.87
892034-01-01$1,580.17$363.55$1,216.62$224,242.32
902034-02-01$1,580.17$365.52$1,214.65$223,876.79
912034-03-01$1,580.17$367.50$1,212.67$223,509.29
922034-04-01$1,580.17$369.49$1,210.68$223,139.80
932034-05-01$1,580.17$371.50$1,208.67$222,768.30
942034-06-01$1,580.17$373.51$1,206.66$222,394.79
952034-07-01$1,580.17$375.53$1,204.64$222,019.26
962034-08-01$1,580.17$377.57$1,202.60$221,641.69
972034-09-01$1,580.17$379.61$1,200.56$221,262.08
982034-10-01$1,580.17$381.67$1,198.50$220,880.42
992034-11-01$1,580.17$383.73$1,196.44$220,496.68
1002034-12-01$1,580.17$385.81$1,194.36$220,110.87
1012035-01-01$1,580.17$387.90$1,192.27$219,722.97
1022035-02-01$1,580.17$390.00$1,190.17$219,332.96
1032035-03-01$1,580.17$392.12$1,188.05$218,940.84
1042035-04-01$1,580.17$394.24$1,185.93$218,546.60
1052035-05-01$1,580.17$396.38$1,183.79$218,150.23
1062035-06-01$1,580.17$398.52$1,181.65$217,751.71
1072035-07-01$1,580.17$400.68$1,179.49$217,351.02
1082035-08-01$1,580.17$402.85$1,177.32$216,948.17
1092035-09-01$1,580.17$405.03$1,175.14$216,543.14
1102035-10-01$1,580.17$407.23$1,172.94$216,135.91
1112035-11-01$1,580.17$409.43$1,170.74$215,726.48
1122035-12-01$1,580.17$411.65$1,168.52$215,314.82
1132036-01-01$1,580.17$413.88$1,166.29$214,900.94
1142036-02-01$1,580.17$416.12$1,164.05$214,484.82
1152036-03-01$1,580.17$418.38$1,161.79$214,066.44
1162036-04-01$1,580.17$420.64$1,159.53$213,645.80
1172036-05-01$1,580.17$422.92$1,157.25$213,222.88
1182036-06-01$1,580.17$425.21$1,154.96$212,797.66
1192036-07-01$1,580.17$427.52$1,152.65$212,370.15
1202036-08-01$1,580.17$429.83$1,150.34$211,940.32
1212036-09-01$1,580.17$432.16$1,148.01$211,508.16
1222036-10-01$1,580.17$434.50$1,145.67$211,073.66
1232036-11-01$1,580.17$436.85$1,143.32$210,636.80
1242036-12-01$1,580.17$439.22$1,140.95$210,197.58
1252037-01-01$1,580.17$441.60$1,138.57$209,755.98
1262037-02-01$1,580.17$443.99$1,136.18$209,311.99
1272037-03-01$1,580.17$446.40$1,133.77$208,865.59
1282037-04-01$1,580.17$448.81$1,131.36$208,416.78
1292037-05-01$1,580.17$451.25$1,128.92$207,965.53
1302037-06-01$1,580.17$453.69$1,126.48$207,511.84
1312037-07-01$1,580.17$456.15$1,124.02$207,055.69
1322037-08-01$1,580.17$458.62$1,121.55$206,597.07
1332037-09-01$1,580.17$461.10$1,119.07$206,135.97
1342037-10-01$1,580.17$463.60$1,116.57$205,672.37
1352037-11-01$1,580.17$466.11$1,114.06$205,206.26
1362037-12-01$1,580.17$468.64$1,111.53$204,737.62
1372038-01-01$1,580.17$471.17$1,109.00$204,266.45
1382038-02-01$1,580.17$473.73$1,106.44$203,792.72
1392038-03-01$1,580.17$476.29$1,103.88$203,316.43
1402038-04-01$1,580.17$478.87$1,101.30$202,837.56
1412038-05-01$1,580.17$481.47$1,098.70$202,356.09
1422038-06-01$1,580.17$484.07$1,096.10$201,872.02
1432038-07-01$1,580.17$486.70$1,093.47$201,385.32
1442038-08-01$1,580.17$489.33$1,090.84$200,895.99
1452038-09-01$1,580.17$491.98$1,088.19$200,404.00
1462038-10-01$1,580.17$494.65$1,085.52$199,909.35
1472038-11-01$1,580.17$497.33$1,082.84$199,412.03
1482038-12-01$1,580.17$500.02$1,080.15$198,912.01
1492039-01-01$1,580.17$502.73$1,077.44$198,409.28
1502039-02-01$1,580.17$505.45$1,074.72$197,903.82
1512039-03-01$1,580.17$508.19$1,071.98$197,395.63
1522039-04-01$1,580.17$510.94$1,069.23$196,884.69
1532039-05-01$1,580.17$513.71$1,066.46$196,370.98
1542039-06-01$1,580.17$516.49$1,063.68$195,854.48
1552039-07-01$1,580.17$519.29$1,060.88$195,335.19
1562039-08-01$1,580.17$522.10$1,058.07$194,813.09
1572039-09-01$1,580.17$524.93$1,055.24$194,288.15
1582039-10-01$1,580.17$527.78$1,052.39$193,760.38
1592039-11-01$1,580.17$530.63$1,049.54$193,229.74
1602039-12-01$1,580.17$533.51$1,046.66$192,696.23
1612040-01-01$1,580.17$536.40$1,043.77$192,159.84
1622040-02-01$1,580.17$539.30$1,040.87$191,620.53
1632040-03-01$1,580.17$542.23$1,037.94$191,078.31
1642040-04-01$1,580.17$545.16$1,035.01$190,533.14
1652040-05-01$1,580.17$548.12$1,032.05$189,985.03
1662040-06-01$1,580.17$551.08$1,029.09$189,433.94
1672040-07-01$1,580.17$554.07$1,026.10$188,879.87
1682040-08-01$1,580.17$557.07$1,023.10$188,322.80
1692040-09-01$1,580.17$560.09$1,020.08$187,762.71
1702040-10-01$1,580.17$563.12$1,017.05$187,199.59
1712040-11-01$1,580.17$566.17$1,014.00$186,633.42
1722040-12-01$1,580.17$569.24$1,010.93$186,064.18
1732041-01-01$1,580.17$572.32$1,007.85$185,491.86
1742041-02-01$1,580.17$575.42$1,004.75$184,916.44
1752041-03-01$1,580.17$578.54$1,001.63$184,337.90
1762041-04-01$1,580.17$581.67$998.50$183,756.22
1772041-05-01$1,580.17$584.82$995.35$183,171.40
1782041-06-01$1,580.17$587.99$992.18$182,583.41
1792041-07-01$1,580.17$591.18$988.99$181,992.23
1802041-08-01$1,580.17$594.38$985.79$181,397.85
1812041-09-01$1,580.17$597.60$982.57$180,800.25
1822041-10-01$1,580.17$600.84$979.33$180,199.42
1832041-11-01$1,580.17$604.09$976.08$179,595.33
1842041-12-01$1,580.17$607.36$972.81$178,987.97
1852042-01-01$1,580.17$610.65$969.52$178,377.32
1862042-02-01$1,580.17$613.96$966.21$177,763.36
1872042-03-01$1,580.17$617.29$962.88$177,146.07
1882042-04-01$1,580.17$620.63$959.54$176,525.44
1892042-05-01$1,580.17$623.99$956.18$175,901.45
1902042-06-01$1,580.17$627.37$952.80$175,274.08
1912042-07-01$1,580.17$630.77$949.40$174,643.31
1922042-08-01$1,580.17$634.19$945.98$174,009.13
1932042-09-01$1,580.17$637.62$942.55$173,371.51
1942042-10-01$1,580.17$641.07$939.10$172,730.43
1952042-11-01$1,580.17$644.55$935.62$172,085.88
1962042-12-01$1,580.17$648.04$932.13$171,437.85
1972043-01-01$1,580.17$651.55$928.62$170,786.30
1982043-02-01$1,580.17$655.08$925.09$170,131.22
1992043-03-01$1,580.17$658.63$921.54$169,472.59
2002043-04-01$1,580.17$662.19$917.98$168,810.40
2012043-05-01$1,580.17$665.78$914.39$168,144.62
2022043-06-01$1,580.17$669.39$910.78$167,475.23
2032043-07-01$1,580.17$673.01$907.16$166,802.22
2042043-08-01$1,580.17$676.66$903.51$166,125.56
2052043-09-01$1,580.17$680.32$899.85$165,445.24
2062043-10-01$1,580.17$684.01$896.16$164,761.23
2072043-11-01$1,580.17$687.71$892.46$164,073.52
2082043-12-01$1,580.17$691.44$888.73$163,382.08
2092044-01-01$1,580.17$695.18$884.99$162,686.90
2102044-02-01$1,580.17$698.95$881.22$161,987.95
2112044-03-01$1,580.17$702.74$877.43$161,285.21
2122044-04-01$1,580.17$706.54$873.63$160,578.67
2132044-05-01$1,580.17$710.37$869.80$159,868.30
2142044-06-01$1,580.17$714.22$865.95$159,154.08
2152044-07-01$1,580.17$718.09$862.08$158,436.00
2162044-08-01$1,580.17$721.98$858.19$157,714.02
2172044-09-01$1,580.17$725.89$854.28$156,988.14
2182044-10-01$1,580.17$729.82$850.35$156,258.32
2192044-11-01$1,580.17$733.77$846.40$155,524.55
2202044-12-01$1,580.17$737.75$842.42$154,786.80
2212045-01-01$1,580.17$741.74$838.43$154,045.06
2222045-02-01$1,580.17$745.76$834.41$153,299.30
2232045-03-01$1,580.17$749.80$830.37$152,549.50
2242045-04-01$1,580.17$753.86$826.31$151,795.64
2252045-05-01$1,580.17$757.94$822.23$151,037.70
2262045-06-01$1,580.17$762.05$818.12$150,275.65
2272045-07-01$1,580.17$766.18$813.99$149,509.47
2282045-08-01$1,580.17$770.33$809.84$148,739.15
2292045-09-01$1,580.17$774.50$805.67$147,964.65
2302045-10-01$1,580.17$778.69$801.48$147,185.95
2312045-11-01$1,580.17$782.91$797.26$146,403.04
2322045-12-01$1,580.17$787.15$793.02$145,615.89
2332046-01-01$1,580.17$791.42$788.75$144,824.47
2342046-02-01$1,580.17$795.70$784.47$144,028.76
2352046-03-01$1,580.17$800.01$780.16$143,228.75
2362046-04-01$1,580.17$804.35$775.82$142,424.40
2372046-05-01$1,580.17$808.70$771.47$141,615.70
2382046-06-01$1,580.17$813.09$767.09$140,802.61
2392046-07-01$1,580.17$817.49$762.68$139,985.12
2402046-08-01$1,580.17$821.92$758.25$139,163.21

Showing the first 240 payments for page speed. Download the CSV to get all 360 payment rows.

This amortization calculator is an educational estimate only. Real lenders may use different rounding rules, fees, escrow charges, day-count conventions, taxes, or payment timing.

How to Use

  1. 1.

    Enter the loan amount or principal balance.

  2. 2.

    Enter the annual interest rate and select the payment frequency.

  3. 3.

    Add the loan term in years and months, then choose the start date.

  4. 4.

    Select the compounding option used for the estimate.

  5. 5.

    Add an optional extra payment or balloon payment if your loan includes one.

  6. 6.

    Review payment amount, total interest, total amount paid, principal vs interest chart, and the amortization schedule table.

  7. 7.

    Download the full schedule as a CSV file for Excel or Google Sheets.

Features

Loan payment calculation

Monthly, weekly, and yearly payment frequencies

Monthly, daily, and annual compounding options

Principal and interest breakdown for every payment

Remaining balance after each payment

Extra payment and prepayment support

Balloon payment option

Principal vs interest summary chart

Full amortization table

CSV export for spreadsheet use

Multiple currency display options

Copyable loan summary

Frequently Asked Questions

What is an amortization schedule?+

An amortization schedule is a table that shows every loan payment, including the payment date, payment amount, principal paid, interest paid, and remaining balance.

How does this amortization calculator work?+

It converts the annual interest rate into a payment-period rate, calculates the regular payment, then builds a schedule showing principal, interest, and balance after each payment.

Can I use this as a mortgage amortization calculator?+

Yes. Enter the mortgage amount, rate, term, start date, and monthly frequency to estimate a mortgage payment schedule.

Does the calculator support extra payments?+

Yes. Enter an extra payment amount and the schedule recalculates to show faster payoff and the updated interest total.

What is a balloon payment?+

A balloon payment is a larger final payment due at the end of the loan. The calculator treats the entered balloon amount as the planned final balance.

Can I download the amortization table?+

Yes. Use the Download CSV button to export the full schedule. CSV files can be opened in Excel, Google Sheets, Numbers, and other spreadsheet tools.

Why is the lender schedule different from this estimate?+

Lenders may use different compounding, rounding, payment dates, fees, escrow charges, variable rates, or day-count rules. Use this calculator as a planning estimate.

Is this calculator financial advice?+

No. It is an educational loan planning tool only. Confirm official numbers with your lender or a qualified financial professional.

About this tool

Free Amortization Schedule Calculator

Use the free WebToolsEdge Amortization Schedule Calculator to estimate a loan payment and build a payment-by-payment amortization table. Enter the loan amount, annual interest rate, loan term, start date, payment frequency, compounding option, and optional extra payment to see how each payment is split between principal and interest. A loan amortization schedule is useful because a single payment number does not show the full cost of borrowing. Early in many loans, a larger share of each payment goes toward interest. Later, as the balance falls, more of each payment goes toward principal. This calculator shows the payment number, payment date, total payment, principal paid, interest paid, and remaining balance after every scheduled payment. The tool supports monthly, weekly, and yearly payment schedules, making it useful as a mortgage amortization calculator, car loan amortization calculator, personal loan schedule calculator, business loan payment table, or general loan repayment planner. You can also compare monthly compounding, daily compounding, and annual compounding assumptions. Extra payments can make a major difference. Add an extra amount per payment period to see whether the loan could be paid off earlier and how the total interest changes. The calculator also includes a balloon payment field for loans where a planned final balance is paid at the end. For reporting, the full amortization schedule can be downloaded as a CSV file that opens in Excel, Google Sheets, Numbers, and most spreadsheet apps. Pair this calculator with the EMI Calculator for a quick monthly payment estimate, the Credit Card Payoff Calculator for revolving debt planning, the Debt-to-Income Ratio Calculator for affordability checks, and the Rent vs Buy Calculator when comparing home ownership costs. This amortization calculator is for educational planning only. Real lenders may use different rounding rules, fees, day-count conventions, escrow charges, taxes, variable rates, payment dates, and contract terms. Review official lender documents before making financial decisions.

Planning a vehicle purchase? Compare trade-in, flat or reducing rates, and car-specific fees with the Car Loan Calculator. Planning a home purchase? Calculate upfront cash, PMI, and affordability first with the Down Payment Calculator. If you only need a quick fixed monthly installment, start with the EMI Calculator. For credit card balances, the Credit Card Payoff Calculator is better suited to revolving debt. You can also check affordability with the Debt-to-Income Ratio Calculator or compare home decisions with the Rent vs Buy Calculator.