Future Value of a Lump Sum Formula


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


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

The formula compounds the value of a lump sum at the start of period 1 (present value), forward to its value at the end of period n (future value).

Excel Function

The Excel FV function can be used instead of the future value of a lump sum formula, and has the syntax shown below.

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

*The pmt and type arguments are not used when calculating the future value of a lump sum.

Future Value of a Lump Sum Formula Example

If a lump sum of 15,000 is received at the start of period 1, and the discount rate is 5%, then the value of the lump sum at the end of period 10 is given by the future value of a lump sum formula as follows:

FV = FV x (1 + i)n
FV = 15,000 x (1 + 5%)10
FV = 24,433.42

The same answer can be obtained using the future value formula in Excel as follows:

FV = -FV(i,n,,PV)
FV = -FV(5%,10,,15000)
FV = 24,433.42 

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

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

You May Also Like

Related pages

owners equity equationroa calculation formulaaccounts payable meaning in accountingdebt to value ratio calculatorwhat kind of account is unearned revenueequation for mortgageformat of cheque receiptincome tax paid journal entryasset contra accountfinancial gearing definitiondefinition of return on capital employedformula for growing perpetuityaccounts receivable and unearned revenueperpetual system accountingdupont accountingcash cheque receipt formatdeferred expense journal entryjournal entry accrued expenseaccumulated depreciation entryinternal controls accounts receivableaccounting special journalsformula for current liabilitiesprofitability index excelthe accounting cycle explainedformula for growing annuitylifo perpetual inventory method exampleretail bookkeepinggeneral ledger spreadsheetrealisable value accountingexcel bookkeepingcreditors turnover daysprepare a multiple step income statementfactoring accounting treatmentpv function in excelgeneral ledger templatesaccumulated depreciation journal entryadjusting entries for suppliescontinuous compound interest formula calculatorcash flow formula in excelhow to calculate a stock splitfuture value and present value tablesassets turnover ratio calculatorhow to calculate variable expensemonth end adjusting entriesdouble declining method depreciationcash flow calculator exceldefine direct labor costcalculate factory overheadabsorption overheadinterest accrual journal entryservice tax accounting entriesaccounting adjusting entries rulestime value of money tables annuityfinancial ratio calculator exceldouble entry bookkeeping for dummiesaccruals double entrybalance sheet vertical analysisgross debt equity ratiodepreciation deferred tax liabilityrevenue expenditures and capital expendituresbookkeeping paper templateconsignor and consigneeinvoice journal entrywhats a fixed costinventory systems in accountinggross margin and contribution marginfixed asset turnover ratioassembly line workers wages are period costsfifo cost formulaexample of pmt function in excelhow to replenish a petty cash fundmultiple step income statements showbank reco