Amortization Schedule With an Unknown Variable

An amortization schedule with an unknown variable can be worked out by using the known loan details and payment history to solve for the missing value, such as the monthly payment, interest rate, loan term, or remaining balance. This calculator estimates the monthly payment, total interest, and total of payments when you enter the loan amount, APR, and term; it does not solve for an unknown input directly.

Formula

A standard amortizing loan has equal monthly payments, a fixed periodic interest rate, and a balance that declines as payments are applied. The payment formula is:

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

• P is the starting principal, in dollars.
• APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
• r is the monthly rate, calculated as APR ÷ 1,200. At 8% APR, r is 0.0066667 per month.
• n is the number of monthly payments, calculated as years × 12.
• M is the monthly payment, in dollars.

The calculator rounds M to cents. Total interest is I = M × n − P, and the total of scheduled payments is M × n. Because the interest output uses the rounded monthly payment, it reflects the effect of cent rounding over the full term.

Worked Example

Using the calculator’s defaults, the principal is $20,000, APR is 8%, and the term is 5 years.

1. Convert APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066666667.
2. Count the payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: M = 20,000 × 0.0066666667 ÷ [1 − (1.0066666667)−60].
4. The unrounded result is about $405.53, so the monthly payment rounded to cents is $405.53.
5. Total scheduled payments are $405.53 × 60 = $24,331.80; estimated interest is $24,331.80 − $20,000 = $4,331.80.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal monthly installments, made at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• Fees, taxes, insurance, mortgage insurance, and escrow are not included.
• The calculation assumes the full stated principal is amortized through the scheduled payments, with no extra payments or missed payments.

What an Unknown Variable Means

An amortization schedule lays out each payment over time. For every period, it separates the payment into interest and principal, then updates the remaining balance. If a schedule has a missing number, first identify which quantity is unknown and which values are known. The equation changes depending on the missing variable.

For a fixed-rate loan, the interest portion in a month is generally the starting balance for that month multiplied by the monthly rate. The principal portion is the payment minus that interest. The next balance is the prior balance minus the principal portion. Early in a typical fully amortizing loan, a larger share of a level payment goes to interest because the balance is higher; later, more goes to principal.

The calculator above answers the forward question: given principal, APR, and term, what is the scheduled payment? It does not infer an APR or term from an observed payment, nor does it reconstruct an exact balance from an incomplete statement. Those are inverse problems requiring different formulas and, in some cases, a numerical solver or additional information.

How to Solve for Common Missing Values

• Payment: If principal, periodic rate, and number of payments are known, use the standard payment formula shown above.
• Balance after a known number of payments: For a fixed monthly rate and level payment, use Bk = P(1+r)k − M[(1+r)k−1]/r, where k is the number of payments already made. This assumes payments occur at period-end and are made on schedule.
• Interest rate: If payment, principal, and term are known, the rate usually must be solved numerically. There is not generally a simple rearrangement of the payment equation that yields the rate directly. A stated payment may also include amounts outside principal and interest, so check what it represents.
• Term: If principal, payment, and rate are known, a logarithmic formula can estimate the number of payments, provided the payment exceeds the interest due each period. If it does not, the balance will not decline under the assumed model.
• Principal: If rate, payment, and term are known, the payment equation can be rearranged to find the principal that those inputs support mathematically. This is a calculation, not an approval or affordability determination.

For a real account, the lender’s balance may differ from a formula estimate because of payment dates, daily interest accrual, rounding practices, fees, rate changes, or payment changes. Use the statement or lender’s payoff information when an exact account figure is needed.

Reading a Schedule and Avoiding Mistakes

A detailed schedule typically has columns for payment number or date, payment amount, interest, principal, and ending balance. The first few rows can help check whether the arithmetic is plausible: interest should equal the period’s opening balance times the periodic rate under the stated assumptions, and principal should equal payment minus interest. Small differences in the final row can arise when payments are rounded to cents; real contracts may adjust the last payment.

• Enter APR as a percentage, not a decimal: enter 8 for 8%, not 0.08.
• Use years for the term in this calculator. A 60-month term is 5 years; entering 60 as years would produce a different and incorrect result.
• Do not confuse the monthly payment with the total amount paid. The total includes every scheduled installment.
• Check whether a quoted payment includes only principal and interest. An all-in bill may include charges the formula does not model.
• Do not treat a rounded estimate as an exact payoff quote. A payoff amount may include interest through a particular date and other account-specific adjustments.

“Amortization” does not always mean the same pattern. A variable-rate loan can have changing payments or changing proportions of principal and interest as its rate resets. An interest-only period, balloon amount, skipped-payment feature, or extra principal payment also changes the schedule. The fixed-rate level-payment formula cannot represent those features without being adapted period by period.

Frequently Asked Questions

Can I calculate an amortization schedule if the interest rate is unknown?
Not exactly from the loan amount and term alone. You also need enough information, such as a known payment and a defined payment frequency, to solve for the rate. The solution is usually numerical and depends on whether the payment includes only principal and interest.

How do I find the remaining balance after several payments?
For a fixed-rate loan with level monthly payments, apply the balance formula using the original principal, monthly rate, scheduled payment, and number of payments made. The result is an estimate under those assumptions; account timing and rounding can create differences.

Why does the first payment include more interest?
Interest is calculated on the outstanding balance. Since the balance is usually largest at the start, the interest portion is also largest then. As principal is repaid, the balance falls and later payments generally contain less interest.

Does this calculator include extra payments?
No. It assumes the same scheduled payment each month and no additional principal payments. Extra payments generally change the later balance and interest, so they require a schedule that records their amount and timing.

Why does my lender’s schedule differ from this estimate?
Possible reasons include daily rather than monthly interest calculations, a changing rate, fees, payment dates, rounding, or a payment that includes non-loan charges. Compare the assumptions and ask the lender for an account-specific breakdown if needed.

This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.

Related

• Auto Loan Amortization Schedule Calculator
• Amortization Schedule: How Normal Payments Work
• 10-Year Amortization Schedule Calculator and Example

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