๐Ÿฆ
personal financebeginner20 min

How to Calculate Monthly Loan Payments: The Amortization Formula with Worked Examples

A step-by-step guide to calculating monthly loan payments using the amortization formula โ€” covering mortgages, car loans, and student loans with worked examples, a breakdown of how each payment splits between interest and principal, and what extra payments actually save you.

What You'll Learn

  • โœ“Apply the loan payment formula to calculate monthly payments for any fixed-rate loan
  • โœ“Break down each payment into its interest and principal components
  • โœ“Build a basic amortization schedule showing the balance over the life of the loan
  • โœ“Calculate how much money and time extra payments save over the life of the loan

1. The Formula: Monthly Payment = P ร— [r(1+r)^n] / [(1+r)^n - 1]

The monthly payment on a fixed-rate loan is calculated with one formula: Payment = P ร— [r(1+r)^n] / [(1+r)^n - 1] Where: P = principal (loan amount), r = monthly interest rate (annual rate รท 12), n = total number of payments (years ร— 12). Worked example โ€” a $300,000 mortgage at 7% for 30 years: P = $300,000. Annual rate = 7%, so monthly rate r = 0.07 รท 12 = 0.005833. Number of payments n = 30 ร— 12 = 360. Plug in: Payment = $300,000 ร— [0.005833 ร— (1.005833)^360] / [(1.005833)^360 - 1]. (1.005833)^360 = 8.1165. Numerator: 0.005833 ร— 8.1165 = 0.04735. Denominator: 8.1165 - 1 = 7.1165. Payment = $300,000 ร— (0.04735 / 7.1165) = $300,000 ร— 0.006653 = $1,995.91 per month. That $1,995.91 is the total monthly payment of principal and interest. Over 360 payments, you pay $1,995.91 ร— 360 = $718,528 total โ€” meaning you pay $418,528 in interest on a $300,000 loan. The interest is more than the principal. This is the math that makes people's jaws drop and is why understanding amortization matters. Snap a photo of any loan payment problem and FinanceIQ solves it step by step โ€” showing the formula, the substitution, and the calculation with the answer. This content is for educational purposes only and does not constitute financial advice.

Key Points

  • โ€ขPMT = P ร— [r(1+r)^n] / [(1+r)^n - 1] โ€” the universal fixed-rate loan payment formula
  • โ€ขr = annual rate รท 12 (monthly rate). n = years ร— 12 (total payments).
  • โ€ขA $300,000 mortgage at 7% for 30 years: $1,995.91/month. Total paid: $718,528 ($418K in interest).
  • โ€ขThe interest paid over the life of most mortgages EXCEEDS the original loan amount

2. How Each Payment Splits: Interest vs Principal Over Time

Here is the part that surprises everyone: early payments are almost entirely interest. On the $300,000 mortgage example, your first payment of $1,995.91 splits: $1,750 goes to interest and only $245.91 goes to principal. You owe $299,754.09 after your first payment โ€” barely a dent. Why? Because interest is calculated on the remaining balance each month. With $300,000 outstanding, one month of interest at 7% annual = $300,000 ร— 0.07 / 12 = $1,750. The remaining $245.91 of your payment reduces the principal. Next month, interest is calculated on $299,754.09 โ€” slightly less interest ($1,748.57), slightly more principal ($247.34). This pattern continues for 360 months. The crossover point โ€” where more of each payment goes to principal than interest โ€” does not occur until approximately month 215 of a 30-year mortgage at 7%. That means for the first 18 years, the majority of every payment is interest. This is why the total interest paid ($418K) exceeds the loan amount ($300K). This math also explains why refinancing or extra payments have the most impact early in the loan โ€” when you reduce the principal balance by $10,000 in year 2, you avoid paying interest on that $10,000 for the remaining 28 years. The same $10,000 extra payment in year 25 saves much less because there are only 5 years of interest remaining. FinanceIQ builds complete amortization schedules from any loan parameters โ€” showing the month-by-month breakdown of interest, principal, and remaining balance.

Key Points

  • โ€ขFirst payment on a $300K/7%/30yr mortgage: $1,750 interest + $246 principal. Almost all interest.
  • โ€ขThe crossover (principal > interest) does not occur until month ~215 of a 30-year mortgage at 7%
  • โ€ขEarly extra payments save dramatically more than late ones โ€” each dollar reduces 28 years of interest
  • โ€ขThis is why total interest ($418K) exceeds the loan amount ($300K) on a standard 30-year mortgage

3. Car Loans and Student Loans: Applying the Same Formula

The formula is identical for any fixed-rate installment loan. Only the numbers change. Car loan example: $35,000 at 6.5% for 5 years. P = $35,000. r = 0.065 รท 12 = 0.005417. n = 60. Payment = $35,000 ร— [0.005417 ร— (1.005417)^60] / [(1.005417)^60 - 1]. (1.005417)^60 = 1.3829. Payment = $35,000 ร— (0.007493 / 0.3829) = $35,000 ร— 0.01957 = $684.96/month. Total paid: $684.96 ร— 60 = $41,098. Interest: $6,098. Student loan example: $45,000 at 5.5% for 10 years. P = $45,000. r = 0.055 รท 12 = 0.004583. n = 120. Payment = $45,000 ร— [0.004583 ร— (1.004583)^120] / [(1.004583)^120 - 1]. Payment = approximately $488.15/month. Total paid: $58,578. Interest: $13,578. The pattern across all three loan types: shorter terms and lower rates dramatically reduce total interest. The same $35,000 car loan at 6.5% costs $6,098 in interest over 5 years. Over 7 years: $8,745 in interest (44% more interest for 2 extra years of payments). This is why financial advisors say take the shortest term you can afford โ€” the monthly payment is higher but the total cost is lower.

Key Points

  • โ€ขSame formula for all fixed-rate loans: mortgages, car loans, student loans, personal loans
  • โ€ขCar loan ($35K/6.5%/5yr): $685/month, $6,098 total interest
  • โ€ขStudent loan ($45K/5.5%/10yr): $488/month, $13,578 total interest
  • โ€ขShorter loan terms = higher monthly payment but dramatically less total interest

4. Extra Payments: How Much They Actually Save

Extra payments go entirely to principal reduction โ€” they skip the interest component because interest is already covered by your regular payment. This makes extra payments disproportionately powerful. On the $300,000 mortgage at 7% for 30 years ($1,995.91/month): adding $200/month extra reduces the loan term from 30 years to approximately 22.5 years and saves approximately $115,000 in total interest. You pay $200 more per month but save $115,000 over the life of the loan โ€” a return of roughly 6.6:1 on every extra dollar. Adding $500/month extra: reduces the term to about 18 years and saves approximately $195,000 in interest. At $500/month extra for 18 years, you invest $108,000 in extra payments and save $195,000 โ€” an 80% return. One extra payment per year (the 13th payment strategy): make one additional full payment per year, spread across 12 months ($1,995.91 รท 12 = $166.33 extra per month). This reduces a 30-year mortgage to approximately 25 years and saves roughly $85,000 in interest. This is the most popular extra payment strategy because the monthly increase ($166) is modest but the lifetime savings are substantial. The important caveat: extra payments only help if you do not have higher-interest debt. Paying an extra $200/month on a 7% mortgage while carrying $10,000 in credit card debt at 22% is mathematically wrong โ€” the credit card interest is costing you 3x more per dollar of balance. Pay off high-interest debt first, then apply extra to the mortgage. FinanceIQ calculates exact extra payment savings for any loan โ€” enter the original terms and your extra payment amount and it shows the new payoff date, total interest saved, and effective return on each extra dollar.

Key Points

  • โ€ขExtra payments go 100% to principal โ€” no interest portion, making them disproportionately powerful
  • โ€ข$200/month extra on a $300K/7%/30yr mortgage: saves $115,000 in interest and 7.5 years of payments
  • โ€ขThe 13th payment strategy: $166/month extra saves ~$85K and cuts 5 years off a 30-year mortgage
  • โ€ขPay off high-interest debt (credit cards) BEFORE making extra mortgage payments โ€” the math demands it

Key Takeaways

  • โ˜…PMT = P ร— [r(1+r)^n] / [(1+r)^n - 1] โ€” the only formula you need for any fixed-rate loan payment
  • โ˜…A $300K mortgage at 7%/30yr: total paid = $718K. The $418K in interest exceeds the original loan.
  • โ˜…First payment on that mortgage: $1,750 interest + $246 principal. The crossover is at month 215 (year 18).
  • โ˜…Extra $200/month on a $300K mortgage saves $115,000 in interest and 7.5 years of payments
  • โ˜…Shorter term = higher monthly but dramatically less total interest. 5-year car loan costs 44% less interest than 7-year.

Practice Questions

1. Calculate the monthly payment on a $25,000 car loan at 5.9% APR for 4 years. How much total interest will you pay?
P = $25,000. r = 0.059/12 = 0.004917. n = 48. PMT = $25,000 ร— [0.004917 ร— (1.004917)^48] / [(1.004917)^48 - 1]. (1.004917)^48 = 1.2652. PMT = $25,000 ร— (0.006221 / 0.2652) = $25,000 ร— 0.023459 = $586.47/month. Total paid: $586.47 ร— 48 = $28,150.56. Total interest: $3,150.56.
2. You have a $200,000 mortgage at 6.5% for 30 years. Your payment is $1,264.14. If you make one extra payment per year ($1,264.14 / 12 = $105.35 extra per month), approximately how many years will you cut from the loan?
Adding $105.35/month extra to a $200K/6.5%/30yr mortgage reduces the term from 30 years to approximately 25 years โ€” cutting about 5 years. Total interest savings: approximately $52,000. You invest $105.35 ร— 12 ร— 25 = $31,605 in extra payments and save $52,000 โ€” a 65% return on the extra dollars.

Study with AI

Get personalized help and instant answers anytime.

Download FinanceIQ

FAQs

Common questions about this topic

Only for the fixed-rate period. An adjustable-rate mortgage (ARM) has a fixed rate for an initial period (typically 5, 7, or 10 years), then adjusts periodically. You can calculate the payment for the fixed period using the standard formula. After the rate adjusts, you recalculate with the new rate and the remaining balance and term. Each rate change requires a new calculation.

Yes. Snap a photo of any loan payment or amortization problem and FinanceIQ solves it step by step โ€” showing the formula, substituting the values, and computing the answer. It builds complete amortization schedules, calculates extra payment savings, and compares different loan terms side by side.

More Study Guides