This calculator works out the monthly payment and total interest for a fixed-rate loan, which is the basis of a national finance loan schedule. You enter the loan amount, annual interest rate (APR), and loan term in years, and you get back the level monthly payment and the total interest paid over the life of the loan. The schedule itself is the detailed breakdown of each payment into principal and interest, and this tool gives you the two key numbers that define it.
Formula
The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:
M = P × (r × (1 + r)^n) / ((1 + r)^n − 1)
- M = monthly payment (in dollars)
- P = principal loan amount (in dollars)
- r = monthly interest rate = annual rate (APR) divided by 12, then divided by 100 (e.g., 8% APR → 0.08/12 = 0.0066667)
- n = total number of monthly payments = loan term in years × 12
The total interest is simply the monthly payment multiplied by the number of payments, minus the principal: Total Interest = M × n − P.
Worked Example
Using the defaults from the calculator: P = $20,000, APR = 8%, term = 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Number of payments: n = 5 × 12 = 60
- Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
- Payment = 20000 × (0.0066667 × 1.4898457) / (1.4898457 − 1) = 20000 × (0.0099323) / (0.4898457) ≈ 20000 × 0.0202762 = 405.52
- Rounded to the cent: M = $405.52
- Total paid = 405.52 × 60 = $24,331.20
- Total interest = 24,331.20 − 20,000 = $4,331.20
The calculator shows a monthly payment of $405.52 and total interest of $4,331.20, matching the example.
Assumptions
- The interest rate is fixed for the entire loan term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at the rate APR/12.
- Fees, taxes, insurance, and other charges are not included; the result is principal and interest only.
What Is a National Finance Loan Schedule?
A national finance loan schedule is simply an amortization schedule used by a lender (often a national bank or finance company) that lists every payment due over the life of a loan. Each row shows the payment number, the payment amount, how much goes to interest, how much goes to principal, and the remaining balance. The schedule is generated from the same formula shown above, but it breaks down each payment individually.
For a fixed-rate loan, the payment amount stays the same every month, but the split changes: early payments are mostly interest, and later payments are mostly principal. This is because interest is calculated on the remaining balance, which decreases over time.
How to Read a Loan Schedule
When you receive a loan schedule from a lender, you’ll typically see columns like:
- Payment #: the sequential number of the payment (1 to n).
- Payment Amount: the fixed monthly payment (e.g., $405.52).
- Interest Portion: the part of that payment that goes to interest (e.g., first payment: $133.33).
- Principal Portion: the part that reduces the balance (e.g., first payment: $272.19).
- Remaining Balance: what you still owe after that payment (e.g., after payment 1: $19,727.81).
To verify the first payment: interest = balance × monthly rate = 20000 × 0.0066667 = $133.33. Principal = 405.52 − 133.33 = $272.19. New balance = 20000 − 272.19 = $19,727.81. The pattern continues until the balance reaches zero.
Why the Payment Is Fixed but the Interest Changes
Many borrowers are surprised that the monthly payment never changes, even though the interest portion decreases each month. This is the nature of amortization: the payment is calculated so that the present value of all payments equals the loan amount at the given interest rate. As the balance shrinks, the interest charged on it shrinks, so more of the fixed payment goes toward principal.
For example, in the first month, interest is $133.33 and principal is $272.19. By the last payment, interest is only about $2.68 and principal is $402.84. The total interest over the 60 months is $4,331.20, which is about 21.7% of the original loan amount.
How to Choose a Loan Term
Your loan term (the number of years) directly affects your monthly payment and total interest. Shorter terms have higher monthly payments but lower total interest; longer terms have lower monthly payments but higher total interest. Using the calculator, you can compare:
- 5-year term: $405.52/month, total interest $4,331.20
- 10-year term: $242.66/month, total interest $9,119.20 (calculated with the same formula)
There is no universally “best” term—it depends on your budget and how much you want to pay in interest. The calculator lets you see the trade-off clearly. Always check with your lender for the exact terms they offer.
Common Mistakes and Misconceptions
Mistake 1: Using the annual rate as the monthly rate. Always divide the APR by 12 (and by 100) to get the monthly decimal rate. For 8% APR, use 0.08/12, not 0.08.
Mistake 2: Rounding too early. In the worked example, rounding the monthly rate to 0.0067 changes the payment slightly. Keep full precision until the final step.
Mistake 3: Confusing APR with the nominal rate. APR includes certain fees in some cases, but the formula here assumes the APR is the annual interest rate. If your loan has origination fees, the actual APR may be higher than the stated rate.
Misconception: Paying extra each month doesn’t help. Extra payments reduce the principal faster, which shortens the loan term and reduces total interest. For example, adding $50 per month to the $405.52 payment would pay off the 5-year loan in about 4 years and 4 months, saving roughly $600 in interest (assuming no prepayment penalties).
Alternatives to a Fixed-Rate Schedule
Not all loans use a fixed-rate, level-payment schedule. Common alternatives include:
- Adjustable-rate loans: the interest rate changes periodically, so the payment can go up or down.
- Interest-only loans: you pay only interest for a set period, then payments increase to cover principal.
- Balloon loans: low monthly payments for a period, then a large lump-sum payment at the end.
- Biweekly payments: you pay half the monthly amount every two weeks, effectively making 13 full payments per year, which shortens the term.
Each type has its own schedule and trade-offs. The formula here applies only to the fixed-rate, fully amortizing loan, which is the most common type for personal and auto loans.
Frequently Asked Questions
Q: How do I get a copy of my loan schedule?
Your lender is required to provide an amortization schedule when you take out the loan, and you can usually request one anytime. Many online banking portals let you download or view the schedule. If you don’t have it, you can generate one yourself using this calculator and a spreadsheet.
Q: Does the schedule change if I make an extra payment?
Yes, but only if you specify that the extra payment goes toward principal. If you just pay more than the required amount, the lender may apply it to future payments or interest. Always tell the lender to apply extra payments to the principal balance, and the schedule will be recalculated with a shorter term and less total interest.
Q: What happens if I miss a payment?
Missing a payment usually triggers a late fee and may increase your APR if your loan has a penalty rate. The schedule assumes you pay every month on time. If you miss a payment, the lender will adjust the schedule, and you may end up paying more interest because the balance stays higher longer.
Q: Is the monthly payment the same as the minimum payment on a credit card?
No. Credit card minimum payments are often a small percentage of the balance (e.g., 2% or 3%), and they vary as the balance changes. A fixed-rate loan has a constant payment that fully amortizes the loan by the end of the term. Credit cards typically have revolving balances and no fixed end date, so the schedules are fundamentally different.
Q: Can I calculate the schedule for a loan with a different payment frequency?
Yes, but the formula changes. For biweekly payments, you’d use a rate per two-week period and the number of periods. The formula is the same structure, but you adjust the rate and n. This calculator assumes monthly payments, which is the most common.
Q: Why does the total interest seem so high?
Because interest is calculated on the entire balance over the full term. Even at a moderate rate like 8%, over 5 years you pay about 21.7% of the principal in interest. Longer terms and higher rates increase this percentage. The schedule shows exactly how much interest you pay each month, so you can see the cost of borrowing.
The result from this calculator is an estimate based on the inputs you provide; the lender’s official disclosure will give the exact figures for your loan.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Jet Fuel Cost per Gallon? Prices and What Affects Them
- High Amount Personal Loan Interest Rate Calculator$405.53
- Fuel Costs and Home Loans: How They Connect$405.53
- Fuel Costs Perth: Prices, Factors and Savings
- Car Quote for a Used-Car Trade-In: What It Means
- Cost of Fuel: Calculate Your Trip’s Fuel Expense$42.00