Amortization Schedule

Amortization Schedule is an amortization calculator used to calculate mortgage or loan payments and generates a printable amortization schedule with fixed monthly payments. You can use this online amortization schedule calculator to calculate monthly payments for any type of loans, such as student loans, personal loans, car loans, or home mortgages. The amortization table is exportable as a free printable amortization schedule excel spreadsheet and pdf file.

Loan Summary
Loan Amount:	$100,000.00
Monthly Payment:	$1,060.66
Total # Of Payments:	120
Start Date:	Aug, 2022
Payoff Date:	Jul, 2032
Total Interest Paid:	$27,278.62
Total Payment:	$127,278.62

Payment Date	Payment #	Interest Paid	Principal Paid	Total Payment	Remaining Balance
Printable Amortization Schedule
Aug, 2022	1	$416.67	$643.99	$1,060.66	$99,356.01
Sep, 2022	2	$413.98	$646.67	$1,060.66	$98,709.34
Oct, 2022	3	$411.29	$649.37	$1,060.66	$98,059.97
Nov, 2022	4	$408.58	$652.07	$1,060.66	$97,407.90
Dec, 2022	5	$405.87	$654.79	$1,060.66	$96,753.11
Jan, 2023	6	$403.14	$657.52	$1,060.66	$96,095.60
Feb, 2023	7	$400.40	$660.26	$1,060.66	$95,435.34
Mar, 2023	8	$397.65	$663.01	$1,060.66	$94,772.33
Apr, 2023	9	$394.88	$665.77	$1,060.66	$94,106.56
May, 2023	10	$392.11	$668.54	$1,060.66	$93,438.02
Jun, 2023	11	$389.33	$671.33	$1,060.66	$92,766.69
Jul, 2023	12	$386.53	$674.13	$1,060.66	$92,092.56
Aug, 2023	13	$383.72	$676.94	$1,060.66	$91,415.62
Sep, 2023	14	$380.90	$679.76	$1,060.66	$90,735.87
Oct, 2023	15	$378.07	$682.59	$1,060.66	$90,053.28
Nov, 2023	16	$375.22	$685.43	$1,060.66	$89,367.84
Dec, 2023	17	$372.37	$688.29	$1,060.66	$88,679.55
Jan, 2024	18	$369.50	$691.16	$1,060.66	$87,988.40
Feb, 2024	19	$366.62	$694.04	$1,060.66	$87,294.36
Mar, 2024	20	$363.73	$696.93	$1,060.66	$86,597.43
Apr, 2024	21	$360.82	$699.83	$1,060.66	$85,897.60
May, 2024	22	$357.91	$702.75	$1,060.66	$85,194.85
Jun, 2024	23	$354.98	$705.68	$1,060.66	$84,489.17
Jul, 2024	24	$352.04	$708.62	$1,060.66	$83,780.56
Aug, 2024	25	$349.09	$711.57	$1,060.66	$83,068.99
Sep, 2024	26	$346.12	$714.53	$1,060.66	$82,354.45
Oct, 2024	27	$343.14	$717.51	$1,060.66	$81,636.94
Nov, 2024	28	$340.15	$720.50	$1,060.66	$80,916.44
Dec, 2024	29	$337.15	$723.50	$1,060.66	$80,192.94
Jan, 2025	30	$334.14	$726.52	$1,060.66	$79,466.42
Feb, 2025	31	$331.11	$729.55	$1,060.66	$78,736.87
Mar, 2025	32	$328.07	$732.58	$1,060.66	$78,004.29
Apr, 2025	33	$325.02	$735.64	$1,060.66	$77,268.65
May, 2025	34	$321.95	$738.70	$1,060.66	$76,529.95
Jun, 2025	35	$318.87	$741.78	$1,060.66	$75,788.17
Jul, 2025	36	$315.78	$744.87	$1,060.66	$75,043.30
Aug, 2025	37	$312.68	$747.97	$1,060.66	$74,295.32
Sep, 2025	38	$309.56	$751.09	$1,060.66	$73,544.23
Oct, 2025	39	$306.43	$754.22	$1,060.66	$72,790.01
Nov, 2025	40	$303.29	$757.36	$1,060.66	$72,032.65
Dec, 2025	41	$300.14	$760.52	$1,060.66	$71,272.13
Jan, 2026	42	$296.97	$763.69	$1,060.66	$70,508.44
Feb, 2026	43	$293.79	$766.87	$1,060.66	$69,741.57
Mar, 2026	44	$290.59	$770.07	$1,060.66	$68,971.51
Apr, 2026	45	$287.38	$773.27	$1,060.66	$68,198.23
May, 2026	46	$284.16	$776.50	$1,060.66	$67,421.74
Jun, 2026	47	$280.92	$779.73	$1,060.66	$66,642.00
Jul, 2026	48	$277.68	$782.98	$1,060.66	$65,859.02
Aug, 2026	49	$274.41	$786.24	$1,060.66	$65,072.78
Sep, 2026	50	$271.14	$789.52	$1,060.66	$64,283.26
Oct, 2026	51	$267.85	$792.81	$1,060.66	$63,490.46
Nov, 2026	52	$264.54	$796.11	$1,060.66	$62,694.34
Dec, 2026	53	$261.23	$799.43	$1,060.66	$61,894.91
Jan, 2027	54	$257.90	$802.76	$1,060.66	$61,092.16
Feb, 2027	55	$254.55	$806.10	$1,060.66	$60,286.05
Mar, 2027	56	$251.19	$809.46	$1,060.66	$59,476.59
Apr, 2027	57	$247.82	$812.84	$1,060.66	$58,663.75
May, 2027	58	$244.43	$816.22	$1,060.66	$57,847.53
Jun, 2027	59	$241.03	$819.62	$1,060.66	$57,027.90
Jul, 2027	60	$237.62	$823.04	$1,060.66	$56,204.87
Aug, 2027	61	$234.19	$826.47	$1,060.66	$55,378.40
Sep, 2027	62	$230.74	$829.91	$1,060.66	$54,548.49
Oct, 2027	63	$227.29	$833.37	$1,060.66	$53,715.12
Nov, 2027	64	$223.81	$836.84	$1,060.66	$52,878.27
Dec, 2027	65	$220.33	$840.33	$1,060.66	$52,037.94
Jan, 2028	66	$216.82	$843.83	$1,060.66	$51,194.11
Feb, 2028	67	$213.31	$847.35	$1,060.66	$50,346.77
Mar, 2028	68	$209.78	$850.88	$1,060.66	$49,495.89
Apr, 2028	69	$206.23	$854.42	$1,060.66	$48,641.47
May, 2028	70	$202.67	$857.98	$1,060.66	$47,783.49
Jun, 2028	71	$199.10	$861.56	$1,060.66	$46,921.93
Jul, 2028	72	$195.51	$865.15	$1,060.66	$46,056.78
Aug, 2028	73	$191.90	$868.75	$1,060.66	$45,188.03
Sep, 2028	74	$188.28	$872.37	$1,060.66	$44,315.66
Oct, 2028	75	$184.65	$876.01	$1,060.66	$43,439.65
Nov, 2028	76	$181.00	$879.66	$1,060.66	$42,560.00
Dec, 2028	77	$177.33	$883.32	$1,060.66	$41,676.67
Jan, 2029	78	$173.65	$887.00	$1,060.66	$40,789.67
Feb, 2029	79	$169.96	$890.70	$1,060.66	$39,898.97
Mar, 2029	80	$166.25	$894.41	$1,060.66	$39,004.56
Apr, 2029	81	$162.52	$898.14	$1,060.66	$38,106.43
May, 2029	82	$158.78	$901.88	$1,060.66	$37,204.55
Jun, 2029	83	$155.02	$905.64	$1,060.66	$36,298.91
Jul, 2029	84	$151.25	$909.41	$1,060.66	$35,389.50
Aug, 2029	85	$147.46	$913.20	$1,060.66	$34,476.30
Sep, 2029	86	$143.65	$917.00	$1,060.66	$33,559.30
Oct, 2029	87	$139.83	$920.82	$1,060.66	$32,638.48
Nov, 2029	88	$135.99	$924.66	$1,060.66	$31,713.81
Dec, 2029	89	$132.14	$928.51	$1,060.66	$30,785.30
Jan, 2030	90	$128.27	$932.38	$1,060.66	$29,852.92
Feb, 2030	91	$124.39	$936.27	$1,060.66	$28,916.65
Mar, 2030	92	$120.49	$940.17	$1,060.66	$27,976.48
Apr, 2030	93	$116.57	$944.09	$1,060.66	$27,032.39
May, 2030	94	$112.63	$948.02	$1,060.66	$26,084.37
Jun, 2030	95	$108.68	$951.97	$1,060.66	$25,132.40
Jul, 2030	96	$104.72	$955.94	$1,060.66	$24,176.47
Aug, 2030	97	$100.74	$959.92	$1,060.66	$23,216.55
Sep, 2030	98	$96.74	$963.92	$1,060.66	$22,252.63
Oct, 2030	99	$92.72	$967.94	$1,060.66	$21,284.69
Nov, 2030	100	$88.69	$971.97	$1,060.66	$20,312.72
Dec, 2030	101	$84.64	$976.02	$1,060.66	$19,336.70
Jan, 2031	102	$80.57	$980.09	$1,060.66	$18,356.62
Feb, 2031	103	$76.49	$984.17	$1,060.66	$17,372.45
Mar, 2031	104	$72.39	$988.27	$1,060.66	$16,384.18
Apr, 2031	105	$68.27	$992.39	$1,060.66	$15,391.79
May, 2031	106	$64.13	$996.52	$1,060.66	$14,395.27
Jun, 2031	107	$59.98	$1,000.67	$1,060.66	$13,394.59
Jul, 2031	108	$55.81	$1,004.84	$1,060.66	$12,389.75
Aug, 2031	109	$51.62	$1,009.03	$1,060.66	$11,380.72
Sep, 2031	110	$47.42	$1,013.24	$1,060.66	$10,367.48
Oct, 2031	111	$43.20	$1,017.46	$1,060.66	$9,350.02
Nov, 2031	112	$38.96	$1,021.70	$1,060.66	$8,328.33
Dec, 2031	113	$34.70	$1,025.95	$1,060.66	$7,302.37
Jan, 2032	114	$30.43	$1,030.23	$1,060.66	$6,272.15
Feb, 2032	115	$26.13	$1,034.52	$1,060.66	$5,237.62
Mar, 2032	116	$21.82	$1,038.83	$1,060.66	$4,198.79
Apr, 2032	117	$17.49	$1,043.16	$1,060.66	$3,155.63
May, 2032	118	$13.15	$1,047.51	$1,060.66	$2,108.13
Jun, 2032	119	$8.78	$1,051.87	$1,060.66	$1,056.25
Jul, 2032	120	$4.40	$1,056.25	$1,060.66	$0.00

Amortization Schedule Calculator

The free amortization table 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.

What is an amortization schedule?

A loan or mortgage amortization schedule is a table that shows borrowers their monthly 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.

What does an amortization table show?

A typical loan or mortgage 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.

Payment Date	Payment #	Interest	Principal	Total Payment	Remaining Balance
Amortization Schedule Example
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.

Payment Date	Payment #	Interest Paid	Principal Paid	Total Payment	Remaining Balance
Amortization Table
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.

How to create an amortization schedule in 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 that you can export to excel and pdf.

Amortization Calculator
Loan Amount
Loan Terms	years
Interest Rate
First Payment Date
Amortization schedule	Show By Month Show By Year

Amortization Schedule

Amortization Schedule

Amortization Calculator

Loan Summary

Printable Amortization Schedule