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

future value formula annuityallocating manufacturing overhead costs is donewhat goes on a trial balancefinance lease accounting journal entriesan expense has what effect on the accounting equationdebtors control account formathow to compute gross profit percentagerestaurant accounting templatecreditors turnover ratiopetty cash withdrawal formdifference between markup and gross profitaccumulated depreciation formulaprepayment on balance sheetmargin markup formulavoucher layout templatehow to calculate double declining depreciationledger entry in accountingdebtor days formulacash flow statement analysisdisbursement ledgerpresent value of lump sum tablenpv formula in excelhow to calculate percent markupreducing balance depreciation methodssubsidiary ledgers and special journalsdepreciation half year conventionwhat does the contribution margin tell youfob destination pointaccounting for owners equitydepreciation on disposal of fixed assetsdeferred revenues accountingjournal entries for periodic inventory systemnpv tablesdouble declining method formulaformula roadiscount on bonds payable on balance sheetexample of annuity due problemsaccrual accounting examplesreceipt voucher samplecurrent asset turnover ratio formulascrap value accountingformula for accounts receivable turnovercalculate effective annual rateequation for net profit marginthe purpose of closing entriescalculate interest expense on bondsperpetual annuity calculatormerchandise inventory debit or creditdu pont identity formulapresent value of perpetuity formulapresent value of an annuity formulaadjusting entries depreciationaccounting templates for small businesswithholding tax accounting treatmentexcel pv functioncash discount accountinginventory holding days formulatimes interest earned ratio calculatormaterial variances formulaspetty cash log printabledebt to equity calculatorcash to accrual conversion worksheetpv of perpetuity calculatordoubling chartallowance for bad debt account typetimes interest earned calculatorhow to calculate weighted average cost of goods soldroyalty accounting noteslifo adjustmentjournal entry of bad debtspresent value of annuity examplesample of bank reconciliation statementdefine monetary unit assumptionaccounts payable credit or debit