IRR calc Monthly vs Annual

G

Guest

I attempt to calculate IRR on projects that extend over a couple years. When
using a monthly model, the IRR is significantly lower than an annual model.
Is there a way of "annualizing" the monthly #? I wouldn't think it would be
as simple as multipying by 12.

or another way of asking, is one way better than the other in evaluating
projects?
 
G

Guest

multiplying by 12 gives you a simple interest rate

to get a monthly compounded rate use
(1+IRR)^12 - 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR Function (formula) convert to annual if monthly data 0
MORE XIRR vs. IRR help 2
annualized return calculation for the purpose of portfolio performance evaluation 2
Should I trust XIRR or Legal & General? 5
Calc Prorated Cost based on Specific Days in a Given Month & Year Range 3
Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) 8
Calc Prorated Cost based Specific Days in a Gven Month & Year Range. 3
Averaging not Summing 4

Top