Future Value of an Annuity Due Formula


FV = Pmt x (1 + i) 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 of an annuity due formula shows the value at the end of period n of a series of regular payments. The payments are made at the start 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 of an annuity due formula, and has the syntax shown below.

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

*The PV argument is not used when using the Excel future value of an annuity due function.

Example Using the Future Value of an Annuity Due Formula

If a payment of 3,000 is received at the start of each period for 7 periods, and the discount rate is 8%, then the value of the payments at the end of period 7 is given by the future value annuity due formula as follows:

FV = Pmt x (1 + i) x ( (1 + i)n - 1 ) / i
FV = 3,000 x (1 + 8%) x ( (1 + 8%)7 - 1 ) / 8%
FV = 28,909.88

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

FV = FV(i, n, Pmt,,1)
FV = FV(8%,7,-3000,,1)
FV = 28,909.88

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

Future Value of an Annuity Due Formula November 6th, 2016Team

You May Also Like

Related pages

format of petty cash bookformula asset turnovernonprofit chart of accounts examplehow to calculate variable manufacturing overheadsold treasury stock journal entryannuity present value factorhow to record unearned revenue journal entrycarriage outwardsaccounting journal and ledgermanufacturing overhead cost exampleswip formuladebit balance in accounts payablehow to calculate lifo liquidation profitdebtors ratiosreversing entriestime value of money calculator excel spreadsheetdeferred tax accounting journal entriesquarterly interest rate formulapetty cash usesweighted average ending inventoryimpress accounthow to maintain petty cash bookinventory turnover days formulacash voucher template excelnpv formula in exceldebit accounts payablefob point of originconsignment stock accountingaccelerated depreciation examplefifo perpetual inventory systemaccounting journal entries templatepetty cash journaladvantages of petty cash bookcash receipt journal entrybad debt provision double entryoperating cash flow margin formulaaccruals and prepayments t accountsdays receivables formulaflowchart accountinghow do you calculate variable cost per unitwithholding tax entrydebit note issued by supplierinventory accounting entries examplechart of accounts manufacturing examplesdays purchases in accounts payablecarriage inwards and outwardsexcel ledger templatepresent value of a perpetuity that starts in the futurepayback ratiopetty cash ledger templategearing calculationwhat is the normal balance of accounts payablecapital receipts examplesoperating lease vs finance lease accountingdouble declining method examplepresent value of lump sumaccounts receivable turnover ratio in dayscapital lease vs operating lease examplefixed asset turnover exampleprovision for bad debts accounting entryaccounting adjusting entries tutorialdeferred expense journal entryaccounting markup formulaexample general ledgerfixed overhead expenditure variance formulaannuity table future valuesupplies expense formulaaccounting accruals and prepaymentspresent value ordinary annuity calculatorformula for calculating markup percentageperiodic inventory system cost of goods soldaccounts recievable turnover ratiowarranty expense