Loan Balance Formula

Formula

PV = Pmt x (1 - 1 / (1 + i)n) / i
Variables used in the annuity formula
PV = Loan Balance
Pmt = Periodic payment
i = Discount rate
n = Number of periods remaining

Use

The balance outstanding on a loan is equal to the present value of the remaining periodic loan installments.

This is further discussed and explained in our How to Calculate an Outstanding Loan Balance tutorial.

The loan balance formula is based on the present value of an annuity formula, and shows the outstanding balance on a loan today (PV) based on of series of regular loan installment payments (Pmt). The payments are made at the end of each period for the remaining n periods of the loan, and a discount rate i is applied.

The loan balance formula discounts the value of each payment back to its value at the start of period 1 (present value).

Excel Function

The Excel PV function can be used instead of the loan balance formula, and has the syntax shown below.

PV(i, n, pmt, FV, type)

*The FV and type arguments are not used when using the Excel present value of an annuity function.

Example using the Loan Balance Formula

A loan of 50,000 with an interest rate of 8%, is repaid over a period of 7 years with monthly installments of 779.31 paid at the end of each month. What is the balance outstanding on the loan after 26 months?

The outstanding balance can be calculated using the loan balance formula as follows:

Pmt = Periodic payment = 779.31 a month
i = Discount rate = 8%/12 a month
n = Number of periods remaining = 84 - 26 = 58
PV = Pmt x (1 - 1 / (1 + i)n) / i
PV = 779.31 x (1 - 1 / (1 + 8%/12)58) / (8%/12)
PV = 37,384.70

The same answer can be obtained using the Excel PV function as follows:

PV = PV(i, n, pmt)
PV = PV(8%/12,58,-779.31)
PV = 37,384.70

The loan balance formula is one of many annuity formulas used in time value of money calculations, discover another at the link below.

Loan Balance Formula October 30th, 2017Team

You May Also Like


Related pages


prepaid rent in balance sheethow to find future value of an annuityprintable ledgerformula for stock turnoversales ledger control account formatwhat is a growing perpetuitysample of a general ledgerturnover ratio formulapurchase ledgecapex examplesrental income journal entrybreakeven calculatorsallowance method for accounting for bad debtsending inventory formula accountingprofit margin formula exceldefine fob originsample excel spreadsheet templatesthe lifo reserve isexcell pmtaccounting tutorialsallocation base for manufacturing overheadannuity tablesannuity tablesaccrual and prepayment examplesmark up formulaexample of accumulated depreciationt accounts debits and creditshow do you calculate dsocontra accounts receivableexamples of intangiblesmanufacturing overhead costs includeweighted average inventory costing methodjournal entry for recovery of bad debtscalculate accounts receivable turnover ratiojournal entry for salary receivedhow to calculate gross margin per unitsafety stock reorder pointexamples of debits and credits in accountinginventory systems accountingwhat is unearned income in accountingnbv depreciationcalculate interest rate excelcash receipt voucher sampleaging of accounts receivable examplebookkeeping worksheetscalculating the present value of an annuityjournal entry for car loanpv growing annuitycalculate finished goods inventoryequivalent units for conversion costsdirect material usage variance formulabalance sheet debit creditcontribution margin ratesubsidary ledgerdeferred tax liability definitionconvertible note accounting treatmentis prepaid insurance a deferralconsignee accountingperforma of income statementaccounts payable example entrysales ledger examplehow do you calculate mark upstatement of retained earnings definitionbookkeeping formulacreditor days calculationslow moving and obsolete inventoryformula for contribution margin ratioformat for petty cash bookpv calculation in excelcash discount accounting treatmentprepare a contribution format income statementdebtors ratiocreditor days definitionaccounting fob