just wondering, do they have smthing called XMIRR

D

David Biddulph

Assuming that you mean David Hager's XMIRR routine, he said:
"I wrote this array formula to combine the functionality of the XIRR and
MIRR functions. This formula returns the internal rate of return for a
schedule of cash flows that is not necessarily periodic while considering
both the cost of the investment and the interest received on reinvestment of
cash."
http://www.j-walk.com/ss/excel/eee/eee017.txt

Isn't that a good enough explanation?

And next time, Pushkar, please remember to ask the question in the body of
the message, not just in the subject line.
 

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
future value 2
Is use of XIRR appropriate when dividends are not reinvested? 2
MIRR Function sensitivity to Finance Rate 2
How do you calculate rate of return on monthly cash flows 1
Calculating Annual Growth Rate of Investment 3
Passing argument to named formula 0
Problem with a named function 0

Top