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

present value of perpetual annuityaccounting principles quizaccounting entry for prepaid expenseshow to record unearned revenueannuity payments formulaaccounting quiz questions and answersadjusting journal entry examplesum of the years digits depreciation formulaexamples of variable expensedeferred liability journal entrymanufacturing overheadspercentage of completion accounting entriesprepaid adjusting entrydepreciation declining balance methodbookkeeper dictionarycash payback periodshrinkage meaningdouble entry for fixed assetsjournal entry for car loancvp income statement formatoverhead cost variancefob merchandisewip calculationrules of bookkeepingjournal entry for operating leasehow to calculate nrvdouble depreciation formulasample accounting excel spreadsheetnominal annual rate of return calculatorlifo calculation formuladouble booking accountingintangible fixed assets amortisation policyincome projection templatetabel present value lengkapshare repurchase journal entrydefine amortization expensepresent value of annuity table excelprepaid rent journal entrygeneral ledger spreadsheetcumulative redeemable preferred stocksafety stock calculation exceldouble declining balance depreciationpv of annuity chartcost of good sold income statementdebit credit journal entriesaccruals and prepayments double entrypayable ledger control accountpv of annuity chartroce ratio formulapresent value of a bond calculatoradjusting entries problemsdirect labor cost varianceexamples of accrued liabilitiespayback period templatedifference between p&l and balance sheetsale ledger control accountnet relizable valuepresent value of a growing annuity formulaeffective interest method of amortizationformula asset turnover60 days eomprovision doubtful debtscalculation of irr in excelbad debts provisionpremium xxx accountsafda accountinggross margin vs markup calculatorvariable overhead spending variance formulaaccounting templates in excelaccounts receivable to working capital ratiodeferred expenses definitionleverage ratio examplesplant overhead costperpetual inventory journal entry