Amortization Schedule


Amortization Schedule



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

Amortization Calculator

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


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.


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 Schedule | Terms | Privacy | Disclaimer | Contact

©2023 Amortization Schedule