![]() |
Home | Mortgage Calculator | Car Loan Calculator | Recast Calculator | HELOC Calculator | Refinance Calculator | Excel |
Loan Calculator with amortization schedule to calculate monthly payment for any type of loans, such as student loans, personal loans, home loans and etc. The loan amortization calculator generates a loan amortization schedule excel that shows you when principal and interest payments, as well as the balance remaining and the payoff date.
Loan Summary |
|
Loan Amount: |
$50,000.00 |
Monthly Payment: |
$966.64 |
Total # Of Payments: |
60 |
Start Date: |
Feb, 2025 |
Payoff Date: |
Jan, 2030 |
Total Interest Paid: |
$7,998.40 |
Total Payment: |
$57,998.40 |
Loan Amortization Schedule |
||||||
Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
---|---|---|---|---|---|---|
Feb, 2025 | 1 | $250.00 | $716.64 | $966.64 | $49,283.36 | |
Mar, 2025 | 2 | $246.42 | $720.22 | $966.64 | $48,563.14 | |
Apr, 2025 | 3 | $242.82 | $723.82 | $966.64 | $47,839.31 | |
May, 2025 | 4 | $239.20 | $727.44 | $966.64 | $47,111.87 | |
Jun, 2025 | 5 | $235.56 | $731.08 | $966.64 | $46,380.79 | |
Jul, 2025 | 6 | $231.90 | $734.74 | $966.64 | $45,646.05 | |
Aug, 2025 | 7 | $228.23 | $738.41 | $966.64 | $44,907.64 | |
Sep, 2025 | 8 | $224.54 | $742.10 | $966.64 | $44,165.54 | |
Oct, 2025 | 9 | $220.83 | $745.81 | $966.64 | $43,419.73 | |
Nov, 2025 | 10 | $217.10 | $749.54 | $966.64 | $42,670.19 | |
Dec, 2025 | 11 | $213.35 | $753.29 | $966.64 | $41,916.90 | |
Jan, 2026 | 12 | $209.58 | $757.06 | $966.64 | $41,159.84 | |
Feb, 2026 | 13 | $205.80 | $760.84 | $966.64 | $40,399.00 | |
Mar, 2026 | 14 | $202.00 | $764.65 | $966.64 | $39,634.36 | |
Apr, 2026 | 15 | $198.17 | $768.47 | $966.64 | $38,865.89 | |
May, 2026 | 16 | $194.33 | $772.31 | $966.64 | $38,093.58 | |
Jun, 2026 | 17 | $190.47 | $776.17 | $966.64 | $37,317.40 | |
Jul, 2026 | 18 | $186.59 | $780.05 | $966.64 | $36,537.35 | |
Aug, 2026 | 19 | $182.69 | $783.95 | $966.64 | $35,753.40 | |
Sep, 2026 | 20 | $178.77 | $787.87 | $966.64 | $34,965.53 | |
Oct, 2026 | 21 | $174.83 | $791.81 | $966.64 | $34,173.71 | |
Nov, 2026 | 22 | $170.87 | $795.77 | $966.64 | $33,377.94 | |
Dec, 2026 | 23 | $166.89 | $799.75 | $966.64 | $32,578.19 | |
Jan, 2027 | 24 | $162.89 | $803.75 | $966.64 | $31,774.44 | |
Feb, 2027 | 25 | $158.87 | $807.77 | $966.64 | $30,966.67 | |
Mar, 2027 | 26 | $154.83 | $811.81 | $966.64 | $30,154.87 | |
Apr, 2027 | 27 | $150.77 | $815.87 | $966.64 | $29,339.00 | |
May, 2027 | 28 | $146.70 | $819.95 | $966.64 | $28,519.06 | |
Jun, 2027 | 29 | $142.60 | $824.04 | $966.64 | $27,695.01 | |
Jul, 2027 | 30 | $138.48 | $828.17 | $966.64 | $26,866.85 | |
Aug, 2027 | 31 | $134.33 | $832.31 | $966.64 | $26,034.54 | |
Sep, 2027 | 32 | $130.17 | $836.47 | $966.64 | $25,198.07 | |
Oct, 2027 | 33 | $125.99 | $840.65 | $966.64 | $24,357.42 | |
Nov, 2027 | 34 | $121.79 | $844.85 | $966.64 | $23,512.57 | |
Dec, 2027 | 35 | $117.56 | $849.08 | $966.64 | $22,663.49 | |
Jan, 2028 | 36 | $113.32 | $853.32 | $966.64 | $21,810.17 | |
Feb, 2028 | 37 | $109.05 | $857.59 | $966.64 | $20,952.58 | |
Mar, 2028 | 38 | $104.76 | $861.88 | $966.64 | $20,090.70 | |
Apr, 2028 | 39 | $100.45 | $866.19 | $966.64 | $19,224.52 | |
May, 2028 | 40 | $96.12 | $870.52 | $966.64 | $18,354.00 | |
Jun, 2028 | 41 | $91.77 | $874.87 | $966.64 | $17,479.13 | |
Jul, 2028 | 42 | $87.40 | $879.24 | $966.64 | $16,599.89 | |
Aug, 2028 | 43 | $83.00 | $883.64 | $966.64 | $15,716.25 | |
Sep, 2028 | 44 | $78.58 | $888.06 | $966.64 | $14,828.19 | |
Oct, 2028 | 45 | $74.14 | $892.50 | $966.64 | $13,935.69 | |
Nov, 2028 | 46 | $69.68 | $896.96 | $966.64 | $13,038.73 | |
Dec, 2028 | 47 | $65.19 | $901.45 | $966.64 | $12,137.28 | |
Jan, 2029 | 48 | $60.69 | $905.95 | $966.64 | $11,231.33 | |
Feb, 2029 | 49 | $56.16 | $910.48 | $966.64 | $10,320.84 | |
Mar, 2029 | 50 | $51.60 | $915.04 | $966.64 | $9,405.81 | |
Apr, 2029 | 51 | $47.03 | $919.61 | $966.64 | $8,486.20 | |
May, 2029 | 52 | $42.43 | $924.21 | $966.64 | $7,561.99 | |
Jun, 2029 | 53 | $37.81 | $928.83 | $966.64 | $6,633.16 | |
Jul, 2029 | 54 | $33.17 | $933.47 | $966.64 | $5,699.68 | |
Aug, 2029 | 55 | $28.50 | $938.14 | $966.64 | $4,761.54 | |
Sep, 2029 | 56 | $23.81 | $942.83 | $966.64 | $3,818.71 | |
Oct, 2029 | 57 | $19.09 | $947.55 | $966.64 | $2,871.16 | |
Nov, 2029 | 58 | $14.36 | $952.28 | $966.64 | $1,918.88 | |
Dec, 2029 | 59 | $9.59 | $957.05 | $966.64 | $961.83 | |
Jan, 2030 | 60 | $4.81 | $961.83 | $966.64 | $0.00 |
To download the amortization schedule in excel format, you can use the Amortization Schedule Excel.
$1000 Loan Payment CalculatorAmortization Schedule | Terms | Privacy | Disclaimer | Contact
©2025 Amortization Schedule