How to Excel at calculating the Internal Rate of Return A blonde wanting to earn some money decided to hire herself out as a handyman-type and started canvassing a wealthy neighbourhood.

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

You can calculate this with the RATE function by filling its five fields — Nper (number of periods - 12), Pmt (periodic investment – 5000 with a minus sign), Pv (present value – 0), Fv ...

Excel will default to a 10% IRR guess if one is not provided. Doing this for both projects, we calculate that the facility expansion would have an internal rate of return of 14.5%, versus 26.5% ...

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...