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.

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 ...

Method Two Let’s assume that we didn’t calculate the IRR of 57% as we did above and have no idea what the correct discount rate is. We can use Excel’s What-If calculator in this case.

This article will talk about the underpinning and computation of key financial metrics such as NPV and IRR and how to compute these metrics in Microsoft Excel.