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

5 types of adjusting entriesbeginning bookkeepingjurnal petty cashover applied overheadinventory value methodsmarkup rate calculatorcalculate double declining balancestated annual interest rateexcel double entry bookkeepingcalculate payback period uneven cash flowsjournal entry of bills receivableowners equity debit or creditaccounting formulas cheat sheetfinished good inventory formulacalculate ytm in exceldu pont formulaaccounting balance sheet template excelhow to prepare multi step income statementdifference between bills payable and accounts payableretained earnings statement templatejournal vouchercalculating straight line depreciationjournal entry for accrual of expensespmt excel functionbank reconciliation excel templateoutstanding cheques in bank reconciliationpresent value of an annuity equationhow to calculate manufacturing overhead applied to work in processfixed asset accounting entrieswhat does gaap stand for in accountingprofit margin calculation excelthe balance sheet equationaccrual to cash conversiondividend formula accountingallowance for doubtful accounts t accountmeaning of unearned revenuebad debts written off meaningworksheet template excelcash cheque receipt formatbonds payable journal entryentry for accrued incomemargin and markup differencewip examplelifo vs fifo inventorydefinition of retail shrinknotes payable debit or creditaccount receivable turnover days formulahow to calculate stockholders equitymultiple step income statement showbookeeping basicssample multi step income statementcash flow calculation in excelaccounting general entriesallowance for doubtful debts in balance sheetvariable overhead rate variance formulahow to do bank reconciliation examplespreadsheet accounting templatedifference between margin and markupamortization spreadsheetformula for inventory turnshow to replenish a petty cash fundfinance lease accounting entriesaccounting intangiblesnegative irr excelaccounts payable debit balancetransactional analysis for dummiesexample of journalizing in accountingreducing balance method calculatordividends declared balance sheetpurchase return and allowancescost volume profit formulaformula of inventory turnoverwhat is the difference between markup and marginweighted average method of inventory valuationsingle entry bookkeeping definitionsample of income statement in excelbond payable balance sheetinterest in suspense definitioncalculate finished goods inventoryprepare a vertical analysis of the income statementcarriage inwards and outwards