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

If the payments are made annually, the next step is straightforward. Use the =IRR () function in your spreadsheet to calculate the interest rate of the capital lease.