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


allocating overheadperpetuity calculator future valueincome summary closing entryamortize bond discountpractice adjusting entriesmeaning of controllablepv pmt calculatordebt to profit ratiocalculating annuity payments in excelgross profit method inventoryretiring bonds journal entryacid test ratio calculatordefinition of retail shrinkthe accumulated depreciation account is calledincome normal balancear turnover days formulapercentage of completion method of accountingcurrent assets current liabilities ratio analysisaccounts payable debit balancewhat is the present value of a perpetuityshort term notes receivablesimple payback period calculatorconsignment accountsbonds payable balance sheetfreight on board fobwhat is nbv in accountingcalculator for present value of annuityrule of 78 amortization schedulegp markup calculatorpartnership liquidation journal entriesgl entries accountingexamples of stockholders equityjournal entries for share capitaljournal entry of bills receivableaccounts receivable forms templatesreducing balance basisexcel ledger templateinventory obsolescence reserverecording bad debt expenseaccount receivable factoringdefine gearing ratioformula to calculate profit margin percentageadjusting entry for depreciationformula for reducing balance depreciationfixed asset register template freethe difference between periodic and perpetual inventory systemsmanufactoring overheadending retained earningspvifa tablesbook value formula depreciationpurchases account normal balancegordon growth model excelbasics of double entry bookkeepingowners equity formulacollection of accounts receivable journal entryis a trademark an intangible assettimes interest earned equationexample of single step income statementallowance method of accountingallowance method of accounting for bad debtsgross profit journal entrypetty cash book templateis prepaid expense an assetformulas for simple interest and compound interestfinancial accounting exercises and solutionsnet gearing ratiocvp formulasnon current asset turnover ratioa subsidiary ledgercreditor definition accountingfactored receivablesfuture value calcwhat is the purpose of the post closing trial balanceconsumable assetsdoubtful accounts journal entryexplain the accounting cycle