Help with Excel IRR calc..Which cell arrays?

In selecting a array of cells, for a five year IRR, do I have 6 cells (first is negative as the amount invested, five years of cash flow, the last year includes sale proceeds…Scenario 1 below), and 8 cells for a 7 year IRR, OR do i include the investment and the cash flow from year 1 as one number…Scenario 2 below), thus 5 cells in the array?

Scenario 1 -1000000 100000 125000 130000 150000 1250000+175000
Scenario 2 -900000 125000 130000 150000 1250000+175000

Please help with this issue. I prefer email contact rk@askrk.com or phone 561 797-2721 THANK YOU!!!

1 Like

See also:
https://exceljet.net/excel-functions/excel-irr-function
Excel IRR Function
and:
https://smartasset.com/investing/internal-rate-of-return-real-estate-investments