Number of Periods Annuity Formula FV

Formula

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

Use

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

The number of periods annuity formula FV can be used for example, to determine the number of periods is will take for a savings account balance to reach a given value assuming regular periodic deposits are made into the account at the end of each period.

Excel Function

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

NPER(i,pmt,PV,FV,type)

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

Example Using Number of Periods Annuity Formula FV

An amount of 5,000 (Pmt) is deposited into a savings account at the end of each period. If the discount rate (i) is 4%, calculate the number of periods (n) it will take from the saving account to reach a balance of 120,000 (FV). The number of periods is given as follows:

n = LN ((FV x i + Pmt) / Pmt) / LN(1 + i)
n = LN ((120000 x 4% + 5000) / 5000) / LN(1 + 4%)
n = 17.16 periods

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

n = NPER(i,pmt,PV,FV,type)
n = NPER(4%,-5000,,120000)
n = 17.16 periods

The number of periods annuity formula FV is one example of an annuity formula used in time value of money calculations, discover another at the link below.

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

You May Also Like


Related pages


cash received from customers journal entryunsecured loans in balance sheetbank leverage ratio formulacalculating dividends from balance sheetaccounting adjusting journal entriesincome statement multiple steptemplate for small business bookkeepinginventory sheets templateformula paybackinstallment note definitionfuture value of an annuity examplevoucher sample templateinventory to cost of goods sold ratiodouble booking accountingexcel pmt exampleamortization schedule excel downloadstraight line depreciation rate formulamonthly ledger templatecalculating gross profittransaction journal entriesdouble entry prepaymentbalance sheet reconciliation templateamortize bond discounthorizontal analysis financial statementshow to calculate cash discountcalculating future value of annuitydeferred taxes definitionallowance for doubtful debts in balance sheetjournal entry accounts receivablehow to figure straight line depreciationlifo reservesrequisition of materialsformula to find variable costallowance to reduce inventory to lifowhat are ledgers in accountingcalculating rocepayback period calculationmarkup calculationsmarkup and margincash float sheetclosing stock debit or creditsale of fixed asset journal entryhow to calculate inventory holding periodaccounts receivable and allowance for doubtful accountstrial balance adjustments exampleinterest bearing note payabledefine imprestaccounts payable ratioscash accruals formulanormal balance of accounts payablehow to amortize bond premiumcompound depreciation calculatorcalculate asset turnover ratioexcel worksheet templateformula of accounting equationcalculate variable expensesoperating lease vs finance lease accountingjournal entries for perpetual inventory systemconvertible redeemable preferred stockexample retained earnings statementpartnership appropriation accountpurchase return debit notebalance formula calculatorfuture value of an annuity due calculatorformula for debtors collection periodconstant growth model excelperiodic inventory formulaannuity due tablebookkeeping test questionsinstallment notescapital lease vs operating lease examplecreditor accounting definitioncapex items example