Mortgage Loan Balance After n Payments

Not Reviewed
Equation / Last modified by AndrewBudd on 2019/07/16 16:12
`Loan Balance = `
Rating
Copied from
ID
eng.Original Mortgage Loan Amount From Balance After n Payments
UUID
f67ad401-a766-11e9-8682-bc764e2038f2

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

Inputs

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 %.

Usage

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