# Lump Sum Number of Periods Calculator

## What does it do?

This lump sum number of periods calculator works out the amount of time it takes to grow a lump sum from its present value to a future value allowing for a given discount rate.

More precisely, the lump sum number of periods calculator, calculates the number of periods (n), for a lump sum to be compounded from its present value (PV) to its future value (FV), using a discount rate i.

## Formula

The calculator uses the lump sum number of periods formula as shown below:

```n = LN (FV / PV) / LN (1 + i)
```

Full details of the formula can be seen at our lump sum number of periods formula page.

## Instructions

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

Enter the future value (FV). The future value is the value of the lump sum required at the end of period n.

### 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 present value (PV). The present value is the value of the lump sum at the beginning of period 1 (today).

### Step 4

The lump sum number of periods calculator works out the number of periods (n). The answer is the number of periods it takes to compound the lump sum from its present value (PV), to its future value (FV), at the discount rate i.