Amortized Loan Calculator
Amortized Loan Calculator
Section titled “Amortized Loan Calculator”Calculate monthly payments, total interest, and amortization schedules for mortgages, auto loans, and home loans instantly.
Guide: How to Calculate a Monthly Mortgage Payment
Also available as: Home Loan Calculator • Loan Payment Calculator • Monthly Mortgage Calculator
Use Cases
Section titled “Use Cases”This amortized loan calculator is commonly used for mortgage calculations, auto loan payments, home equity loans, student loans, and any fixed-rate loan with regular payments.
What is an Amortized Loan?
Section titled “What is an Amortized Loan?”An amortized loan is a loan with scheduled periodic payments of both principal and interest, designed to pay off the loan in full by the end of the term.
Formulas
Section titled “Formulas”1. Payment Amount (Per Period)
Section titled “1. Payment Amount (Per Period)”The payment for an amortized loan is calculated using:
Where:
- = Payment amount per period
- = Present value (loan principal)
- = Interest rate per period
- = Total number of payments
Converting Annual Rate to Period Rate:
- Daily:
- Monthly:
- Quarterly:
- Yearly:
- Custom (every days):
Math.js Expression:
loan_principal = 200000;annual_rate = 0.06;monthly_rate = annual_rate / 12;num_payments = 360;
payment_per_period = (monthly_rate * loan_principal) / (1 - (1 + monthly_rate)^-num_payments);payment_per_period2. Total Interest
Section titled “2. Total Interest”The total interest paid over the life of the loan:
Where:
- = Payment amount per period
- = Total number of payments
- = Original loan principal
Math.js Expression:
payment = 1199.10;num_payments = 360;loan_principal = 200000;
total_interest = (payment * num_payments) - loan_principal;total_interest3. Number of Payments
Section titled “3. Number of Payments”From Loan Term (Most Common):
Calculate the total number of payments based on the loan term:
- Daily payments:
- Monthly payments:
- Quarterly payments:
- Yearly payments:
- Every days:
Math.js Expression:
loan_term_years = 30;payments_per_year = 12;
num_payments = loan_term_years * payments_per_year;num_paymentsFrom Payment Amount (Reverse Calculation):
If you know the payment amount and want to calculate how many payments are needed:
Where:
- = Number of payments
- = Interest rate per period
- = Loan principal
- = Payment amount per period
Math.js Expression:
loan_principal = 200000;annual_rate = 0.06;monthly_rate = annual_rate / 12;payment = 1199.10;
num_payments = -log(1 - (monthly_rate * loan_principal) / payment) / log(1 + monthly_rate);num_payments4. Final Payment Amount
Section titled “4. Final Payment Amount”If the number of payments results in a fractional value, the final payment will be different:
Where the remaining balance after payments is:
Math.js Expression:
loan_principal = 200000;annual_rate = 0.06;monthly_rate = annual_rate / 12;payment = 1199.10;full_payments = 360;
remaining_balance = loan_principal * (1 + monthly_rate)^full_payments - payment * ((1 + monthly_rate)^full_payments - 1) / monthly_rate;final_payment = remaining_balance * (1 + monthly_rate);final_paymentExample Calculation
Section titled “Example Calculation”Loan Details:
- Loan Amount: $500,000
- Loan Term: 10 years
- Interest Rate: 6% APR
- Payment Frequency: Monthly
Step 1: Calculate Number of Payments
loan_term_years = 10;payments_per_year = 12;
num_payments = loan_term_years * payments_per_year;num_paymentsStep 2: Calculate Monthly Payment
loan_principal = 500000;annual_rate = 0.06;monthly_rate = annual_rate / 12;num_payments = 120;
payment_per_period = (monthly_rate * loan_principal) / (1 - (1 + monthly_rate)^-num_payments);payment_per_periodStep 3: Calculate Total Interest
payment_per_period = 5551.23;num_payments = 120;loan_principal = 500000;
total_interest = (payment_per_period * num_payments) - loan_principal;total_interestExamples
Section titled “Examples”- 1,199/month payment (total interest: $231,676)
- 5,551/month payment (total interest: $166,147)
- 553/month payment (total interest: $3,175)
- 1,186/month payment (total interest: $63,509)
Example Amortization Schedule (First 3 Payments)
Section titled “Example Amortization Schedule (First 3 Payments)”Example loan: $200,000, 6% APR, 30 years (monthly payments).
| Payment # | Payment | Interest | Principal | Remaining Balance |
|---|---|---|---|---|
| 1 | $1,199.10 | $1,000.00 | $199.10 | $199,800.90 |
| 2 | $1,199.10 | $999.00 | $200.10 | $199,600.80 |
| 3 | $1,199.10 | $998.00 | $201.10 | $199,399.70 |
Note: values are rounded to cents for readability, so totals may differ slightly from a full precision schedule.
Common Mistakes & Tips
Section titled “Common Mistakes & Tips”Not Shopping for Better Rates: A 0.5% rate difference on a 20,000 in interest over 30 years. Always compare lenders.
Ignoring Total Interest: Focus on total loan cost, not just monthly payment. Longer terms mean lower payments but much higher total interest.
Missing Extra Payment Opportunities: Even one extra payment per year can shorten a 30-year mortgage by 4-5 years and save tens of thousands in interest.
Confusing APR and Interest Rate: APR includes fees and closing costs. Use the actual interest rate for payment calculations, but compare loans using APR.
Frequently Asked Questions
Section titled “Frequently Asked Questions”How is a monthly mortgage payment calculated?
Section titled “How is a monthly mortgage payment calculated?”Monthly payment is calculated using the loan amount, interest rate divided by 12, and total number of monthly payments. The formula ensures the loan is fully paid by the end of the term.
Can I pay off my loan early?
Section titled “Can I pay off my loan early?”Most loans allow early payoff, but check for prepayment penalties. Extra payments reduce principal and can save significant interest over time.
What’s the difference between a 15-year and 30-year mortgage?
Section titled “What’s the difference between a 15-year and 30-year mortgage?”15-year mortgages have higher monthly payments but much lower total interest. 30-year mortgages offer lower payments but cost significantly more over time.
How much can I afford to borrow?
Section titled “How much can I afford to borrow?”Lenders typically suggest monthly payments no more than 28-30% of gross monthly income. Use this calculator to find payments that fit your budget.
Does this calculator include property taxes and insurance?
Section titled “Does this calculator include property taxes and insurance?”No, this calculates principal and interest only. Add property taxes, insurance, and HOA fees separately for total monthly housing cost.
Related Calculators
Section titled “Related Calculators”- Compound Interest Calculator - Calculate investment growth
- Inflation Calculator - Understand purchasing power
- Unit Converter - Convert between different units
- Scientific Calculator - Advanced math calculations