Amortization Schedule

Amortization Schedule Calculator is a tool to calculate mortgage and loan payments and generates a free printable amortization schedule with fixed monthly payments. The amortization table is exportable as an Excel spreadsheet and a pdf file.

Amortization Calculator
Loan Amount		Loan Terms	years
Interest Rate		First Payment Date	Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038
Amortization Schedule	Show By Month Year

Amortization Schedule Calculator
Loan Amount:	$100,000.00
Monthly Payment:	$1,205.36
Total # Of Payments:	120
Start Date:	Oct, 2024
Payoff Date:	Sep, 2034
Total Interest Paid:	$44,643.74
Total Payment:	$144,643.74

Printable Amortization Schedule
Payment Date	Payment #	Interest Paid	Principal Paid	Total Payment	Remaining Balance
Oct, 2024	1	$654.17	$551.20	$1,205.36	$99,448.80
Nov, 2024	2	$650.56	$554.80	$1,205.36	$98,894.00
Dec, 2024	3	$646.93	$558.43	$1,205.36	$98,335.57
Jan, 2025	4	$643.28	$562.09	$1,205.36	$97,773.48
Feb, 2025	5	$639.60	$565.76	$1,205.36	$97,207.72
Mar, 2025	6	$635.90	$569.46	$1,205.36	$96,638.25
Apr, 2025	7	$632.18	$573.19	$1,205.36	$96,065.06
May, 2025	8	$628.43	$576.94	$1,205.36	$95,488.12
Jun, 2025	9	$624.65	$580.71	$1,205.36	$94,907.41
Jul, 2025	10	$620.85	$584.51	$1,205.36	$94,322.90
Aug, 2025	11	$617.03	$588.34	$1,205.36	$93,734.56
Sep, 2025	12	$613.18	$592.18	$1,205.36	$93,142.38
Oct, 2025	13	$609.31	$596.06	$1,205.36	$92,546.32
Nov, 2025	14	$605.41	$599.96	$1,205.36	$91,946.37
Dec, 2025	15	$601.48	$603.88	$1,205.36	$91,342.48
Jan, 2026	16	$597.53	$607.83	$1,205.36	$90,734.65
Feb, 2026	17	$593.56	$611.81	$1,205.36	$90,122.84
Mar, 2026	18	$589.55	$615.81	$1,205.36	$89,507.03
Apr, 2026	19	$585.53	$619.84	$1,205.36	$88,887.19
May, 2026	20	$581.47	$623.89	$1,205.36	$88,263.30
Jun, 2026	21	$577.39	$627.98	$1,205.36	$87,635.32
Jul, 2026	22	$573.28	$632.08	$1,205.36	$87,003.24
Aug, 2026	23	$569.15	$636.22	$1,205.36	$86,367.02
Sep, 2026	24	$564.98	$640.38	$1,205.36	$85,726.64
Oct, 2026	25	$560.80	$644.57	$1,205.36	$85,082.07
Nov, 2026	26	$556.58	$648.79	$1,205.36	$84,433.29
Dec, 2026	27	$552.33	$653.03	$1,205.36	$83,780.26
Jan, 2027	28	$548.06	$657.30	$1,205.36	$83,122.95
Feb, 2027	29	$543.76	$661.60	$1,205.36	$82,461.35
Mar, 2027	30	$539.43	$665.93	$1,205.36	$81,795.42
Apr, 2027	31	$535.08	$670.29	$1,205.36	$81,125.14
May, 2027	32	$530.69	$674.67	$1,205.36	$80,450.46
Jun, 2027	33	$526.28	$679.08	$1,205.36	$79,771.38
Jul, 2027	34	$521.84	$683.53	$1,205.36	$79,087.85
Aug, 2027	35	$517.37	$688.00	$1,205.36	$78,399.86
Sep, 2027	36	$512.87	$692.50	$1,205.36	$77,707.36
Oct, 2027	37	$508.34	$697.03	$1,205.36	$77,010.33
Nov, 2027	38	$503.78	$701.59	$1,205.36	$76,308.74
Dec, 2027	39	$499.19	$706.18	$1,205.36	$75,602.56
Jan, 2028	40	$494.57	$710.80	$1,205.36	$74,891.76
Feb, 2028	41	$489.92	$715.45	$1,205.36	$74,176.32
Mar, 2028	42	$485.24	$720.13	$1,205.36	$73,456.19
Apr, 2028	43	$480.53	$724.84	$1,205.36	$72,731.35
May, 2028	44	$475.78	$729.58	$1,205.36	$72,001.77
Jun, 2028	45	$471.01	$734.35	$1,205.36	$71,267.42
Jul, 2028	46	$466.21	$739.16	$1,205.36	$70,528.26
Aug, 2028	47	$461.37	$743.99	$1,205.36	$69,784.27
Sep, 2028	48	$456.51	$748.86	$1,205.36	$69,035.41
Oct, 2028	49	$451.61	$753.76	$1,205.36	$68,281.65
Nov, 2028	50	$446.68	$758.69	$1,205.36	$67,522.96
Dec, 2028	51	$441.71	$763.65	$1,205.36	$66,759.31
Jan, 2029	52	$436.72	$768.65	$1,205.36	$65,990.66
Feb, 2029	53	$431.69	$773.68	$1,205.36	$65,216.99
Mar, 2029	54	$426.63	$778.74	$1,205.36	$64,438.25
Apr, 2029	55	$421.53	$783.83	$1,205.36	$63,654.42
May, 2029	56	$416.41	$788.96	$1,205.36	$62,865.46
Jun, 2029	57	$411.24	$794.12	$1,205.36	$62,071.34
Jul, 2029	58	$406.05	$799.31	$1,205.36	$61,272.03
Aug, 2029	59	$400.82	$804.54	$1,205.36	$60,467.48
Sep, 2029	60	$395.56	$809.81	$1,205.36	$59,657.68
Oct, 2029	61	$390.26	$815.10	$1,205.36	$58,842.57
Nov, 2029	62	$384.93	$820.44	$1,205.36	$58,022.14
Dec, 2029	63	$379.56	$825.80	$1,205.36	$57,196.34
Jan, 2030	64	$374.16	$831.21	$1,205.36	$56,365.13
Feb, 2030	65	$368.72	$836.64	$1,205.36	$55,528.49
Mar, 2030	66	$363.25	$842.12	$1,205.36	$54,686.37
Apr, 2030	67	$357.74	$847.62	$1,205.36	$53,838.75
May, 2030	68	$352.20	$853.17	$1,205.36	$52,985.58
Jun, 2030	69	$346.61	$858.75	$1,205.36	$52,126.83
Jul, 2030	70	$341.00	$864.37	$1,205.36	$51,262.46
Aug, 2030	71	$335.34	$870.02	$1,205.36	$50,392.44
Sep, 2030	72	$329.65	$875.71	$1,205.36	$49,516.72
Oct, 2030	73	$323.92	$881.44	$1,205.36	$48,635.28
Nov, 2030	74	$318.16	$887.21	$1,205.36	$47,748.07
Dec, 2030	75	$312.35	$893.01	$1,205.36	$46,855.06
Jan, 2031	76	$306.51	$898.85	$1,205.36	$45,956.21
Feb, 2031	77	$300.63	$904.73	$1,205.36	$45,051.47
Mar, 2031	78	$294.71	$910.65	$1,205.36	$44,140.82
Apr, 2031	79	$288.75	$916.61	$1,205.36	$43,224.21
May, 2031	80	$282.76	$922.61	$1,205.36	$42,301.60
Jun, 2031	81	$276.72	$928.64	$1,205.36	$41,372.96
Jul, 2031	82	$270.65	$934.72	$1,205.36	$40,438.24
Aug, 2031	83	$264.53	$940.83	$1,205.36	$39,497.41
Sep, 2031	84	$258.38	$946.99	$1,205.36	$38,550.43
Oct, 2031	85	$252.18	$953.18	$1,205.36	$37,597.25
Nov, 2031	86	$245.95	$959.42	$1,205.36	$36,637.83
Dec, 2031	87	$239.67	$965.69	$1,205.36	$35,672.14
Jan, 2032	88	$233.36	$972.01	$1,205.36	$34,700.13
Feb, 2032	89	$227.00	$978.37	$1,205.36	$33,721.76
Mar, 2032	90	$220.60	$984.77	$1,205.36	$32,736.99
Apr, 2032	91	$214.15	$991.21	$1,205.36	$31,745.78
May, 2032	92	$207.67	$997.69	$1,205.36	$30,748.09
Jun, 2032	93	$201.14	$1,004.22	$1,205.36	$29,743.87
Jul, 2032	94	$194.57	$1,010.79	$1,205.36	$28,733.08
Aug, 2032	95	$187.96	$1,017.40	$1,205.36	$27,715.68
Sep, 2032	96	$181.31	$1,024.06	$1,205.36	$26,691.62
Oct, 2032	97	$174.61	$1,030.76	$1,205.36	$25,660.86
Nov, 2032	98	$167.86	$1,037.50	$1,205.36	$24,623.36
Dec, 2032	99	$161.08	$1,044.29	$1,205.36	$23,579.08
Jan, 2033	100	$154.25	$1,051.12	$1,205.36	$22,527.96
Feb, 2033	101	$147.37	$1,057.99	$1,205.36	$21,469.96
Mar, 2033	102	$140.45	$1,064.92	$1,205.36	$20,405.05
Apr, 2033	103	$133.48	$1,071.88	$1,205.36	$19,333.17
May, 2033	104	$126.47	$1,078.89	$1,205.36	$18,254.28
Jun, 2033	105	$119.41	$1,085.95	$1,205.36	$17,168.32
Jul, 2033	106	$112.31	$1,093.06	$1,205.36	$16,075.27
Aug, 2033	107	$105.16	$1,100.21	$1,205.36	$14,975.06
Sep, 2033	108	$97.96	$1,107.40	$1,205.36	$13,867.66
Oct, 2033	109	$90.72	$1,114.65	$1,205.36	$12,753.01
Nov, 2033	110	$83.43	$1,121.94	$1,205.36	$11,631.08
Dec, 2033	111	$76.09	$1,129.28	$1,205.36	$10,501.80
Jan, 2034	112	$68.70	$1,136.67	$1,205.36	$9,365.13
Feb, 2034	113	$61.26	$1,144.10	$1,205.36	$8,221.03
Mar, 2034	114	$53.78	$1,151.59	$1,205.36	$7,069.45
Apr, 2034	115	$46.25	$1,159.12	$1,205.36	$5,910.33
May, 2034	116	$38.66	$1,166.70	$1,205.36	$4,743.63
Jun, 2034	117	$31.03	$1,174.33	$1,205.36	$3,569.29
Jul, 2034	118	$23.35	$1,182.02	$1,205.36	$2,387.28
Aug, 2034	119	$15.62	$1,189.75	$1,205.36	$1,197.53
Sep, 2034	120	$7.83	$1,197.53	$1,205.36	$0.00

Amortization Schedule Calculator

The free amortization schedule and amortization chart will show you the mortgage payment schedule with all the details about your monthly loan payments, including principal, interest, and loan balance. You can view the loan amortization schedule with dates annually and monthly. The monthly amortization schedule is printer friendly, easily exportable to excel, and downloadable as a pdf file. The amortization schedule works even for loans with a zero interest rate.

What is an amortization schedule?

A loan or mortgage amortization schedule with fixed monthly payment is a table that shows borrowers their loan payments. The monthly loan payment is determined by the loan amount, interest rate, and terms. Initially, most monthly payments go to paying interest rather than reducing the principal. As time goes by, the interest and principal payments start to balance and eventually reverse, where the principal amount becomes larger than the interest on each payment. On a fixed interest loan or a 30-year fixed mortgage, the monthly payment is the same each month, whereas a mortgage with an adjustable rate will see its monthly payments fluctuate from time to time.

How does an amortization schedule work?

With fixed monthly loan payments, part of the payment is for principal and the rest is for interest payments. At the beginning of a 30-year fixed mortgage term, a large part of the monthly payment is for paying interest. It could take years for the principal to catch up with interest payments as you pay down your debt. Towards the end of the term, the majority of the monthly payments will then shift to principal payments. It is important that you understand your amortization schedule so that you know how much you are paying in interest payments and how much you are paying down your debt. You will also learn if it is worth it to refinance when the interest goes down and know when is the best time for refinancing your mortgage.

What does an amortization table show?

A typical mortgage or loan amortization schedule should show the interest payment, principal payment, total payment, and the remaining balance of the loan for each pay period, usually every month. Following is a sample amortization schedule table that shows the amortization chart for a 30-year mortgage with a $350,000 balance and a 5.25% interest rate.

Amortization Schedule Example
Payment Date	Payment #	Interest	Principal	Total Payment	Remaining Balance
Jun, 2022	1	$1,531.25	$401.46	$1,932.71	$349,598.54
Jul, 2022	2	$1,529.49	$403.22	$1,932.71	$349,195.32
Aug, 2022	3	$1,527.73	$404.98	$1,932.71	$348,790.33
Sep, 2022	4	$1,525.96	$406.76	$1,932.71	$348,383.58
Oct, 2022	5	$1,524.18	$408.53	$1,932.71	$347,975.04
...	...	...	...	...	...
...	...	...	...	...	...
...	...	...	...	...	...
Jan, 2052	356	$41.73	$1,890.98	$1,932.71	$7,647.03
Feb, 2052	357	$33.46	$1,899.26	$1,932.71	$5,747.77
Mar, 2052	358	$25.15	$1,907.57	$1,932.71	$3,840.21
Apr, 2052	359	$16.80	$1,915.91	$1,932.71	$1,924.29
May, 2052	360	$8.42	$1,924.29	$1,932.71	$0.00

How to read an amortization schedule?

There are four main components of an amortization schedule, interest, principal, total payment, and remaining balance. Interest - The interest payment that borrowers need to pay back the lender on a monthly basis with a fixed interest rate. Principal - The principal payment that would reduce the mortgage balance. Total Payment - The total monthly payment which is interest plus principal. Remaining Balance - The remaining balance after deducting the principal payment from the current balance. As we can see from the mortgage amortization table above, the principal amount is less than 1/3 of the interest payment in the initial stage. As time progresses, the payments between interest and principal start to balance and eventually reverse where the principal payment is larger than the interest payment.

How to calculate monthly mortgage payments?

The amortization schedule formula on how to calculate monthly mortgage payments is given below. M = (P *i) / (1 - 1 / (1 + i)^ n)) where M = monthly payment P = principal loan amount i = interest rate n = number of months to pay off the loan For example, to calculate the monthly payments for a 30-year fixed mortgage with an interest rate of 5%, and a principal loan amount of $200,000, we would plugin the above formula with our numbers. Step 1 - convert the numbers Monthly Interest Rate = 5% = 5/12/100 = 0.004167 - the interest rate has to be divided by 12 to get the monthly interest rate, and divided by 100 to convert percent to decimal. The Number of months = 12 x 30 = 360 - convert the number of years to several months. Step 2 - plugin the monthly payment formula M = (P *i) / (1 - 1 / (1 + i)^ n)) M = 200,000 x 0.004167/(1 - 1/(1 + 0.004167) ^ 360) M = 833.4/(1 - 1/1.004167^360) M = 833.4/(1- 1/4.46828) M = 833.4/(1 - 0.2238) M = 833.4/(0.7762) M = 1073.64 Therefore, the monthly payment for a loan of $200,000 with a fixed 30-year loan and a 5% interest rate is $1,073.69.

How to create an amortization schedule?

To create an amortization schedule by hand, we need to use the monthly payment that we've just calculated above.

• Find the monthly interest payment - take the interest rate and divide by 12 to get the monthly interest rate, and then multiply the total loan amount by the monthly interest to get the interest payment for that month.
• Find the monthly principal payment - subtract the monthly interest payment from the total monthly payment to get the principal payment.
• Remaining balance - subtract the monthly principal payment from the loan amount to get the remaining balance.
• Repeat the above steps - repeat until the balance of your loan is 0. Starting from the second payment, you need to use the remaining balance instead of the initial loan amount in your calculation for steps 1 & 3.

Let's try to create an amortization schedule with our previous example. We've already calculated the monthly payments to be $1,073.64 for a 30-year fixed interest rate with 5% and a principal of $200,000. Step 1 - Find the monthly interest payment Monthly Interest Payment = 0.004167 x $200,000 = $833.33, the monthly interest rate is 0.004167 or 5%/12/100. Step 2 - Find the monthly principal payment Monthly Principal Payment = Monthly Payment - Interest Payment = $1,073.64 - $833.33 = $240.31 Step 3 - Find the remaining balance  Remaining Balance = $200,000 - $240.31 = $199,759.69 Step 4 - Repeat step 1 - 3 The above step 1 to 3 gives us the amortization schedule for the first month, to get the amortization schedule for all 360 payments (12 x 30 years = 360), we need to keep repeating step 1 to 3. Instead of using the principal loan amount in our calculation in steps 1 & 3, we use the remaining balance. Following the 4 steps above, we created an amortization table that looks like the following.

Amortization Table
Payment Date	Payment #	Interest Paid	Principal Paid	Total Payment	Remaining Balance
Jun, 2022	1	$833.33	$240.31	$1,073.64	$199,759.69
Jul, 2022	2	$832.33	$241.31	$1,073.64	$199,518.38
Aug, 2022	3	$831.33	$242.32	$1,073.64	$199,276.06
Sep, 2022	4	$830.32	$243.33	$1,073.64	$199,032.74
Oct, 2022	5	$829.30	$244.34	$1,073.64	$198,788.40
...	...	...	...	...	...
...	...	...	...	...	...
...	...	...	...	...	...
Jan, 2052	356	$22.09	$1,051.55	$1,073.64	$4,250.21
Feb, 2052	357	$17.71	$1,055.93	$1,073.64	$3,194.27
Mar, 2052	358	$13.31	$1,060.33	$1,073.64	$2,133.94
Apr, 2052	359	$8.89	$1,064.75	$1,073.64	$1,069.19
May, 2052	360	$4.45	$1,069.19	$1,073.64	$0.00

To make life easier, we've created this amortization schedule calculator to generate an amortization table for your mortgage payments. Borrowers can easily view, print, and download the loan amortization schedule for their loans.

How to Use The Amortization Calculator?

Our Amortization calculator requires only three fields, the loan amount, loan terms, and the interest rate. Loan Amount - The loan amount for your home mortgage, car loan, or any other type of loan. Loan Terms - The term for your loan. The most common home mortgage terms are 15 and 30 years. Interest Rate - The fixed interest rate for your loan, this is the interest that you will pay back to your lender or bank. First Payment Date - This is an optional field that allows you to create an amortization schedule that starts in the future or past the date. Amortization schedule - You have the option to view the amortization table monthly and annually. The default for the amortization schedule is monthly.

Amortization Schedule With Fixed Monthly Payment

The amortization schedule calculator will generate an amortization schedule with fixed monthly payment. This means this amortization calculator is for fixed interest rates loans and mortgages only. If you need to create an amortization schedule with an adjustable rate, use the adjustable rate mortgage calculator. You can also use the biweekly amortization schedule to create an amortization schedule with biweekly payment options. Those who want to pay off their loans earlier can use the extra payment amortization schedule to calculate how much they can save in interest payments and how much earlier they can pay off their loans.

Amortization Schedule Excel

There are many good tutorials online on how to create an amortization schedule in excel, so we won't repeat the steps here. Instead, we give borrowers the option to download their amortization schedule in excel so that they don't have to do it manually in excel. Simply enter the loan information, and the amortization schedule calculator will calculate the monthly mortgage payments with an amortization schedule excel that you can export.

Amortization Schedule PDF

The amortization schedule PDF gives users the option to generate a printable loan amortization schedule in PDF format. Enter all the necessary information such as the loan amount, interest rate, and the terms, you can then generate a PDF amortization schedule that you can print and share with others.

Compare Today's Mortgage Rates
Today's Home Equity Rates


Check Today's Mortgage Rates


Compare Today's Mortgage Rates
Check HELOC Rates