NPV is the difference between the present ... function is the better tool for calculating the IRR. To use this function, Excel and Google Sheets need both the cash flow amounts and the dates ...