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

perpetual and periodic inventory systemsinventory impairment gaappreferred stock journal entrydeferred income journal entrybudgeted overhead absorption ratecapital lease amortizationjournal entry for interest expenseexpense ledger templatecapital lease journal entries lesseeunadjusted trail balancejournal entries for accrued incomewhat is an imprest systemaccounting cycle 8 stepscommon size balance sheet ratiosannuity table for present valueaccounting quizzamortization table makerthe basic accounting equation isformula retained earningshow to extract a trial balancedebt and equity ratiosnotes payable examplesperpetual formulagearing ratio debt to equityprofit margin per unit formulasimple expenses claim form templatewage accrualwhat is a contra entry give an exampleeffective annual rate calculationfifo method examplenetbook valuelump sum formulaannuity due definitionsample cash receipt voucherformula to calculate simple interest and compound interestpresent value of growing annuitygrowing annuity calculatoryear end accounting entriessinking fund accounting entriesdirect material efficiency varianceaccounting general entriesadjusting entry depreciationjournal entry for cash received in advanceprofitability index calculator financialrealised and unrealised gains and losses in accountingeom invoicethe receivables turnover ratio is computed by dividingcash count spreadsheetbookkeeping ledgerslifo reserve definitionexpense template for small businessweighted average inventory methodvoucher layout templateallowance for bad debt journal entryaccounts payable entriesbank reconciliation exercises and answersending cash balance formulacompute straight line depreciationsimple excel accounting spreadsheetobjectivity principle accountingnpv depreciationgeneral ledger journal entriesprofit percentage formula in excelcalculate irr on excelhow to calculate lifoaccrued and prepaid expenseshow to calculate capital employed from balance sheetgive journal entry for provisiondu pont ratiostemplate for timesheetformula of accumulated depreciationdividend statement template