Lump Sum Number of Periods Formula


n = LN(FV / PV) / LN(1 + i)
Variables used in the formula
PV = Present Value
FV = Future Value
i = Discount rate
n = Number of periods
LN = natural logarithm


The lump sum number of periods formula is used to work out the amount of time (n) it takes to grow a lump sum from its present value (PV), to a future value (FV) allowing for a given discount rate (i%).

Lump Sum Number of Periods Formula Excel Function

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


*The pmt and type arguments are not used when calculating the number of periods for a lump sum.


If a lump sum of 1,000 is received at the start of period 1, and the discount rate is 10%, then the number of periods to increase the value of the lump sum to 2,000 is given by the lump sum number of periods formula as follows:

n = LN(FV / PV) / LN(1 + i)
n = LN(2,000 / 1,000 / LN(1 + 10%)
n = 7.27 periods

The same answer can be obtained using the number of periods formula in Excel as follows:

n = NPER(i,,PV,-FV)
n = NPER(10%,,1000,-2000)
n = 7.27 periods

*don’t forget the minus sign on FV

The lump sum number of periods formula is one of many used in time value of money calculations, discover another at the links below.

Lump Sum Number of Periods Formula November 6th, 2016Team

You May Also Like

Related pages

how to calculate residual value on a leaseformula of present value of annuityloss on disposal of fixed assetslifo perpetual inventory method exampleaccruals vs cashdaily bookkeeping templatedepreciation salvage value formuladouble declining amortizationstockholders equity journal entriesthe formula for computing annual straight line depreciation isfcf calculatorirr accountingdu pont identity formulaoverstated understated accountingvariable cost revenue ratiobook rate of return formulajournal entry for accounts receivable collectedwhich journal would adjusting entries be foundmortgage constant formulaavailable for sale securities journal entrieswhat is the purpose of the bank reconciliation statementvariable cost percentagedouble entry for hire purchase of motor vehicleaccounts receivable ledgerthe double declining balance method of depreciation is used forcalculate a perpetuitywhat does fob on an invoice meaninfinite cash flowmarkup vs marginjournal entry for bad debtsunits of output depreciation calculatorpayroll journal templateprepaid wages journal entrymaterial price variance calculatordays sales outstanding formulacalculate future value of annuityjournal entries of accounts receivablevoucher payment sampleissuance of treasury stockfifo and lifo in accountingcommon size balance sheetscalculate interest expense on bondsyield to maturity formula excelfuture value of annuity chartconsignee account numberleverage ratio formulameaning of double entry bookkeepingcontra account listaccrued expenses and outstanding expensesdso ratio formulamark up vs marginwhat is a cash floateffective interest rate amortization calculatordebtor days calculation formulaaccounting adjusting entries problemsperpetual inventory system journal entrywhat is double entry bookkeeping systemgaap vacation accrualhow to calculate gp percentageoverstating ending inventorycompute the contribution margin ratiopercent markup calculatorcash book ledger formatcalculating gross margin formulaoverhead recovery rate formulaloan repayment equationdu pont equationmargin versus mark upaccrual accounting versus cash accountingcalculate payback period excelcalculating retained earningsfixed overheadpresent value of lump sum formulahow to calculate weighted average inventoryjournal entries for accounts receivablewhat does eom meanincome account normal balancewhat is beginning inventorycalculate perpetuityaccounting debit and credits