IRR() Function in MS Access

Last Updated : 06 Oct, 2020

IRR() Function in MS Access is used to return a Double value specifying the internal rate of return for a series of periodic cash flows, for example, payments and receipts.

Syntax :

`IRR( values () [, guess ] )`

Parameter :
IRR() Function accepts six parameters as mentioned above and described below.

• values () –
It accepts an array of Double specifying cash flow values. In IRR function accepts array that must contain at least one negative value (a payment) and one positive value (a receipt) which is Required.
• guess –
It accepts a variant specifying value the user estimate will be returned by IRR. If omitted, guess is 0.1 (10 percent). (Optional)

Returns :
It returns in double specifying the internal rate of return.

Note :
In IRR function to interpret the order of payments and receipts, it uses the order of values within the array. Payment and receipt values should be entered in the correct sequence. The cash flow for each period doesn’t have to be fixed, as it is for an annuity.

Example-1 :
Let’s assume the guess value (cost of the business) equals 7500 and the annual income for four consecutive years are stored in values().
Consider these values like –

```value(0) = 3000
value(1) = 5000
value(2) = 1200
value(3) = 4000
```
```SELECT IRRInterest = IRR( values(), -7500)*100 AS Interest_IRR;
```

Output :

Interest_IRR

28

Example-2 :
Cash flow data is provided in a table test_tbl.

ID Cash Flow
1 50243.25
2 50243.25
3 50243.25
4 50243.25
5 50243.25
6 50243.25
```SELECT IRR(cursor( SELECT cash_flow FROM test_tbl order by id asc )) as Interest
```

Output :

Interest

.490408759

Previous
Next