Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.


Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.