Hello friends,
In line 3, there is the investment (0),and a series of cash flows.(15).
In line 5 Cumulative Cash Flow for Payback,
The challenge, is to find the exact payback period for an investment.
The solution should be based on the data in line 5.
The emphasis is on the solution in the shortest formula and without volatile functions.
The right solution is between 2 and 3 years.
My solution next Saturday.
good luck !
David
In line 3, there is the investment (0),and a series of cash flows.(15).
In line 5 Cumulative Cash Flow for Payback,
The challenge, is to find the exact payback period for an investment.
The solution should be based on the data in line 5.
The emphasis is on the solution in the shortest formula and without volatile functions.
The right solution is between 2 and 3 years.
My solution next Saturday.
good luck !
David
Attachments

22.5 KB Views: 55
Last edited: