You lend a friend $10,000, which your friend will repay in 5 equal annual​ end-of-year payments of ​$3,000​, with the first payment to be received 1 year from now. What rate of return does your loan​...

You lend a friend $10,000, which your friend will repay in 5 equal annual​ end-of-year payments of ​$3,000​, with the first payment to be received 1 year from now. What rate of return does your loan​ receive?

I need to be able to use excel and manually calculate as well.