I am doing break-even analysis on a set of data. There is a time series and a number associated with that time. The number starts off negative and eventually becomes positive. I need a formula that will calculate the crossover point, the time at which the data becomes positive. There are other scenarios that must be accounted for. The data can start negative, turn positive, and revert back to negative. In these situations, I need the value to equal the first breakeven point. Also, the data can start positive and turn negative after a period of time.
For example,
1 -10000
2 -8000
3 -4000
4 -2000
5 0
6 1000
7 10000
8 15000
9 20000
BE is 5
The forumla should execute as quickly as possible. The formula will be applied to an extraordinary amount of data...millions of times.
Thanks for any help I can get.
For example,
1 -10000
2 -8000
3 -4000
4 -2000
5 0
6 1000
7 10000
8 15000
9 20000
BE is 5
The forumla should execute as quickly as possible. The formula will be applied to an extraordinary amount of data...millions of times.
Thanks for any help I can get.