Mortgage Loan Balance After n Payments

Not Reviewed
Equation / Last modified by AndrewBudd on 2019/07/16 16:12
`Loan Balance = `
Copied from
eng.Original Mortgage Loan Amount From Balance After n Payments

This Loan Balance equation computes the remaining debt (principal balance) on a fixed interest loan after a period of monthly payments have been made.  


The input parameters are:

  1. L - The Principal loan amount, the amount originally financed
  2. n - The number of months in the duration of the original loan; for a 30 year loan that is `n = 30 *12 = 360`
  3. p - The number of months into the loan,  the number of monthly payments that have been made to date
  4. r -The annual interest rate entered as a percent; i.e., enter 4.5 for an interest rate of 4.5 %.


This equation might be simply used just to give a homeowner an idea how much there still is to be paid on their mortgage loan. 

The equation would be useful in analysis of refinancing options, first computing with this equation how much will have to be refinanced at the present point into the loan.  The output from this equation would then serve as the financed principal for calculating refinancing options.

See also