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


rate of return calculator excelaccounting unearned revenueput option accounting entrieseconomic entity assumption accountingdefine utilities expensecollection of accounts receivable journal entryfob shipping point and destinationskillcheck online testing answersliquidity quick ratiojournal entry for dividend incomeapr formula excelbank reconciliation format in excelcreditors ledgerpmt excel examplestatement of retained earningcauses of labour rate variancegoodwill accounting entryjournal entry interest expensepresent value perpetuity calculatorpresent value of annuity calculatorexcel annuity calculationhow to do trial balance from ledgerdebit vs credit accountingfreight charges that are paid by a buyer areissuance of common stock journal entrytrial balance of balanceswhat are unearned revenueswhat is a retained earningformula to calculate pvjournal entries and t accountsunearned revenue in balance sheetcurrency translation adjustment journal entryallowance for doubtful accounts credit or debitpmt formula exceldisbursement ledgerfifo calculation formulaaccounting quizesaccounts payable adjusting entryperpetual system journal entriesdiscuss the accounting cycledepreciation on disposal of fixed assetscheque received journal entryannuity factors tablefuture value of growing annuityprepaid insurance journal entry adjustmentswhere is unearned revenue recordedaccounting for owners equitypresent value annuity excelwhat does nett mean on an invoicediscount amortization schedulecalculating annuity payments in excelasset register samplewhat is liquidity ratio formulairr accountingbank reconciliation exercises and answersanuity duecalculating pmtloan accounting basicsaged creditorsaccounting fobposting from journal to ledgeradjusting journal entries for depreciationhow to record petty cash expensesthe journal entries for a bank reconciliationpmt functionsbond amortization schedulepetty cash fund accountingsubsidiary ledger examplespetty cash balancefree payment voucher templatewhat is the accounts receivable turnover ratiopetty cash log sheet templatelease accounting entries