IRR() Function in MS Access

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