Lump Sum Discount Rate Formula


The lump sum discount rate formula is used to work out the discount rate (i), needed to compound a lump sum from from its present value (PV), to a future value (FV) in a number of periods (n).


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

Our lump sum discount rate calculator is available to help when using the above formula.

Excel Function

The Excel RATE function can be used instead of the lump sum discount rate formula, and has the syntax shown below.

RATE(n, pmt, PV, FV, type, guess)

*The pmt, type, and guess arguments are not used when calculating the discount rate for a lump sum.

Lump Sum Discount Rate Formula Example

If a lump sum of 1,500 is received at the start of period 1, then the discount rate needed to compound this to 5,000 after 10 periods is given by the lump sum discount rate formula as follows:

i = (FV / PV)(1 / n) - 1
i = (5,000 / 1,500)(1 / 10) - 1
i = 0.1279 or 12.79%

The same answer can be obtained using the discount rate formula in Excel as follows:

i = RATE(n,,PV,-FV)
i = RATE(10,,1500,-5000)
i = 12.79%

*don’t forget the minus sign on FV

The lump sum discount rate formula is one of many used in time value of money calculations, discover another at the links below.

Lump Sum Discount Rate Formula December 7th, 2017Team

You May Also Like

Related pages

what is the maturity date of a note receivablerate implicit in the leasehow to calculate variable expensesaccrual versus cashhow to do adjusting entries in accountingaccelerated depreciation methodsonline tvm calculatoraccrued expenses examples8 steps in the accounting cyclestraight line depreciation definitionstraight line method of depreciation exampleexample of general ledger entries for accountingdebtor control account formatfuture value calcformula for total variable costannuity function excelcalculation of gearing ratiowhy is prepaid expense an assetformula for annuitiesloan calculator with balloon payment exceljournal entry to record depreciationpresent value annuity calculationasset retirement journal entrywhat is the profitability indexmirr calculationhow to prepare a contribution margin income statementdiminishing value depreciation formulasimple excel bookkeeping templateaccrual to cash worksheetgeneral entries of accountsformula for calculating gross profithow to calculate roce from balance sheetdebit journal entryis prepaid expense a liabilityaccounts receivable debit or credit balancebookkeeping meaning and definitionliquidity ratios listissuance of treasury stockaccumulated depreciation trial balancecalculate accounts payable daysfob terms shippingwhat is the imprest systemhow to convert margin to markupis petty cash an asset accountaccounts payable control accountcost sell margin calculatormargin and markup formulascalculating gross profitfreight on board originfob shipping point and destinationtrial balance worksheet templatereceivables turnover ratio calculatorhow to calculate future value of money in excelturnover accounting formulafifo calculation formulahow to calculate interest receivabledepreciation deferred tax liabilitydefinition of capital employeddebtors days outstandinggeneral ledger layoutadjustment trial balance worksheetdebtors ratiosfuture value of ordinary annuity calculatorprofit margin calculator downloadhow to calculate weighted average of percentagesasset efficiency ratiosformula of total fixed costexpense accrualsdiminishing balance depreciation method200 declining balance formulaaccounts payable balance sheet exampleabsorption costing equationdepreciation adjusting entryoutstanding chequeshow to calculate cash coverage ratiodebtors turnover periodleverage gearing ratiojournal entry for goodwillstatement of stockholders equity example