How do you calculate rate of return on monthly cash flows

P

Philly Fan

Can I use the IRR formula for internal rate of return calculations for
monthly cash flows? If so do I multiply the result by twelve? If not how do I
calculate the annual IRR using monthly cash flows?

Thanks for your help.
 
F

Fred Smith

Almost all financial functions work with the *periodic* interest rate. In
other words, only you know the period. Excel simply calculates an interest
rate given the cash flows.

If your periods are monthly, and you want an annual rate, yes, you can
multiply by 12. However, this would not compound the return. Suppose your
monthly IRR is 1%. If you invested $100 at 1% per month, you would end up
with more than $112 because of compound interest. If you want the compounded
annual return, the formula is =(1+i)^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

XIRR vs. IRR Function 11
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
Rate vs. IRR 1
Working with arrays as arguments 6
IRR showed #NUM! 16
Cash Flows Inflation Adjusted 2
IRR, with cash flows in non-adjacent cells 6
IRR formula for monthly cash flows 3

Top