Let's say you have an investment that costs $X on Date A and on Date B it
pays $Y and you get back your principal. How do you calculate the annual
rate of return for this simple investment in Excel?

Assume that I already calculated the one time payment as a present value,
based on the value at the start date of the investment.

--
W