Future Value Annuity Formula


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


The future value annuity formula shows the value at the end of period n of a series of regular payments. The payments are made at the end of each period for n periods, and a discount rate i is applied.

The formula compounds the value of each payment forward to its value at the end of period n (future value).

Excel Function

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

FV = FV(i, n, pmt, PV, type)

*The PV and type arguments are not used when using the Excel future value of an annuity function.

Future Value Annuity Formula Example

If a payment of 5,000 is received at the end of each period for 10 periods, and the discount rate is 4%, then the value of the payments at the end of period 10 is given by the future value annuity formula as follows:

FV = Pmt x ( (1 + i)n - 1 ) / i
FV = 5,000 x ( (1 + 4%)10 - 1 ) / 4%
FV = 60,030.54

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

FV = FV(i, n, Pmt)
FV = FV(4%,10,-5000)
FV = 60,030.54

The future value of annuity formula is one of many annuity formulas used in time value of money calculations, discover another at the link below.

Future Value Annuity Formula November 6th, 2016Team

You May Also Like

Related pages

double entry bookkeeping examplesdepreciation expense entrygeneral ledger layoutgross profit equationoutstanding rent journal entryaccounting journal entries cheat sheetaccounting entry for retained earningsaccounting general ledger examplevariable expense per unit formularestaurant bookkeeping templatesunpresentedcash flow statement equationcapital lease calculatorjournal entries for depreciationsmall business excel accounting templateaccrual to cash worksheetpv calculator excelcash book accounting examplecontra assets accountcreditors collection period formulaaccounts receivable aged trial balancewhat is account receivable turnoverhow to calculate profit markupaccounting for joint ventures equity methodtrade receivables debtorsis commission a variable costtrial balance dividendsallowance for doubtful receivablescalculating straight line depreciationpetty cash accounting templateintangible assets journal entrybalance sheet debit credithow to calculate margins and markupsexample of economic entity assumptionjournal entry prepaid expenseoutstanding chequesunearned creditdepletion expensereverse stock split examplewhats petty cashjournal entry worksheet accountinggross margin equalsprintable accounting worksheetsinstallment note definition200 declining balance depreciation methodpresent value of lump sum tablenpv perpetuity formula excelgross method perpetual inventory systemvendor statement reconciliationoperating cycle in accountingjournal entry for accrued rentissuance of preferred stockformula for continuous compoundingfutures accounting entriesaccounting journal ledgerdupont ratiosmargin and markup calculator ukamortization definition and examplepayroll accounting meaninghow to calculate costs of goods manufacturedasset turnover ratio equationdouble entry system of bookkeepingamortization bond premiumhow to calculate direct materials used in productioncalculate annuity in excelprepaid expense accounts appear onrevenue equation accountingexcel depreciationvariable overhead rate variancecredit memo accounting entrysales and purchase ledgersformula of inventory turnoverexamples of suspencesales returns and allowances definitionaccounting excel templatesbank reconciliation example problems