Present Value of a Perpetuity Formula


PV = Pmt / i
Variables used in the annuity formula
PV = Present Value
Pmt = Periodic payment
i = Discount rate


The present value of a perpetuity formula shows the value today of an infinite stream of identical cash flows made at regular intervals over time.

The formula discounts the value of each cash flow 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 a perpetuity 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 a perpetuity function.

Present Value of a Perpetuity Formula Example

If a payment of 4,000 is received each period for ever, and the discount rate is 5%, then the value of the payments today is given by the present value of a perpetuity formula as follows:

PV = Pmt / i
PV = 4,000 / 5%
PV = 80,000.00

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

PV = PV(i, n, pmt)
PV = PV(5%,999,-4000)
PV = 80,000.00

The Excel formula requires a value for n. Although the value should be infinite, a value of 999 is used as an approximation in the formula.

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

Present Value of a Perpetuity Formula November 6th, 2016Team

You May Also Like

Related pages

how to calculate operating capitalstandard costing and variance analysis formulaswhen a partnership is liquidatedunearned revenue isperpetuity with growthbond amortization schedule examplenpv calculation in excelclosing inventory formuladividend payable in balance sheetcalculate beginning inventorydeferred revenue examplesmarkup equationdividend declaration form templateaccounting concept and principlesformulas of simple interest and compound interestinventory turnover rate calculatordays sales in receivables ratiojournal entry for bills receivablecreditors aging reportcalculate the variable cost per unitaverage account receivables formulalease journal entriesbookkeeping entrieshow to prepare a retained earnings statement examplecontra entriesarr accountingwhat is variable cost in accountingcredit sales vs accounts receivablepayback period formula uneven cash flowswhat is owner's equitythe effective interest amortization methodprepayments in balance sheetsale of fixed asset entrybookeeping teststraight line amortization calculatortrade creditor definitionsingle entry accounting examplepresent value of an annuity formula calculatorrumus receivable turnovernpv function in excelbills payable journal entryannuity due tablehow to calculate days in accounts receivableclosing entry for income summaryjob costing formatasset disposal double entrypayback excelhow to calculate net realizable valuepayback period examplesdefinition of capital expenditure and revenue expendituregross profit percentagesis depreciation a period costexamples of balance sheet reconciliationsmarketable securities examplewhat is a trade debtor on the balance sheetworksheet for accountingprovision doubtful debtsdeclining balance method examplepetty cash register containcash receipt journal templatehigh asset turnover ratiopercentage markup calculatorperpetual inventory system pdfconvertible bond accountingadjusting entries questions and answers12 column ledger bookweighted average inventory methodperiod cost formulanominal annual rate of return formulawhat is the dupont equationmarkup based on cost calculatoramortised valuehow to calculate the ending inventoryinvoiced definitionformula for annuitiesdepreciation depletion and amortizationbond accounting journal entriespmt excelactivity based costing formulacapital expenditure accounting entry