cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TMD_
‎01-29-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Doubt about IRR

by Calcite | Level 5 in SAS Procedures
‎01-29-2018 09:27 AM
‎01-29-2018 09:27 AM
Basically if i do irr(12, -initialpayout, monthly pay (n) to (n+1))  it works.   But i have 72 months, it is not very pratical....any work around? ... View more

Re: Doubt about IRR

by Calcite | Level 5 in SAS Procedures
‎01-29-2018 08:07 AM
‎01-29-2018 08:07 AM
Does not work completly   I am using this in excel : =+(1+IRR(G54:G174))^12-1    Which means that in G54 to G174 there is in G54 the -2462.5 € and from G55 to G126 there is only the value 48.71€.   The final result is 13.18% .   In sas using the formula you gave me it hits 8.4560170962.    What am i doing wrong?  ... View more

Doubt about IRR

by Calcite | Level 5 in SAS Procedures
‎01-26-2018 07:20 AM
‎01-26-2018 07:20 AM
Hello everyone,   I have a litle problem at work and i have difficulty solving it.   Here it goes:   I am trying to use the IRR function (just like excel) to calculate what we call TAEG / interest rate.   The problem i using the IRR function in a pratical way.   Basically i have (for example) a stable monthly payout of 47.22 € and i want to use the IRR to calculate what kind of rate i will have after 72 months. The initial outlay is 2462.5 for example.   In sas i tried using the formula irr(12, -2462.5, 47.22, 47.22, 47.22, 47.22, 47.22, 47.22) and it returns -99€.    What i assume is that i have to put 1 as the beginning value and put the monthly payout 72 times...but it is just not pratical, even more since i have more than one example.    Isn't there a simpler way when you have a stable monthly payout? Should i try to do a cycle?   Thanks for the help guys. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-29-2018 10:19 AM
Quick links