Open In App

IRR() Function in MS Access

Last Updated : 06 Oct, 2020
Like Article

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 :



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 :



Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads