A loan repayment schedule report viewer shows how each scheduled payment is divided between principal and interest, and how the balance changes over time. This calculator estimates a fixed-rate, monthly-payment schedule from the loan amount, APR, and term, then reports the monthly payment and total interest; use your lender’s statement or loan documents for the exact schedule.
Formula
The calculator uses the standard level-payment formula for a fully amortizing loan with monthly payments. The monthly payment before display rounding is:
Payment = P × r ÷ [1 − (1 + r)−n]
- P is the starting loan principal, in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200. For an APR of 8%, r is 0.08 ÷ 12.
- n is the total number of monthly payments, calculated as years × 12.
The displayed monthly payment is rounded to cents. Estimated total interest is the rounded monthly payment multiplied by the number of payments, minus the original principal. Because the payment is rounded, the final scheduled payment on a real loan may differ slightly from the regular payment shown here.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a 5-year term:
- Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
- Find the number of monthly payments: 5 × 12 = 60.
- Apply the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $405.53 per month, rounded to cents.
- Calculate estimated total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The estimated regular payment is $405.53, and estimated interest over the scheduled term is $4,331.80.
Assumptions
- The interest rate is fixed for the full term.
- Payments are made monthly at the end of each period.
- Interest accrues monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, and escrow, because none of those are inputs.
What a Repayment Schedule Report Shows
A repayment schedule—also called an amortization schedule—organizes the loan into payment periods. A complete report commonly includes the payment number or date, the scheduled payment, the interest portion, the principal portion, and the remaining balance. The calculator above gives the core payment and interest estimates, not a date-by-date table.
Early in a standard amortizing loan, the outstanding balance is larger, so more of a level payment goes to interest. As principal is paid down, the interest portion generally shrinks and more of each payment reduces principal. The payment can stay level even though its components change. This pattern assumes the rate and payment structure do not change.
For example, with a monthly rate r and a balance B at the start of a period, the period’s interest is approximately B × r. The principal reduction is the payment minus that interest, and the next balance is the prior balance minus the principal reduction. Real servicing calculations can depend on payment dates, rounding, and contract terms, so this illustration is not a substitute for a lender-generated report.
How to Read and Use the Estimate
Enter the principal amount being borrowed, the annual percentage rate supplied for the loan, and the term in years. Check whether the lender’s quoted figure is an APR or a different rate measure; the calculator treats the entered percentage as an annual rate and divides it by 12 for monthly calculations.
- Monthly payment: A fixed scheduled payment estimate under the stated assumptions. It is not necessarily the full amount due if a loan has separate charges.
- Total interest: Estimated interest across all scheduled payments, based on the cent-rounded payment. It is not the total cost of borrowing if fees or other charges apply.
- Remaining balance: A detailed schedule would show this after each payment. The balance falls as principal is repaid, subject to the lender’s posting and interest rules.
A report viewer may let a reader inspect, print, or export an existing schedule, while a calculator estimates one from inputs. This page is the calculation part: it does not access a loan account, retrieve a lender’s report, or create a downloadable statement. To reconcile an estimate with a statement, compare the principal, rate, term, payment frequency, and any listed fees or extra payments.
Common Differences and Limitations
An estimate can differ from a lender’s schedule without either display being arithmetically inconsistent. A variable rate can change the interest charged. A payment date that differs from the assumed monthly timing can affect accrued interest. Fees financed into the balance, skipped or late payments, extra principal payments, and a final payment adjustment can also alter the schedule.
APR and the rate used for periodic interest are related but not always interchangeable descriptions in loan documents. This calculator follows the specified convention of dividing APR by 12. It does not model daily accrual, irregular payment periods, interest-only periods, balloon payments, payment holidays, or changing rates. It also does not estimate taxes, insurance, escrow, or an approval decision.
Rounding matters most when comparing individual rows or the final balance. Calculators and servicers may round interest per period, use more precise internal values, or adjust the final payment. Treat the displayed totals as estimates, and use the contract and servicing records when an exact amount or payoff figure is needed.
Frequently Asked Questions
What is a loan repayment schedule report viewer?
A report viewer displays the entries in a repayment schedule, such as payment dates, interest, principal, and remaining balances. A calculator estimates payment arithmetic but does not retrieve an account-specific lender report.
How do I calculate a monthly loan payment?
Use the level-payment formula with the principal, monthly rate (APR divided by 1,200), and number of monthly payments. The calculator applies that formula and rounds the payment to cents.
Why does the interest portion decrease over time?
For a fixed-rate amortizing loan, interest is calculated on the outstanding balance. As principal is repaid, the balance falls, so the interest portion generally becomes smaller.
Does the estimate include fees or insurance?
No. The inputs include only principal, APR, and term. Fees, taxes, insurance, PMI, escrow, and other charges are not included.
Why does my lender’s schedule show different figures?
The loan may use different dates, rate conventions, rounding, fees, extra payments, or a variable rate. Check the loan documents and lender statement for the calculation details that apply to that account.
This result is an estimate for education, and 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
- Cash-Out Refinance a Car? Calculator and Costs$405.53
- Case Total Cost of Ownership Calculator$405.53
- Cash-Out Auto Refinance: Calculate Your New Loan$405.53
- Car Cost of Ownership Calculator and Key Expenses$650.00
- Car Total Cost of Ownership Calculator: Full Cost
- Car Refinance Cash Out Options and How They Work$405.53