Present Value of a Lump Sum Formula


PV = FV / (1 + i)n
Variables used in the formula
PV = Present Value
FV = Future Value
i = Discount rate
n = Number of periods


The present value of a lump sum formula shows what a cash lump sum received in the future is worth today.

The formula discounts the value of the lump sum received at the end of period n (future value), 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 lump sum formula, and has the syntax shown below.

PV(i, n, pmt, FV, type)

*The pmt and type arguments are not used when performing the present value calculation in Excel.

Present Value of a Lump Sum Formula Example

If a lump sum of 25,000 is received at the end of period 10, and the discount rate is 5%, then the value of the lump sum today is given by the present value of a lump sum formula as follows:

PV = FV /(1 + i)n
PV = 25,000 /(1 + 5%)10
PV = 15,347.83

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

PV = -PV(i,n,,FV)
PV = -PV(5%,10,,25000)
PV = 15,347.83

The present value of a lump sum formula is one of many used in time value of money calculations, discover another at the link below.

Present Value of a Lump Sum Formula November 6th, 2016Team

You May Also Like

Related pages

straight line amortization formulaobsolete and slow moving inventory definitionprepayment assetbond amortization tablesimple excel spreadsheet templatetemplate balance sheet and income statementbank reconciliations examplesmileage claim form templateinventory systems accountingequity multiplier formulaaccrued revenue journal entry exampleretained earning balance sheetvertical analysis income statementdupont model calculatorcash received from customers journal entrysimple ledger templateformula present value of annuityimputed interest calculation exampleaccounts receivable days on handimprest account formatverifiability in accountingprinciples of accounting conceptsprovision for bad debts journal entryactivity based depreciation formulaposting entries to the general ledgeradjusting journal entries accountingcalculate pmt in excelfifo method in cost accountingdebit and credit meaning with examplehow to establish a petty cash fundbep formulaaccrued payroll journal entrypvifa tablesdays in accounts payable calculationuses of trial balancetable present value annuitycontribution income statement formulabook in accountingjob costing sheetexcel annuity payout calculatorformula for calculating inventory turnover ratiochart of accounts for merchandising businessfob destination freight collectrule of 78 refund calculatorwhat does return on capital employed meanafs securitiesbasics of accounting for interviewgross profit ratio formulaaccounts receivable credit or debit balancedebtor definition accountingmarkup vs margin chartperiodic inventory system fifovariance analysis and standard costingcost of goods sales formulafuture value calcprofit margin calculation excelbookkeeping for a small business templatehow to calculate cvpamortised definitionhalf year convention depreciationpurchase price variance calculationeom payment termssimple annuity duebookkeeping cycletotal assets turnover ratio formulaadjusting entries journalpresent value of a perpetuity calculatordebit and credits accountingdouble declining formulapv and fv tablesallowance for uncollectible accountsperpetual accounting journal entriesfuture value of annuity due calculatormargin and markup calculator ukunearned rent revenue adjusting entrydoubtful accounts expensewhat does eom meanhow to calculate pmt in excelhow do you calculate contribution marginadjusting entries affectamortization table makernotes payable formulablank accounting worksheetformula for asset turnover ratiohow to calculate variable costs per unit