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

cash profit ratio formulaintroduction to double entry bookkeepingpresent value of increasing annuitydupont return on equitychain discount calculatoris allowance for doubtful accounts a liabilityweighted average cost formula inventorygearing in accountingpv calculation exceldirect labor cost variancemargin versus markup calculatorhire purchase journal entrythe accounting cycle 10 stepsmargin markup calculatorgross fixed assets formulareorder point definitionentry to replenish petty cashaccounting worksheet excel templatewhat does the contribution margin tell yougearing ratios formulauneven cash flowpayback period method exampledeferred tax double entryaccount payable formulatransposition error in accountingaccount receivable templatepre opening expenses accounting treatmentjournal entries for accrued expensesmeaning of consignment accountaccounting entries for purchasesaccounting journal template excelhow to calculate variable costingmeaning of accounting cyclecalculating future value of an annuitybalance sheet sample excelaverage debtors formulameaning of journal voucher in accountingspreadsheets for small businessyield to maturity formula excelhow do you calculate quick ratiogross margin percentage calculatorchart of accounts for a restaurantbookkeeping templates excelequation for gross marginpayment terms examples invoicesdebtors control account examplenet present value formula in excelwhat are consumable storesformula of retained earningsaccounting for intangiblesmark up calculatorcontrollable marginprovision for obsolescencesum of the digits formulahow to write cash book and ledgerhow to do closing entries in accountingoverhead spending variancediscounted cash flow formula in excelsum of years digits depreciationcomputation of deferred taxcogs formulaweighted average contribution margin per unitbank reconciliation statement formatnet present value excel spreadsheetcapacity utilization calculation formulawithout recourse factoringdouble entry for finance leasewhat is accrual accounting vs cash accountingloss on disposal of fixed assets income statementfifo perpetual inventory examplewhat is interest suspense accountsum of digits method of depreciationcalculating payback periodallowance doubtful accountsexample of zero coupon bondimprest cash bookaccounting aptitude test questions and answersunearned revenue earned journal entrysample petty cash bookaccounting aptitude test questions and answersmanufacturing overhead calculationvariable manufacturing overheadperpetuity payment