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

liquidity acid testdefine petty cash voucherbookkeeping to trial balance examplessum of the years digits formulaformula for direct laborwhat is the formula for variable costgearing ratio formulacalculate total variable costhow to calculate salvage value of an assetgeneral ledger pdfmeaning of consignment accountfuture value annuity formulachart of accounts sample for manufacturing companyprepaid expense journal entryprinciples of bookkeepinghow to calculate manufacturing overhead costfifo method in cost accountingcalculate interest expense on loancvp formulassample of adjusting entriescash disbursement voucheraccounting principles and conventions pdfinterest calculator compounded continuouslyexpense chart templatecontinuously compounding interest calculatordeclaring a cash dividendunearned revenue in income statementtime sheet spreadsheetcorrecting journal entrymarketable securities in accountingaccrued expenses cash flowdeferred tax calculation spreadsheetallowance for doubtful accounts ratiolump sum annuity formulareceivable turnover days formulaaccruals journal entryfuture value annuity table pdfprofitability ratio return on assetslifo reserve calculationfuture value annuitywhat is dishonour of billmultiple step income statement templateamortization of bond premium journal entryfob value of goodshow to calculate write offscalculate depreciation straight lineformula for profit margin ratiotally journal entriesdso ratio formulacommon stock valuation formulapercent of completion methodexcel ledger templateformula for double declining depreciationexample of cash discountfv of annuity formulaexample payroll journal entryhow to calculate days sales in inventorydupont analysis calculatorjob order costing accountingdepreciation journal entryclosing inventory in trial balancejournal entry for goodwill impairmentcost of goods manufactured and sold statementlifo examplebookkeeping chart of accountscompute the payback periodsum of years digits depreciation formulaover absorption of overheadsbank reconciliation explanationunearned rent revenue balance sheetexpense spreadsheet for small businessaccounts receivable checklistdefine reversing entriesreducing balance method formula for depreciationaccounting spreadsheet templatesmonthly debtor days calculation formula