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!
Bookmarks