Introduction
The monthly payment for an amortizing loan is: M = P × [r(1+r)^n] / [(1+r)^n - 1], where P is principal, r is monthly interest rate (annual rate / 12), and n is the number of payments (years × 12). Each payment first covers the interest accrued since the last payment, then the remainder reduces principal. Over time, the interest portion decreases and principal portion increases.
The PMT Formula Explained
The monthly payment for an amortizing loan is: M = P × [r(1+r)^n] / [(1+r)^n - 1], where P is principal, r is monthly interest rate (annual rate / 12), and n is the number of payments (years × 12). Each payment first covers the interest accrued since the last payment, then the remainder reduces principal. Over time, the interest portion decreases and principal portion increases.
Amortization Schedules
A full amortization schedule shows every payment's principal/interest split and the remaining balance after each payment. For a 30-year mortgage at 6% on a $300,000 loan, the first payment is $449 interest + $350 principal. Payment 360: $2 interest + $797 principal. Total interest paid: ~$347,000 — more than the principal. Adding $50/month extra saves $30,000+ interest and shortens the term by 4-5 years.
APR vs Interest Rate
The interest rate determines your monthly payment. APR includes points, origination fees, and closing costs, giving the true annual cost. APR is always >= the interest rate. When comparing loans, use APR. When computing monthly payment waterfalls, use the interest rate. Our loan calculator shows both and generates the full amortization table.
Frequently Asked Questions
What is the PMT formula and how is it derived?
The PMT formula M = P × [r(1+r)^n] / [(1+r)^n - 1] calculates the fixed monthly payment for an amortizing loan. It is derived from the present value of an annuity formula, where each payment is discounted back to the present. The numerator represents the interest accrued on the principal, and the denominator accounts for the cumulative discount factor over all payments. Every major spreadsheet and programming language implements this formula in its PMT function.
How does extra principal payment affect a loan?
Extra principal payments directly reduce the outstanding balance, which means less interest accrues on the next payment. Over the life of a 30-year, $300,000 mortgage at 6%, adding just $50 per month saves over $30,000 in interest and shortens the loan term by 4-5 years. Adding $100 per month saves over $55,000 and cuts the term by 7-8 years. The earlier in the loan you make extra payments, the greater the savings because the outstanding balance is largest at the start.
What is the difference between APR and interest rate?
The interest rate (or note rate) is the base rate used to calculate your monthly payment. APR (Annual Percentage Rate) includes the interest rate plus points, origination fees, broker fees, and certain closing costs spread across the loan term. APR is always equal to or higher than the interest rate. Use APR to compare the true cost of different loan offers, but use the interest rate to calculate your actual monthly payment.
How do I calculate the total interest paid over the life of a loan?
Total interest = (monthly payment × number of payments) - principal. For a fully amortizing loan, you can also sum the interest portion of each payment in the amortization schedule. Most loan calculators display this as "Total Interest Paid" or "Cost of Borrowing." For a typical 30-year mortgage at current rates, total interest often exceeds the principal amount borrowed.
What is an amortization schedule and how do I build one?
An amortization schedule is a table showing each payment's breakdown into interest and principal, plus the remaining balance after each payment. Start with the principal balance. For each period: calculate interest = balance × monthly rate, principal portion = payment - interest, new balance = old balance - principal portion. Repeat for all payments. The last payment's principal portion should exactly match the remaining balance, with interest rounding to zero.
How does loan term (15-year vs 30-year) affect total cost?
A 15-year mortgage has higher monthly payments but significantly lower total interest. On a $300,000 loan at 6%, a 30-year term has a ~$1,799 monthly payment with ~$347,000 total interest. A 15-year term has a ~$2,531 monthly payment but only ~$155,000 total interest — a savings of ~$192,000. The trade-off is the higher monthly payment, which must be affordable within your budget.
What is the difference between fixed-rate and adjustable-rate mortgages (ARM)?
A fixed-rate mortgage has the same interest rate for the entire loan term, providing predictable payments. An ARM has a fixed rate for an initial period (typically 3, 5, 7, or 10 years), then adjusts periodically based on a benchmark index plus a margin. ARMs start with lower rates but carry the risk of higher payments after the initial period. Use an ARM only if you plan to sell or refinance before the adjustment period begins.
How do I calculate the break-even point for refinancing?
The refinancing break-even point is the time it takes for monthly payment savings to exceed closing costs. Calculate: monthly savings = current payment - new payment. Break-even months = total closing costs / monthly savings. For example, if closing costs are $5,000 and you save $200/month, the break-even is 25 months. If you plan to stay in the home longer than 25 months, refinancing makes financial sense.
What is PMI and how does it affect my loan calculations?
PMI (Private Mortgage Insurance) is required when your down payment is less than 20% of the home's value. PMI typically costs 0.3% to 1.5% of the original loan amount per year, divided into monthly payments. PMI automatically terminates when the loan reaches 78% of the original property value, and you can request cancellation at 80%. Our loan calculator models PMI and shows the exact month it drops off.
How do I account for property taxes and insurance in loan calculations?
Property taxes and homeowner's insurance are typically paid into an escrow account and included in your monthly payment. Together with Principal and Interest, these form PITI (Principal, Interest, Taxes, Insurance). Most lenders require escrow for loans with less than 20% down. To calculate the full monthly payment, add (annual taxes / 12) and (annual insurance / 12) to the P&I payment from the PMT formula.
What happens if I miss a loan payment?
Missing a payment triggers late fees (typically 4-5% of the payment amount), and the missed interest accrues and gets added to the principal balance (negative amortization). After 30-90 days, the lender reports the delinquency to credit bureaus, damaging your credit score. Foreclosure proceedings can begin after 90-120 days of non-payment. Most lenders offer a grace period of 10-15 days before late fees apply.
How does compound interest differ in loans versus investments?
In loans, interest compounds on the outstanding balance, meaning you pay interest on previously unpaid interest. In investments, compound interest works in your favor — you earn interest on previously earned interest. The compounding frequency (daily, monthly, annually) significantly affects the total cost of a loan or the total return on an investment. Our loan calculator uses monthly compounding, which is standard for mortgages and personal loans.
Conclusion
Understanding loan mathematics is essential for developers building financial applications, as well as for anyone making informed borrowing decisions. The PMT formula provides the foundation for calculating fixed payments, while amortization schedules reveal the true cost of borrowing over time. The distinction between APR and interest rate, the impact of extra principal payments, and the trade-offs between different loan terms all have significant financial implications. By implementing these calculations correctly — handling rounding, accounting for PMI and escrow, and providing clear visualizations of amortization data — developers can build loan calculators that genuinely help users make better financial decisions. Remember that even small differences in interest rates or terms can compound into tens of thousands of dollars over a typical mortgage, so accuracy and transparency in your calculations matter.
Frequently asked questions
What is the PMT formula and how is it derived?
The PMT formula M = P × [r(1+r)^n] / [(1+r)^n - 1] calculates the fixed monthly payment for an amortizing loan. It is derived from the present value of an annuity formula, where each payment is discounted back to the present. The numerator represents the interest accrued on the principal, and the denominator accounts for the cumulative discount factor over all payments. Every major spreadsheet and programming language implements this formula in its PMT function.
How does extra principal payment affect a loan?
Extra principal payments directly reduce the outstanding balance, which means less interest accrues on the next payment. Over the life of a 30-year, $300,000 mortgage at 6%, adding just $50 per month saves over $30,000 in interest and shortens the loan term by 4-5 years. Adding $100 per month saves over $55,000 and cuts the term by 7-8 years. The earlier in the loan you make extra payments, the greater the savings because the outstanding balance is largest at the start.
What is the difference between APR and interest rate?
The interest rate (or note rate) is the base rate used to calculate your monthly payment. APR (Annual Percentage Rate) includes the interest rate plus points, origination fees, broker fees, and certain closing costs spread across the loan term. APR is always equal to or higher than the interest rate. Use APR to compare the true cost of different loan offers, but use the interest rate to calculate your actual monthly payment.
How do I calculate the total interest paid over the life of a loan?
Total interest = (monthly payment × number of payments) - principal. For a fully amortizing loan, you can also sum the interest portion of each payment in the amortization schedule. Most loan calculators display this as "Total Interest Paid" or "Cost of Borrowing." For a typical 30-year mortgage at current rates, total interest often exceeds the principal amount borrowed.
What is an amortization schedule and how do I build one?
An amortization schedule is a table showing each payment's breakdown into interest and principal, plus the remaining balance after each payment. Start with the principal balance. For each period: calculate interest = balance × monthly rate, principal portion = payment - interest, new balance = old balance - principal portion. Repeat for all payments. The last payment's principal portion should exactly match the remaining balance, with interest rounding to zero.
How does loan term (15-year vs 30-year) affect total cost?
A 15-year mortgage has higher monthly payments but significantly lower total interest. On a $300,000 loan at 6%, a 30-year term has a ~$1,799 monthly payment with ~$347,000 total interest. A 15-year term has a ~$2,531 monthly payment but only ~$155,000 total interest — a savings of ~$192,000. The trade-off is the higher monthly payment, which must be affordable within your budget.
What is the difference between fixed-rate and adjustable-rate mortgages (ARM)?
A fixed-rate mortgage has the same interest rate for the entire loan term, providing predictable payments. An ARM has a fixed rate for an initial period (typically 3, 5, 7, or 10 years), then adjusts periodically based on a benchmark index plus a margin. ARMs start with lower rates but carry the risk of higher payments after the initial period. Use an ARM only if you plan to sell or refinance before the adjustment period begins.
How do I calculate the break-even point for refinancing?
The refinancing break-even point is the time it takes for monthly payment savings to exceed closing costs. Calculate: monthly savings = current payment - new payment. Break-even months = total closing costs / monthly savings. For example, if closing costs are $5,000 and you save $200/month, the break-even is 25 months. If you plan to stay in the home longer than 25 months, refinancing makes financial sense.
What is PMI and how does it affect my loan calculations?
PMI (Private Mortgage Insurance) is required when your down payment is less than 20% of the home's value. PMI typically costs 0.3% to 1.5% of the original loan amount per year, divided into monthly payments. PMI automatically terminates when the loan reaches 78% of the original property value, and you can request cancellation at 80%. Our loan calculator models PMI and shows the exact month it drops off.
How do I account for property taxes and insurance in loan calculations?
Property taxes and homeowner's insurance are typically paid into an escrow account and included in your monthly payment. Together with Principal and Interest, these form PITI (Principal, Interest, Taxes, Insurance). Most lenders require escrow for loans with less than 20% down. To calculate the full monthly payment, add (annual taxes / 12) and (annual insurance / 12) to the P&I payment from the PMT formula.
What happens if I miss a loan payment?
Missing a payment triggers late fees (typically 4-5% of the payment amount), and the missed interest accrues and gets added to the principal balance (negative amortization). After 30-90 days, the lender reports the delinquency to credit bureaus, damaging your credit score. Foreclosure proceedings can begin after 90-120 days of non-payment. Most lenders offer a grace period of 10-15 days before late fees apply.
How does compound interest differ in loans versus investments?
In loans, interest compounds on the outstanding balance, meaning you pay interest on previously unpaid interest. In investments, compound interest works in your favor — you earn interest on previously earned interest. The compounding frequency (daily, monthly, annually) significantly affects the total cost of a loan or the total return on an investment. Our loan calculator uses monthly compounding, which is standard for mortgages and personal loans.