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


example of perpetuityhow to calculate cash coverage ratiojournal entry for sale of inventorytrade discount in accountingaccounting suspense account examplesmarkup cost formulaaccruals journal entriesis income summary a temporary accountdays sales in receivable formulacreditor days formulajournal entry of bills receivableacrued expense200 db depreciation tablebank reconciliation excel spreadsheetwarranty journal entryannuity to present valuemargin of safety formula percentagelump sum annuity formulaaccounting and bookkeeping pdfabbreviated accounts templatesales return and allowances normal balancedepletion expense formulajournal entry to record deferred revenuehow to calculate manufacturing overhead applied to work in processjournal entry of goodwillexamples of profitability ratiosaccounting for unrealized gains and losses on investmentsredeemable common stockcoupon rate bond calculatorcapital expenditure balance sheetaccrued revenue journal entryconsignor vs consigneedirect labor rate formulabookkeeper duties checklistnpv calculation example in excelpresent value of annuity formulapayback period calculator onlinepayback calculation formulafuture value of an annuity formula calculatorpetty cash log templateamortization expense on income statementtrading marketable securitiesfuture value of an annuity calculator monthlytreatment of intangible assetspresent value of lease payments formulaadvance payment journal entryentry to replenish petty cashmaterial price variance calculatoraccounting rate of return calculationnon interest bearing note payableformula for total contribution marginwhat is double entry bookkeeping definitionsalary expense journal entrynotes receivable journal entryamortization of bond premium journal entrydividends declared balance sheetchart of accounts templateswhat is the meaning of bills payable and bills receivablesfinished goods inventory definitiontrade payables definitionstraight line method of calculating depreciationending inventory adjusting entrydepreciation reducing balance methodexcel worksheet templatesdefine debit note and credit noteannuity due tableannuity due present valuebond accounting journal entriesannuity perpetuity formuladirect materials formulacommon size analysis of income statementfixed asset reconciliation templateadjusting entries bad debt expenseexamples of accounting equationebit pbitdays debtors ratio