Property & finance
Calculation method and formula
B(0) = Current balance − Extra payment; r = Annual rate [%] ÷ 1200; B(next month) = maximum(0, B × (1 + r) − A)
Understand the inputs
- Current balance
- Use a measured value or your own assumption.
- Extra payment
- Use a measured value or your own assumption.
- Annual rate
- Unit: %. Use a measured value or your own assumption.
- Years remaining
- Unit: J.. Use a measured value or your own assumption.
Assumptions and limitations
A is the original constant annuity payment, r the monthly interest rate and B the balance. The extra payment is immediate; keeping the same payment shortens the term. The model compares accumulated monthly interest with and without the extra payment. Fees and contractual prepayment limits are excluded.
The formula uses the specified units. Displayed numbers are rounded; whole packs, item counts and full time periods may also be rounded within the calculation.