turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- Base SAS Programming
- /
- IRR function

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-24-2008 05:42 PM

Does anyone now how to use the IRR function in SAS?

Here's an example of a cash flow that I used:

Month1: $-3,000

Month2: $600

Month3: $1,200

Month4: $600

Month5: $700

In excel I use the IRR function (=IRR(-3000,600,1200,600,700,.01)) and get a monthly IRR of 1.35%.

In SAS I use the IRR function (monthly_irr=IRR(5,-3000,600,1200,600,700)) and get a monthly IRR of 6.93. INTRR gives .0693.

Does anyone know how to use the SAS IRR function to get 1.35%? In support.sas it says that IRR should be written IRR(frequency,cash1,cash2,...,cashn).

Thanks for the help!!!

Here's an example of a cash flow that I used:

Month1: $-3,000

Month2: $600

Month3: $1,200

Month4: $600

Month5: $700

In excel I use the IRR function (=IRR(-3000,600,1200,600,700,.01)) and get a monthly IRR of 1.35%.

In SAS I use the IRR function (monthly_irr=IRR(5,-3000,600,1200,600,700)) and get a monthly IRR of 6.93. INTRR gives .0693.

Does anyone know how to use the SAS IRR function to get 1.35%? In support.sas it says that IRR should be written IRR(frequency,cash1,cash2,...,cashn).

Thanks for the help!!!

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

07-25-2008 09:55 AM

are you expecting the IRR per period or per year?

A first order approximation indicates (SAS Result)/frequency approx= (excel result)

I guess you might need to check on the excel doc, too

PeteC

A first order approximation indicates (SAS Result)/frequency approx= (excel result)

I guess you might need to check on the excel doc, too

PeteC

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

07-25-2008 01:28 PM

Hi Pete,

Thanks for the help. My periods are months so I'm looking for it by period and annualy. I thought that the function did it by period as it asks for frequency and then i used this calculation to change it to annual.

annual_irr=((monthly_irr+1)**12)-1;

Thanks again for the help!

Laura

Thanks for the help. My periods are months so I'm looking for it by period and annualy. I thought that the function did it by period as it asks for frequency and then i used this calculation to change it to annual.

annual_irr=((monthly_irr+1)**12)-1;

Thanks again for the help!

Laura

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

07-28-2008 08:32 AM

you'll find the SAS doc for function INTRR() more helpful, as it includes an example that might clarify the purpose of the FREQ parameter.... see http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000245903.htm.