Hi all,

I am trying to calculate the payback period for a series of cash flows. I have 5 years of cumulative cash flows from cells b24:f24 with the first year's cash flow being negative.

What is the right formula for calculating the payback period?

B24: -94,352
C24: 97,944
D24: 286,081
E24: 469,891
F24: 649,201

Thanks in advance!