Amortization Calculator

$
Enter the total loan amount in dollars
%
Enter the annual interest rate as a percentage
Enter the loan term in years
Select whether the term is in years or months
Optional: Enter the loan start date to show payment dates in the schedule
$
Optional: Enter additional monthly payment to pay off loan faster
$
Optional: Enter annual property tax to include in total monthly payment
$
Optional: Enter monthly HOA fee to include in total monthly payment

Common Loan Examples:

Loan Summary

Early Payoff Savings

Amortization Schedule

# Date Payment Principal Interest Balance

Copy these formulas into Excel or Google Sheets. Replace cell references with your values.

Monthly Payment (PMT)

Calculate monthly principal and interest payment

=PMT(B2/12, B3*12, -B1)
B1 = Loan Amount B2 = Annual Rate (decimal, e.g., 0.065) B3 = Term in Years

Total Interest Paid

Calculate total interest over the life of the loan

=(PMT(B2/12,B3*12,-B1)*B3*12)-B1

Remaining Balance After N Payments

Calculate how much you still owe after a number of payments

=FV(B2/12, B4, -PMT(B2/12,B3*12,-B1), B1)
B4 = Payments Made

Interest Portion of Payment N

Calculate interest portion of a specific payment

=IPMT(B2/12, B4, B3*12, -B1)
B4 = Payment Number

Principal Portion of Payment N

Calculate principal portion of a specific payment

=PPMT(B2/12, B4, B3*12, -B1)