A loan repayment table shows how each scheduled payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual percentage rate (APR), and term below to estimate the monthly payment and total interest; this calculator does not generate a row-by-row schedule.
Formula
This calculator estimates a fixed monthly payment using the standard amortizing-loan formula:
Monthly payment = P × r ÷ [1 − (1 + r)−n]
- P is the amount borrowed, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1,200. APR is entered as a percentage per year.
- n is the number of monthly payments: loan term in years × 12.
The displayed payment is rounded to cents. Estimated total interest is the rounded monthly payment multiplied by the number of payments, minus the original loan amount. This follows the calculator’s stated assumption that the same rounded payment is made each month; actual loan servicing may adjust a final payment to clear a small remaining balance.
Worked Example
Using the default inputs—$20,000 borrowed, 8% APR, and 5 years:
- Convert the annual rate to a monthly decimal: 8 ÷ 1,200 = 0.0066667.
- Find the number of monthly payments: 5 × 12 = 60.
- Substitute into the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- The estimated monthly payment is $405.53.
- Using the rounded payment, estimated total interest is $405.53 × 60 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are level, made monthly, and assumed to occur at the end of each monthly period.
- Interest is modelled monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, and other charges are not included.
What a Loan Repayment Table Shows
A full repayment table, also called an amortization schedule, lists each payment period separately. Common columns include the payment number or date, opening balance, payment amount, interest charged, principal repaid, and closing balance. The closing balance for one row becomes the opening balance for the next.
For a fixed-rate loan with regular payments, interest for a period is generally calculated on the outstanding principal. Early payments therefore tend to contain a larger interest share; as the balance falls, the interest portion usually declines and more of each level payment goes toward principal. The payment may remain steady even though its allocation changes.
The calculator above gives the payment and an aggregate interest estimate, not the individual rows. To build a table, a lender’s payment schedule or a separate amortization calculator needs to apply the payment-period calculation repeatedly and account for the loan’s actual dates, rounding, and terms.
How to Read and Use the Estimate
Use the monthly payment as the scheduled principal-and-interest amount under the inputs shown, not as a complete measure of the cost of borrowing. A housing payment, for example, can involve charges such as taxes or insurance that are outside this calculation. Likewise, a loan may have fees or a changing rate that make actual payments differ.
The total-interest figure is an estimate across the full stated term. It is not the total amount of all payments: the principal is repaid as well. In the example, the sum of payments is $24,331.80, of which $20,000 repays principal and $4,331.80 is estimated interest.
For a personal repayment table, use the exact principal, APR, and term shown in the lender’s documents. If the APR includes costs that are not charged as monthly interest, the APR may not be the rate used to calculate each scheduled interest charge. Check the loan disclosure for the contract’s payment amount and calculation method.
Common Problems and Limits
- Confusing APR with a monthly rate: Enter APR as a yearly percentage, such as 8, not 0.08 or a monthly figure. The formula converts it to a monthly rate.
- Expecting a complete bill: The result excludes fees, taxes, insurance, and other charges unless they are incorporated into the loan amount or separately modelled.
- Rounding differences: A schedule may round interest to cents each period, while this estimate applies a formula to the inputs and rounds the payment. Small differences can accumulate; a final payment may be adjusted.
- Variable rates or irregular payments: A fixed-rate level-payment formula does not capture rate resets, skipped or late payments, payment holidays, or extra principal payments.
- APR at zero: This calculator requires APR of at least 0.01% because its formula divides by the monthly rate. For a genuinely interest-free loan, the basic payment is principal divided by the number of payments.
An amortization table is a forecast based on stated assumptions, not proof of the balance at a future date. The actual schedule depends on the lender’s terms and the timing and amount of payments posted.
Frequently Asked Questions
What is a loan repayment table?
A loan repayment table lays out scheduled payments over time, showing how much is assigned to interest and principal and what balance remains after each payment.
How do I calculate a monthly loan payment?
Convert APR to a monthly decimal by dividing it by 1,200, multiply the loan term in years by 12, and use the fixed-payment formula shown above. This calculator performs those steps for the entered values.
Why does a repayment table show more interest at the beginning?
When interest is based on the outstanding principal, the balance is largest near the start. As principal is repaid, the balance generally falls, reducing later interest charges when the rate and schedule stay unchanged.
Does the monthly payment include fees and insurance?
No. The calculator estimates principal and interest only. Other charges may apply under the loan terms, so use the lender’s disclosure to see the full scheduled amount.
Is a repayment table the same as an amortization schedule?
Usually, yes. “Amortization schedule” commonly refers to the period-by-period table showing payments, interest, principal, and remaining balance.
Can extra payments change the table?
They can reduce principal sooner and may change future interest or the payoff date, depending on how payments are applied and the loan terms. This calculator assumes regular level payments and does not model extra payments.
This result is an estimate; the lender’s disclosure gives the exact figures.
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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term