Annuity Payment Formula FV

Formula

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

Use

This annuity payment formula FV calculates the annuity payment required to provide a given value in the future FV (future value). The annuity formula assumes payments are made at the end of each period for n periods, and a discount rate i is applied.

The annuity payment formula FV can be used for example, to calculate the periodic deposits needed to provide a required savings account balance (FV), given the number of deposits (n), and the account interest rate (i).

Excel Function

The Excel PMT function can be used instead of the annuity payment formula FV, and has the syntax shown below.

PMT(Rate, Nper, PV, FV, Type)

*In this instance, the PV and type arguments are not used when using the Excel annuity payment function.

Example Using Annuity Payment Formula FV

An investor wants to save an amount of 7,000 by depositing regular annuity payments for 14 periods at an interest rate of 3% per period. The amount of the annuity payment is given by the annuity payment formula FV as follows:

Annuity payment = Pmt = FV x i / ( (1 + i)n - 1 )
Annuity payment = Pmt = 7000 x 3% / ( (1 + 3%)14 - 1 )
Annuity payment = Pmt = 409.68

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

Annuity payment = PMT(Rate, Nper, PV, FV, Type)
Annuity payment = PMT(3%,14,,-7000)
Annuity payment = 409.68

The annuity payment formula FV is one of many used in time value of money calculations, discover another at the links below.

Annuity Payment Formula FV November 6th, 2016Team

You May Also Like


Related pages


future value of an annuity duecalculation of deferred tax on depreciationstock turnover ratio examplehow to calculate npv in excelpresent value of a growing perpetuityaccrued expense adjusting entrycreditors days formulawhat is a subsidiary ledgerpermanent accounts in accountingaccounts receivable factorwhat are bank reconciliationsintangibles accountingleverage calculatorcontra liabilitiesactivity ratios definitionhorizontal income statementwhy are adjusting entries neededpetty cash credit or debitcalculate the asset turnover ratioaccounting ledger book formatpayment formula excelwhat is fixed asset turnover ratioamortization of bond discountnper excelimprest system for petty cashunearned rent adjusting entrydiminishing balance method of depreciationdebt to owners equitycalculating fifooperating leaveragejournal voucher entrymortgage constant formula excelformula for reducing balance methodpv of dividends calculatorexamples of prepaymentshow to enter contra entry in tallywhen using the allowance method of accounting for uncollectible accountsinventory accounting basicsasset retirement obligation journal entryinventory nrvaccounts payable entries general ledgerformula for double declining balance depreciationlabor usage variancecompany bookkeeping templatesexample of common size income statementbalance sheet template for excelcost of goods manufactured formulaflat rate to apr converterpetty cash statementaccounting ledgers and journalsdividends payable journal entryinterest coverage ratio calculatorfactoring accounts receivable exampleperpetual inventory system fifojournal entry worksheet accountingfinancial accounting worksheetwhat is nsf chequegross profit formulascash and equivalents turnovertypes of subsidiary ledgersjournal entry for credit salescash flow statement analysisexpense accrual journal entryreceivables turnover calculationstraight line method of amortization calculatorlease accounting entriesinventory wippresent value of annuity due of 1 tableexample of petty cash bookcompounding continuously interest calculatorfob destination meansexamples of accrued incomeis unearned revenue an asset or liabilitypurchase returns and allowances debit or credithow to calculate retained earnings on balance sheettransposition error in trial balancepresent value of perpetuitycost variance example