Future Value Annuity Formula

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

Use

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


compute the cost of goods manufacturedchart of accounts numbering systemexample of variable expensesaccounts receivable accounting entriessample chart of accounts for merchandising businessweighted average inventory methoddouble declining balance method depreciation calculatorcogs balance sheetroce ratio formulanet realisable value methodjournal entry for prepaid rent receivedvariable expense formulafv of an annuity calculatorcoupon bond calculatoraccounting debit and creditspetty cash balancearr equationexamples of debit and credit entriespresent value annuity factor calculatoraccelerated depreciation method examplecommon size balance sheetseconomic entity conceptpresent value of dividends calculatormarkup on selling price calculatorfob origin collectis prepaid expense a liabilitygp formula calculationexcel pmt formulacp sp formulasallowance for sales returns journal entrypv of lump sum tablehow to calculate trial balancedepreciation schedule straight line methodsale ledger control accountconvertible bond accounting treatmenthow to calculate manufacturing overhead applied to work in processaccounting quizzes with answersaccounts payable credit or debitvariable cost examples in accountingledger debitaccounts payable salary ukfob freight on boardperiodic interest rate formulaaccrual and prepaymentsannuity timelinewhat is nbv in accountingunearn revenuedso calcdso calculation examplehow to calculate annual depreciation expensegeneral journal adjusting entriesaccounting spreadsheet templates excelstockholders equity examplereorder formulastandard costing method examplewhat is unadjusted trial balancedeferred liability journal entryaccounting treatment of buyback of sharesaccounting journal entries cheat sheetpresent value interest factor annuity tableposting journal entries to t accountsbook keeping testwhat is a accrued expensebookkeeping exampleshow to calculate profit mark upfuture value function in excelprepare a multiple-step income statementstock turnover calculationcommon size comparative statementsthe balance of a control account in the general ledgerformula for markup percentageaccount receivable entriesfob shipping point and destinationcogs formula income statementa total materials variance is analyzed in terms of