> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# CAGR

> Use the Sigma CAGR function to return the compound annual growth rate of an investment.

The **CAGR** function returns the compound annual growth rate of an investment.

**CAGR** is part of the set of financial functions that Sigma supports.

## Syntax

```
CAGR(n, bv, ev)
```

The **CAGR** function syntax has the following arguments:

<dl>
  <dt>
    n
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    The number of periods of the investment
  </dd>

  <dt>
    bv
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    The beginning value 
  </dd>

  <dt>
    ev
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    The end value
  </dd>
</dl>

The general formula for the **CAGR** function is:\
`(ev / bv )^(1 / n) - 1`.

## Examples

```
CAGR(4, 3000, 48000)
```

An investment that grew from \$3,000 to \$48,000 in 4 periods has a return rate of 100% for each period.

```
CAGR(10, [Beginning Investment], [Ending Investment])
```

Calculate the annual rate of return of an investment over a period of 10 years, as a percentage:

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/5844c0b5a7f364c2cddba9a3ce621e23052ba8c6aa6fa80beb677d1a70d18558/assets/docs-images/82adf7a-mceclip2.png)

## Related resources

* [PV](/docs/pv)
* [FV](/docs/fv)
* [Pmt](/docs/pmt)
* [NPer](/docs/nper)