Loan Payoff Calculator Excel

Loan Payoff Calculator Excel to calculate early payoff for your loan. You can use our Early Loan Payoff Calculator with amortization schedule for any type of loans, such as student loans, personal loans, home loans, personal loans, credit cards, and auto loans.

Early Loan Payoff Calculator
Loan Balance	$
Interest Rate
Current Monthly Payment	$
Extra Monthly Payment	$
	OR
Desired Payoff Years	years

Original vs. Early Payoff
		Original		Early Payoff
Monthly Payment		$400.00		$530.00
Expected Payoff Time		32 months		24 months
Total Interest		$718.15		$537.46
Total Principal		$12,000.00		$12,000.00
Total Payment		$12,718.15		$12,537.46
Total Interest Savings		$0		$180.69
Payoff Date		Apr, 2026		Aug, 2025
Early Payoff Amortization Schedule
Payment Date	Payment #	Interest Paid	Principal Paid	Total Payment	Remaining Balance
Sep, 2023	1	$43.00	$487.00	$530.00	$11,513.00
Oct, 2023	2	$41.25	$488.75	$530.00	$11,024.25
Nov, 2023	3	$39.50	$490.50	$530.00	$10,533.76
Dec, 2023	4	$37.75	$492.25	$530.00	$10,041.50
Jan, 2024	5	$35.98	$494.02	$530.00	$9,547.49
Feb, 2024	6	$34.21	$495.79	$530.00	$9,051.70
Mar, 2024	7	$32.44	$497.56	$530.00	$8,554.13
Apr, 2024	8	$30.65	$499.35	$530.00	$8,054.79
May, 2024	9	$28.86	$501.14	$530.00	$7,553.65
Jun, 2024	10	$27.07	$502.93	$530.00	$7,050.72
Jul, 2024	11	$25.27	$504.73	$530.00	$6,545.98
Aug, 2024	12	$23.46	$506.54	$530.00	$6,039.44
Sep, 2024	13	$21.64	$508.36	$530.00	$5,531.08
Oct, 2024	14	$19.82	$510.18	$530.00	$5,020.90
Nov, 2024	15	$17.99	$512.01	$530.00	$4,508.89
Dec, 2024	16	$16.16	$513.84	$530.00	$3,995.05
Jan, 2025	17	$14.32	$515.68	$530.00	$3,479.36
Feb, 2025	18	$12.47	$517.53	$530.00	$2,961.83
Mar, 2025	19	$10.61	$519.39	$530.00	$2,442.44
Apr, 2025	20	$8.75	$521.25	$530.00	$1,921.20
May, 2025	21	$6.88	$523.12	$530.00	$1,398.08
Jun, 2025	22	$5.01	$524.99	$530.00	$873.09
Jul, 2025	23	$3.13	$526.87	$530.00	$346.22
Aug, 2025	24	$1.24	$346.22	$347.46	$0.00

Early Loan Payoff Calculator

The loan amortization schedule is exportable in an excel format. You can pay off your loan by increasing your monthly payment or using the desired payoff time.

Check Today's Mortgage Rates
Today's Home Equity Rates

Mortgage Calculators

Refinance Calculators

Early Mortgage Payoff Calculators

Real Estate Investment Calculators

Mortgage Related Calculators

Auto Loan Calculators

Loan Calculators

Savings & Investments Calculators

Credit Card Calculators

Mortgage Guide

Mortgage Calculator Widget