When it comes to calculating interest rates for investments and bonds, the Yield and IRR formulas in Excel can quickly become your friends.

Calculating the IRR for a project with an initial outlay and single cash flow is very easy to do. It's also very practical for measuring the returns.