---
url: /cube-functions/cubexirr.md
description: 'Only Executes Under: Cards'
---

# CUBEXIRR

**Only Executes Under:** `Cards`

Calculates the extended internal rate of return for a series of cash flows at irregular intervals.

```js
CUBEXIRR(cube, value_location, dimension, hierarchy, start_position, count, guess)
```

#### Parameters

* `cube` - Cube to look in.
* `value_location` - Location in cube to pull values from.
* `dimension` - The name of the time dimension.
* `hierarchy` - The name of the hierarchy.
* `start_position` - Position in hierarchy to start from.
* `count` - How many elements in hierarchy to include.
* `guess` - An initial guess at the XIRR. `(optional)`

#### Examples

```js
CUBEXIRR("Profit and Loss", ["Amount"], "Time", "Month List", 3, 4)
```