Present Value of Annuity Due Formula


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


The present value of annuity due formula shows the value today of 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 discounts the value of each payment back to its value at the start of period 1 (present value).

Excel Function

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

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

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

Example Using the Present Value of Annuity Due Formula

If a payment of 6,000 is received at the start of each period for 9 periods, and the discount rate is 6%, then the value of the payments today is given by the present value of annuity due formula as follows:

PV = Pmt x (1 + i) x (1 - 1 / (1 + i)n) / i
PV = 6,000 x (1 + 6%) x (1 - 1 / (1 + 6%)9) / 6%
PV = 43,258.76

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

PV = PV(i, n, pmt,,1)
PV = PV(6%,9,-6000,,1)
PV = 43,258.76

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

Present Value of Annuity Due Formula November 6th, 2016Team

You May Also Like

Related pages

reversing journal entriescash conversion cycle equationwhy is prepaid expense an assetnet realizable value inventorytrade accounts receivable definitioncontinuous compounding formulareceipt voucher sampleformula for days sales in inventoryallowance method for bad debtsdebtors account definitionaccounting journal entries transactionsales taxes collected by a retailer are recorded byan example of an accrued revenue ispayback analysis calculatorinterest suspense account in balance sheetassets liabilities capital equationtrading marketable securitiesclosing entries for perpetual inventory systemprofitability index formulafob shipping meansdouble declining balance depreciationcost of good sold on balance sheetnpv perpetuity calculatorexamples of balance sheet reconciliationsdupont accountingincreasing annuity calculatormarkup and marginhow to calculate fixed manufacturing overhead costswhat is office supplies expense in accountingcalculate annuity formulaaccounting prepaid rentsmall business chart of accounts spreadsheetexample of an accelerated depreciation methodpetty cash reconciliationsample of a bank reconciliation statementexamples of double entry bookkeepingjournal entry for bills payableconsignment sales accounting entriesaccounting for restaurants chart of accountsdaily time sheet templateoperating lease vs finance lease accountingsimple depreciation formulahow to calculate interest expense on a loancontra account journal entryar turnover in days formulapv table annuityoperating lease journal entries lesseeprepare a multi step income statementmarkup vs marginaccounts receivable turnover definitionjurnal account payablecreditors control account exampleeac calculatordef sundrydouble entry bookkeeping system definitioncalculate periodic interest ratemarkup and margin differenceledger template printablecash profit ratio formulaconsignment accounting journal entriessample money receipt formatfinancial accounting quizzesmark up ratiocalculating accounting rate of returnsales tax quizaccounting formulas and calculationscalculation of payback periodhow to compute ending inventoryformula for contribution margincalculate npv excelgift card breakageadjusting entries problemsdegree of operating leverage accounting