Annuity Due Payment Formula FV

Formula

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

Use

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

The annuity due payment formula FV can be used for example, to calculate the periodic deposits needed at the start for each period 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 due payment formula FV, and has the syntax shown below.

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

*In this instance, the PV argument is not used when using the Excel Annuity due payment function.

Example Using Annuity Due Payment Formula FV

An investor wants to save an amount of 8,000 by depositing regular annuity payments at the start of each period for 15 periods at an interest rate of 4% per period. The amount of the annuity payment is given by the annuity due payment formula FV as follows:

Annuity payment = Pmt = FV x i / ((1 + i)( (1 + i)n - 1 ))
Annuity payment = Pmt = 8000 x 4% / ((1 + 4%)( (1 + 4%)15 - 1 ))
Annuity payment = Pmt = 384.16

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

Annuity payment = PMT(Rate, Nper, PV, FV, Type)
Annuity payment = PMT(4%,15,,-8000,1)
Annuity payment = 384.16

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

Annuity Due Payment Formula FV November 6th, 2016Team

You May Also Like


Related pages


prepaid expense entrywhat is the expanded accounting equationcalculate mortgage constantending inventory calculatorquarterly interest rate formuladepreciation and amortization formulasale of fixed asset entryprofit margin calculator excelwhen is bad debt expense recordedmultiple step income statement showfifo perpetual inventoryaccounting debit and credit chartjournal entries debits and creditsformula for mirrdeferred tax liability formulaperpetual bond formulacoverage ratiosaccounts receivable turnover equationaccounting liquidity ratioswhat is gearing ratio formuladifference between markup and profit marginbank reconciliation statement solved problemsaccruals accounting exampleformula perpetuitydupont return on assetsaccumulated depreciation is what type of accountleasing calculator formulasundry accounting definitionaccrual accounting entryroce financial ratiodepreciation rate calculatordegree of operating leverage equationexamples of double entry journalsrent revenue journal entryaccrual accounting entryytm excelimplicit rate calculatorperpetual inventory accountinghow to prepare a vertical analysisbookkeeping debit creditmcq on accounting with answersmarkup vs marginfreight prepaid and freight collectpv of an annuity dueexample of accumulated depreciationreimbursement of petty cashdouble declining balance method depreciation calculatorwip calculationdefine debtorwages payable journal entryformula of payback periodmeaning of bookkeepingfifo method process costingaccount payable turnover days formulabond calculator excellabor efficiency variance calculatordouble declining method formulameaning of accrued expensesperiodic inventory system journal entriescredit and debit chartshould i be an accountant quizinventory lcmexcel margin formulaallowance for bad debt balance sheetaccruals and prepayments definitionadjusting entry depreciationtimes interest ratio formulahow to prepare an accounting worksheetfactoring without recoursewhen is the trial balance preparedreturn on common stockholders equity calculatoradvantages of payback periodexample of debit noteoperating lease journal entries