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

Capital lease interest can be computed using the IRR function in a spreadsheet. Adjust IRR formula for payment frequency to get correct annual interest rates.