On Thu, 3 Sep 2009 13:02:40 -0700 (PDT), Seth M
wrote:



Thanks, that helps. Is my initial attempt using the XIRR function
incorrect because of the daily compounding?

They have different purposes. XIRR returns the internal rate of return for a
schedule of cash flows that is not necessarily periodic. To calculate the
internal rate of return for a series of periodic cash flows, use the IRR
function. And if the cash flows are identical, you can use the RATE function.
--ron