IRR for monthly outflows

B

bhreddy

Joined
Mar 3, 2006
Messages
2
Reaction score
0
I've a different situation, instead of monthly inflows I've monthly outflows. I invest Rs.1000 a month for 19 months and on 20th month I get Rs.25000. In Excel sheet for IRR I get 2.08% and when I calculate effective annualized yield by (1+R)^12-1 I get 28%.

Can someone verify what I do is correct. I'm new to these calculations and I'm trying to understand these.

Thanks,
Hem
 

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, with cash flows in non-adjacent cells 6
IRR - inflow first, followed by only outflows 4
IRR or NPV 3
XIRR versus IRR 1
Irr function 4
NPV, IRR, and MIRR help 1
To XIRR or Not To XIRR 3
IRR - #NUM error 1

Back
Top