Here’s how you’d set up the formula: In Google Sheets and Excel, you can type this directly or reference cell values for each component. Remember, the negative sign for present value is ...

The internal rate of return (IRR) measures an investment's profitability, taking into account the time value of money ... second scenario. The formula is the same for MS Excel and Google Sheets.