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

margin markup formulareorder point calculation formulaadjusting entries definitionpurchase treasury stock journal entryaccounts receivable aging report samplefuture value of an annuity due tabledeferred tax liability accounting entrychange in nwc formulauses of general journal in accountingt accounts and journal entriesmerchandise inventory formulafinancial ledger examplewhat are deferrals in accountingjournal voucher in accountinghow to book accrued expensesreceived advance payment journal entrypmt calculator excelnegative irr excelexamples of contra asset accountsonline amortization schedule generatorroa return on assetsconsignment accounting treatmentreceivables examplesexcel chart of accountsfactoring process flowprinciples of bookkeepingnotes payable vs accounts payableinterest in suspense accounting treatmenthow to estimate salvage valuewhat is difference between margin and markupbank reconciliation statement formatar turnover ratio formulalease accounting journal entriesvariable expenses examplesinfinite cash flowremittance advice chequegrowth annuity formuladeferred expenses journal entrysum of the years digits depreciation formulawip inventory formulapvad tablebalance sheet with accumulated depreciation examplestockholders equity balance sheet examplenet gearing ratio formulacash journal templatemeaning of amortization in accountingworksheet examples accountingaccrued expenses income statementinventory to cost of goods sold ratiohow to calculate depreciation on fixed assetsdiminishing interest calculatorprepayment debit or creditretained earnings reconciliationcalculating trade discountwhat is a journal voucherfixed asset register formatpresent value of annuity calculator exceltrial balance adjustments exampledeferred tax calculation spreadsheetobjectivity principle accountingfinancials templatetwo column journal accountingdeferred tax asset accountingjournal entry for dividend incomeannuity table for present valuedebit prepaid expensefactoring without recoursewarranty journal entryjournal entry for deferred revenuepayback calculation formulabank loan accounting entriesdefinition of post closing trial balancesundry creditors definition accountingreceivables turnover ratio examplecreditors turnover daysformat of general ledgerdeferred tax asset accounting treatmentretained earnings on cash flow statementpayback period examples