Formula & Calculator
Amortization Remaining Loan Balance
Calculates the outstanding balance remaining on an amortizing loan after a given number of payments have been made.
Interpretation
B = P(1+r)^p − PMT×(((1+r)^p − 1)/r). The outstanding balance after p payments. Used to track loan progress and to plan refinancing.
Variables
| Symbol | Quantity | Unit |
|---|---|---|
| B | Remaining balance | currency |
| P | Original loan principal | currency |
| r | Periodic interest rate | |
| p | Number of payments made | |
| PMT | Fixed periodic payment | currency |
What it means
This formula calculates the remaining balance of a loan after a certain number of payments (p) have been made. It is derived from the amortization formula. It is useful for understanding how much principal remains, for refinancing decisions, and for early payoff calculations. It helps borrowers see the impact of extra payments on the loan term and interest savings. Understanding this calculation is important for effective debt management and financial planning.
Worked example
Remaining Loan Balance – Two Detailed Examples
Real‑World| Parameter | Value |
|---|---|
| Principal | 300000 |
| Payments Made | 60 |
| Monthly Payment | 1896.2 |
| Parameter | Value |
|---|---|
| Principal | 25000 |
| Payments Made | 24 |
| Monthly Payment | 495 |
Common mistakes
- Remaining balance: The outstanding loan balance after a certain number of payments (p).
- P: Original loan amount.
- r: Monthly interest rate (in decimal).
- PMT: The fixed monthly payment.
- p: The number of payments already made – not the total number.
- Formula: This is the standard amortization formula – ensure you use the same interest rate per period.
Applications
The remaining loan balance formula gives the unpaid principal after a certain number of payments (p) in an amortising loan. This is used for tracking loan progress, for evaluating refinancing opportunities, and for assessing early payoff options. Borrowers can use it to see how much principal remains and to plan extra payments. Lenders use it for servicing and for calculating interest accrual. By understanding the remaining balance, individuals can make informed decisions about extra payments, refinancing, and debt management. This formula is also useful for calculating equity in a mortgaged property. It is a key tool in loan management and financial planning.
- Mortgage balance tracking and equity calculation
- Refinancing decision analysis
- Early payoff planning and extra payment strategies
- Loan servicing and amortisation schedules
- Personal debt management and tracking
Frequently Asked Questions
B = P*(1+r)^p − PMT*(((1+r)^p − 1)/r). It calculates the outstanding principal balance on a loan after p payments have been made, based on the original principal P, monthly rate r, and fixed payment PMT.
It is derived from the loan payment formula and uses the same variables. It is essentially the present value of the remaining payments at time p.
Because early payments are mostly interest; principal is paid slowly at first. As time progresses, more of each payment goes toward principal, so the balance decreases faster near the end of the term.
For each period, calculate interest = previous balance × r, principal = PMT − interest, new balance = previous balance − principal. The formula gives the balance after a given number of payments directly.
Extra principal payments reduce the balance faster, shortening the loan term and reducing total interest. You can recalculate the remaining balance after the extra payment using this formula with the reduced principal.
For adjustable‑rate loans, use the remaining balance at the adjustment date as the new principal, then recalculate the payment with the new rate and remaining term.
- Using the wrong number of payments (p) – count payments made, not years.
- Forgetting to use the same periodicity for r and p.
- Confusing monthly payment with annual payment.
For an interest‑only loan, the principal does not decline during the interest‑only period. The balance remains at the original principal until amortization begins. The formula would still work if PMT equals the interest amount, making the balance unchanged.
It helps determine the current outstanding balance, which is needed to evaluate the cost and benefit of refinancing at a lower rate.
The formula does not include penalties – those are separate costs. If there is a prepayment penalty, it would be added to the payoff amount.