IRR function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When we calculate an IRR using the IRR function with
yearly and monthly cash flow payments we are getting very
different results. The monthly payments sum up to the
yearly payments.

Any insight would be appreciated.
 
Since you don't use dates with IRR, it calculates the return *per period*,
i.e. monthly rate if you enter monthly cash flows, annual rate if you enter
only 1 cash flow per year. Are you taking that into account?
 
You are getting the monthly rate of return when you calculate the result on
the monthly data and an annual rate when you use the annual data.

PC
 
Back
Top