Home  Mortgage Calculator  Car Loan Calculator  Recast Calculator  HELOC Calculator  Refinance Calculator  Excel 
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 Schedule Calculator 

Loan Amount: 
$100,000.00 
Monthly Payment: 
$1,205.36 
Total # Of Payments: 
120 
Start Date: 
Nov, 2024 
Payoff Date: 
Oct, 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  

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