Present Value of Annuity Formula

Formula

PV = Pmt 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

Use

The present value of annuity formula shows the value today of 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 annuity calculation 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 and type arguments are not used when using the Excel present value of an annuity function.

Present Value of 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 today is given by the present value of annuity formula as follows:

PV = Pmt x (1 - 1 / (1 + i)n) / i
PV = 5,000 x (1 - 1 / (1 + 4%)10) / 4%
PV = 40,554.48

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

PV = PV(i, n, pmt)
PV = PV(4%,10,-5000)
PV = 40,554.48

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

Present Value of Annuity Formula November 6th, 2016Team

You May Also Like


Related pages


common size income statement exampleamortization spreadsheet xlsequation for net profit marginmarkup percent calculatorledger sheet templatejournal entry for writing off accounts receivablecash receipts and cash disbursementsbank reconciliation formulahow to get the ending inventoryaccounting quiz beecapitalized leasehow to calculate average receivableshow to calculate earning before interest and taxesledger posting in accountingcost of good sold income statementefficiency ratio inventory turnover formulawhat is a trade debtor on the balance sheetifrs journal entriesmargin vs markup calculationfinancials templatefuture value annuity factor tableis allowance for doubtful accounts a liabilityexcel formula irrhow to calculate the contribution margin ratiohow to calculate raw materials inventoryhow is a common size balance sheet createdconvertible bonds accounting journal entriessample chart of accounts for rental propertydiscounting of debtorsjournaling accountingbookkeeper duties checklisthow to calculate pbithow to calculate fixed manufacturing overhead costscash book proformadouble entry bookkeeping books free downloadstraight line amortization examplecalculate npv excelthe double declining balance methodwhats petty cashwhat is nper in financeannuity calculation formulaexample of a cashbookoverapplied overhead journal entrycalculate net profit margin ratiofifo perpetualreceipt book template excelfinancial ratios formulas excelprove it test answers excelinventory reorder pointunearned revenue classificationpv formula in excelspreadsheet accounts templatehow to calculate allowance for bad debtcalculating manufacturing overhead ratesmall business accounts spreadsheet templateformula to calculate current ratioperiodic and perpetual inventory systemsjournal entry for stock dividendexamples of ledgersformula for pay back periodaccounting entries for fixed assetsamortization in income statementjournal entry for warrantydeferred tax calculation spreadsheetformula to calculate margin percentageroa ratiodeferred income double entryprofit markupproject payback period calculatora debit balance in retained earningssample accounting ledgeraccounting adjusting entrieslessee accountingcash book proformaformula for pv ratio