calculate-loan

01 Loan payments

Loan Amortization Schedule Federal Bank

Calculator No. 01-20860 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A loan amortization schedule from a federal bank shows each monthly payment split into principal and interest over the life of the loan. You enter the loan amount, interest rate, and term, and the schedule lists every payment, the remaining balance, and the total interest paid. Use the calculator below to generate a full amortization table for any fixed-rate loan.

Formula

The monthly payment for a fixed-rate amortizing loan is calculated using the standard formula:

M = P × [r(1 + r)^n] / [(1 + r)^n – 1]

Where:

  • M = monthly payment (in $)
  • P = principal loan amount (in $)
  • r = monthly interest rate = annual percentage rate (APR) divided by 12, expressed as a decimal (e.g., 8% APR → 0.08/12 = 0.0066667)
  • n = total number of monthly payments = loan term in years × 12

Each month, the interest portion is the current balance times r. The principal portion is the monthly payment minus the interest. The new balance is the old balance minus the principal portion. Repeating this for each payment creates the amortization schedule.

Worked Example

Using the default values from the calculator: P = $20,000, APR = 8%, term = 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Total number of payments: n = 5 × 12 = 60
  3. Calculate (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
  4. Monthly payment: M = 20000 × [0.0066667 × 1.4898457] / [1.4898457 – 1] = 20000 × 0.0099336 / 0.4898457 ≈ 20000 × 0.020276 = $405.53 (rounded to the cent)
  5. Total paid over 60 months: $405.53 × 60 = $24,331.80
  6. Total interest: $24,331.80 – $20,000 = $4,331.80

The calculator gives the same results: monthly payment $405.53 and total interest $4,331.80.

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 APR/12.
  • The payment is rounded to the cent; the final payment may differ slightly to clear the balance.
  • This calculation does not include fees, taxes, insurance, PMI, or escrow amounts.

How to Read an Amortization Schedule

An amortization schedule is a table with rows for each payment period. Columns typically show:

  • Payment number (e.g., 1, 2, 3, … 60)
  • Payment amount (constant for a fixed-rate loan)
  • Interest portion (decreases over time)
  • Principal portion (increases over time)
  • Remaining balance (decreases to zero at the end)

Early in the schedule, most of each payment goes to interest. For example, in the first month of the $20,000 loan above, interest is $20,000 × 0.0066667 = $133.33, so principal paid is $405.53 – $133.33 = $272.20. By the last payment, interest is only a few dollars and nearly the entire payment reduces principal.

Why Federal Bank Amortization Schedules Matter

Federal banks (such as central banks or government-affiliated lenders) often provide amortization schedules for mortgages, student loans, or small business loans. The schedule helps borrowers see exactly how much interest they will pay over the life of the loan and how extra payments can shorten the term. For example, adding $50 per month to the $405.53 payment on the $20,000 loan would reduce the term from 60 months to about 54 months and save roughly $400 in interest. You can verify this by recalculating with a higher payment in the formula.

Common Mistakes and Misconceptions

One common mistake is confusing APR with the monthly rate. The APR is an annual rate; dividing by 12 gives the monthly rate. Another mistake is using the nominal rate instead of the effective rate when comparing loans with different compounding periods—this calculator assumes monthly compounding, which is standard for most amortizing loans.

A frequent misconception is that the total interest is simply the APR times the loan amount times the term. That would be $20,000 × 0.08 × 5 = $8,000, but the actual interest is $4,331.80 because the principal is being paid down each month. The amortization schedule shows this declining balance effect.

Another error is rounding intermediate values too early. Always keep at least six decimal places in the monthly rate and the (1+r)^n term until the final payment is computed.

How to Use the Calculator for Your Own Loan

To generate a schedule for your specific loan, enter the exact loan amount, the APR your lender quoted, and the term in years. The calculator gives the monthly payment and total interest. To see the full schedule, you can use the formula to compute each month’s interest and principal as described above, or use a spreadsheet with the PMT, IPMT, and PPMT functions.

If you are considering extra payments, you can adjust the formula: subtract the extra amount from the payment and recalculate the number of months needed to pay off the balance using the formula n = -ln(1 – rP/M’) / ln(1+r), where M’ is the new payment. This shows how much time and interest you can save.

Limitations of the Amortization Formula

The formula assumes a fixed interest rate and constant payment. It does not apply to adjustable-rate loans, interest-only loans, or loans with balloon payments. For those, the schedule is different and requires a more complex calculation. Also, the formula does not include any fees that might be financed into the loan, such as origination fees or closing costs. If fees are added to the principal, the loan amount should be the total financed amount, not just the purchase price.

For federal student loans, income-driven repayment plans or deferment periods change the schedule. This calculator does not model those program rules; check with your loan servicer for the exact schedule under such plans.

Frequently Asked Questions

What is an amortization schedule?

An amortization schedule is a table that shows each monthly payment on a loan, broken down into the interest and principal portions, and the remaining balance after each payment. It runs from the first payment to the last, when the balance reaches zero.

How do I get an amortization schedule from a federal bank?

Most banks, including federal ones, provide amortization schedules when you apply for a loan. You can also request one from the loan officer, or generate your own using the formula above or a spreadsheet. The schedule is usually included in the loan disclosure documents.

Does paying extra each month reduce the total interest?

Yes, making extra principal payments reduces the balance faster, which lowers the interest charged on the remaining balance. This can shorten the loan term and reduce total interest paid. For example, on a $20,000 loan at 8% for 5 years, paying an extra $50 per month saves about $400 in interest and pays off the loan about 6 months early.

Why is my interest payment higher in the early months?

Because the loan balance is highest at the start, the interest calculated on that balance is also highest. As you pay down principal, the interest portion decreases, and more of your payment goes toward principal. This is the standard amortization pattern for fixed-rate loans.

Can I use this calculator for a mortgage or car loan?

Yes, the formula works for any fixed-rate amortizing loan, including mortgages, auto loans, and personal loans. Just enter the loan amount, APR, and term in years. For mortgages, remember that property taxes, insurance, and PMI are not included in the payment calculation.

The result from this calculator is an estimate based on the inputs you provide. Your lender’s disclosure statement will show the exact payment, interest, and schedule for your specific 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

The whole Loan payments section →