# PERIOD_LOOKUP

Last updated

Last updated

A PERIOD_LOOKUP function returns any periods values.

Syntax

PERIOD_LOOKUP(offset, initialValue) - > [number]

Arguments

Arguments | Datatype | Description |
---|---|---|

Remarks

This function can only be used after referring a node for which this calculation needs to be done as shown below in the example.

If we give negative number for the offset it will go back to the past periods and vice versa.

Period lookup will only work if there is 1 series (Year). To use it for multiple series PRIOR_SERIES_PERIOD_LOOKUP function should be used along with PERIOD_LOOKUP.

Example 1

Consider a scenario where you want to calculate the closing balance of Non-Current assets by including the monthly movements. Below is the information.

To achieve this, the following formula should be written in the [Opening Balance] node:

**[Closing Balance]****.****PERIOD_LOOKUP****(-1,30000000)**

Closing Balance node name is referred in the formula before using PERIOD_LOOKUP so that the calculation is performed for this specific node values. Since we have mentioned the first period value as $30 million it will take this as January month value. After that it will take the Closing Balance node as the previous period value as we have mentioned -1.

Result

Example 2

Consider a scenario where you have Year 1's Unit price value and Growth rate of Unit price for Years 2 to 5. We need to calculate the current year's price by taking the previous year's price and multiplying it with the growth rate.

To achieve this, the following formula should be written in the [Unit Price] node:

**(****THIS****.****PERIOD_LOOKUP****(-1,400)*(1+****[Growth rate (Years 2-5)]****)**

Result

Period | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec |
---|---|---|---|---|---|---|---|---|---|---|---|---|

Year | 1 |
---|---|

Year | 1 | 2 | 3 | 4 | 5 |
---|---|---|---|---|---|

offset

Number

The number of periods it has to go back or front.

initial Value

Number

The value of first period.

Non-Current Asset Balance

$30 million

Depreciation (Straight line)

12% pa

Opening Balance

30000000

29700000

29400000

29100000

28800000

28500000

28200000

27900000

27600000

27300000

27000000

26700000

Monthly movements

300000

300000

300000

300000

300000

300000

300000

300000

300000

300000

300000

300000

Closing Balance

29700000

29400000

29100000

28800000

28500000

28200000

27900000

27600000

27300000

27000000

26700000

26400000

Unit price

400

Growth rate (Years 2-5)

5%

Unit price

400

420

441

463.05

486.20