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.

Why Excel falls short The Internal Rate of Return is a key metric used by investors, business managers and many other decision-makers to evaluate project profitability and viability. In the past, an ...