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


freight prepaid collectadjusting entry for supplies useddouble declining depreciation method formulahow to calculate common size income statementdeferral definition accountingjournal entry of outstanding expensesliquidating partnerformula to calculate inventory turnover ratiototal conversion cost formulaexamples of perpetuitydepreciation with salvage valuetotal assets turnover formulasales ledger account formatlifo calculationbalance sheet closing entriesinventory spreadsheet exampletrial balance accounting definitioncapitalized lease vs operating leaserecognition of unearned revenuedilapidation provision ifrscash denomination sheetvoucher designsbreakeven calculatorsaccruals and deferred income balance sheetinterview questions and answers for accounts payable positiondepreciation spreadsheethire purchase journal entryaccelerated depreciation calculatorunits of production method of depreciationcash disbursement voucherppe fixed assetsjournal entry to replenish petty cashpresent value of perpetuity calculatoraccrued expenses income statementfixed overhead expenditure variance formulaprovision for bad debts accounting entrycash conversion ratio formulawhat is the meaning of bills payable and bills receivablescalculate markup formulaformula for present value of perpetuityirr excellexample of accounting cyclenet gearing ratio formulamoney receipt format docfuture value of a lump sumbookkeeping samplesstatement of retained earnings examplesfob destination vs fob originmark up calculatoroverhead cost variancehow to calculate accrued interest on a note payablevalue of perpetual bonderrors not affecting the trial balancepayment voucher sample formataccounting basic quizpetty cash countgrowing annuity present valuedouble entry bookkeeping books free downloadcalculation for inventory turnseconomic entity assumption definitionpresent value ordinary annuity calculatorsuspense examplesprovision for uncollectible accountshire purchase journal entriespremium on bond payablegross margin percentage calculatorfob transportationthe journal entry to adjust supplies iscash received from customers journal entryexample of accrual basis of accountingconsumable expenseshow to calculate stock split 2 for 1simple annuity formulapresent value of an anuityhow to calculate stockholder equitydirect labour efficiency variance