Future Value of a Lump Sum Calculator

What does it do?

This future value of a lump sum calculator works out what a lump sum of money received today will be worth in the future, taking into account a discount rate.

More precisely, the future value of a lump sum calculator, calculates the value (FV) at the end of period n, of a lump sum (PV) received at the beginning of period 1, using a discount rate i.

Formula

The calculator uses the future value of a lump sum formula as shown below:

`FV = PV x (1 + i)n`

Full details of the formula can be seen at our future value of a lump sum formula page.

Instructions

The Excel future value of a lump sum calculator, available for download below, is used to compute the future value by entering details relating to the present value, discount rate and the number of periods. The calculator is used as follows:

Step 1

Enter the present value (PV). The present value of the lump sum is entered. This is the amount received at the beginning of period 1.

Step 2

Enter the discount rate (i). The discount rate is the rate used to compound the lump sum forward from the beginning of period 1 (today) to end of period n. The rate should be for a period, so for example, if the period is a year, then the rate should be the yearly rate.

Step 3

Enter the number of periods (n). The number of periods is entered. A period can be any term (month, year etc), but must be consistent with the discount rate provided (see step 2)

Step 4

The future value of a lump sum calculator works out the future value (FV). The answer is the value at the end of period n, of a lump sum of money received today (beginning of period 1), at a discount rate of i.