Hello there,

Is there an Excel function or other way to calculate payback period for a series of cash flows?

For instance, I have the following cash flows:
Year 1: -200,000
Year 2: 500,000
Year 3: 700,000

What's the most accurate way to calculate the payback period?

Thanks in advance