Number of Periods Annuity Formula PV


n = LN (Pmt / (Pmt - PV x i)) / LN(1 + i)
Variables used in the annuity formula
PV = Present Value
Pmt = Periodic payment
i = Discount rate
n = Number of periods
LN = Natural logarithm


This number of periods annuity formula PV calculates the number of periods required for an annuity payment (Pmt) made at the end of each period to produce a present value (PV) when a discount rate (i) is applied.

The number of periods annuity formula PV can be used for example to determine the number of annuity payments required to clear the balance on a loan account.

Excel Function

The Excel NPER function can be used instead of the number of periods annuity formula PV, and has the syntax shown below.


*In this instance, the FV and type arguments are not used when using the Excel number or periods function.

Example Using Number of Periods Annuity Formula PV

A loan account balance of 50,000 (PV) is being paid off with regular periodic payments of 6,000 (Pmt) at the end of each period. If the interest rate on the loan is 6%, the number of periods (n) it would take to clear the loan balance is given as follows:

n = LN (Pmt / (Pmt - PV x i)) / LN(1 + i)
n = LN (6000 / (6000 - 50000 x 6%)) / LN(1 + 6%)
n = 11.90 periods 

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

n = NPER(i,pmt,PV,FV,type)
n = NPER(6%,-6000,50000,,)
n = 11.90 periods

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

Number of Periods Annuity Formula PV November 6th, 2016Team

You May Also Like

Related pages

factor accounts receivableendowment fund accountingchart of accounts pakistanhow to calculate total assets turnoverin a journal entry which is debit and credithow to prepare a vertical analysisrecord cogsaccounting turnover formulawhat is a current liabilities examplesliquidity ratio acid testis petty cash an asset or expenseformula to calculate simple interest and compound interestexamples of revenue expenditure and capital expenditurecalculating percentage markupwhat is roce in accountingsample questions on bank reconciliation statementfuture value of annuity due calculatoradjusted trial balance worksheet templatecash flow statement retained earningsgross profit equationreturn on capital employed ratio formulaaccounts payable credit or debitvertical analysis income statement calculatorprofitable indexformula for annuitydoubtful accounts expensepurchase returns and allowances journal entrycalculate the total estimated bad debtsmonthly depreciation calculatorpresent value table annuity duehow to calculate lifo liquidation profitprocess costing tutorialjournal entry bad debt expenseaccounts receivable days ratioannuity present valuejournal entries examples accountingbookkeeping double entry examplesblank ledger sheetsaccounting for insurance recoveriesretire treasury stock journal entrywhat is predetermined overhead ratepresent value annuity factor formulaannuity growth calculatorpresent value of annuity in excelnominal annual rate of return formulaadvantages of payback periodsales returns income statementnominal discount rate formulajournal entry to write off bad debtweighted average cost inventory formulahow to reduce gearing ratiopledging receivablesdouble entry for fixed assetsunearned revenue arethe basic accounting equation isretained profit meaningcommon size balance sheet ratiostrial balance example ukbills receivable accountequation rearranger calculatornon profit financial statement template freeallowance for impairment of receivables journal entrypre determined overhead ratecomputing payback periodhow to calculate manufacturing overhead ratebank cheque definitioncomplicated accounting journal entriesrecording petty cashnotes payable adjusting entrystandard costing systemtrade discount accounting treatmentaccounts payable test questions and answerspresent value of infinite cash flowvertical analysis of a balance sheetexcel accounting templates for small businesses